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

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: May 2010

Is Pivot Worth it?

I’ve been trying to learn more about the T-SQL changes in SQL Server 2005/2008 over time. I don’t have requirements to write a lot of T-SQL, so I have to futz around with it and just try things I see in articles or presentations. One that I’ve been meaning to… Read more

6 comments, 599 reads

Posted in The Voice of the DBA on 11 May 2010

Creating a Server Audit - SSMS

Building an audit in SQL Server 2008 is very easy, much easier than in previous versions using SQL Trace. That was painful, and I am glad that it’s not required anymoer.
Building a server audit consists of first setting up the audit. You do that in SSMS through the…

Read more

3 comments, 1,608 reads

Posted in The Voice of the DBA on 10 May 2010

SQL Saturday #49 – Call for Speakers

SQL Saturday #49 in Orlando just opened their call for speakers. I’m debating if I want to go out there. The event is on Oct 16, 2010, and this is always one of the larger SQL Saturday crowds. I have a lot of friends there, but I was hoping… Read more

3 comments, 839 reads

Posted in The Voice of the DBA on 6 May 2010

Internal Marketing

I heard this recently at my company. Our group, which is relatively removed from the main business of writing software, doesn’t always have the best relationship with everyone else. I think some of it might be that they don’t understand what we do, and some might be that they don’t… Read more

6 comments, 701 reads

Posted in The Voice of the DBA on 6 May 2010

Getting a Page of Results

The other day I was looking over a couple of articles on paging, looking to see if I could learn something new in T-SQL. I’ve implemented some SQL2000 era paging systems, none of which performed wonderfully, so I checked out Jacob Sebastian's basic Server Side Paging and Paul White’s Optimizing… Read more

2 comments, 373 reads

Posted in The Voice of the DBA on 5 May 2010

CLR Stability

Recently I was at a UK user group meeting and Simon Sabin of SQL Skills presented a short “SQL Nugget” on UDFs and some of the issues with performance. He then showed a better way using a TVF and mentioned that in many cases the CLR can perform on par… Read more

1 comments, 594 reads

Posted in The Voice of the DBA on 4 May 2010

A Glimpse of the Future

I’m not sure what happened here. I walked up to my desktop, wiggled the mouse, and nothing happened. In the true definition of insanity, I then did it a few more times and achieved the same result. Hitting the keyboard didn’t help and it appeared frozen.

Weird, but no cause… Read more

8 comments, 491 reads

Posted in The Voice of the DBA on 4 May 2010

When Did SQL Server Restart?

I saw Joe Webb’s post, and then Gethryn Ellis’ post as well on when SQL Server last restarted. It’s something that can be handy when troubleshooting and trying to figure out what’s going on with SQL Server.

I’ve also used it to track potential issues as well, like when… Read more

3 comments, 405 reads

Posted in The Voice of the DBA on 3 May 2010

Newer posts