Statistics and Cardinality Estimation
Cardinality
This is a term originally from Mathematics, generally defined as “The number of objects in a given set or grouping”....
2017-06-30 (first published: 2017-06-20)
5,881 reads
Blog Posts
Using OPENROWSET in SQL Server on Linux
I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the...
2017-06-30 (first published: 2017-06-21)
2,950 reads
Using Organization Hierarchies as Reporting Unit filters with Management Reporter
Well, hello. It has been more than three years since my last blog, since then I have been really busy...
2017-06-30
596 reads
VMworld 2017 USA Sessions
I’m proud to announce that my sessions for this year’s VMworld 2017 conference in Las Vegas have turned up in...
2017-06-30
664 reads
Data lake details
I have blogged before about data lakes (see What is a data lake? and Why use a data lake?), and wanted to provide...
2017-06-29
4,587 reads
DevOps Basics–Staging and Committing Changes
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-06-29
708 reads
Persisting data in docker containers – Part One
Normally when I work with SQL instances within containers I treat them as throw-away objects. Any modifications that I make...
2017-06-29 (first published: 2017-06-21)
1,834 reads
PowerShell Module for the SQL Server Diagnostics API – 1st Command Get-SQLDiagRecommendations
I saw this blog post about the SQL Server Diagnostics add-on to SSMS and API and thought I would write...
2017-06-29
739 reads
Reading the log on SQL for Linux
The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server...
2017-06-29
906 reads
Recording of PASS Security VC Webinar
If you were unable to attend this month’s PASS Security Virtual Chapter webinar, The Dirty Business of Auditing, it has...
2017-06-29
571 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers