Please Lend Me Your Vote for Documentation of TMSCHEMA DMVs

I spent a good bit of time looking for the definitions/descriptions of the TMSCHEMA DMVs that allow us to view...

Monday Morning SQL Break – November 7, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch...

Monday Morning SQL Break – November 7, 2016

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...

Power BI Custom Visuals Class (Module 24 – Globe Map)

In this module you will learn how to use the Globe Map Power BI Custom Visual.  The Globe Map is...

When disks have different sector sizes for primary and secondary replica log files in an AlwaysOn Availability Group Config

Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error logs to see if there is anything out of...

When disks have different sector sizes for primary and secondary replica log files in an AlwaysOn Availability Group Config

Recently I was analyzing a stress test result for an AG configuration, and as usual I was reading to SQL error...

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...