Browse by Tags

All Tags » SQL Server (RSS)

SQL Nugget - script content of a table as INSERT statements by MartinIsti

I have wrestled a couple of times what was easy when I used TOAD but became painful with SQL Server. For example you have a control table that is manually edited most of the times in DEV. When you want to move it to TEST you can transfer the whole table...
Filed under: , , ,

Oracle DATE vs SQL DATE by MartinIsti

During the development of a simple (or so we thought ) SSIS task a strange error came up: we had a dbtimestamp column from Oracle which we had to load into a SQL Server ( 2005! ) table. It was a transaction date so by default there shouldn't have...

Books to read by MartinIsti

This post is mainly for fellow BI folks such as me who feel that they are only at the beginning of this road: First I show you what I've already read (or at least have learnt a lot from): The 70-445 Training Kit - it's a great book, teaches a...
Filed under: , , , , , , , ,
Powered by Community Server (Commercial Edition), by Telligent Systems