Steve Rezhener

About Steve Rezhener

I'm a database professional enthusiastic about the Microsoft BI stack. I started my IT career trying to outsmart Excel using VBA, then on to VB 6, VB.NET, C# and then developed a passion for SQL Server 2005 and related tools. My lunch menu for 10+ years consisted of SSIS & SSRS with some occasional SSAS for breakfast. I'm super excited about the innovation baked into AWS, Azure, PowerBI, and SQL Server 2017. I hold relics such as MCITP Microsoft certifications on SQL Server 2005 and SQL Server 2008. I'm also the organizer of SQL Saturday in Los Angeles (#SQLSatLA), LA Data Platform (aka SQLMalibu) and a frequent SQLSaturday speaker. When not dealing with data, I fix a kitchen, plays an XBOX and enjoys my kids.

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

Introduction
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 |September 8th, 2020|SQL Group|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 |September 3rd, 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 |July 16th, 2020|SQL Group, SQL Server|0 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

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

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

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

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

How to fix a failed “SSIS Server Maintenance Job” job

In this article we will explore how to fix a failed “SSIS Server Maintenance Job”.
Introduction
The SSISDB database (a.k.a. the Integration Services catalog) was introduced back in SQL Server 2012 as a way to de-clutter the MSDB database and provide some built-in logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework making SQL […]

By |January 28th, 2020|SQL Group, SQL Server|0 Comments

Can not create Catalog (SSISDB) due to an error

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

Database […]

By |January 14th, 2020|SQL Group, SQL Server|0 Comments