Color-coding production connections in SSMS adds a visual warning, while an identity query confirms the real destination.
SQL SERVER – Difference between SQL Server Express and MySQL
SQL Server Express and MySQL are both free relational databases for smaller or embedded apps, yet they differ in important ways. Here is how they compare.
SQLAuthority News – Shaivi Dave – Baby SQLAuthority
On September 1st, 2009, God blessed us with a baby girl. After the Namkaran naming ritual we named her Shaivi Dave. Why we picked Shaivi from nearly 100 names.
SQL SERVER – Importance of Database Schemas in SQL Server
Why database schemas matter since SQL Server 2005: a schema is now a container separate from the user who created the objects inside it.
SQL SERVER – Find Gaps in The Sequence
How do you find gaps in a Sequence of numbers? A reader asked, and two experts, Brian and Tejas, replied with good scripts. Here are both solutions.
SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
Error 3724 stops you from dropping a database once used for replication. My simple fix: back up an empty database with the same name and force a restore.
SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
A Microsoft white paper on designing Analysis Services cubes that work well with Excel 2007 PivotTables, shared after requests from my BI roadshow.