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

Archives: April 2010

Marathon Schedule

Finally I am putting down to paper my marathon race list for this season. Some of my favorite races are Hurricane Half Marathon, HobbleCreek Half Marathon, Top of Utah Half Marathon, Top of Utah Marathon, St. George Marathon, and the Deseret News (Pioneer Days) Marathon. My normal season would have… Read more

4 comments, 1,450 reads

Posted in SQL RNNR on 30 April 2010

Six Months

“Show up for work on time for six months and then we’ll talk. Until then, I have four words for you: shut the fuck up.” – Kitchen Confidential

I wish people showed up and heard this on their first day of work. Too many people I think have a very… Read more

8 comments, 2,149 reads

Posted in The Voice of the DBA on 30 April 2010

PASS Update #30 (Surveys)

Recently we released the results of the annual survey to determine interests for the 2010 Summit. That’s a step in the right direction, sharing the results, but what we didn’t do was share what we thought we had learned from the results, and we were taken to task some by… Read more

6 comments, 2,024 reads

Posted in SQLAndy on 30 April 2010

Two Ways to Get System and Server Information on SQL Server from Management Studio / Enterprise Manager


To collect information for your SQL Server Infrastructure, there are two ways I can recommend. 
The first, as mentioned from Technet recently, is to execute the following parameter details on any SQL Server installation (I tested back to 2000), by run the following command.

exec xp_msver "ProductName", "ProductVersion", "Language", "Platform", "WindowsVersion",… Read more

2 comments, 9,944 reads

Posted in The Database Hive for SQL Server DBAs on 30 April 2010

SCRUM Training with Alistair Cockburn

I wanted the SCRUM Master certification this year, and could have gone local, but I wanted to get the training from Dr. Alistair Cockburn after watching a video of his training - and noting how great a teacher he is - and also after having read his impressive book Crystal… Read more

1 comments, 2,012 reads

Posted in Bill Nicolich on 30 April 2010

Windows 7 v the iPad

No, I didn’t buy an iPad, but I have to say on a trip to the Apple Store this week (for an iPod issue), I played with one for about 20 minutes and I came to this conclusion.

It. Is. Cool.

It’s not semi-cool. Or neat. It is very, very… Read more

3 comments, 2,076 reads

Posted in The Voice of the DBA on 30 April 2010


It seems to rear it’s ugly head more and more these days. Once again I found some content from my site republished on another site, without permission, and without a link.

I can’t speak for others, but if I knew you were plagiarizing content, I wouldn’t hire you. I believe… Read more

2 comments, 1,910 reads

Posted in The Voice of the DBA on 30 April 2010

A DMV A Day – Day 30

The DMV for Day 30 is sys.dm_os_buffer_descriptors, which is described by BOL as:

Returns information about all the data pages that are currently in the SQL Server buffer pool. The output of this view can be used to determine the distribution of database pages in the buffer pool according…

Read more

9 comments, 3,230 reads

Posted in Glenn Berry's SQL Server Performance on 30 April 2010


If you follow me on Twitter or are my friend on Facebook, you might already know the news. I am joining Microsoft next week as a Data Technology Specialist in St. Louis. It was really hard to leave my job as a DBA at Bryan Cave. Bryan Cave was my world for… Read more

5 comments, 1,947 reads

Posted in Advice from Aunt Kathi on 29 April 2010

When was SQL Server last restarted?

How do you tell when your SQL instance was lasted restarted?

I was reading a post by Joe Webb (Blog|Twitter) about a query he uses to to gather information about his clients SQL Server instance including how he find out when an instance of SQL Server… Read more

11 comments, 6,141 reads

Posted in The SQL DBA in the UK on 29 April 2010

SQLSaturday #41 - Atlanta Session Recap

Last Saturday, April 24, I presented my session, Why I Use Stored Procedures and You Should Too, at SQLSaturday #41-Atlanta, see my event summary here.  My session was in the last block of the day, which at this event was at 4:45PM, so it was a long day for attendees,…

Read more

1 comments, 1,421 reads

Posted in Wise Man or Wise Guy on 29 April 2010

PASS Update #29

By the time you read this we’ll have completed the transfer of the SQLSaturday web sites and data to PASS HQ, leaving only the clean up tasks of transferring the domain and the email aliases for active events, something we plan to do by the second week of May. It… Read more

0 comments, 1,434 reads

Posted in SQLAndy on 29 April 2010

A DMV a Day – Day 29

The DMV for Day 29 is sys.dm_exec_connections, which is described by BOL as:

Returns information about the connections established to this instance of SQL Server and the details of each connection.

This DMV can be used to help identify who and what is connecting to an instance of SQL… Read more

5 comments, 2,867 reads

Posted in Glenn Berry's SQL Server Performance on 29 April 2010

A Identity Bug

Someone asked an interesting question recently. If they had this code:

if OBJECT_ID('aa') is not null
   drop table aa
create table aa (id int identity(1,1))
set identity_insert aa on
insert aa (id) select -10 union select -11
set identity_insert aa off

insert aa default values

select * from… Read more

1 comments, 2,197 reads

Posted in The Voice of the DBA on 29 April 2010

How to Tell When SQL Server Started?

As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to me by the client. They don’t mean any harm, but different people in the organization have different perspectives and different memories. Sometimes it is difficult to know what is really… Read more

4 comments, 1,813 reads

Posted in Joe Webb on 28 April 2010

SQL Server Connection Strings

The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string for your SQL Server servers and databases.  This tip was first showed to me by a friend of mine, Paul Blackwell, a while back and I wanted to share it… Read more

442 comments, 13,470 reads

Posted in The SQL DBA in the UK on 28 April 2010

Undocumented Capabilities of Extended Event Objects

Undocumented Capabilities of Extended Event Objects

The extended event objects (objects exposed by an event package) are listed in the system catalog sys.dm_xe_objects. This dynamic management view is documented in Books Online, but it does not adequately document the capabilities_desc column. I understand from a member of the SQL… Read more

SQL University Post Coming Tomorrow

This is a short note to say that the SQL University post will arrive tomorrow. Today we're dealing with the funeral of a long time family friend, who passed away on Sunday somewhat unexpectedly. She lived a long life, and she will be missed. So if you're reading this, let me… Read more

Social Networking and SQLSaturday

I think we do a pretty good job of delivering technical content, but not such a great job at getting the attendees talking to each other. The speaker side of things has definitely turned into a social event, how do we do that for attendees?

I don’t have the answer… Read more

4 comments, 1,441 reads

Posted in SQLAndy on 28 April 2010

Backup Compression in SQL Server 2008 – The Complete Presentation

From the PASS 2010 Summit Survey: 29% of people want a presentation on backup compression. OK, here it is.

Turn it on:


Turn it off:


That’s it. If you want to script it, go here.

I saw Brent Ozar’s (blog, twitter) interpretation of the… Read more

9 comments, 2,332 reads

Posted in The Voice of the DBA on 28 April 2010

Older posts