Friday, June 29, 2012

SQL 2005 Upgrade Exams Expire 31st July 2012

›
The SQL 2005 to 2008 upgrade exams expire on 31st July 2012. This includes: Exam 70-453 : Upgrade: Transition Your MCITP SQL Server 2005 D...
Wednesday, June 27, 2012

Creating Database Snapshots Via SMO

›
The SMO (Server Management Objects) API is the best way to programmatically interact with SQL Server. On a recent project I had a requiremen...
1 comment:
Friday, June 22, 2012

Using the ADO.NET SqlBulkCopy Class

›
Recently I had an interview where I was asked about the ADO.NET Bulk Copy class. Frustratingly, I had used it about 12 months prior and coul...
Friday, May 25, 2012

ADO.NET Entity Data Model – Unexpected Number of Rows Affected

›
I use the Entity Data Model in almost all of my projects now. Major time saver usually, but today I received an error that I hadn’t seen bef...
Tuesday, May 22, 2012

Ancient SQL 2000 Bug

›
Recently I’ve been running an automated data collection across a couple of hundred SQL Server instances. I hit an issue today when I ran a p...
Friday, October 7, 2011

Window Functions

›
Last night I was lucky enough hear Itzik Ben-Gan speak at the SQL Server user group here in London. The topic for the evening was Window Fun...
Friday, July 29, 2011

SQL Server Table Partitioning – A Round Robin Approach

›
Over the last few weeks I’ve been working on designing a large, partitioned table using SQL Server 2008 R2. This table needs to hold 30 days...
1 comment: