Today I am happy to announce that Database Health Monitor Beta 10 has been released. Click here to go to the download page. The following changes have been made since Beta 9.3. New Features Updated new, fresh icon. Adding filegroup and partitioning key into the partitioning report. Added linking to the IndieGoGo campaign to help fund the next beta. Bug …

Database Health Monitor Beta 10 Released Read more »

This weeks training as part of the Free SQL Training for the 70-461 certification course is now available on YouTube. This week we covered Aggregating Data and Aggregation strategies.  For more information on sessions, take a look at the Free SQL Training course that we have outlined. TSQL Aggregation video The first half is presented by Aaron Buma and the second …

TSQL Aggregation Strategies and Aggregating Data Read more »

I have been asked to help a development team with training so that they can all take and pass the SQL Queries 70-461 Microsoft certification. After looking it over and understanding all the topics needed for the 70-461 SQL Queries certification, Aaron Buma and I we have worked out a plan to get everyone on the development team through this training. …

Free SQL Server Training Read more »

I am starting to fill out my schedule for SQL related conferences to attend this year, and I wanted to if anyone has any favorite conferences that I may be overlooking. PASS Summit 2015 is the big, must attend conference, and SQL Saturdays are always good, but I am interested in what other conferences people have found interesting. So, if …

What are your favorite SQL Conferences / Trainings? Read more »

Coming from a SQL Server, and PHP background, I often get asked, does SQL Server work with PHP? The answer is YES. I have been using SQL Server and PHP together in a high availability load balanced environment with multiple data centers for the last 4 years. Microsoft offers drivers that plug into PHP to allow the connectivity. You get support …

Does SQL Server work with PHP Read more »

Today I had the pleasure of releasing Beta 9.3 of the Database Health Monitor. It has been a whole week since the last beta update, and here is the outline of the new features and bug fixes. Download at DatabaseHealth.com New Features New report, Partitioned Tables. This new report shows all of the partitioned tables in a database. Double clicking …

Database Health Beta 9.3 Released Today Read more »

I released Database Health Monitor Beta version 9.2 today.  No new features, just lots of bug fixing. I don’t want to make it sound like database health reports is unstable, it is very stable, however with any software there are occasionally unexpected things that cause a crash. My goal is to get Database Health monitor as close to zero crash …

Database Health Monitor Beta 9.2 Released Today Read more »

As the DBA, you get a call from the IT Team who monitors disk space and they tell you the following: “One of our server that has SQL Server running on it is running low on disk space. It has gone from around 60% disk utilization to 95% disk utilization just overnight. What’s the problem?” In this case it happens …

My SQL Server is Out Of Disk Space Read more »

Today I have released beta 9 of the Database Health Monitor. It has been 27 months since the release of Database Health Beta 1, and almost 4 years since the original SSRS implementation of Database Health reports. To be honest for the first half of 2014, I didn’t contribute much to the Database Health Reports, then in the couple of …

Database Health Reports Beta 9 – Released Read more »