Backing Up Your Data is Obvious, Or Isn’t It?
Often, when I give presentations on DBA best practices, I make the obvious point that databases need to be regularly...
2009-10-16
491 reads
Blog Posts
Dev Days
I heard about the Stackoverflow Dev Days earlier this year and thought it was an interesting idea. We had talked...
2009-10-16
1,156 reads
Free E-Book on XSD SQL Server Schema Collections
Whether you like it or not, as a SQL Server DBA or Developer, you will eventually have to learn about...
2009-10-16
558 reads
PASS Board of Directors Debate - Transparency and Vision
There is an amazing debate occurring on Brent Ozar's blog where he interviewed Matt Morollo. Being a little out of...
2009-10-16
1,378 reads
Shipping
I've got a conference to attend in a few weeks, and needed to get some things out the door. Every...
2009-10-16
635 reads
SQLSaturday #21 Shirt Snafu!
Thought I’d share a funny story. Way back before SQLSaturday #1 my friend Shawn recommended a local shirt/embroidery vendor, I...
2009-10-16
496 reads
Table Variable and Temp Table
Today I come across the great blog by Wayne Sheffield on Sqlservercentral.com about temp table and table variable so I...
2009-10-16
579 reads
Vetting the PASS Board of Directors candidates
I've had a pretty heavy involvement in Brent Ozar's interview of Matt Morollo. The reason for my intense activity is he was...
2009-10-16
1,360 reads
A DBA's Role with Respect to Improving Microsoft Dynamics CRM 4.0 Performance
1linerForward: here's a webinar from Microsoft regarding this subject, the following is a summary of what was required to improve CRM performance.
Microsoft's...
2009-10-15
3,403 reads
Are you sticking to your goals? Do you know what they are?
I've engaged a little in the discussion on Matt Morollo's interview on Brent Ozar's blog. It made me go back...
2009-10-15
1,193 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
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