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 »
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 health monitor in just one place. This course is $39.99 and worth every penny. Below is the Curriculum details:
A quick warning to ALL businesses. Ransomware is on the rise! We have seen too many people get hit with ransomware and we just hate it! Learn more about Ransomware in the video above. And see if you’re safe from a Ransomware attack with our assessment services.
One possible cause of the “Cannot resolve the collation conflict” error message is that your database collation doesn’t match the TempDB Collation. Recommendation It is recommended that the collation of your database match the collation TempDB. It is possible that if your collations do not match that you may get errors, or that queries using TempDB will not run correctly.If …