Where Do I Start With A Run Book?
On SuperUser.com, a question came up about how to do a proper Linux backup, including the applications installed, and associated configurations. In light of a… Read More »Where Do I Start With A Run Book?
Home » Archives for Randolph »
Randolph
On the importance of good backups
I’ve been vocal for some years about the importance of backups, and I have zero sympathy for anyone who does not have good backups*. This… Read More »On the importance of good backups
Adventures in @BlobEater, sp_WhoIsActive and DBCC CHECKDB
The latest version of sp_WhoIsActive (and apparently last for SQL Server 2005/2008, according to Adam Machanic), was released a week ago. Yesterday, out of curiosity… Read More »Adventures in @BlobEater, sp_WhoIsActive and DBCC CHECKDB
Remove duplicate indexes in SQL Server 2000
With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index… Read More »Remove duplicate indexes in SQL Server 2000
My brain hurts
Kimberly Tripp has a very neat series of stored procedures on her blog which are rewrites of sp_helpindex. Unfortunately for those of us with customers… Read More »My brain hurts
Increasing the number of SQL Server Error Logs
Via Tim Radney, here’s a quick and easy way to increase the number of error logs from the default of six. The blog post also… Read More »Increasing the number of SQL Server Error Logs
What I did today
Today at the clinic, we did the second of three phases of network reorganisation. In the first phase, which we completed a week ago, our… Read More »What I did today
Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000
For those of you battling with a 64-bit SQL 2005 Server linking to 32-bit SQL 2000 Servers, here’s a handy solution. This problem has been… Read More »Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000
- « Previous
- 1
- …
- 25
- 26
- 27