Author: SteveStedman

Microsoft SQL Server’s database corruption can lead to severe operational complications, making crucial data inaccessible and potentially jeopardizing business continuity. Comprehending this problem requires a firm grasp of corruption indicators, its root causes, and effective strategies for prevention and repair. Transcribed from a presentation on Database Corruption by Steve Stedman and Derrick Bovenkamp. Steve : Now, one of the things …

SQL Server Corruption: Corruption vs Drive Failure Read more »

The Power of Proactive Monitoring in a World of Constant Change As the world continually evolves, the need for robust and proactive solutions in the realm of IT managed services becomes ever more critical. In an environment where a single change can have cascading effects, businesses cannot afford to be reactive. This is where Stedman Solutions steps in with its …

Proactive Monitoring in a World of Constant Change Read more »

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 is no private client information to expose here. For this month, here are the details. CXCONSUMER MEMORY_ALLOCATION_EXT CXPACKET SP_SERVER_DIAGNOSTICS_SLEEP ASYNC_NETWORK_IO LCK_M_U LCK_M_SCH_S PREEMPTIVE_OS_GETPROCADDRESS XE_LIVE_TARGET_TVF PREEMPTIVE_OS_PIPEOPS Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

As an expert in SQL Server with extensive experience since 1990, I’ve witnessed the pivotal role that a deep understanding of joins plays in database performance and query efficiency. It’s my pleasure to introduce a specialized course focused exclusively on SQL Server Joins, now available through Stedman’s SQL School. Why Focus on Joins? Joins are crucial in SQL Server for …

SQL School: SQL Server Joins: A Comprehensive Course Read more »

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. When a client application requests data from the database, the request is placed in a queue and the client application must wait for its turn to access the data. The time that the query spends …

SQL Server Wait Type: WRITELOG Read more »

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 on SQL Server allows you to create stored procedures, triggers, and functions using languages such as C# and VB.NET. The “CLR strict security” option is an important security feature of CLR that allows you to …

Securing SQL Server: Securing CLR Read more »

DBCC INDEXDEFRAG is a has been announced to be deprecated for more than 10 years ago, meaning it may disappear in future versions of SQL Server. DBCC INDEXDEFRAG is a database console command (DBCC) in Microsoft SQL Server that can be used to defragment the indexes of a database. Defragmenting the indexes can be useful for improving the performance of …

SQL Server DBCC Commands: DBCC INDEXDEFRAG Read more »

This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Security Risks of SQL Server Agent Jobs at Startup Having SQL Server Agent jobs run at startup poses several security and operational risks. It’s important to understand the context and the specific requirements of certain components, like replication, which …

SQL Server: Startup Jobs Security Risks Read more »

Unlock the Full Potential of Your SQL Server with Stedman Solutions’ Managed Services In today’s fast-paced world, your SQL Server database is more crucial than ever. It’s the powerhouse behind your most critical operations. That’s where Stedman Solutions, LLC, steps in. We offer flexible, fully managed services tailored to the unique demands of your SQL Server environment. Our elite SQL …

Unlock the Full Potential of Your SQL Server with Stedman Solutions Managed Services Read more »