Next Weekly Training: Functions (Logical Functions, Time Functions, and UDFs)

On Thursday March 19th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I at Emergency Reporting to prepare for the Microsoft 70-461 SQL Queries exam. This week we will be a three part session on functions. This is provided free of charge to give back to the SQL community.

CoverSlide

We have been getting quite a following so far with about 8 of us on the team at Emergency Reporting watching live in the conference room, and about 20 other viewers watching live remotely each week. My goal is to share this with as many people as possible, and to one day have over 100 live viewers each week. Please share the Google Live Broadcast with as many people as possible.

Here is the outline:

  • Time Functions
  • Logical Functions
  • User Defined Functions

Here is the link to the Google On Air Broadcast where you can watch for free.

https://plus.google.com/events/cb0pj9ghp5elt6i241kstphcvr0

This session will be about 90 minutes, Aaron Buma will present about half and I will present the other half. After the broadcast is over, it will be made available on YouTube for replay.

See Also:

Using Cursors, followed by Using String Functions

On Thursday March 12th at 9:00am (pacific time), we will be hosting another free training provided by Aaron Buma and I at Emergency Reporting to prepare for the Microsoft 70-461 SQL Queries exam. This week we will be a two part session Using Cursors, followed by Using String Functions. This is provided free of charge to give back to the SQL community.

Here is the outline:

  • Using Cursors
  • Using String Functions

Here is the link to the Google On Air Broadcast where you can watch for free.

https://plus.google.com/events/ci8jms67qttuteegimrf4sj70sk

This session will be about 90 minutes, Aaron Buma will present about half and I will present the other half. After the broadcast is over, it will be made available on YouTube for replay.

See Also:

 

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.