Fixing PRIMARY KEY constraint issues in SQL Server 2005 Replication

I must admit that I had to stay away from replication for quite a while since most of the work I’ve done in my previous job has a lot to do with disaster recovery. Nonetheless, I’m presented with new challenges every single day which I need to face. I got notified for an error regarding […]

Using LINQ with SQL Server Compact Edition

I was trying to use MS Access with one of the applications I was writing for a non-profit organization but thought about the security of the database file. That being said, I opted to use SQL Server Compact Edition as it is just a small application that requires a database. This would enable the database […]

Why Windows Instant File Initialization for SQL Server 2005 (and higher) matters

SQL Server 2005 supports Database Instant File Initialization which skips zeroing out data pages that can reduce the time when performing operations like creating databases, adding files to an existing database, increasing the size of an existing database file manually or thru autogrowth or restoring a database or filegroup. I’ve written an article in MSSQLTips.com […]