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 |August 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).
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 |July 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 |July 9th, 2020|SQL Group, SQL Server|3 Comments

Inspecting Power BI performance

Introduction
This blog post is going to discuss inspection of Power BI performance when you use Power BI Gateway to push data to PowerBI.com service.
I am going to assume here that you are not new to PowerBI. I am also going to assume that you skipped PowerBI Report Server (which requires a hefty Software Assurance $$$) […]

By |June 17th, 2020|SQL Group|0 Comments

The times we live in

This is not the kind of blog post I ever expected to write for SQL Solutions Group, because it has nothing to do with technology or business or what we do here at SSG. It has everything to do with who we are as people and how we relate to others. You could say it’s […]

By |June 4th, 2020|SQL Group|0 Comments

How TCP Chimney Offloading Affects SQL Server

TCP Chimney Offload transfers network traffic workload processing from the CPU to a network adapter that supports TCP Chimney Offload. This feature was introduced with Windows Server 2003 SP2, and it was called the Microsoft Scalable Networking Pack (SNP). Since Windows Server 2008, these features are a base part of these operating systems, so they […]

By |May 16th, 2020|SQL Group|1 Comment

How to ensure that all the SSRS features are working while using Always On Availability Groups OR have an RSExecRole as a default

Introduction

This blog post addresses SSRS on Always On and RSExecRole. To make sure I’m staying laser focused on this topic, I need to cover some fundamentals.
SSRS installation (SQL Server 2017 and later)
Starting from SQL Server 2017, Microsoft decided to separate SSRS from a SQL Server installation container (ISO). Keeping the pros and cons of this […]

By |May 15th, 2020|SQL Group|0 Comments

What happened to SQL Server Data Tools in SQL Server 2014?

I’ve seen this question a few times and it is something that can be very confusing: You’ve installed SQL 2014 (a full version, not Express) and selected all components, yet when you go to your SQL Server 2014 program group, you can’t find SQL Server Data Tools.

In all versions of SQL Server between 2005 and […]

By |May 9th, 2020|SQL Group|0 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 |April 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 |April 7th, 2020|SQL Group, SQL Server|0 Comments