What counts as a schema change for plan caching? More than table structure: adding or dropping an index also qualifies, per Greg Low’s white paper.
geometry STDimension: Count Dimensions, Not Points
geometry STDimension describes dimensionality rather than the number of coordinates. A mixed collection reports its highest-dimensional element.
Finding Databases Nobody Uses
Finding databases nobody uses requires index activity, connection samples, job searches, and owner evidence before an offline trial.
Finding Unused Logins and Users Before an Audit
Review unused logins with password metadata, database mappings and activity capture, then use an owner approved disable-first plan.
Color-Coding Production Connections in SSMS
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.