Monthly Archives: March 2011

Microsoft DreamSpark for Students

If you, or anyone you know, is a high school or college student, Microsoft has a great program called DreamSpark that you should be aware of. This program is designed to give students lots of free Microsoft software, training and … Continue reading

Posted in Microsoft, Teaching | Tagged | Leave a comment

Are You Taking Advantage of Twitter for SQL Server?

One thing I always do lately, whenever I give a presentation is ask the audience how many of them use Twitter. In most cases, less than half of the audience is on Twitter, and it is often much lower than … Continue reading

Posted in PASS, Teaching | Tagged , | 9 Comments

Teaching Two Classes at University College–University of Denver

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

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

Boulder SQL Server User’s Group Meeting

I will be presenting at the Boulder SQL Server User’s Group (BSSUG) on March 15, 2011. My presentation will be on “Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance”.  Here is the abstract: The foundation of database performance … Continue reading

Posted in Computer Hardware, SQL Server 2008 R2, Teaching | Tagged , | 2 Comments

Mirrored Database Backups vs. Striped Database Backups

I have seen a few people get confused about the difference between a mirrored database backup (which is only available in SQL Server 2005 Enterprise Edition and above) and a striped database backup. A Mirrored Backup is simply a database … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 3 Comments

A Small Collection of SQL Azure Queries

We have been doing some more work with SQL Azure lately, so I have put together a small collection of queries that are pretty useful if you are working with SQL Azure. As a DBA who likes to know what … Continue reading

Posted in Microsoft, SQL Azure | Tagged , | 6 Comments