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. …
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 …
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 …
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 …
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 …
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 …
Last week the Uzility team did a number of live broadcast training sessions covering details on getting started with Uzility, importing cards, working with cards and everything else that you might want to know about Uzility. Here is the overall full length video training session.
If you owned a convenience store, or other business that was likely to get robbed you would likely have surveillance cameras with the intention of having evidence to provide the police with the information that they need in order to track down and prosecute the person who may rob the store. Most of our databases have far more value to …