SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2007

Midlands PASS Job Board

In order to assist those members of the Midlands PASS Chapter looking for new positions, I have put up a job boards page here:


Positions will stay up for two weeks or when the original submitter tells me the position is no longer available, whichever comes first. We've got…

Read more

0 comments, 1,039 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 26 February 2007


Boy that was fun. Getting a bunch of emails that we had been hacked and tracking down someone updating all of our link addresses with their name. Fortunately it didn't take too long to fix, but it certainly was a pain.

I know we're vulnerable to SQL Injection in quite…

Read more

1 comments, 1,175 reads

Posted in The Voice of the DBA on 22 February 2007


Mentioned by Tim Mitchell, but SP2 is out.

Seems more like enhancements to make things smoother and lots of changes in response to complaints I've seen voiced by people. I think the relatively small number of bug issues addresses speaks to the amazing work that has been done on this…

Read more

0 comments, 1,131 reads

Posted in The Voice of the DBA on 20 February 2007

SQL Server SP2 released

Today, Microsoft released Service Pack 2 for SQL Server 2005. Though mostly a series of fixes for minor issues, there are a couple of new breakthroughs. Most notably is the new vardecimal data type, which is as its name suggests a variable length decimal value (though the initial press release…

Read more

0 comments, 1,094 reads

Posted in Tim Mitchell on 19 February 2007

Microsoft SQL Server certification

A few weeks ago I was engaged in a useful discussion about the merits of getting certified on Microsoft SQL Server.  A number of people I've talked with about the MCDBA certification share my opinion that these tests were too easy and therefore held limited value to one's career.  After…

Read more

4 comments, 1,518 reads

Posted in Tim Mitchell on 18 February 2007

Daylight Saving Time and SQL Server

If you're in the United States, chances are you've already heard about Daylight Saving Time (DST) occurring 3 weeks early this year. This is due to the Energy Policy Act of 2005, so it's not new news, but a lot of systems and applications are only now getting the…

Read more

8 comments, 2,163 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 13 February 2007

Midlands PASS Site Online

I have put the Midlands PASS site online temporarily at Truth Solutions. You can reach it here:


The slides from Paul Shearer and Bill Stevenson's presentation, Performance Monitoring for SQL, has also been posted to the site. This is from the most recent meeting on February 8, 2007.

Read more

0 comments, 1,228 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 12 February 2007

Guest Editorial Week

I've been writing the editorials for over two years now and it's become an almost daily part of my life. I say almost daily because I learned after 6 or 7 hard months that I need to try and get ahead a couple of days, especially when I'm busy or…

Read more

0 comments, 1,106 reads

Posted in The Voice of the DBA on 11 February 2007

Midlands PASS February Meeting Postponed

We are postponing due to the weather. Training Concepts has shut down for the day due to the wintry mix. Their personnel has offered to come back and open the doors if we wanted to hold the meeting, but in the interest of everyone's safety, we'll postpone the meeting until…

Read more