Upcoming PASS Events

There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me...

Webinar- SQL Server 2016 - Always Encrypted / Security

Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PMSQL Server has had ways to encrypt data in the past - for...

Webinar- SQL Server 2016 - Always Encrypted / Security

Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PM

SQL Server has had ways to...

Automating DBCC PAGE – Part 3 (Is a Clustered Index physically sorted on disk?)

In several of my last few blog posts, I’ve shared several methods of getting internal information from a database by...

Azure Cognitive Services – Text Analytics API Application

[read this post on Mr. Fox SQL blog] [UPDATED 7 JUN 2020 – ADDED NEW TEXT ANALYTICS v3.0 FEATURES!] Just last week we had the fantastic opportunity to present at Microsoft...

Estimated Costs of All Queries

One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty...

How to sign a SQL Server CLR Assembly in Visual Studio 2015

It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...

Read Statistics Histogram using DMV

DMV: sys.dm_db_stats_histogram (object_id, stats_id) 
For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics....

Reminder – SQL Saturday Chicago Precon

I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic...

Remotely Administering the Docker Engine on Windows Server 2016

Continuing on my series in working with Docker on Windows, I noticed that I always open up a remote powershell...