Dashboard Server Status
Dashboard Server In the Server Dashboard the tile background can change between Green (Ok), Orange (Warning) and Red (Error). When...
2017-10-20
182 reads
Blog Posts
Error Installing SQL Server 2017
A quick blog post on an error I got when installing SQL Server 2017 RTM. I ran the set-up for...
2017-10-20
5,626 reads
My First Migration with dbatools
I’ve been a proponent of dbatools for close to a year now and even contributed to the project, but surprisingly haven’t been a heavy user of it. Mostly due...
2017-10-20
7 reads
New Features in SSMS 17.3
SSMS 17.3
SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention:
Import Flat...
2017-10-20 (first published: 2017-10-11)
4,111 reads
SQL Server on Linux – External Memory Pressure
In this blog post we’re going to explore how SQL Server on Linux responds to external memory pressure. On Windows based SQL Server systems we’ve become accustomed to the...
2017-10-20
21 reads
SQL Server on Linux Content at PASS Summit
PASS Summit is right around the corner and I’ll be there speaking on Monitoring Linux Performance for the SQL Server...
2017-10-20
424 reads
SQL Server on Linux Content at PASS Summit
PASS Summit is right around the corner and I’ll be there speaking on Monitoring Linux Performance for the SQL Server Admin!
There’s a fantastic amount of SQL Server on Linux...
2017-10-20
6 reads
Avoid “Constants” in T-SQL
Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...
2017-10-19 (first published: 2017-10-10)
3,678 reads
Connecting to Azure SQL Database Primary Endpoint – Failover Groups
When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint...
2017-10-19
698 reads
Deactivate SQLTreeo license
Version SQLTreeo SSMS Add-in version 0.8.4 or higher. Purpose Deactivate a SQLTreeo license when your workstation is unavailable. SQLTreeo is...
2017-10-19
139 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