I founded SQL Solutions Group 10 years ago (October 2010). In that time, we’ve done more than 100 Health Checks on customer systems. Based on that experience, we’re starting a series of posts to help you avoid pitfalls we often encounter. With this post, we show you how to configure Windows for better SQL Server […]
In a previous blog post we laid out the basics of database recovery models and backups. As part of that blog we briefly discussed Log Sequence Numbers and Log Chains, and how they both apply to, and affect, backups. This blog will explore that topic deeper, looking in detail at backups and the log chain.
As SQL Server consultants, we’re always working with customer requirements and tackling diverse database needs, from the mundane to the critical. Clients turn to us for various reasons—maybe they don’t have the personnel, maybe the challenge is beyond their skill—but regardless of the circumstance, without question we have more SQL Server knowledge than they do.
This blog post discusses how to leverage SentryOne’s SQL Sentry product to monitor database backups and integrity checks.
At SSG, we are big fans of SentryOne and have been a partner for many years. If you are not familiar with the product, it is a Performance Monitoring solution for SQL Server, as well as Analysis Services, […]
Executing a strategy to prevent ransomware can save your firm big bucks, expensive downtime, and a boatload of headaches. How bad can it get?
A report from Coveware shows that the average ransomware payment jumped 104% in the last quarter of 2019—up to $84,116 from $41,198 in the previous quarter. If you’re looking for a silver […]
One of the fundamental and basic responsibilities of a database administrator is ensuring the protection and safekeeping of company data. Information, or data, is knowledge and power for any organization. Therefore, the task of protecting the data cannot be understated. This blog won’t list the reasons why you should back up your data (but as […]
Using Extended Event Session, once we add filters, we can see specifics – queries that are hitting a specific database on Server A (primary) from a specific server (and many excluding the monitoring software).
The Always On Availability Group (aka AG) feature in SQL Server provides a great HADR (high-availability and disaster recovery) solution. This HADR […]
I have had to migrate SQL Server instances many times over the years. Sometimes as part of an upgrade from one version to another, and other times just to move to new/bigger better hardware. In my current situation, the client wants to virtualize all of their SQL Server instances. Most of their database servers are already virtualized, […]
I’m a loserI’m a loserAnd I’m not what I appear to be
— John Lennon
As a SQL Server or other IT professional, do you ever feel like you’re doing it with smoke and mirrors? Do you fear you’ll soon be exposed as a pretender? Do you feel like a fraud, merely acting in your role? You’re […]