Five Tips: Configure Windows for Better SQL Server Performance

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 […]

By Randy Knight|2020-11-16T12:29:41-08:00November 16th, 2020|SQL Group, SQL Server|0 Comments

Share a SQL Trick, Get a Treat!

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 […]

By Jason Russell|2020-11-02T06:23:46-08:00October 21st, 2020|SQL Group|13 Comments

What You Need To Know: Log Sequence Numbers and Log Chains

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.
Setting […]

By Scott Klein|2020-10-19T09:06:50-07:00September 25th, 2020|SQL Group, SQL Server|0 Comments

Working with Customer Requirements: Is the Customer Always Right?

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.
That […]

By Jason Russell|2020-09-17T10:34:29-07:00September 17th, 2020|SQL Group, SQL Server|0 Comments

How to use PowerShell to get your toolbelt into a Windows Server without a browser

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) […]

By Steve Rezhener|2020-09-08T10:49:24-07:00September 8th, 2020|SQL Group|0 Comments

How to monitor database backups and integrity with SentryOne SQL Sentry custom advisory conditions


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, […]

By Steve Rezhener|2020-09-03T08:01:47-07:00September 3rd, 2020|SQL Group, SQL Server|0 Comments

Six Ways to Prevent Ransomware

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 […]

By Jason Russell|2020-08-28T13:25:51-07:00August 25th, 2020|SQL Group, SQL Server|0 Comments

The Basics of SQL Server Backups

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 […]

By Scott Klein|2020-08-18T14:07:43-07:00August 19th, 2020|SQL Group, SQL Server|0 Comments

Fixing SQL Problems: Do you Know too Much?

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 […]

By Jason Russell|2020-08-04T13:00:37-07:00August 4th, 2020|SQL Group|0 Comments

Using Extended Event Session (XE) to track queries going against Always On AG primary

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 […]

By Steve Rezhener|2020-07-23T10:19:10-07:00July 16th, 2020|SQL Group, SQL Server|0 Comments
Exit mobile version