Calculating ROI on Performance Tuning
Recently on the SSC forums, someone asked about how to measure the money in an actual dollar figure that they...
2010-06-02
757 reads
SQL Server 2008 and 2008R2 Diagnostic Information Queries for June 2010
This version has updated build lists for SQL Server 2008 and 2008 R2. It also has several new queries, and...
2010-06-02
1,566 reads
Speaking at SQL Saturday #22 - Pensacola, FL
If you are near Pensacola, FL this weekend, I will be speaking at their SQL Saturday on June 5th, 2010. I will...
2010-06-02
753 reads
Submitted Session Abstracts for PASS Summit 2010
I guess I will join the trend, and list the session abstracts that I submitted for PASS Summit 2010. There...
2010-06-02
908 reads
Inventory SQL Servers with CLR Function
In an enterprise with several SQL Server instances it is pivotal that you keep track of each instance and its...
2010-06-02
741 reads
Daily SQL Server 2008 New Feature – Day 14
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-02
338 reads
2010-06-02
639 reads
Would You Do Your Hobby For a Living?
Another recent editorial I wrote for SQLServerCentral talks about whether you would be happy doing your hobby for living. For...
2010-06-02
699 reads
Table Variables
I was never a big fan of temp tables, mostly because there were serious contention issues in SQL Server v6.5....
2010-06-02
1,012 reads
Winner of the May SQL Aloha Contest
This month’s question had 21 responses, although a few were duplicates. The question was:
What is your favorite DBA joke?
If you...
2010-06-02
415 reads
Blogs
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....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
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