CROSS JOIN for fun
My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts...
2018-02-17
1,111 reads
dbatools and Orphaned Users
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-02-16
797 reads
Black Panther is Going to Change Superhero Movies
Hello Dear Reader! Sorry it has been so long, I've been blogging over on the MSDN site about technology. I'll have a Twitter Sentiment update for Black Panther later...
2018-02-16
9 reads
Black Panther is Going to Change Superhero Movies
Hello Dear Reader! Sorry it has been so long, I've been blogging over on the MSDN site about technology. I'll...
2018-02-16
410 reads
Backup & Restore Script with a Move
Ok, I’ll admit it. I like scripts that are handy and do things. Especially if the scripts make my life...
2018-03-01 (first published: 2018-02-16)
2,339 reads
TDE and backup compression – still not working?
Until SQL 2016 if you used TDE (Transparent Data Encryption) you couldn’t use backup compression.
In 2016 Microsoft changed this, but...
2018-03-01 (first published: 2018-02-16)
2,399 reads
A Guide for Decrypting SQL Server Database Objects
Overview
The SQL Server 2005 and SQL Server 2008 provide a new feature for encrypting data to protect it from...
2018-02-28 (first published: 2018-02-16)
4,561 reads
"What's New in SQL 2017?" at the Baton Rouge SQL Server UG meeting
We had a great joint meeting tonight of the Baton Rouge SQL and .NET User Groups at the Louisiana Tech...
2018-02-15
551 reads
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level
Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...
2018-02-28 (first published: 2018-02-15)
2,649 reads
Enabling Guest in a Database–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-02-15
1,407 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