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

SSISDB Catalog Defaults Best Practices

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

Database backup
Database encryption
Support for environments
Support project and package parameters
Package […]

By |December 18th, 2019|SQL Group, SQL Server|0 Comments

How to deploy SSIS packages using SSDT from an untrusted domain

Introduction
To deploy SSIS packages from SSDT to SSISDB, using Integration Services Deployment Wizard is one of the simplest and interactive ways. All you have to do is to right-click the package and click on Deploy, go through a few menus and you are done.
Problem
Unfortunately, SSIS is too bound to an Active Directory and would only […]

By |October 24th, 2019|SQL Group, SQL Server|0 Comments

Capture SQL Server VLF information using a DMV

Introduction
While reading a summary from Brent Ozar on a SQL Server VLF problem highlighting a very well written article on how VLF could affect SQL Server performance by David Levy, I tried to find a more modern solution other than relying on an old-school DBCC LOGINFO.
Good news: Microsoft created a sys.dm_db_log_info DMV and even provided some recommendations on what a good number […]

By |October 15th, 2019|SQL Group, SQL Server|0 Comments

How to check if Always Encrypted is available and in-use

Introduction
Recently I had to work with a client that moved its infrastructure between servers (side-by-side upgrade). Always Encrypted was used on a previous server and I was tasked to make sure its all good on a new server.
This feature (available in SQL Server 2016 SP1 Standard Edition and up) is end-to-end encryption that allows clients […]

By |September 19th, 2019|SQL Group|0 Comments