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,851 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,941 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
586 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
662 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,583 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,831 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
735 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
897 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
570 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers