Mainstream Support Ending Soon || SQL Server 2008 and SQL Server 2008 R2

Microsoft declares to release last & final service packs for SQL Server 2008 and SQL Server 2008 R2 very soon.
Mainstream Support...

Partitioning Basics – Part 2 – Splitting/Merging Partitions

This post follows on from the previous post Partitioning Basics – Part 1
Let’s have a look at the partitions setup in...

Presentation DAC “SQL Server Implementation Framework From Dev to Prod”

The San Francisco SQL Server User Group – June 11 2014 Uploading presentation DAC for Today’s session….

Presentation DAC SQL Server Implementation Framework From Dev to Prod

Presentation DAC SQL Server Implementation Framework From Dev to Prod

Presentation DAC SQL Server Implementation Framework From Dev to Prod

Presentation DAC SQL Server Implementation Framework From Dev to Prod

Spring may be long gone but you still need to clean up MSDB

System databases are often neglected, part of this is due to Microsoft’s message of SQL Server will run and look...

SQL Server 2012 Service Pack 2 (SP2) RTM Is Now Available !

SQL Server 2012 Service Pack 2 (SP2) RTM is now available for download at the Microsoft Support site. Service Pack...

SSIS Lessons Learned, Or Not, And Mistakes Beginners Make

It’s been a while since I’ve used SSIS for anything of substantial complexity, and a lot longer than that since...