tSQLt Course
In the last half of 2017, I decided to run a tSQLt course and went down the route of putting...
2018-02-06
294 reads
Getting Your SET Options
Have you ever used @@options? I haven’t typically needed this, but there are times that you might wonder what options...
2018-02-15 (first published: 2018-02-06)
2,191 reads
Conversations with Data Warehouse Experts – Podcast
In this podcast I talk with Mike Rabinovici of Dimodelo Solutions about data being the new currency, the importance of showing...
2018-02-06
58 reads
Conversations with Data Warehouse Experts – Podcast
In this podcast I talk with Mike Rabinovici of Dimodelo Solutions about data being the new currency, the importance of showing...
2018-02-06
510 reads
I’m Speaking At SQL Saturday Richmond
I am so excited, I was selected to speak at SQL Saturday Richmond on March 24, 2018, in Richmond, Virginia.
SQL...
2018-02-06
266 reads
Lessons Learned From SQL Saturday Cleveland
I can finally breath a sigh of relief, my first time of presenting two sessions back to back is finally...
2018-02-06
254 reads
Waiting Tasks Reveal Pain Points
Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I...
2018-02-14 (first published: 2018-02-06)
2,838 reads
“How do I contribute to dbatools?” with Drew Furgiuele
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the...
2018-02-06
111 reads
"How do I contribute to dbatools?" with Drew Furgiuele
Watch this week's video on YouTube
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the open-source dbatools PowerShell module.
If...
2018-02-06
6 reads
Bug in SSMS V17.4
If you are using SSMS V17.4 as I am
You may encounter a weird error. This can be repeated as follows:
Open...
2018-02-06
486 reads
Blogs
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....
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...
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers