Add Database File on Database invloved in DB Mirroring

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file...

Database Lifecycle Management

There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every...

Update to “The clustered index columns are in all of the non clustered indexes.”

I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments...

SQL Server TABLESAMPLE

Using TABLESAMPLE in SQL Server
SQL Server has several ways for you to limit the number of records returned from a...

Reducing the size of the distribution database & improving transactional replication performance: Part 3

Part 1 of this series of articles looked at the intricacies of SQL Server transactional replication, and made the observation that the...

Be Careful! Backups Can Bite You!

Here is a riddle for you…
You are requested to move a database from an old server to a new server....

My Best LinkedIn Articles

Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation.

7 Bad Management...

Reblog: October 10 to October 16

Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...

Untrusted Foreign Keys

Reading Time: 4 minutes
  What is a Foreign Key?
Do you trust your foreign keys?
A foreign key is a link between...

Untrusted Foreign Keys

  What is a Foreign Key?
Do you trust your foreign keys?
A foreign key is a link between 2 tables that is...