A great day at SQL Saturday in Vancouver BC
I spent the day today at SQL Saturday in Vancouver BC. I met some fabulous SQL Server professionals, and presented 2 sessions. The first… Read More »A great day at SQL Saturday in Vancouver BC
SQL Server
4 Sessions Submitted to Seattle Code Camp
It has been a busy week getting ready for SQL Saturday Vancouver, planning sessions to present at future training’s and determining new material to present.… Read More »4 Sessions Submitted to Seattle Code Camp
How big is your procedure cache?
Part of SQL Server running queries is that once a query is analyzed, parsed and compiled, that compiled plan is kept in memory so that… Read More »How big is your procedure cache?
SQL Server Health Report Updated – Top IO added
In preparation for SQL Saturday 114 in Vancouver on March 17th, I have been updating and finalizing the SQL Server Health Reports. The upload today contains… Read More »SQL Server Health Report Updated – Top IO added
Multiple CTE’s in a single Query
Common Table Expressions are a great way to simplify complex derived table queries. If it makes sense to break out one derived table or subquery… Read More »Multiple CTE’s in a single Query
Determining free disk space with TSQL
Working on a new report for the SQL Server Health reports, I needed to display the amount of free disk space on a SQL Server.… Read More »Determining free disk space with TSQL
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?
Questions and Answers Website.
Tonight I created the Questions and Answers website. My wife was watching Mamma Mia (the movie), and that lost my interest quickly so I went… Read More »Questions and Answers Website.
Database Tuning at Emergency Reporting
This week I started working at Emergency Reporting doing database performance tuning and scalability work. Currently this is a half time gig focused on SQL Server… Read More »Database Tuning at Emergency Reporting
SQL Server 2005 Compatibility Level
SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility… Read More »SQL Server 2005 Compatibility Level