August Blog Post Wrap-up
TSQL Pivot Table TSQL Pivot Table? What’s that? Here is a quick sample of how to implement a pivot table in TSQL for SQL Server.… Read More »August Blog Post Wrap-up
August 2021
TSQL Pivot Table
TSQL Pivot Table? What’s that? Here is a quick sample of how to implement a pivot table in TSQL for SQL Server. The example below… Read More »TSQL Pivot Table
Excited to Release Training Videos
Just this week the team at Stedman Solutions finished the SQL Server JOIN Types paid training course. I am very excited to complete this and… Read More »Excited to Release Training Videos
What’s your favorite SSMS time saving hotkey?
Recently I have been on the LEAN improvement quest to make a 2 second improvement in my process every day. Part of that improvement is… Read More »What’s your favorite SSMS time saving hotkey?
Using the OUTPUT Clause in TSQL for Auditing
The OUTPUT clause is often times underappreciated by the TSQL programmer. There are many really interesting things that you can do with the OUTPUT clause,… Read More »Using the OUTPUT Clause in TSQL for Auditing
Cumulative Distribution Function (CDF) – Analyzing the Roll of Dice with TSQL
After the last post on Cumulative Distribution Function (CDF) or as it is known in TSQL CUME_DIST(), I realized that although I showed how to… Read More »Cumulative Distribution Function (CDF) – Analyzing the Roll of Dice with TSQL
More TSQL Analytic Functions – PERCENT_RANK
Percent rank is defined as the number of values that are the same or less than the current value divided by one less than the… Read More »More TSQL Analytic Functions – PERCENT_RANK
Using a CTE in a Function to Split Up a Database Connect String
I came across this example when preparing my CTE presentation a while back. Which produces the following output. Download my book for FREE when you… Read More »Using a CTE in a Function to Split Up a Database Connect String
August SQL Daily Monitoring – SQL Server Versions
Here listed is the current percentages of SQL server versions running our Daily Check-up with Database Health Monitor. Compare this month’s percentages to Last Month’s… Read More »August SQL Daily Monitoring – SQL Server Versions
Risk Assessment Matrix for SQL Server Upgrades
A couple years ago in my Incident Safety Officer class with the fire department we studied risk assessment for any incident that the fire department… Read More »Risk Assessment Matrix for SQL Server Upgrades