Behemoth of the Server Room?
Back during the PASS 2011 Summit in Seattle, I was interviewed by Tony Davis, Andrew Clark, and Rodney Landrum about...
2012-02-10
869 reads
Blog Posts
Executing scripts with sp_addscriptexec
Looking for ways to do things more quickly and efficiently, I thought I would talk a little bit about sp_addscriptexec...
2012-02-10
2,677 reads
Hardware Fun
This has been a bit of a hardware week for me, which is strange. I used to love hardware, building...
2012-02-10
1,092 reads
Notes from the February Space Coast SQL Meeting
I drove over to Melbourne last night to the new home of Space Coast SQL at the Harris Institute for...
2012-02-10
727 reads
Powershell default start directory
This post discusses some methods in configuring the Powershell default start directory
By default , the installation process will add a value...
2012-02-10
1,871 reads
Review: I Done This
IDoneThis is a simple web site for tracking accomplishments. The premise is that you get a checkbox on the calendar...
2012-02-10
822 reads
Slides and Scripts from Idera February webcast
For those who've asked, here are the slides and scripts from my SQL Server auditing webinar with Idera:
Presentation (.PDF)Scripts (.ZIP)
If...
2012-02-10
1,048 reads
Speaking At SQL Saturday #110 in Tampa
I got word this week that one of my sessions for the upcoming SQL Saturday #110 in Tampa, FL was...
2012-02-10
439 reads
SQL Azure
SQL Azure is a cloud-based service from Microsoft that uses a special version of SQL Server as its backend. SQL Azure...
2012-02-10
2,441 reads
Thanks to Brian Kelly for a Great Presentation on Auditing for SQL Server - Please Find the Notes Below
For those interested in following a great MVP who contributes regularly on Infrastructure and Security, here are notes I took...
2012-02-10
1,041 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