Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2010

Dynamically Backing Up All User Databases in SQL Server

I recently had a request from a client to come up with a routine to do a full compressed database backup of all of the user databases on an instance of SQL Server 2008. They wanted to be able to add and delete databases with having to worry about changing… Read more

2 comments, 791 reads

Posted in Glenn Berry's SQL Server Performance on 16 November 2010

SQL Server 2008 Service Pack 2 Cumulative Update 1

Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 1, which is Build 4266. I count 67 fixes in this Cumulative Update, which is meant to get the SP2 code branch in synchronization with SQL Server 2008 SP1 CU11. This means that you can migrate to the SP2… Read more

0 comments, 561 reads

Posted in Glenn Berry's SQL Server Performance on 16 November 2010

Handy Hardware Assessment Tools For SQL Server

Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you are interested in, whether it is a database server or a laptop. The first one is CPU-Z, which gives you very detailed information about your processor(s), motherboard, and memory.… Read more

4 comments, 1,082 reads

Posted in Glenn Berry's SQL Server Performance on 16 November 2010

New Path to MCM in SQL Server 2008

Last week, during the first day of the PASS 2010 Summit, Microsoft’s Joe Sack announced the revamped testing program for the Microsoft Certified Master (MCM) for SQL Server 2008. Previously, you had to pay roughly $20K to attend three consecutive weeks of intense training (from people like Kimberly Tripp,… Read more

2 comments, 543 reads

Posted in Glenn Berry's SQL Server Performance on 15 November 2010

SQL Server 2005 Diagnostic Information Queries (November 2010)

Here is the November 2010 version of my diagnostic information queries for SQL Server 2005. Many of these queries are DMV queries that require VIEW SERVER STATE permission in order to run. Some of these queries will also run on SQL Server 2008 and 2008 R2, but you are really… Read more

0 comments, 1,322 reads

Posted in Glenn Berry's SQL Server Performance on 15 November 2010

My Conversation with Ted Kummert at the PASS 2010 Summit

For some mysterious reason, I was selected as one of the “official” bloggers/tweeters during the PASS Keynotes last week. This meant that I got to sit at one of the three blogger’s tables in the back of the conference hall, just in front of the AV equipment. We had a… Read more

0 comments, 218 reads

Posted in Glenn Berry's SQL Server Performance on 15 November 2010

XBox 360 250GB and Kinect Bundle

I took the plunge and bought one of the new 250GB XBox 360 and Kinect bundles for $399 at Best Buy yesterday. Getting the bundle saves you about $100 over getting the 250GB XBox 360 and the Kinect sensor separately, since it also comes with the game Kinect Adventures.… Read more

0 comments, 327 reads

Posted in Glenn Berry's SQL Server Performance on 14 November 2010

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

I will be presenting my session on hardware selection and sizing today at 10:15AM in Room 608 at the PASS 2010 Summit. It will be the first session after the keynote address, and I will be going against some very well known and popular speakers in other tracks, so hopefully… Read more

0 comments, 303 reads

Posted in Glenn Berry's SQL Server Performance on 11 November 2010

Full-Text Search Enhancements in SQL Server Denali

Since Microsoft announced the existence of CTP1 of SQL Server Denali during Ted Kummert’s keynote address at PASS 2010 yesterday, they have made Books Online available in both Online form and as downloadable content that you can view offline.  The release notes are located here, and here is a… Read more

1 comments, 473 reads

Posted in Glenn Berry's SQL Server Performance on 10 November 2010

Why is SQLSaturday Such a Big Secret?

One of the small mysteries of the universe that I have been pondering lately is the fact that so many SQL Server professionals have never heard of SQLSaturday. When I was at SQLConnections in Las Vegas last week, I heard a couple of other speakers ask their audiences whether… Read more

5 comments, 178 reads

Posted in Glenn Berry's SQL Server Performance on 10 November 2010

Day 1 at SQLPASS Keynote Address

Microsoft announced the RTM of SQL Server 2008 R2 Parallel Data Warehouse, which will be available as an appliance in December from Hewlett Packard. They did a live demo on stage, running an 800 billion row query, using 40 nodes, that came back in 19 seconds. They also announced and… Read more

0 comments, 184 reads

Posted in Glenn Berry's SQL Server Performance on 9 November 2010

November 2010 Version of SQL Server 2008 Diagnostic Information Queries

Apparently, when I posted this a few days ago, the Windows Live Writer plug-in that I used mangled the T-SQL code pretty badly, so I am going to try again…

I am definitely going to get my blog moved over to Word Press after PASS!

 

-- SQL Server 2008 and… Read more

2 comments, 724 reads

Posted in Glenn Berry's SQL Server Performance on 9 November 2010

Official Blogger at 2010 PASS Summit

I will be one of the “official” bloggers during the 2010 PASS Summit, which means that I get to sit at the blogger’s table during the morning keynotes, where I will be expected to live tweet and live blog as much as possible during the keynote addresses each day of… Read more

0 comments, 183 reads

Posted in Glenn Berry's SQL Server Performance on 9 November 2010

Live Streaming Keynotes From PASS Summit 2010

I just wanted to help spread the word that the PASS Summit Keynotes will be streamed live via LiveMeeting next week. I always like watching keynotes, since they usually announce new products or releases, and they usually have cool demonstrations. Last year at PASS, Dr. David Dewitt gave a technical… Read more

0 comments, 240 reads

Posted in Glenn Berry's SQL Server Performance on 5 November 2010

Dr. DMV Queries From Fall 2010 SQLConnections Conference

This is the SQL Server 2008/2008 R2 version of the DMV Diagnostic Information Queries that I did for my Dr. DMV presentation at SQLConnections in Las Vegas today. Many of these queries will also work on SQL Server 2005, but I also have a SQL Server 2005 version of this… Read more

1 comments, 494 reads

Posted in Glenn Berry's SQL Server Performance on 4 November 2010