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

Speaking at PASS Summit

I found out last week that I will be presenting three sessions at the PASS Summit 2013 in Charlotte, NC. The first one will be a full-day pre-conference session on Scaling SQL Server 2012. This will be an updated and reorganized version of the preconference session that I have…

Read more

1 comments, 356 reads

Posted in Glenn Berry's SQL Server Performance on 5 August 2013

24 Hours of PASS: Summit Preview Edition

The latest 24 Hours of PASS (24HOP) event will start at 12:00 GMT on July 31, with 24 back-to-back one hour live virtual sessions, ending exactly 24 hours later. I have the honor of presenting the final session of the event, so if you are up and about at 11:00… Read more

0 comments, 285 reads

Posted in Glenn Berry's SQL Server Performance on 30 July 2013

Hardware 201: Selecting and Sizing Database Hardware

On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download my deck here.

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

The foundation of database performance is the underlying server hardware and storage subsystem. Even the…

Read more

0 comments, 408 reads

Posted in Glenn Berry's SQL Server Performance on 26 July 2013

SQL Server 2008 Service Pack 3 CU12

On July 15, Microsoft released SQL Server 2008 Service Pack 3 Cumulative Update 12, which is Build 10.0.5844. I count six fixes in the public fix list.

If you are still running SQL Server 2008 (and I know many people are), you should be aware that only Service Pack… Read more

1 comments, 345 reads

Posted in Glenn Berry's SQL Server Performance on 23 July 2013

SQL Server 2012 Service Pack 1 CU5

On July 15, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 5. This is Build 11.0.3373, and I count 30 fixes in the public fix list. This CU is only for SQL Server 2012 Service Pack 1.

If you are running SQL Server 2012, I think you… Read more

0 comments, 586 reads

Posted in Glenn Berry's SQL Server Performance on 23 July 2013

OT: Kicked Out of a Motel for Charging at 12 Amps

This is a pretty long story…

My wife and I had an interesting road trip to Salida, CO this past weekend, going to the Colorado Brewer’s Rendezvous. We drove down from Parker, CO on US-285, which was 151 miles. I had a range-charge in my P85 before we left,… Read more

10 comments, 535 reads

Posted in Glenn Berry's SQL Server Performance on 16 July 2013

SQL Server Diagnostic Information Queries for July 2013

I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. Rather than having a separate blog post for each version, I’ll just put the links for all four versions here.

SQL Server 2005 Diagnostic Information Queries Read more

9 comments, 439 reads

Posted in Glenn Berry's SQL Server Performance on 9 July 2013

SQL Server 2008 R2 Cumulative Updates Released

Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. One is for SQL Server 2008 R2 Service Pack 1 and the other one is for SQL Server 2008 R2 Service Pack 2.

SQL Server 2008 R2 Service Pack 1 CU13 is Build 10.50.2876, and it has five… Read more

0 comments, 948 reads

Posted in Glenn Berry's SQL Server Performance on 17 June 2013

Speaking in Denver and Boulder in June

I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013 and at the Denver SQL Server User’s Group on June 20, 2013. In both cases, I will be presenting an updated version of  Hardware 201. Here is the abstract:

Hardware 201: Selecting and Sizing Database… Read more

0 comments, 366 reads

Posted in Glenn Berry's SQL Server Performance on 6 June 2013

New Immersion Event Classes at SQLskills

There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the two-day IEHW class on September 18-19.

I am really excited to get the chance to teach the IEHW class, and I think it will be a lot of fun! … Read more

0 comments, 365 reads

Posted in Glenn Berry's SQL Server Performance on 28 May 2013

Tesla Time

I now  have a red, P85 Tesla Model S. I picked it up at the Denver Tesla Service Center on May 3, 2013.  After slightly more than a week of ownership, I am still extremely happy. It is incredibly quick (0-60 in 4.0 seconds), it handles well, and it… Read more

10 comments, 479 reads

Posted in Glenn Berry's SQL Server Performance on 14 May 2013

SQL Server 2005 Diagnostic Information Queries (May 2013)

Here is the May 2013 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries.

To go with it is an updated, blank 2005 results spreadsheet, where the tabs in the spreadsheet are labeled and in the…

Read more

0 comments, 392 reads

Posted in Glenn Berry's SQL Server Performance on 8 May 2013

SQL Server 2008 Diagnostic Information Queries (May 2013)

Here is the May 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008.

To go with it is an updated,…

Read more

0 comments, 406 reads

Posted in Glenn Berry's SQL Server Performance on 8 May 2013

SQL Server 2008 R2 Diagnostic Information Queries (May 2013)

Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008 R2.

To go with it is…

Read more

2 comments, 409 reads

Posted in Glenn Berry's SQL Server Performance on 7 May 2013

SQL Server 2012 Diagnostic Information Queries (May 2013)

Here is the May 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have improved the formatting of the results to make many of the queries easier to read and interpret, especially for the missing…

Read more

0 comments, 316 reads

Posted in Glenn Berry's SQL Server Performance on 7 May 2013

SQL Server 2012 Diagnostic Information Queries (April 2013)

Here is the April 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the formatting of the results to make many of the…

Read more

3 comments, 416 reads

Posted in Glenn Berry's SQL Server Performance on 16 April 2013

New SQL Server Cumulative Updates

Microsoft has released three new Cumulative Updates for SQL Server today, two for SQL Server 2008 R2 and one for SQL Server 2012.

The first one is SQL Server 2008 R2 SP1 CU12, which is Build 10.50.2874. This CU has seven fixes in the public fix list.

The second… Read more

4 comments, 315 reads

Posted in Glenn Berry's SQL Server Performance on 15 April 2013

Speaking at SQLSaturday #197 in Omaha on April 5-6

I will be speaking on both Friday and Saturday (April 5-6) at SQLSaturday #197 in Omaha, Nebraska. I will be delivering a full day pre-con on Friday, and then doing Hardware 201 on Saturday. Here is the abstract for my pre-con:

Scaling SQL Server 2012

How can you scale SQL…

Read more

0 comments, 394 reads

Posted in Glenn Berry's SQL Server Performance on 25 March 2013

Scaling SQL Server 2012 in Lisbon, Portugal

I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon, Portugal. This was the first time I have spoken at a SQLSaturday outside of the United States, and I really enjoyed it! This never would have happened without the enthusiasm…

Read more

2 comments, 411 reads

Posted in Glenn Berry's SQL Server Performance on 16 March 2013

SQL Server 2012 Diagnostic Information Queries (March 2013)

Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the formatting of the results to make many of the…

Read more

3 comments, 575 reads

Posted in Glenn Berry's SQL Server Performance on 4 March 2013

Newer posts

Older posts