SQL Sunday Word Scramble
SQL Server – TSQL Analytics Word Search Find the following words in the word scramble above. TOP RANK DENSE_RANK ROW_NUMBER NTILE OVER LAG LEAD FIRST_VALUE… Read More »SQL Sunday Word Scramble
TSQL Queries – Using NTILE
NTILE is a SQL Server function that can be called in a TSQL Query. This is part of the free sql query training to prepare… Read More »TSQL Queries – Using NTILE
SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs
The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam. Next… Read More »SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs
TOP, Ranking, NTILE, and Aggregate Functions
Continuing our weekly SQL Query Training for the 70-461 exam preparation, at Steve Stedman, sharing this weeks class with the world. Free SQL Query… Read More »TOP, Ranking, NTILE, and Aggregate Functions
Downloads for this weeks SQL Training
As posted earlier. This weeks SQL Queries training for the 70-461 certification will be on Thursday at 9:00am (US pacific time). Please join the live… Read More »Downloads for this weeks SQL Training
Whiteboard Interview Questions
Last week Aaron Buma and I were attended a session at Western Washington University where we were asked to present to the ACM club on how to… Read More »Whiteboard Interview Questions
This Weeks SQL Server Queries Training
This weeks SQL Queries training for the 70-461 certification will be on Thursday at 9:00am (US pacific time). Please join the live broadcast on Google… Read More »This Weeks SQL Server Queries Training
TSQL Aggregation Crossword Puzzle
Based on this weeks Free SQL Server training on Aggregation, I have created a crossword puzzle with terms in the Aggregation session. Download the… Read More »TSQL Aggregation Crossword Puzzle
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… Read More »Database Health Monitor Beta 10 Released