Everyone who shares a SQL Sever or other helpful “technical” trick (i.e., hack/tip/shortcut) as a comment to this post by Saturday, Oct. 31, will receive a SQL Solutions Group reusable cotton face mask and pen (pumpkin orange!). Plus, everyone who participates is eligible for our grand prize: A $50 Amazon gift card. We’ll select one […]
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 post describes how to use PowerShell to get your favorite toolbelt into a new database environment, your new jump box or VM that is based on a Window Server OS, without using an internet browser.
For me personally, I like to have the same tools everywhere I go. Tools (I often call it a toolbelt) […]
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 […]
Here’s a thought-provoking thesis: Too much knowledge can distort your perception, even when fixing SQL problems. I’m not entirely sure I can prove or even adequately elaborate on this idea, but here goes.
Lessons from Comic Books
In my youth, I was a fairly invested collector of comic books. Even now, there are still three or four […]
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, […]