A DMV a Day – Day 21
The DMV for Day 21 is sys.dm_os_ring_buffers, which is helpfully NOT described by BOL as:
The following SQL Server Operating System–related...
2010-04-21
2,588 reads
Whats a Good Rule for Max Degree of Parallelism?
Introduction
I am one of those people that believe that anything worth doing is worth having a script to do it....
2010-04-20
561 reads
Stepping Stone Cert II
Back on March 30, I wrote about a Stepping Stone Certification that seems to be missing between the MCM and...
2010-04-20
753 reads
SQL Saturday #39, New York, New York
A town so big they named it twice.
If you’re not excited about SQL Saturday in NYC this weekend… why not?...
2010-04-20
521 reads
Staying Current with SQL Server Builds
There was some conversation on Twitter about how to get notification when new Cumulative Updates are released for SQL Server...
2010-04-20
976 reads
Sad Sack – Hardware Failures all over
I feel like I have some bad digital karma lately. In the past week I’ve had these downed systems:
iPod iTouch...
2010-04-20
646 reads
Growing PASS Step One - Communication
My History with PASS
Over the last two years I have become more involved in the SQL Server community through attending...
2010-04-20
618 reads
SQL Server Agent
Found out this week – that we should be restarting this service at least once a week ! (thus allowing the CPU...
2010-04-20
385 reads
Review: Ninite
Found Ninite while browsing a list of efficiency tools on PCWorld.com. It’s a one stop super installer, you run through...
2010-04-20
632 reads
A DMV a Day – Day 20
The DMV for Day 20 is sys.dm_exec_cached_plans which is described by BOL as:
Returns a row for each query plan that...
2010-04-20
1,097 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers