DBA Morning Check List
This article helps the DBA find and fix issues quickly by creating a DBA Morning Checklist.
2010-08-27 (first published: 2008-04-14)
56,030 reads
Bill Richards
Database Server Upgrades – The Plan, The Template, and The Task List
This article enables DBAs to efficiently upgrade servers by assembling an upgrade team, using an upgrade template, and communicating effectively.
2009-05-08
8,683 reads
Linked Server Optimization
This article demonstrates the negative affect that linked servers can cause in queries and offers alternatives to speed up performance.
2008-03-07
14,686 reads
Blogs
Join me at SQLBits 2020
The SQLBits conference is taking place in London again this year, between March 31st...
DBA, a job, a vital job
DBA, a job, a vital job. T-SQL a language that is fun. Select, a...
SOS_SCHEDULER_YIELD – What is it really telling us?
I decided to write this off the back of a conversation I was having...
Forums
Constraint on multiple columns
Hi, I want to restrict users from adding duplicate rows. Is there a way...
Table self-join for derived columns
Hi, I have a requirement to derive additional columns and populate the values by...
Ask SSC