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

Archives: May 2007

Midlands PASS Chapter Meeting for June 6, 2007

Our next meeting will be on Thursday, June 7th, at 6:30 PM. Training Concepts will once again be our gracious host. I'll be speaking on the following:
Title: Making the SQL Server Security Model Work for You
SQL Server has a very robust security model with ownership chaining,…

Read more

Speaking at PASS 2007

I'll be doing a spotlight session called 'Transactional Replication for Beginners' this year. I've been speaking at the Summit since 2000 and have always tried to present a topic that would appeal to the beginner to intermediate users - part of my quest to improve the SQL world!

Speaking or…

Read more

0 comments, 1,340 reads

Posted in SQLAndy on 29 May 2007

Book Reviews

I've got a new article running on SSC today with a few more book reviews: http://www.sqlservercentral.com/columnists/awarren/2998.asp.

Read more

0 comments, 1,397 reads

Posted in SQLAndy on 23 May 2007

The Developer Differences

Here we are starting to see information on Katmai and I'm just getting around to an article comparing SQL 2005 and 2000. I had someone post a question a month or so ago and I couldn't find a good answer. So I created one.

As I was going through it,…

Read more

0 comments, 1,286 reads

Posted in The Voice of the DBA on 22 May 2007


I've spent my spare time the last few weekends helping a non-profit called Fast Forward here in the Columbia, SC area. I don't post this here to blow my own horn but rather to point out the need many non-profit organizations have for quality IT support. Most non-profits operate on…

Read more

Webcast on exceptions and errors in SQL Server

When you have an hour to spare, jump over and view this useful discussion about errors and exceptions in SQL Server:


Read more

0 comments, 1,417 reads

Posted in Tim Mitchell on 21 May 2007

Stored procs vs user defined functions

I was at DevTeach/SQLTeach in Montreal last week. The conference was very well run and the organizers did a great job. I gave two presentations, one of which was "T-SQL for Beginners".

During the presentation, a member of the audience asked me a question that I never really thought about… Read more

0 comments, 1,257 reads

Posted in Advice from Aunt Kathi on 19 May 2007

The BI World

It's been an interestng week here at the Microsoft BI Conference in Seattle and a first for me happened this morning. I was going over to the Steve Ballmer keynote and I got told "press" wasn't allowed in the session. So a young lady picked me out of the stream…

Read more

0 comments, 1,442 reads

Posted in The Voice of the DBA on 11 May 2007

No Excuse

I know writing and working on SQL Server is hard. It's a huge project and just managing that is hard. Andy and I argue about this all the time when we find things wrong. My feeling is that once a single person can't keep the entire project organized themselves, it…

Read more

0 comments, 1,342 reads

Posted in The Voice of the DBA on 4 May 2007

Midlands PASS Chapter Meeting Tonight

Our next meeting will be on Thursday, May 3rd, at 6:30 PM. Training Concepts will once again be our gracious host. Our speaker will be Sean McLean of DBA24Hrs (http://www.dba24hrs.net/)His presentation is:
  DBLaunch/SQLNitro - Deployment/Management/Compression tools designed with you in mind

Read more


Despite being without power for a few days, a hectic scramble at work to get things done, and kids off from school, I managed to take and pass the 70-431 exam last Friday. I had the book from Jordan and whoever (Sybex) that covered the exam and I spent a…

Read more

0 comments, 1,444 reads

Posted in The Voice of the DBA on 1 May 2007