Author: SteveStedman

SQL Server Managed Services: A Cost-Effective, Hassle-Free Solution to Your Database Needs In the ever-evolving landscape of database administration and maintenance, businesses face the crucial decision of ensuring their SQL Server environments are not just operational but also optimized for performance and security. The traditional approach of hiring a full-time database administrator (DBA) has been the go-to for many organizations. …

SQL Server Managed Services: A Cost-Effective, Hassle-Free Solution 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: BACKUPIO 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. While CLR can be a useful feature, it can also be a security risk if not …

Securing SQL Server: Disable CLR Read more »

Optimizing Your Backup Strategy: Understanding RTO and RPO In the intricate landscape of data management and disaster recovery, the concepts of Recovery Time Objective (RTO) and Recovery Point Objective (RPO) are pivotal in crafting an effective backup strategy. My extensive experience with SQL Server and a nuanced grasp of data protection principles have illuminated the critical role these metrics play …

Understanding RTO and RPO Read more »

How Vital Is Your SQL Server Data? A Guide to Preparedness In an era dominated by data, the significance of your SQL Server data to your business’s success is paramount. Despite its importance, a prevalent oversight I’ve encountered in my extensive experience with SQL Server is the absence of a comprehensive backup and business continuity plan. This article aims to …

How Vital Is Your SQL Server Data? A Guide to Preparedness Read more »

Strategically Managing SQL Server Growth: Balancing Expansion and Costs As businesses flourish and evolve, the underlying data infrastructure must adapt accordingly. SQL Server, serving as a cornerstone for numerous organizations’ IT ecosystems, is no stranger to this evolution. While growth signifies success, it concurrently introduces increased complexity and, inherently, elevated costs. Through my extensive journey with SQL Server spanning decades, …

Strategically Managing SQL Server Growth Read more »

Fortifying Your Business Against the Unexpected: A Guide to Business Continuity Planning In an era where business operations are increasingly digital and data-driven, the importance of a robust business continuity plan cannot be overstated. Disruptions, whether they are natural disasters, cyber-attacks, hardware malfunctions, or even simple human errors, have the potential to bring operations to a grinding halt. With my …

A Guide to Business Continuity Planning Read more »

Stay Ahead: The Imperative of Keeping SQL Server Updated In the rapidly evolving world of technology, maintaining the currency of your software is not merely a matter of accessing the newest bells and whistles—it’s a foundational element of safeguarding your organization’s data integrity, security, and operational efficiency. This principle is nowhere more critical than in the realm of SQL Server …

Stay Ahead: The Imperative of Keeping SQL Server Updated 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 SP_SERVER_DIAGNOSTICS_SLEEP MEMORY_ALLOCATION_EXT CXPACKET ASYNC_NETWORK_IO LCK_M_IS LCK_M_S LCK_M_SCH_S PREEMPTIVE_OS_GETPROCADDRESS XE_LIVE_TARGET_TVF Our daily monitoring product scans your SQL Server hourly and …

Common Waits Reported by Daily Monitoring This Month Read more »

Is Your SQL Server Performing Slowly? Discover How Stedman Solutions Can Turbocharge Your Database Performance In the realm of database management, SQL Server stands as a cornerstone for countless organizations, powering critical applications and data storage. However, as your business grows, so does the demand on your databases, which can lead to decreased performance, sluggish response times, and, ultimately, frustrated …

Stedman Solutions Can Turbocharge Your Database Performance Read more »