KeePass – to improve your process
Before proceeding with the article, please take this quick password safety test. Password Safety Test – Score one point for every YES answer.: Scoring: If… Read More »KeePass – to improve your process
June 2021
TSQL Basics Part 12: OUTER APPLY – Video Explanation
This is part 12 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these… Read More »TSQL Basics Part 12: OUTER APPLY – Video Explanation
SQL Server Memory Hog Query
The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the… Read More »SQL Server Memory Hog Query
Raving fan June 2021
We contacted Steve when we were in desperate need of repair on a corrupted SQL database. After dealing with a couple of other vendors without… Read More »Raving fan June 2021
TSQL Basics Part 11: CROSS APPLY – Video Explanation
This is part 11 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these… Read More »TSQL Basics Part 11: CROSS APPLY – Video Explanation
Rows and Range, Preceding and Following
This feature has been available since SQL server 2012 and is one of my favorites. It is the Rows/Range enhancements to the over clause. These… Read More »Rows and Range, Preceding and Following
TSQL Basics Part 10: CROSS JOIN – Video Explanation
This is part 10 “cross JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each… Read More »TSQL Basics Part 10: CROSS JOIN – Video Explanation
Finding tables that don’t have a clustered index.
Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be… Read More »Finding tables that don’t have a clustered index.
Raving fan May 2021
We were moving our SaaS offering from one cloud provider to another and took the opportunity to evaluate our database performance and security ahead of… Read More »Raving fan May 2021
TSQL Basics Part 9: FULL OUTER JOIN – Video Explanation
This is part 9 “full outer JOIN of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between… Read More »TSQL Basics Part 9: FULL OUTER JOIN – Video Explanation