Audit Yourself Regularly
Around April this year, my men's accountability group was talking about a shared pain: income taxes. We were all worried...
2012-08-13
1,710 reads
Bloggers–Don’t Make It Hard to Comment
Lately I’ve hit a couple blogs that wanted me to enter some kind of credentials before I could post a...
2012-08-13
376 reads
Database Corruption, Transparent Data Encryption, and Trace Flag 5004
This one comes straight from the email bag. A friend recently had a problem, they were placing TDE on a...
2012-08-17 (first published: 2012-08-13)
5,735 reads
Find AD user detail - PowerShell Script
I developed the below script to find the details of a AD user and the AD groups he is associated...
2012-08-13
7,916 reads
Find Members of AD Group - PowerShell Script
This is one of the powershell script I have been using quite regularly from the day I developed. Most of SQL...
2012-08-13
2,163 reads
Monitor Deadlock in SQL 2012
Do you still use trace flag 1204 and 1222 to monitor Deadlock? or using profile to capture deadlock? Now we...
2012-08-16 (first published: 2012-08-12)
18,071 reads
How to list all CLR objects inside your database?
I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:
SELECT o.object_id AS [Object_ID]
...
2012-08-12
1,312 reads
How to find SQL Agent Jobs without Notification Operator Configured?
We can either use SQL Server Management Studio or use Transact-SQL query to find any SQL Agent jobs that have...
2012-08-12
2,653 reads
Ever Want to See How a Hand Plane Works?
If you’re interested in woodworking, read on!
I’ve been thinking of making a hand plane out of wood and was doing...
2012-08-12
809 reads
SQL Server: Understanding the Data Page Structure
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-15 (first published: 2012-08-12)
8,775 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