July 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 Percentages
TSQL Basics Part 15: INNER AND OUTER JOIN – Video Explanation
This is part 15 “inner and outer JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of JOINS, and when they should be used. Then we’ll explore some common uses for JOINS, such as replacing a not in clause with JOIN to get the same results …
TSQL Basics Part 15: INNER AND OUTER JOIN – Video Explanation Read more »
June Blog Post Wrap-up
KeePass – to improve your process Before proceeding with the article, please take this quick password safety test …. Read More …. TSQL Basics Part 12: OUTER APPLY – Video Explanation Next, we have the OUTER APPLY. And this is a lot like, instead of an INNER JOIN, where it’s gonna be a lot like a LEFT OUTER JOIN between…. …
TSQL Basics Part 14: FULL OUTER JOIN w/ exclusion – Video Explanation
This is part 14 “full outer JOIN with exclusion” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same …
TSQL Basics Part 14: FULL OUTER JOIN w/ exclusion – Video Explanation Read more »
Are You Using All Your CPU Cores
We recently worked on a SQL Server Performance Assessment for a client and during that we assisted with the upgrade from SQL Server standard edition to SQL Server enterprise edition. Part of the upgrade was an attempt to make use of more cores on the server. They were using Standard Edition of SQL Server which was fully utilizing 48 cores …
In Observation
Any emails received this day will be answered the following day! Have fun and stay safe!
TSQL Basics Part 13: EQUI vs NON EQUI JOIN – Video Explanation
This is part 13 “equi JOIN vs non equi JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the …
TSQL Basics Part 13: EQUI vs NON EQUI JOIN – Video Explanation Read more »
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 you answered the above questions with YES more than 5 times, then your use of passwords are extremely insecure and you may be in danger, you may be in serious trouble, keep reading and find …
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 types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better performance. You …
TSQL Basics Part 12: OUTER APPLY – Video Explanation Read more »