2018 PASS Summit Community Speakers Announced
Today was the announcement of the 2018 PASS Summit Community Speakers, and I am fortunate enough to have been included on that list for the… Read More »2018 PASS Summit Community Speakers Announced
Today was the announcement of the 2018 PASS Summit Community Speakers, and I am fortunate enough to have been included on that list for the… Read More »2018 PASS Summit Community Speakers Announced
It can be a bit time consuming to work through the the SQL Server Management Studio (SSMS) user interface to check on the agent job… Read More »TSQL Script to Display Agent Job History
Its not always quick and easy in SQL Server to get a full list of the jobs that have been run, when they were run… Read More »SQL Server Script to Display Job History
Yesterday I blogged about submitting to SQL Saturday Denver, which is about 5 months away, after writing that post, I realized that I haven’t even blogged about SQL Saturday Redmond which is occurring in just over 2 weeks.
SQL Saturday #393 Redmond marks just 3 years since my first time speaking at a SQL Saturday #108 in Redmond. So lets take a look back, at Feb 5th, 2012, it was my first time presenting at a SQL Saturday ever, I had discovered this cool new query tool called the Common Table Expression, and I prepared my presentation. I practiced my presentation once before Saturday, and I was ready. Did I mention, that this was also my first time every attending a PASS event, or a SQL Saturday, and I was presenting. I was in the morning time slot after the keynote, and boy was I nervous. Over the next year I presented at I few other SQL Saturdays, and finally a book publisher, Joes 2 Pros noticed my presentation and asked me if I wanted to turn it into a book. In 2012 and 2013, I turned it into a book, which was released the same day as SQL Saturday #212 Redmond, where I again was selected to present on Common Table Expressions, this time I had books to give away as a prize.
>>> Try our online JOIN Types Course Today! As I have been working on the SQL Server JOIN Types poster, I have received several questions… Read More »FULL OUTER JOIN vs CROSS JOIN
The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END… Read More »SQL Sunday Fun – Word Search with SQL Server Keywords
Here is a quick rundown on the T-SQL DATEPART function for SQL Server. DATEPART is used to pull a single part of a date/time element… Read More »T-SQL DATEPART Explained