SteveStedman

DBCC SHRINKDATABASE is a DBCC command in Microsoft SQL Server that can be used to reduce the size of a database by moving pages of… Read More »SQL Server DBCC Commands: DBCC SHRINKDATABASE

Wait statistics, in the context of SQL Server, refer to the amount of time that a query spends waiting to access data in the database.… Read More »SQL Server Wait Type: PREEMPTIVE_OS_GETFILEATTRIBUTES

Configuring Database Mail in SQL Server: A Dual Approach In the realm of SQL Server management, setting up Database Mail is a critical task for… Read More »Configuring Database Mail in SQL Server: Video

Cut Costs Without Compromising Quality: Outsource Server Maintenance with Managed Services and Watch Your Savings Grow Welcome back, fellow data enthusiasts! Today, we’re diving into… Read More »Cut Costs Without Compromising Quality

Today Microsoft released a new update for SQL Server. SQL Server 2022 CU12 for 2022 (16.0.4115.5 – March 2024) CU10 + GDR (16.0.4100.1 – January… Read More »New SQL Update from Microsoft

Hi there, I’m Steve Stedman, and I’m excited to share with you my SQL Server course focused on SQL Server Joins, available at http://SteveStedman.com/joins. As… Read More »SQL School: Master SQL Server Joins with My Comprehensive Course

Hello, I’m Steve Stedman, and I want to talk about my SQL Server course on preparing for corruption. This course is designed to help SQL… Read More »Stedman SQL School: Database Corruption Course

Enhancing Business Continuity with Stedman Solutions SQL Server Managed Services In today’s digital landscape, the resilience of your SQL Server databases against unexpected events is… Read More »Enhancing Business Continuity with Stedman Solutions

In the world of database management, maintaining optimal performance is an ongoing challenge. One crucial aspect that often gets overlooked is the management of indexes.… Read More »Dangers of Removing Indexes

Monitoring backups is an essential part of database administration, as it ensures that you have reliable and up-to-date backups in case of data loss or… Read More »Database Health: Monitoring Backups with Database Health Monitor