Next Week’s Free SQL Training: MERGE Statement and Recursive Queries

Next week, on Thursday Feb 26th Aaron Buma and I, as part of the Free SQL Training provided by Emergency Reporting, will be presenting on the use of the MERGE Statement and how to do Recursive Queries. This is intended to help prepare TSQL Developers for the 70-461 certification exam.

Here is the basic abstract for the presentation:

This will be a free training provided by Steve Stedman and Aaron Buma at Emergency Reporting to prepare for the Microsoft 70-461 SQL Queries exam. This week we will be two topics, first on the MERGE Statement, then Recursive Queries.  This is provided free of charge to give back to the SQL community.

You can watch via Google On Air Hangouts at this link: https://plus.google.com/u/0/events/cma01e76ll4kfsaopdj6jue1gno

A week ago we touched slightly on recursive queries in the CTE presentation, in this session I will go into much more detail on the recursive queries.

 

For more information:

 

Next Free SQL Query Training – OUTPUT Clause and Derived Tables

On Thursday Feb 19th at 9:00am pacific time, Aaron Buma and I will be doing another FREE SQL query training session.

This is a free training provided by Steve Stedman and Aaron Buma at Emergency Reporting to prepare for the Microsoft 70-461 SQL Queries exam. This week we will cover OUTPUT Clause and Derived Tables.  This is provided free of charge to give back to the SQL community. I would like to thank our employer Emergency Reporting for providing us the time to prepare and present this training to the SQL Community.

  • —OUTPUT Clause
  • —Derived Table Queries (ie Subqueries)
    • —Correlated Sub Queries
    • —Sub Query Extensions (ANY, ALL, SOME)
    • —Exists

Here is the link to the Google On Air Broadcast for the session.

CoverSlide

 

This will be about a 90 minute session Aaron Buma will present about half, and I will present the other half. After the live broadcast is over, the recorded session will be available on my YouTube channel for watching later.

See Also:

Database Health Monitor Beta 10 Released

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 Fixes

  • Improved background processing, better handing of SQL connection failures.
  • Improved error handling on all background threads when attempting to connect to a database. Better handling when the connection fails.
  • Improved error handling on the pie chart on click event.
  • Updated copyright line to 2015.
  • Fixed crashing bug in the technical debt report.
  • Fixed bug causing a crash on the Table Size Advisor.

Other Notes

Due to the increased demand on my time to complete the next beta, I have created an IndieGoGo campaign to help fund the next beta version. If you haven’t heard of IndieGoGo, its sort of like KickStarter, it is a crowd funding site. Please give something if you can to help me fund the next beta release. http://igg.me/at/DatabaseHealth11

CrowdFunding

Any help towards my goal for the next beta would be greatly appreciated.

-Steve Stedman

What are your favorite SQL Conferences / Trainings?

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 you have a favorite SQL conference, please add a reply to this post, I would be very interested in hearing what the community may recommends.

Database Health Monitor – Beta 8 – Soft launch

Today I launched Database Health Reports Beta 8 as a soft launch. What I mean by the soft launch is that other than updating the DatabaseHealth website and this blog posting, I haven’t done much to promote it.  Why you might ask?  Due to it being a holiday week between Christmas and New Years, there are many people out of the office. I figured I would wait until after January 1st to make a big splash.

Beta 8 is out. The biggest change is the charting. About 75% of the charts in the system have been completely rewritten. I was using a charting module that didn’t allow for the flexiblity that was needed to make the charts look the way I wanted. In September right after the Beta 7 release I started rewriting the charts from scratch.  Between now and the next Beta I will work to get more of the charts converted over to the new look.

Here is an example of some of the newer charts. The red and green bars on the plan cache are used to indicate change.  Red indicates that the value was worse, and green indicates that it improved or stayed the same. The CPU by database chart was rewritten to make better use of the available space.

New Charts

 

Also shown in the above screen shot is the new Server Configuration panel with details on the specific version of SQL Server, when it was installed, the number of processors and more.

Beta 8 Release Notes

Beta 8 Released 12/29/2013.

The following changes have been made since Beta 7. The big feature in the Beta 8 is the rewrite of many of the charts.

New Features

  • Renamed to Database Health Monitor, attempting to avoid confusion with SSRS Reports.
  • Additional checks for obsolete or unusual settings (SHRINK_DATABASE, TORN_PAGE_DETECTION).
  • Blocking reporting with hierarchical drilldown on the blocking queries.
  • Server details panel showing logical and physical cpu counts, SQL Server Start time, SQL Server install data, Server Name, SQL Server version info, and information on real or virtual server.

Bug Fixes

  • Multithreading the re-connect of databases, vastly improving the startup time if one or more databases is not available.
  • A large amount of the project has been refactored to help mature the product and allow for additional feature growth, and reduce bugs.
  • Improved background threading.
  • Updates and bug fixes on SQL Technical Debt.

SQL Server Performance for Developers

For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to properly use parameterized queries, using the query analyzer, and avoiding common SQL Server performance pitfalls.

PerformanceTuning

This presentation is a lot of fun. This is one of the few presentations where there is audience participation. Four luck participants will be selected to help simulate the work that SQL Server does when accessing tables structured with different types of indexes.

Download the presentation here:

PerformanceTuning.zip

If you are interested in performance, please take a look at the Database Heath Monitor.