Category Archives: SQL Server Denali

Microsoft SQL Server Denali CTP 3 Product Guide

Posted on August 11, 2011 by Glenn Berry

Microsoft has released a Product Guide for SQL Server Denali CTP3, which has datasheets, white papers, technical presentations, demonstrations, and links to videos that will help you evaluate Microsoft SQL Server Denali. You can get to Books Online for SQL … Continue reading →

Posted in Microsoft, SQL Server Denali | Tagged | Leave a comment

Building or Buying a High Performance, Low Cost Desktop Machine for SQL Server Development and Testing

Posted on July 23, 2011 by Glenn Berry

There was a lengthy discussion on Twitter this morning, where one of my friends, Grant Fritchey (Twitter) was asking the community for suggestions about a good hardware setup that would enable him to run two to three concurrent virtual machines, … Continue reading →

Posted in Computer Hardware, Processors, SQL Server 2008, SQL Server 2008 R2, SQL Server Denali | Tagged | 15 Comments

Presenting Two Sessions at PASS Summit 2011

Posted on June 19, 2011 by Glenn Berry

I found out earlier this week that I was fortunate enough to have my half day session on “Scaling SQL Server” accepted for the PASS Summit 2011, which was quite a pleasant surprise! I had previously been informed that I … Continue reading →

Posted in Computer Hardware, PASS, SQL Server 2008, SQL Server 2008 R2, SQL Server Denali, Teaching | Tagged | 1 Comment

PASS Announces Pre-conference and Spotlight Sessions for PASS 2011 Summit

Posted on June 1, 2011 by Glenn Berry

Today, PASS announced the Pre-conference and Spotlight Sessions for the PASS Summit 2011 in Seattle, which will run from October 11-14, 2011. I actually found out last week that I was lucky enough to be selected for a 90 minute … Continue reading →

Posted in PASS, SQL Server 2008 R2, SQL Server Denali, Teaching | 1 Comment

Getting More Hardware Information from SQL Server Denali DMV Queries

Posted on April 6, 2011 by Glenn Berry

As I recently discussed, I often hear from database professionals who are not allowed to access their database servers directly. Instead, they can only use SQL Server Management Studio (SSMS) to remotely manage the database servers that they are responsible … Continue reading →

Posted in Computer Hardware, SQL Server Denali | Tagged , | 1 Comment

Adding a processor_description column to sys.dm_os_sys_info in SQL Server Denali

Posted on April 5, 2011 by Glenn Berry

I opened a new Connect Item today, asking Microsoft to add a new column to the sys.dm_os_sys_info DMV in SQL Server Denali. This seems like a pretty easy change that would be extremely useful, especially for the many database professionals … Continue reading →

Posted in Computer Hardware, Microsoft, Processors, SQL Server Denali | Tagged , | 2 Comments

Teaching Two Classes at University College–University of Denver

Posted on March 18, 2011 by Glenn Berry

I will be teaching two classes for the Spring 2011 Quarter at University College – University of Denver. One will be on campus, and one will be online. The on campus class will be ICT 4415 Database Backup and Recovery … Continue reading →

Posted in SQL Server 2008 R2, SQL Server Denali, Teaching | Tagged | Leave a comment

SQL Server Denali CTP1 Diagnostic Information Queries

Posted on March 16, 2011 by Glenn Berry

Here is the first SQL Server Denali–specific version of my Diagnostic Information Queries. There are actually only two queries (which are marked in the script) that are different from the SQL Server 2008 and 2008 R2 version of these queries. … Continue reading →

Posted in SQL Server Denali | Tagged | 2 Comments

SQL Server Videos on Channel 9 From Microsoft

Posted on March 9, 2011 by Glenn Berry

Here is a collection of 13 short (less than 10 minutes each) videos about improvements in SQL Server Denali, and in some cases SQL Server 2008 R2 that are posted on Channel 9. They were all added on March 4, … Continue reading →

Posted in Microsoft, SQL Server 2008 R2, SQL Server Denali | Tagged | 2 Comments

Don’t Be Afraid of Windows Failover Clustering!

Posted on February 28, 2011 by Glenn Berry

One of the more exciting features in SQL Server code-named “Denali” (which is the current official name for the next major version of SQL Server) is called SQL Server AlwaysOn, which Microsoft describes like this: The new SQL Server AlwaysOn … Continue reading →

Posted in SQL Server Denali | Tagged , | 2 Comments