Sessions Submitted for SQL Saturday #120 Orange County CA

January 30, 2012 by Leave a Comment

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.

Filed under Classes, CTE, Server Health, SQL Saturday Tagged with

Update available for the SQL Server Health Reports

January 8, 2012 by Leave a Comment

I am now getting back into things after the holidays.  Today I fixed a number of small layout related bugs in the SQL Server health reports.  The updated reports are now available for download.

 

Here is a sample of the Fragmented Indexes report.

Filed under Server Health Tagged with

2 Sessions Accepted for SQL Saturday 114 in Vancouver

January 8, 2012 by Leave a Comment

I just checked the schedule and 2 of the sessions that I submitted for SQL Saturday 114 in Vancouver BC on March 17th have been accepted.

The first one is on Unleashing Common Table Expressions in SQL Server, and the second session is Using SSRS reports to analyze SQL Server health.

This should be fun!

Filed under Classes, CTE, Server Health, SQL Saturday

Index Statistics Report added to the FREE SQL Server Health Reports

December 10, 2011 by Leave a Comment

In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project.

The new Index Statistics Report is the 8th report in the series, intended to give DBA’s and database developers access to the information they need to analyze the health of their database.

 

Here is a screen shot of the Statistics report.

Statistics that are out of date may impact the actual usage of those indexes.  With out of date or no statistics, SQL server can’t accurately make the decisions needed for a query to perform well.  You may get an index scan when an index seek may be the better solution.

Again this report is absolutely free something what I want to share with the SQL Server community.  If you have any questions, just send me an email or contact me on twitter @SqlEmt.

Filed under Performance, Server Health, SQL Saturday Tagged with , ,

Backup Set Report added to FREE Server Health Reports

December 8, 2011 by Leave a Comment

In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project.

 

The Backup Set Report has been added to the SQL Health Reports.  The Backup Set Report  is the 7th report to be added to the Database Health Reports package.

The Database Health reports package is a FREE collection of several reports that I have created to monitor and maintain the health of your SQL server.

 

With this report you can quickly check out the sizes and growth of the databases with the 10 largest backups.

 

 

 

Download it and enjoy.  If you have any feedback, please send it my way.

Filed under Recovery, Server Health, SQL Saturday Tagged with , , ,

Database Size report added to SQL Health Reports

December 7, 2011 by Leave a Comment

In preparation for a SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project.

 

The Database Size Report has been added to the SQL Health Reports.  The Database Size Report  is the 6th report to be added to the Database Health Reports package.

The Database Health reports package is a FREE collection of several reports that I have created to monitor and maintain the health of your SQL server.

 

With this report you can quickly assess the size of your databases and the logs to determine which may be growing faster than you expect.

Filed under Server Health, SQL Saturday Tagged with , ,

← Older posts