Sql Server Insights

In this blog I will tell you about some issues I had to face as a SQL Server DBA and what were the insights I gained from each

March 19, 2009

Compare varchar and int - Implicit vs Expclicit conversions

Hi While working on a query I stumbled across the following issue completely by mistake, but I believe it is worth mentioning. I had a tab...

Best way to truncate time part of datetime

Hi I needed to truncate the time part from a datetime column in a query I perform, in order to group by the date part of my datetime colum...

March 11, 2009

Automatic Decryption of Encrypted Data

Hi Couple of days ago a colleague DBA presented me with a problem. He has a data warehouse with encrypted data, and he wants to run report...

March 4, 2009

Using a stored procedure with SSIS OLE DB Source

Hi I had a mission to write a SSIS package that transfers data from a source to destination (pretty ordinary... :-)), but the problem was I...

February 25, 2009

Generate Random Numbers

I needed to generate a massive amount of random numbers. There are two ways to do it in SQL Server 2005 and above that I know of. The first...

View web version

About Me

Shalom Momi Sabag: I have been a DBA for the past 10 years, mostly working with DB2 for zOS.

View my complete profile

Powered by Blogger.