Derrick Leggett Blog

Ramblings, grumblings, and other nonintelligible nonsense about SQL Server.

<b>Migrating SQL Servers</b>

I see a lot of question on the forums about migrating to new servers.At all the companies I have worked at, we have implemented server build processes to help with this process and also document needed DR procedures. Read more →

Have I mentioned???????

That EMC sucks!!!! :) We lost yet another hard drive today on the CX-700. I would say I'm surprised, but lightning would strike me dead on the spot. We are buying EMC Replication Manager, which will allow us to save a LOT of disk space. Read more →

SQL Server 2005 September CTP

We are now running full-speed with SQL Server 2005 at work. I have my team testing the new features and spending part of each week learning the technology. I've been telling everyone how much there is to learn. Read more →

<b>SQL Server 2005 Install Notes</b>

I've now installed SQL Server 2005 about 18 trillion times since the first beta came out. :) Seriously, since I have been trying to take all the free webcasts, training, etc that's out there and ramping up my skillset on the new technology, I have completed around 25 installs of the product. Read more →

<b>Virtual Server 2005 Woes</b>

I’m using Virtual Server 2005 to setup all my labs and training sessions that I’m trying to write for SQL Server 2005.I ran into a little problem when I tried to install Visual Studio 2005 on the virtual machines though. Read more →

<b>SQL Server SP4 Rollout</b>

As we all know, SQL Server SP4 arrived on the scene late last week.It’s been a LONG time since we’ve had a major service pack release for SQL Server 2000, so this service pack is very large. Read more →

Oracle and jhermiz

Oracle and jhermiz This has been a test of absolutely nothing. I do believe this might be the most ridiculously stupid blog post I ever make. :) Legacy Comments Brett (Not just a Number. Read more →

SQL Server 2005 Free Training

Microsoft has set up virtual labs for people to train on their new technologies, including SQL Server 2005. You can find them here. The labs I have taken so far are really good for an introduction to SQL Server 2005 and Visual Studio technology. Read more →

<b>Applications that SUCK!!!!!</b>

In this world of third-party insanity, I'm constantly amazed how much companies spend for third-party applications that are written like crap and have ZERO security. Lately, I've been plagued by a series of third-part applications using the sa username and password. Read more →

SQL Server Datetimes

I feel like posting today. :) We get asked about datetime formats a lot on the forums. Here is a simple little script to tell you what formats SQL Server supports using the CONVERT function. Read more →

<b>SOX Auditing Companies SUCK!!!!</b>

Just gotta rant for a second. (I know it's hard to believe.) There are only a few approved SOX auditing companies out there currently. The law is so broad in scope, yet undefined, that auditing companies really have no idea what they are auditing for. Read more →

<b>Database Security Initiative</b>

Physical Database Security ·Move a SQL Server out of DMZ (this one was ticking me off). --Completed. ·Create new VLAN's for SQL Server and migrate servers.--Completed. oCreated four VLAN's to provide separation of database servers on network. Read more →

PASS 2004 - Part 4

I know this is a little late, but I wanted to finish it up for my own purposes. The final day of PASS was incredible. Anytime you get a chance to listen in on Kimberly Tripp you should take that chance and remember it. Read more →

PASS 2004 - Part 3

WOW....what an interesting last couple days. I was priviliged to attend a couple incredible meetings. I was unfortunate enough to attend a session that was not so great (cough, cough)!!!!! Such is life in the world of conferences. Read more →

PASS 2004 - Part 2

High Availability with SQL Server 2005 This was a great session. It was cut a little short by an EMERGENCY EVACUATION!!! Go figure. :) It focused on the new enhancements that SQL Server 2005 has added to provide for greater flexibility and implementation of high-availability networks. Read more →

PASS 2004 - Part 1

Just thought I'd give a brief rundown of what's going on at PASS. I just attended the keynote address and my first session. The session was Developer Productivity and Server Extensibility with SQL Server 2005. Read more →

<b>SQL Server redundancy options</b>

This recently came up as a discussion on the forums. I posted the options below and Kristen suggested I post it in my blog, so here it is. :) This is by no means meant to be comprehensive. Read more →


We are currently putting processes in place to comply with the Deloitte & Touche interpretation of Sarbanes-Oxley for our internal audit department, and for certification of compliance with Deloitte & Touche. Read more →

Moving system databases 101

This is something I see posted continuously on various forums. Some fine, young idiot on one forum yesterday said the solution was to just detach and attach all the system databases. Read more →

<b>Yukon…Let the ride begin!!!!</b>

I got to attend the second part of a Yukon review last week that was really informing and interesting. It covered some of the basics which I had already seen, such as the additions to Transact-SQL (pivot, apply, etc). Read more →