sp_executesql Is Not Faster Than an Ad Hoc Query

This requires an immediate caveat. You should absolutely be using sp_executesql over any type of non-parameterized execution of T-SQL. You...

Thoughts on the 2016 PASS Summit

I’ll have several more posts this week on specific activities at the Summit, but wanted to start with how the...

MVP No More

Back in September I received a call from my MVP lead that I wasn’t being renewed. Not a big surprise,...

Comparing xSQL Schema Snapshots

Applies to: xSQL Schema
Compare v7.0.0 – 9.0.2

Before I develop a scenario where
xSQL Schema Compare snapshot comparison is necessary let’s explain what xSQL
Schema snapshots are. An xSQL Schema snapshot is...

Comparing xSQL Schema Snapshots

Applies to: xSQL Schema Compare v7.0.0 – 9.0.2
Before I develop a scenario where xSQL Schema Compare snapshot comparison is necessary let’s...

Writing More This Month

I haven’t written much in a while, having had to put more time into both personal and professional obligations over...

Query Store Instance Dashboard

Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t...

Implementing Fuzzy Sets in SQL Server, Part 5: The Mystery of the Missing Left Join

By Steve Bolton
…………Information on set operations like complements, intersections and unions is plentiful in the literature on fuzzy sets, which...

Mastering Index – Index on Computed Columns

This
article is the part of series Mastering Index, in this particular article
we will be exploring Index on computed
columns. Take a look...

Copying your SQL Database

If you have created a SQL Database in Azure (PaaS) and need to make a copy of it on the...