SQL Audit 302 – Deploying the Audit Solution with Powershell
This is it, ladies and gentlemen. One last post and I promise I won’t mention the word audit for at...
2012-08-29
2,647 reads
Free Second Shot offer for Microsoft Certification Exams
Nothing for me to really say except if you mess up, you get a free second chance Click HERE to see...
2012-08-29
1,141 reads
September 2012 Speaking Events
September is another busy month of speaking events for me and I thought I’d share them with you so maybe...
2012-08-29
1,731 reads
SQL in the City – FREE Training
Is SQL in the City coming to a town near you? The events are being held in New York, Austin,...
2012-08-29
1,415 reads
Upcoming Speaking Events
I will be the inaugural speaker for the Northern Colorado Database Professionals on September 17, in Loveland, CO. I will...
2012-08-28
2,037 reads
Suppressing namespace attributes in nested select statements when using FOR XML workaround
I was helping out on the forums the other day with a user who had stumbled across the quirk of...
2012-08-28
6,882 reads
Lookup transformation in SSIS: Performance Improvements
There are 2 suggestions I hear about when performance tuning the Lookup transformation on a large dimension table when getting...
2012-08-28
9,144 reads
Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused
There is a way to view the size of a particular PDW database using the DBCC_pdw_showspaceused command via the NEXUS...
2012-08-28
3,399 reads
These People Are Exceptional
I should know. I was one of the judges of this year’s Exceptional DBA of the Year award. I had...
2012-08-28
1,011 reads
SQL Server Guest User – Still a Serious Security Threat
One of the security recommendation inside SQL Server Security Best Practice white paper for guest user is that, to disable...
2012-08-31 (first published: 2012-08-28)
5,280 reads
Blogs
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
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...
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers