SQL Saturday #74 Session Recap
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some...
2011-05-04
517 reads
Writing Better Emails
In January 2009, I made the transition back to being a senior DBA. One of the first things my manager...
2011-05-04
2,941 reads
How do you create or update stored procedures.
G’day,
Running object creation scripts into other environments is a big part of most DBA’s work – especially when a new system...
2011-05-04
17,955 reads
May 2011 S3OLV Meeting
After a whirlwind of last minute changes last month, we expect stability this month with the monthly meeting. Meeting Time is 6:30PM PST Erika Bakse (blog | twitter) has...
2011-05-03
10 reads
May 2011 S3OLV Meeting
After a whirlwind of last minute changes last month, we expect stability this month with the monthly meeting.
Meeting Time is...
2011-05-03
583 reads
T-SQL Tuesday #18 Coming Next Week
Other than the week I hosted it, I’ve been caught off guard by T-SQL Tuesday most months. This time I...
2011-05-03
690 reads
Indexing for ORs
All of the indexing strategy posts I’ve written in the past have been concerned with predicates combined with ANDs. That’s...
2011-05-03
1,026 reads
How often do you check email?
If you read the experts, most folks check their emails too many times during the day. Today, while giving a...
2011-05-03
796 reads
Iterating Over Columns in the SSIS Script Component
Just recently a question was posed in the MSDN SSIS Forums about how to create a "generic" script component that would read all columns for each row passed through...
2011-05-03
22 reads
Iterating Over Columns in the SSIS Script Component
Just recently a question was posed in the MSDN SSIS Forums about how to create a "generic" script component that would read all columns for each row passed through...
2011-05-03
153 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