The Hidden Danger of Missing Primary Keys
The Hidden Danger of Missing Primary Keys in SQL Server One of the most overlooked issues in SQL Server databases is missing primary keys. You… Read More »The Hidden Danger of Missing Primary Keys
Business Continuity – Backup and Recovery
Ensuring Your SQL Server’s Resilience: Free Backup, Recovery, and Business Continuity Self-Assessment In the realm of database management, the terms “backup,” “recovery,” and “business continuity”… Read More »Business Continuity – Backup and Recovery
DBCC CHECKDB Options Overview
In SQL Server, the DBCC CHECKDB command is a critical tool for ensuring the integrity of your databases. It performs checks on the logical and… Read More »DBCC CHECKDB Options Overview
New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2022 CU21 for 2022 (16.0.4215.2 – September 2025) CU20 + GDR (16.0.4212.1 – September… Read More »New SQL Update from Microsoft
Pull vs Push Replication Video
Here is a short video that I created explaining the difference between Push and Pull Replication. Watch it on YouTube. https://youtu.be/ykHsAHH-ggs?si=Msr4jRgeygOs3_Gq Replication Course Enrollment Information… Read More »Pull vs Push Replication Video
New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2016 CU17 + GDR for SP2 (13.0.5893.48 – June 2022) CU17 for 2016 SP2… Read More »New SQL Update from Microsoft
Testing Your Backups
Why Testing Your Backups is a Game Changer Regularly testing your backups is critical to ensure your data is secure and recoverable. Here is why… Read More »Testing Your Backups
SQL Server DBCC Commands: DBCC IND
SQL Server’s DBCC IND command is an undocumented database console command that is used to display the allocation and deallocation status of the data pages… Read More »SQL Server DBCC Commands: DBCC IND
Stedman Solutions Products and Services
Unlocking the Power of SQL Server: An Overview of Stedman Solutions, LLC Products and Services In today’s data-driven world, businesses rely heavily on efficient, secure,… Read More »Stedman Solutions Products and Services
Securing SQL Server: Transparent Data Encryption
Transparent Data Encryption (TDE) is a feature of Microsoft SQL Server that enables the encryption of a databases data and log files, as well as… Read More »Securing SQL Server: Transparent Data Encryption