My Join Types Course
As the instructor of the Join Types course, I’m thrilled to offer a comprehensive guide to SQL Server join types. Join types are essential for… Read More »My Join Types Course
SteveStedman
SQL Server DBCC Commands: Shrink Errors
Recently when shrinking a SQL Server data file, I ran into the following error: File ID 3 of database ID 15 cannot be shrunk as… Read More »SQL Server DBCC Commands: Shrink Errors
Multiple Joins – Poster
SQL Server provides several join types to combine data from two or more tables based on a common column or set of columns. Among these… Read More »Multiple Joins – Poster
SQL Server DBCC Commands: DBCC SHOWCONTIG
DBCC SHOWCONTIG is a has been announced to be deprecated for more than 10 years ago, meaning it may disappear in future versions of SQL… Read More »SQL Server DBCC Commands: DBCC SHOWCONTIG
Fighting back against Ransomware
In the last year I have seen far too much ransomware. I have seen some people lose their databases with no way of getting them… Read More »Fighting back against Ransomware
Our “Beach Side Cabana with Drink Delivery” SQL Service
Yes, our Managed Services is just that! Well almost. This service is the all-inclusive resort of SQL Services. Take look at what’s included. Agile Support… Read More »Our “Beach Side Cabana with Drink Delivery” SQL Service
New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2019 CU20 for 2019 (15.0.4312.2 – April 2023) CU18 + GDR (15.0.4280.7 – February… Read More »New SQL Update from Microsoft
20% Off Now Until April 30th
Our comprehensive assessments are designed to evaluate the health and performance of your databases, identifying major and minor issues that need to be addressed. By… Read More »20% Off Now Until April 30th
Join Types On Your Wall
As a long-time SQL Server consultant and database administrator, I understand the importance of having a clear understanding of the different join types available in… Read More »Join Types On Your Wall
SQL Server DBCC Commands: DBCC PAGE
SQL Servers DBCC PAGE command is a powerful tool that allows users to view the contents of a database page at the physical level. This… Read More »SQL Server DBCC Commands: DBCC PAGE