Testing BackBlaze Restores
The most important thing for a data guy is having a way to restore data. If security, performance, etc. are...
2018-07-13 (first published: 2018-07-05)
2,321 reads
Why Aren’t You Using SSMS 17?
Last fall, Microsoft split the coding and release of SQL Server Management Studio away from any dependency on the server...
2018-07-12 (first published: 2018-07-05)
4,768 reads
Contained Database – No more need for Server Level Logins
Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained...
2018-07-11 (first published: 2018-07-05)
2,922 reads
Community recognition
On the first day of January 2017, I was honoured to receive an email naming me as a Microsoft MVP...
2018-07-04
313 reads
Updating VSTS to SQL Change Automation
We (Redgate) released SQL Change Automation a few weeks back. This is the first stage to implementing a combined toolset...
2018-07-04
1,003 reads
Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,750 reads
Building Better Test Data on the Redgate Hub
I have a new piece published over at the Redgate Hub: Building Better Test Data with SQL Provision. Part of...
2018-07-03
848 reads
Mastering Index Tuning–Day 3
This is a short series of posts on the courses I took with Brent Ozar. I actually completed the courses...
2018-07-03
961 reads
Half-year round-up
So, to do the name “blog” justice, I should post something every now and then. Alright, here you go, let...
2018-07-03
281 reads
A bug in merge replication with FILESTREAM data
I wish I could say that every DBA has a love/hate relationship with Replication, but, let’s face it, it’s only...
2018-07-11 (first published: 2018-07-03)
2,198 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