April Blog Post Wrap-up

SQL Server DBCC Commands: DBCC CLEANTABLE

Sat, 29 Apr 2023

DBCC CLEANTABLE is a DBCC command in Microsoft SQL Server that can be used to remove deleted rows from a table and reclaim the space occupied by the deleted rows. It is similar to the TRUNCATE TABLE command, but unlik Read more…

Incorrect Backups? You’ll Pay for That Mistake

Fri, 28 Apr 2023

In the end it will come down to one question. That question being, “how much data can your company afford to lose? One hour? One day? One week? Choose wisely or it could cost more than you think. For example Read more…

SQL Server Join Types Poster

Thu, 27 Apr 2023

SQL Server is a popular relational database management system that is widely used in businesses and organizations of all sizes. One of the most important operations in SQL Server is joining tables, which involves combining data from two or mor Read more…

Details on Inner, Left Outer, and Right Outer

Wed, 26 Apr 2023

As a SQL Server professional with many years of experience, I know how important it is to understand the different types of joins. Join types are a fundamental concept in SQL Server, and they are essential for retrieving data fro Read more…