Using a gMSA with SQL Server
As you already know, SQL Server runs as a service. And services require a service account to run under. While...
2018-03-02 (first published: 2018-02-19)
17,308 reads
Automating Database Deployment: Part 2 Setting Up the RoundhousE Environment
Remember from the introduction that RoundhousE is a command line driven database deployment engine. This article of the series will discuss the deployment flow and the RoundhousE environment, looking...
2018-02-19
46 reads
The default filegroup, and why you should care.
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index...
2018-02-19
579 reads
Dealing with stress
Anyone who knows me will know that I’m something of a stress head. I tend to worry about things and...
2018-02-19
383 reads
How to create System-versioned temporal tables? – New database feature of SQL Server 2016
Creating a System-Versioned Temporal Table – There are three ways to create a system-versioned temporal table with regards to how the...
2018-02-19
1,181 reads
Distributing SSH User Keys via PowerShell
Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take a minute to look at what it takes to...
2018-02-18
15 reads
Distributing SSH User Keys via PowerShell
Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take...
2018-03-02 (first published: 2018-02-18)
6,523 reads
New Pluralsight Course – LFCE: Linux Service Management – Advanced HTTP Services
My new course “LFCE: Linux Service Management – Advanced HTTP Services” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want...
2018-02-17
27 reads
New Pluralsight Course – LFCE: Linux Service Management – Advanced HTTP Services
My new course “LFCE: Linux Service Management – Advanced HTTP Services” in now available on Pluralsight here! If you want to learn about the...
2018-02-17
525 reads
SQL Server Error 3013: Restore Database is Terminating Abnormally
Overview of SQL Server Error 3013
One of the most frustrating situations that a user experiences while working with SQL Server...
2018-02-17
17,554 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