SQL Saturday 58 Schedule Released
We technically released it on Monday but I didn’t want to blog about it for a couple days since we...
2010-10-06
748 reads
StrateSQL
Return of Index Analysis Part 2
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-06
1,048 reads
5-Weeks to PASS Summit 2010 Countdown
With 5-weeks until the PASS Summit it’s time to start getting ready for the event. As I’ve discussed a couple...
2010-10-06
748 reads
PASSMN Board of Directors Nominations
It’s that time of the year again. Time to get in some nominations for the 2011 PASSMN Board of Directors. ...
2010-10-06
1,105 reads
SSWUG Fall 2010 Virtual Conference This Month
Conference Time! The SSWUG Fall 2010 Virtual Conference is coming up. On October 20-22, you can attend a conference from...
2010-10-05
706 reads
Return of Index Analysis Part 1
Let’s Anaylze An Index!Time for part two of my continued Index Analysis query. The previous posts in this series are:
Analyze...
2010-10-05
954 reads
Return of Index Analysis
Now that I’ve finished going through some of the details for sys.dm_db_index_operational_stats, it’s time to take that information and incorporate...
2010-10-04
451 reads
Index Black Ops Part 6 – Fill Factor vs. Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-10-02
1,612 reads
Create Empty Raw File
I need an empty Raw file for my SQL Server Integration Services (SSIS) package. Over the last summer I’ve discovered...
2010-10-01
739 reads
Index Black Ops Part 5 – Page Splits
In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in...
2010-10-01
885 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
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
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...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers