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 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

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

Social distancing in IT: Five tips to make working from home work for you

So, it’s here: a global pandemic impacting billions around the globe and changing the ways we live, work, and interact with each other. Our new normal, for an unknown length of time, is all about social distancing and that means working from home for many of us.

At SSG, this is nothing new to us, and […]

By |March 18th, 2020|SQL Group, SQL Server|0 Comments

Why it Matters: CapEx or OpEx for information technology?

IT expenditure decisions are never purely financial, as those who pull the trigger must consider how the purchase, or perhaps delaying the purchase, could impact other departments, from marketing and regulatory to operations and human resources. Once you have made the decision to proceed with an outlay, you then must decide: Capital Expenditure (CapEx) or […]

By |March 12th, 2020|SQL Group, SQL Server|0 Comments

Data Governance – your ultimate stored procedure to get a record count from any table and compare

Introduction
Data Governance plays an important role in building a successful data-driven company as it helps business users to trust the data. While a typical Data Analytics project starts with identifying all relevant transactional sources of information, building your Data Warehouse according to business needs and feeding (and converting) the data as often as possible, one […]

By |March 5th, 2020|SQL Group|0 Comments

Yes, On-premises Infrastructure has a (Bright) Future

With AWS and Azure leading the way, it’s easy to think the future of on-premises infrastructure is grim. Before you say, “we’re migrating to the cloud,” realize on-premises is alive and well, and probably always will be.

To Cloud Or Not To Cloud
When considering cloud vs. local options, one thing becomes quickly clear: There is no […]

By |February 25th, 2020|SQL Group, SQL Server|0 Comments

Bringing back an informative SQL Server Agent job email notification on failed SSIS packages

Introduction
The SSISDB database (a.k.a. the Integration Services catalog) was introduced back in SQL Server 2012 as a way to de-clutter MSDB database and provide some built-in logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework (see Fig #1) making SQL Server Integration Services more robust and enterprise-friendly by providing the following features:

Database […]

By |February 17th, 2020|SQL Group, SQL Server|0 Comments