Verifying Last Successful CheckDB with Powershell and SMO - sorta
A few years ago, I wrote a script that was published on SQLServerCentral.com about how to verify the last successful...
2012-02-03
1,719 reads
Blog Posts
A Script A Day - Day 2 - Database Mail Troubleshooting
Today's script is a collection of simple queries I have saved for a time when I need to troubleshoot database...
2012-02-02
488 reads
PowerPivot for Excel Install Issues
At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...
2012-02-02
991 reads
Returning Results from an Insert – OUTPUT clause
I needed to return an identity value recently from an insert for use in another piece of code. For a...
2012-02-02 (first published: 2012-01-30)
3,593 reads
SmartPaster
I recently discovered this great little free Visual Studio Add-in that allows pasting text as preformatted strings in VB or...
2012-02-02
822 reads
Speaking for Baton Rouge UGs and SQL Lunch Next Week
I have been quiet over the past year trying to get acclimated to my new job and my new found...
2012-02-02
391 reads
SQL Server – COPY TABLE from another SQL Server
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and...
2012-02-02
1,019 reads
2012-02-02
5 reads
2012-02-02
8 reads
2012-02-02
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