Trekking Through Formatting Forest on the #SQLPrompt Treasure Map
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-11
1,591 reads
Dates and Times in SQL Server: the science of time
Now that we have covered the various date and time data types (see the post from last time) in SQL...
2018-04-11
861 reads
Checking for temporary table existence
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,304 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
169 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
1,016 reads
Privacy and Protection, By Design
With all the noise about the upcoming enforcement of GDPR, I know that people are starting to focus more on...
2018-04-11
446 reads
Free Webcast: DBA vs Memory Settings
Join me in two weeks for a really fun free webcast. Update: watch the recording of the webcast here! DBA vs Memory Settings Tues, April 24, 2018 – 8:30AM...
2018-04-11
9 reads
Understanding database recovery models in SQL Server
A recovery model is a database configuration option that determines the type of backup that one could perform and provides...
2018-04-11
777 reads
Baton Rouge SQL Server User Group – Execution Plans
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton Rouge .Net User Group does the same at the...
2018-04-11
12 reads
Baton Rouge SQL Server User Group – Execution Plans
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton...
2018-04-11
315 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