With so many recent contacts from possible clients who have been hit by ransomware, I have seen too many companies lose their entire SQL Server databases, their backups, and any hope of recovery. I have even seen a few where the ransomware failed and did not fully encrypt or fully decrypt the database making it impossible to get their data …
Here listed is the current percentages of SQL server versions running our Daily Check up with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages
I was recently remembered of a time I was working more with performance tuning on Oracle. The following is something that I had discovered to be very similar between Oracle and Microsoft SQL Server, but the names are different between the two systems. So this brings me back to the question of how much procedure cache memory does one SQL …
How much Procedure Cache memory does one SQL Statement take up? Read more »
At Stedman Solutions, we do a lot of work with SQL Server replication, mostly transactional and merge replication. The other day I needed a query to show all the merge replication publication on a SQL Server, not just a single database, but to see it for all databases on the SQL Server. Here is the query that I came up …
As the DBA, you get a call from the IT Team who monitors disk space and they tell you the following: “One of our server that has SQL Server running on it is running low on disk space. It has gone from around 60% disk utilization to 95% disk utilization just overnight. Whats the problem?” In this scenario it’s a …
Technical Debt is a programming concept that is also known as code debt. The concept of Technical Debt applies closely with Agile software development, but also applies to database development. There are many tools available to report on technical debt for C#, PHP or other programming languages, but there isn’t much available to manage the SQL Server or T-SQL technical …
Just Released! – Using Database Health Monitor Course Wed, 27 Oct 2021 Thousands of people are using Database Health Monitor but there can be a learning curve. So we’ve come up with a way to speed up the learning curve. You will learn most everything that you want to know about database…. Read more… Informational Ransomware Video Tue, 26 Oct …
We are releasing new courses and new discounts all the time. To make it easy for you, we will be posting all coupons and current sales every other week. Check back in and maybe you’ll save yourself some money. 50% Off Microsoft TSQL JOIN Types Course Coupon Code: 50OFFJOINS Coupon valid until 10/31/2021 50% off “Getting Started with SQL Server” …
With the rise in ransomware and freak weather we knew we must offer this service! Don’t let the next disaster end your business. With proper planning you can survive, and we can make it easy!
Today Microsoft released SQL Server 2017 CU 27 (KB 5006944) . Here are the latest updates for each version of SQL Server. 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 …
SQL Server 2017 CU 27 Just Released by Microsoft Read more »