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

Archives: February 2009

Inserting Markup into a String with SQL

 There are a number of occasions when one might want to insert information at various places in a string. Where one has a template for reporting or emailing, for example; or maybe creating an HTML-formatted result.  Here is a method that I've used a fair amount, and which I'm refining… Read more

6 comments, 1,570 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 12 February 2009

Things You Know Now…

Someone tagged me, and I’ve lost the email in all the pile up from vacation where I was very, very unwired from work, despite being wired to the world. Actually I’ll make that one my first thing:

Know When to Walk Away

Not quit, not stop progressing on something or… Read more

3 comments, 921 reads

Posted in The Voice of the DBA on 12 February 2009

Word Up

A short post today. For a while I've been subscribing to the Word of the Day from Merriam-Webster (free) and I like it because it also includes a little background on the history of the word. I don't check it every day (yeah, I know that should be the plan),… Read more

1 comments, 571 reads

Posted in SQLAndy on 11 February 2009

Networking - Part 4

You may want to read Part 1, Part 2, and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let the social animal in us interact… Read more

2 comments, 497 reads

Posted in SQLAndy on 11 February 2009

Speaking at the West Palm Beach SQL Group in May 2009

Scott Klein invited me to speak to his group in West Palm Beach, so I'll be going down on May 7th, 2009 to do a presentation and also to do my evangelist thing for SQLSaturday (Scott is setting up to do one in August, details soon). If you're in the… Read more

0 comments, 458 reads

Posted in SQLAndy on 11 February 2009

Things I Wish I Had Known

I was tagged by Grant Fritchey (aka Scary DBA) in the latest get-to-know-you question.  This one asks, “What do you wish you had known when you started?”  I could go on for hours about the things I wish I hadn’t had to learn the hard way, but here are the… Read more

17 comments, 2,014 reads

Posted in Tim Mitchell on 11 February 2009

Registration for SQLBits in Manchester, England is Now Open

Registration for SQLBits IV, to be held in Manchester, England on Saturday, March 28, 2009, is now open. This free event is billed as the largest SQL Server conference in the United Kingdom, and it offers 28 different sessions, in 5 tracks, on many different aspects of SQL Server. See… Read more

0 comments, 532 reads

Posted in SQL Aloha on 11 February 2009

Counterpoint: Against Specialization

Brent Ozar wrote his Things you know now and in it he says this under his first point, Pick one thing and get really good at it:

"I’m not saying you should stop learning, but you should focus your learning on a very small surface area, and dive deeply into…

Read more

9 comments, 1,987 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 11 February 2009

New Security Bulletin for SQL Server 2000/2005 (MS09-004)

Affected Versions:

  • SQL Server 2000 SP4
  • SQL Server 2005 SP2

Unaffected Versions:

  • SQL Server 2005 SP3
  • SQL Server 2008

Original Vulnerability Report: http://www.securityfocus.com/archive/1/archive/1/499042/100/0/threaded

Microsoft Security Bulletin Link: http://www.microsoft.com/technet/security/bulletin/ms09-004.mspx

Brief Analysis:

The extended stored procedure, sp_replwritetovarbin, has a buffer overflow vulnerability which can be exploited to perform a remote code exploit… Read more

Kindle 2

The Kindle 2 was announced recently and it’s on sale at Amazon, starting shipping Feb 24, 2009.

I’m glad I didn’t wait to buy one as I’ve probably read 30-40 books since I got mine in early September and I’d have spent probably $60 or so more on books… Read more

2 comments, 691 reads

Posted in The Voice of the DBA on 11 February 2009


A mildly humorous title, spawned by a link my friend Jon sent me about calculating Pi using a batch file. Technically interesting, if less than useful. Made me curious what had been done with Pi in SQL, so went looking:

Read more

1 comments, 730 reads

Posted in SQLAndy on 10 February 2009

PASS Update #5 (Blogger's Please Read)

We'll be announcing this on the main www.sqlpass.org site and the PASS blog over the next day or two, but the first major revision of the blog directory has been posted. We had many people email us their blog info, some sent OPML containing their feeds, and then we spent… Read more

7 comments, 1,147 reads

Posted in SQLAndy on 10 February 2009

Things you know now...

This was the brainchild of Mike Walsh, who asked, "What do you wish you knew when you were starting?" I was tagged by Michelle Ufford, so here are my answers.

 "To Lead Is to Follow" - I've written about this before, but just understanding that at some… Read more

2 comments, 1,115 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 10 February 2009

Opening Up

I read Andy Warren’s PASS Update #3 the other day and I was amazed. Actually I’m late in getting this published due to a scheduleding conflict and Andy has Update #4 out now as well.

Update #3 had a tremendous amount of openness and information about PASS, more than I… Read more

0 comments, 573 reads

Posted in The Voice of the DBA on 10 February 2009

Notes on the 2009 South Florida Code Camp

As I mentioned last week I drove to Miramar for the South Florida Code Camp, arriving in time for the Friday night speaker party that we (End to End Training) hosted, and spent a great three hours just talking shop. Saturday morning I went over about 7:30 to see how… Read more

0 comments, 489 reads

Posted in SQLAndy on 9 February 2009

SQL Server 2008 Enterprise Edition install - use the "right" version of the Microsoft .NET 3.5 SP1 install

This is something that bit us over the weekend as we attempted to install two new SQL Server 2008 Enterprise Edition instances on a Windows Server 2003 failover cluster. The cluster already had existing SQL Server 2005 instances, but I don't think that matters. In any case, we went to… Read more

1 comments, 1,653 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 9 February 2009


I’m a little frantic this morning trying to get caught up on work, lots of stuff piled up, Tia leaving, kids had to get to school, etc. I need to run as well, which I was hoping to do early, but I might need to leave until before karate.

I… Read more

2 comments, 685 reads

Posted in The Voice of the DBA on 9 February 2009

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that… Read more

19 comments, 1,120 reads

Posted in SQLAndy on 8 February 2009

Reminder: MSDN Tiki Hut Roadshow Coming to Pensacola, Tallahassee, and More

Forwarding on a note from my local MS Developer Evangelist Joe Healy about his next series of free presentations coming up in Florida. While the "Tiki Hut" name may sound less than serious, it's intent is to bring free MSDN content to smaller cities that don't usually get a full… Read more

0 comments, 718 reads

Posted in SQLAndy on 8 February 2009

Professional Goals for 2009

Every time management / professional development book out there tells one to not only develop goals but actually write them down. That's the first real step to accomplishing them. One source I read suggested writing the goals as if you've already accomplished them. Because that puts you in the frame of… Read more

4 comments, 1,135 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 6 February 2009

Newer posts

Older posts