What’s Wrong with this Picture: A Database Misconfiguration Well Demonstrated
Recently, I was doing some testing/playing around on a particular database on my home test servers. After I was done,...
2012-01-06
808 reads
Blog Posts
LOOP, HASH and MERGE Join Types
Today I’ll talk about the available JOIN operator types in SQL Server (Nested Loops, Hash and Merge Joins), their differences,...
2012-01-05
5,857 reads
Management Studio Split Tabs
This is by far the simplest and silliest post ever, but i just figured how to create vertical tabs in...
2012-01-05 (first published: 2012-01-03)
3,112 reads
Msg 7395: Unable to start a nested transaction
Happy new year, SQL peeps! I hope everyone had a wonderful holiday. Last week was very quiet at work, but...
2012-01-05
3,360 reads
PASS Summit Eval – Extended Events
As I mentioned in yesterday’s post, I had two sessions at the PASS Summit this past year in which I...
2012-01-05
749 reads
Safely Restart SQL Agent with Powershell
I recently had to enable tokens in SQL Agent across about 50 instances. Unfortunately, enabling tokens requires a SQL Agent...
2012-01-05
1,764 reads
SQL Server Disable Indexes and Rebuild Indexes dynamically
To generate the ALTER INDEX..DISABLE and the ALTER INDEX..REBUILD statements for all nonclustered indexes for a single table use the...
2012-01-05
1,177 reads
SQL Server Login Auditing
In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed...
2012-01-05 (first published: 2012-01-03)
2,891 reads
The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
You may fire up the SharePoint 2010 Management Shell (which allows you to run PowerShell commands to do cool SharePoint...
2012-01-05
2,240 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a year ago as a gift – but it...
2012-01-04
10 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