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 →

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>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 →

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>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 →

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 →