Sessions Submitted for SQL Saturday #120 Orange County CA

After being approved as a speaker at SQL Saturday 114 – Vancouver BC, and SQL Saturday 108 – Redmond WA, I have decided to give it another shot at SQL Saturday 120 in Orange County California.

I have submitted 2 abstracts for sessions:

The first one is titled Unleashing Common Table Expressions in SQL Server, and if accepted this will be the third time presenting this one on a SQL Saturday.

The next session which I will also be presenting in Vancouver BC is Using SSRS reports to analyze SQL Server health.

 

I am looking forward to travelling to sunny southern California for these presentations.  Nice to get away from the snow and rain for a while.

SQL Server Developer Edition – Under $50

Having taught several Introduction to SQL Server classes, it is always a challenge for new users to get SQL Server running on their computer for the first time. I have seen cases where people attempt to download the 90 day trial, if that even exists any more, or to download SQL Express. Here is my recommendation, for developers or anyone learning SQL Server if you need SQL Server on your laptop for a class or to just develop or try things out, then go for the SQL Server Developer Edition. SQL 2008 R2 developer edition is under $50 at Amazon.com.

My suggestion would be to go for the developer edition, it as all of the features of the full version and doesn’t expire after 90 days.

Session Accepted For SQL Saturday 108 in Redmond

I just checked the schedule and one of the sessions that I submitted for SQL Saturday 108 in Redmond WA on February 25th has been accepted.

I will be presenting Unleashing Common Table Expressions in SQL Server.

If you are going to be there, drop me an email and let me know.

This should be fun!

Snow in Bellingham….

At work today… The snowstorm shot of the Emergency Reporting parking lot in Bellinhgam WA.

Although it does’t look like that much snow, this is a lot for Bellingham.

image

Snowstorm in Bellingham today.

-STEVE STEDMAN

image

More snowing coming down in Bellingham today.

Latest Backups with TSQL

After rebooting a SQL Server, for whatever reason, it is always good to confirm that the system is running good.  There are many things that I check, one of which is to confirm that backups are running.

You can always go to the server browse to the various directories holding backups, and check on the latest files.  This can be difficult for servers with many databases.

Here is my quick check to confirm which backups are running on SQL Server. The query below gives you the 20 most recent backups that have been run.

SELECT TOP 20 database_name,
type,
backup_start_date,
backup_finish_date,
compressed_backup_size,
backup_size
FROM   msdb.dbo.backupset
ORDER  BY backup_set_id DESC;

In order to get the exact results you are looking for it may require you to add a where clause to filter on specific databases, or to expand the number of results in the TOP statement.

I hope that you find this as useful as I do.

You can also check this with charts and additional details using the Database Health Reports project.