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!
At work today… The snowstorm shot of the parking lot at work in Bellinhgam WA. Although it does’t look like that much snow, this is a lot for Bellingham. Snowstorm in Bellingham today. -STEVE STEDMAN
More snowing coming down in Bellingham today.
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 …
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.
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!
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 into a CTE, it can make sense to do multiple CTE’s. To use multiple CTE’s in a single query you just need to: Finish the first CTE Add a comma Declare the name and optional …
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 …
Index Statistics Report added to the FREE SQL Server Health Reports Read more »
Normally by blog/website is focused only on SQL Server topics, but this just jumped out at me and I have to share it. The holiday shopping season is here again, and so are the scammers. Here is a copy of an email message that I received today, wanting a few simple things like name, age, eye color, home city, …
It is sad when Santa Claus wants to break into your bank account. Read more »
In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. This report has been replaced with the Backup Report in the Database Health 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 …
Backup Set Report added to FREE Server Health Reports Read more »