Query Store and Automated Cleanup

Query Store has mechanisms for automatically cleaning your data. It is possible to cause them to break down. While presenting...

Revisiting catch-all queries

I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code....

The 700 Milestone for SQL Saturday

This past weekend was SQL Saturday #700. Another milestone in the franchise of events, and I was glad to attend....

SQL Saturday Madison 2018

Come out to see how to leverage Microsoft Machine Learning Server  

Allowing Azure Service to Connect to your Azure SQL server.

Allowing Azure Service to Connect to your Azure SQL server.

In this video David will look at the impact of allowing...

Community

Community.
In the SQL Server community, we are basically one big #sqlfamily.  This is a story of how the family helped...

Power BI Custom Visuals Class (Module 95 – VitaraCharts–MicroChart)

In this module you will learn how to use the VitaraCharts – MicroChart. The VitaraCharts – MicroChart provides a intuitive way to...

Scripting Tables with dbatools

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...

SQL Saturday #695 Guatemala

This is probably a very delayed post, but I have been really busy lately.
As mentioned in my previous post, I...

SQLSaturday Madison – “Data Security for the Cloud” and “Three Steps to Lasting Encryption”

In just a few short weeks, SQLSaturday Madison will happen in Madison, WI, and I’m happy to say that I’m...