Don’t do these things in SQL Server
Recently Brent Ozar posted a link to the PostgreSQL “Don’t do this” page, which I am shamelessly reproducing below, re-tailored...
2018-08-01
517 reads
SQL Homework – August 2018 – Set up database mail
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail.
Why database mail?...
2018-08-01
336 reads
A PowerShell Conference In A Book
A Question
Shortly after the European PowerShell Conference and the PowerShell and Devops 2018 summit in the USA Mike Robbins b...
2018-08-17 (first published: 2018-08-01)
2,747 reads
Have you ever wonder why Log Send Rate doesn’t show against Primary Replica on the AlwaysOn Dashboard?
Recently, I was working on the AlwaysOn Availability group issue where the log records were not moving from primary to...
2018-08-01
473 reads
Information Measurement with SQL Server, Part 4.2: The Jensen–Shannon Divergence and Its Relatives
by Steve Bolton
…………In the last installment of this amateur series of self-tutorials on DIY data mining metrics, we saw how...
2018-08-15 (first published: 2018-07-31)
2,310 reads
SQL Server – Blocking a Truncate
The truncate option is fast and efficient but did you know that it takes a certain lock where you could...
2018-07-31
575 reads
Community Engagements Second Half of 2018 – It’s all about Biml
I have a couple of community engagements coming up in the second half of 2018 and I’d like to share...
2018-07-31
338 reads
Power BI Custom Visuals Class (Module 113 – Small Multiple Line Chart)
In this module you will learn how to use the Small Multiple Line Chart. The Small Multiple Line Chart allows...
2018-08-07 (first published: 2018-07-31)
2,283 reads
SQL Operations Studio: Keyboard Shortcuts, Actual Plans, & More
Last week I posted a quiz on SQL Operations Studio, a free, multi-platform tool from Microsoft. This tool is under active development and the features are improving by the day...
2018-07-31
29 reads
Should You Use Index Hints?
Watch this week’s post on YouTube
One of the things that the SQL Server query optimizer does is determine how to...
2018-08-16 (first published: 2018-07-31)
3,865 reads
Blogs
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....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers