Archives: April 2010
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
“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
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
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
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
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
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
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…
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
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
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
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
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
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
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
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
1 comments, 884 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 28 April 2010
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
1 comments, 504 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 April 2010
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
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.