An overview of Python vs PowerShell for SQL Server Database Administration

Today, Microsoft claims that Linux runs like a First-Class citizen on Azure, .NET Core has been open-sourced, and has been...

SQL PASS Summit 2017 Day 2 – Keynote Notes and Ideas

This morning, Dr Rimma Nehme tells us the story of the birth of Azure Cosmos DB, a global, scale-out database system. At the beginning of the talk, I can already...

Microsoft MVP!?

What? Is probably the most common reply out there and if it is then that is how I felt when...

SQL Query Experiment - "WHERE" & "ON"

Sometimes the mistakes you make in the coding lead you to a better understanding of a particular concept.

This happened recently...

Contained Databases

Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or used that it deserves even when it helps solving...

Contained Databases

Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or...

Capture the most expensive queries across your SQL Server using Query Store

I’m a big fan of using queries based on the dynamic management view sys.dm_exec_query_stats to capture the most resource hungry...

Avoiding confusion with SQLCMD variables

SQLCMD variables can be a useful way of having changeable parameters for your SQL scripts, allowing you to specify the...

Windows Tips and Tricks – Why do I Have Trouble Ejecting USB Hard Drives?

External USB drives should be safely detached from Windows instead of just unplugging them from the computer. Most of us...

SQL PASS Summit 2017: Day 1 Keynote Thoughts and Memories

Whee! It’s the first day of the main SQL PASS Summit conference and I made it to the keynote early for the first time ever. The hype says we’re going...