Big One Time Use Queries
There is a newer version of this posting, click here. Part of my regular database maintenance or tuning routine is to look for the queries… Read More »Big One Time Use Queries
Indexing Presentation – The Basics
Attached is the slide deck for a short presentation on indexing that was created to educate software developers on the basics of indexing. Outline: What… Read More »Indexing Presentation – The Basics
SQL Server 2008 R2 Compatibility Levels
There was no change to the compatibility levels between SQL Server 2008 and SQL Server 2008 R2. SQL Server can run in a number of… Read More »SQL Server 2008 R2 Compatibility Levels
What is SQL Server?
Originated as Sybase SQL Server Acquired by Microsoft and named Microsoft SQL Server in 1989 Recent Versions (2005, 2008, and 2008 R2) But what is… Read More »What is SQL Server?
Notes from the Introduction to SQL server class.
Here are the slide decks from the Introduction to SQL Server class – January 2010. Class 1 About the Instructor Introduction and Class Overview (Review… Read More »Notes from the Introduction to SQL server class.
Moving to a new datacenter – EPIC FAIL – Fibercloud.
The current datacenter has failed. The company that we have been using Fibercloud in Bellinhgam WA, with their “Always On” slogan has had an epic… Read More »Moving to a new datacenter – EPIC FAIL – Fibercloud.
Windows Shake in Windows 7
If you are using Windows 7, give this a try. When you have multiple windows all visible on your desktop, just click on the title… Read More »Windows Shake in Windows 7
Home after a week at SQL DevConnections 2009 in Las Vegas
This week I have been at the SQL Connections conference in Las Vegas. With 7 to 9 hours of classes and presentations every day, all… Read More »Home after a week at SQL DevConnections 2009 in Las Vegas
DevConnections – SQL Server Track
This week I am in Las Vegas attending the DevConnections conference on the SQL Server track. A whole week of classes on SQL Server.
How to Mount ISO Files on Windows 7
First off if you are not familiar with ISO files, an ISO file is a file that is a disk image of a a CD… Read More »How to Mount ISO Files on Windows 7