SQL Server is a powerful and complex database management system that is used by millions of organizations worldwide to store, manage, and analyze their critical… Read More »Steps to help keep your SQL Server running smoothly.
The sys.databases table in SQL Server contains information about all databases in the current SQL Server instance. The state_desc column in this table represents the… Read More »What are all the values of the state_desc column in the sys.databases system table in SQL Server?
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
Microsoft SQL Server is a relational database management system (RDBMS) available in several editions to cater to different needs and requirements. Two of the commonly… Read More »SQL Server Standard Edition vs. SQL Server Express Edition
There are a few ways to stop blocking in SQL Server: It’s important to note that these methods should be considered on a case-by-case basis… Read More »How to Stop Blocking in SQL Server
If you’d like to: Then Register for this Training March 29th at 1:30-2:15pm PST via Zoom Steve will demonstrate tips, tricks and features of this… Read More »Webinar is 7 Days Away – Register Today
Are you working on a SQL project that needs expert guidance to ensure its success? Stedman Solutions’ SQL Server Mentoring provides the support and expertise… Read More »Accelerate Your SQL Projects with Stedman Solutions’ Expert Mentoring Services
Running the DBCC CHECKDB command is a critical part of database administration, as it ensures that your SQL Server database is free from corruption and… Read More »CheckDB and Database Health Monitor
Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there… Read More »Common Waits Reported by Daily Monitoring This Month
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