Hey there, fellow SQL enthusiasts! I’m Steve Stedman, and I’m excited to share my latest SQL Server course on the TSQL Output Clause. If you’re… Read More »SQL School: Master the TSQL Output Clause with My SQL Server Course
CLR (Common Language Runtime) is a feature of SQL Server that allows you to create and run managed code within the database engine. Enabling CLR… Read More »Securing SQL Server: Disable CLR
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_LOADLIBRARY
A couple days ago I was working with a client, they called me they needed desperate help about a query that was running really slow… Read More »Slow Running System the Other Day
Running backups on a SQL Server Fri, 31 Mar 2023 Running backups on a SQL Server is crucial for several reasons: Disaster Recovery: SQL backups… Read More »March Blog Post Wrap-up
Running backups on a SQL Server is crucial for several reasons: Disaster Recovery: SQL backups are essential for disaster recovery. If your SQL Server fails,… Read More »Running backups on a SQL Server
Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. Steve : Now, one of the things that when we talk about… Read More »SQL Server Corruption: Corruption vs Drive Failure
Our Database Health Monitor Training is about to launch! It’s today at 1:30pm PST via Zoom! Can’t Make It? Register anyways and we’ll email you… Read More »Last Chance to Register
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?