I was working with a client just the other day that has several SQL Server 2000 servers still in mission critical production environments, and a couple of newer versions of SQL Server 2005, 2016, 2019. Not often do I admit that I do still occasionally work on SQL Server 2000, and given that we are now in 2022, that makes …
SQL Server 2000 to SQL Server 2019 – What’s the difference? Read more »
25% OFF SQL Server Backup and Recovery Course Coupon Code: BACKUPFEB Expires: February 28th at 11:59pm This complete course will help you determine if you have a sufficient backup strategy and restore plan OR will help you build one from scratch.
If you have a SQL Server you must have a backup and restore plan. If you don’t you’re in for a rude awakening for sure. Backups are absolutely essential for your SQL Server protection from a dropped table to a ransomware attack. But building a backup strategy and restore plan can be daunting task if you’re new at it or …
Build a backup strategy and restore plan from scratch Read more »
At Stedman Solutions, even prior to Covid we have encouraged that all team members work from home. We have no office space that we rent, although the team does have great office space in their homes. Also since most of our work is remote, we very rarely go onsite with customers, the home office environment works great. Having gone through …
Here you have all of Steve Stedman’s SQL Server tips, announcements and news posts of January. Hot Topics: Cumulative Update 15 for SQL Server 2019 Just Released by Microsoft Today Microsoft released SQL Server 2019 CU 15 (KB 5008996) If you need help updating and patching your SQL Server, or upgrading to a new version of SQL Server Stedman Solutions …
Today Microsoft released SQL Server 2019 CU 15 (KB 5008996) If you need help updating and patching your SQL Server, or upgrading to a new version of SQL Server Stedman Solutions can help. With the amount of ransomware we are seeing, it is becoming more important than ever to apply any updates that contain security patches. Here are the latest …
Cumulative Update 15 for SQL Server 2019 Just Released by Microsoft Read more »
Even though we just release Database Health Monitor version 991 the January 2022 release, I am already working on the next version. I have added a new chart to replace some of those older pie charts. Here is the comparisons on a couple of reports. The Database By Size report from Version 991 Compared to the same report on the …
Working on the February 2022 Database Health Monitor Version Read more »
Just yesterday we were on a call with one of our monthly managed services customers. They have been a customer now for about 2 and a half years, and we have helped them through a few upgrades, and even a corruption repair. The corruption repair was our initial contact with them. Nearly finished, our client says to me, “I can …
Every DBA, owner or CEO etc. have worries regarding their SQL Server. We face challenges everyday with constant evolving business and technology needs. We at Stedman Solutions are interested and concerned about your worries in regards to SQL Server work. What is your biggest SQL Server worry today? Tell us so that we can focus our attention on the issues …
When working on different client servers, we often times get asked, why all their memory is not being used, and often times we are hitting the memory limits for SQL Server Standard Edition. Keep in mind that this limit on memory is for the buffer pool and what is being used by databases. SQL Server can use more than this …