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

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 monitor database backups and integrity with SentryOne SQL Sentry custom advisory conditions

 

 
 
Introduction
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

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).
Introduction
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

A Faster Way to Migrate SQL Server Instances!

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

By Mike Tutor|2020-07-13T09:01:22-07:00July 9th, 2020|SQL Group, SQL Server|4 Comments

Impostorism: It’s (mostly) Okay if You Feel Like a Fraud

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

By Jason Russell|2020-07-09T09:07:25-07:00April 14th, 2020|SQL Group, SQL Server|0 Comments

Linked Server in SQL Server: the good, the bad, and the way to make it perfect!

One of the all-time best performing posts on our blog is from Randy Knight and outlines how to use Linked Servers the right way. In this post from Steve Rezhener, he shows how OPENQUERY can make all the difference with Linked Servers.
Introduction (the good)
If you are not familiar with a linked server concept in SQL […]

By Steve Rezhener|2020-07-03T10:22:27-07:00April 7th, 2020|SQL Group, SQL Server|0 Comments
Exit mobile version