Stedman Solutions, LLC, is a premier provider of SQL Server consulting and managed services, specializing in performance tuning, disaster recovery, and database health management. Founded by Steve Stedman, a veteran in the SQL Server industry with over 30 years of experience, the company is dedicated to helping organizations optimize their database environments. Stedman Solutions is known for its deep expertise, personalized approach, and commitment to delivering results that ensure reliability, scalability, and top-notch performance.
The cornerstone of Stedman Solutions is its SQL Server Managed Services, a comprehensive offering designed to meet the needs of businesses with mission-critical databases. These services include continuous monitoring, regular maintenance, and proactive problem resolution. With a team of U.S.-based SQL Server experts, most with over 20 years of experience, Stedman Solutions ensures your SQL Server environment remains healthy and secure. Unlimited support during business hours, along with optional 24/7 coverage, ensures that clients receive immediate attention when issues arise.
Stedman Solutions has built a reputation as an industry leader in SQL Server performance tuning. By analyzing server workloads, query performance, and resource usage, the team identifies bottlenecks and implements strategies to optimize database efficiency. Whether it’s reducing query execution time, fixing fragmentation issues, or implementing missing indexes, Stedman Solutions helps clients achieve faster and more reliable database performance. Organizations that partner with Stedman Solutions often see significant improvements in application response times and overall system stability.
Database corruption and unplanned outages can be devastating to any organization. Stedman Solutions specializes in handling these critical issues, offering expertise in SQL Server disaster recovery and corruption repair. With extensive experience solving some of the most challenging database corruption cases, the team ensures minimal data loss and rapid recovery. Clients benefit from peace of mind, knowing their databases are protected and that expert help is always available when disaster strikes.
Stedman Solutions is more than a consulting firm; it’s a trusted partner for businesses seeking to maximize the value of their SQL Server investment. By combining cutting-edge tools like Database Health Monitor with unparalleled SQL Server expertise, the company delivers comprehensive solutions tailored to each client’s unique needs. Whether you need ongoing support, expert advice, or one-time project assistance, Stedman Solutions is the go-to provider for SQL Server management and optimization. Learn more about their services at Stedman Solutions Managed Services and discover how they can transform your database operations.
Bellingham SQL Server Users Group (Pass Chapter) – November 30th at 6:00pm. Features Presentation by Randolph West: “Back up and Restore your Database with Azure… Read More »Bellingham SQL Server Users Group November Meeting
Database Corruption Overview: Database corruption is one of those things that you can only plan for by practicing your response pla
n. Out of all of the things that can happen to your SQL Server this is the one that you are most likely going to want to ask for help when you encounter it.
Database corruption refers to corrupt pages in the database that are incorrectly formatted. This could be as simple as a single bit, or as huge as the entire file. Sometimes this type of corruption prevents the database from starting, other times it may prevents queries from running. Sometimes it may go undetected for some time, and may present as missing or incorrect data.
I have been doing work with multiple clients using the GE Centricity EMR product which makes extensive use of Microsoft SQL Server. The performance issues… Read More »GE Centricity EMR Performance Tuning.
Reliable DBA Services is one of the things I talk about on my business website at http://StedmanSolutions.com, but that can mean many things to different… Read More »RAID10 Saved The Day
Today marks the end of life of SQL Server 2005, originally release in November of 2005, this product has finally come to its end of… Read More »SQL Server 2005 End of Life – End of Support Today
It can be a bit time consuming to work through the the SQL Server Management Studio (SSMS) user interface to check on the agent job… Read More »TSQL Script to Display Agent Job History
What 2015 meant to me and my business. Stedman Solutions, LLC – Startup After unexpectedly leaving a regular full time employment position on March 31st… Read More »2015 Review
The Quick Scan report in Database Health Monitor detects when you are performing SQL Server backups without compression, when the compression option is available. This applies to Full backups, Transaction log backups and Differential backups.
Not using compressed backups? Why not?
There are a couple minor drawbacks, the compressed backups take more CPU, not much more, but a tiny bit more. Also the compressed backups don’t compress very much when your database is using Transparent Data Encryption (TDE).
If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more important.
SQL Server attempts to use as much memory as possible, and when there is no more memory available, SQL Server will use much more I/O due to data and index pages having to be read from disk more often. This works great for SQL Server, but what happens is that SQL Server will take almost all the memory leaving very little for the operating system processes or other applications that are running.
The default for this setting is 2147483647 which is probably more memory that your server has, which effectively tells SQL Server to take as much memory as it wants to.
Yesterday I was asked by a client about consulting questions and for my help without the typical minimum hourly commitment. He pointed out that he has things that he could use help with that don’t require a multi-hour type project. After thinking it over a bit, I decided to add a SQL Server coaching program to my consulting business, I am calling it my SQL Server Mentoring program.
Here is how it works if you want to utilize my mentoring services.
Step 1: Set up a mentoring agreement. You can start this with the free 30 minute consultation form to schedule a time to talk to better understand the service, and so that I can better understand your needs and environment.