Wednesday, September 27, 2006 - Posts

Restoring your SQL Server - Chicken and the Egg

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Restoring your SQL Server - Chicken and the Egg
The new RSS feed is here

Have you tested your DR plan? Do you have one?

Well if you do have one then unless you test it its worthless. There are many nuances that occur in a recovery process. The Storage Engine Team have posted about one suhc nuance.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Restoring your SQL Server - Chicken and the Egg

posted Wednesday, September 27, 2006 8:27 AM by SimonSabin with 1 Comments

SSIS - Be very very careful

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - Be very very careful
The new RSS feed is here

I've mentioned before that a good practice is to not use the table or view option in the OLEDB source and lookups due to returning more columns than you need and being tied to the structure (i.e column order) of the table.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - Be very very careful

posted Wednesday, September 27, 2006 1:13 PM by SimonSabin with 0 Comments

SQL 2005 Rocks

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL 2005 Rocks
The new RSS feed is here

Those are the words my ops DBA utered this morning, was it some big new feature like database mirroring, snapshot isolation, ssis.

No it was the fact that failed login attempts, when recorded in the log file, now include the Client IP address.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL 2005 Rocks

posted Wednesday, September 27, 2006 12:43 PM by SimonSabin with 0 Comments