Today Microsoft released a new update for SQL Server. SQL Server 2022 CU10 for 2022 (16.0.4095.4 – November 2023) CU10 + GDR (16.0.4100.1 – January 2024) 2024-01-09 Here are the latest updates for each version of SQL Server. SQL Server 2008 R2 RTM Download links: SP3 (10.50.6000.34 – September 2014) SP2 (10.50.4000.0 – July 2012)None SQL Server 2022 RTM Download links: NoneCU10 …
This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. Why Auto Create Statistics is an Important Setting in SQL Server Auto create statistics is a crucial setting in SQL Server that significantly impacts the performance of your queries. When enabled, it allows SQL Server to automatically create statistics …
Why Auto Create Statistics is an Important Setting in SQL Server Read more »
Need help with this, Stedman Solutions can help. Find out how with a free no risk 30 minute consultation with Steve Stedman. 3 Essential Checks for Diagnosing a Slow SQL Server Are you struggling with a slow SQL Server? Before you deep dive into the complex world of performance tuning, there are three primary areas you should inspect first. These …
3 Essential Checks for Diagnosing a Slow SQL Server Read more »
Out of all of the customers we have running our daily monitoring here are the versions of SQL Server that are being run. All the data is sanitized, so there is no private client information to expose here. What is this service? With this service we detect and alert you of any issues that arise on your SQL Server. Then …
Daily Server Monitoring – SQL Versions for January Read more »
Understanding the Importance of TDE Certificate Backups in SQL Server This is just one of the many checks that our Daily Checkup and Quickscan Report from Stedman Solutions will report on. In SQL Server, Transparent Data Encryption (TDE) is a valuable feature that provides encryption at the file level. It’s an essential tool for ensuring that your data is secure …
Managing SQL Servers is a critical but often complex task. That’s why our Managed Services offer you the assurance and expertise of our team acting as your part-time or fractional DBA, for a fixed monthly cost. We don’t just provide services; we’re your go-to experts whenever you need help, ensuring you never have to navigate challenges alone. How We’ve Got …
Never Go It Alone: Our Managed Services Team is Your Lifeline for SQL Server Management Read more »
Navigating SQL Server Management: The Unmatched Value of Stedman Solutions’ Managed Services In the ever-evolving landscape of database management, businesses are continually seeking reliable, efficient, and cost-effective solutions to ensure their SQL Server environments are running at peak performance. As the owner of Stedman Solutions, LLC, I’ve seen the challenges and costs that organizations face when trying to manage and …
The Unmatched Value of Stedman Solutions Managed Services Read more »
Common Uses of TempDB in SQL Server TempDB in SQL Server is a globally available temporary storage area used by the SQL Server Database Engine for various purposes. Here’s a list of the most common uses of TempDB: User Objects: Includes user-defined temporary tables and temporary stored procedures. Used to temporarily hold data for processing within a session. Internal Objects: …
Introduction In the digital age, effectively managing your SQL Server has never been more critical. You might think that employing a full-time Database Administrator (DBA) is the only way to go, but have you considered outsourcing SQL Server management to a specialized Managed Services Provider (MSP) like us, Stedman Solutions? Below we will delve into why opting for our services …
Why Choosing Stedman Solutions is a Cost-Effective Alternative to Hiring a Full-Time DBA Read more »
Understanding the Quick Scan Report: Backup to NUL When managing SQL Servers, one often overlooked yet critical aspect is ensuring that backups are functioning as intended. It’s not just about having backups, but about understanding the nuances and potential pitfalls associated with them. A particular situation that requires attention is the practice of backing up to a NUL device. While …