Steve Rezhener

Steve Rezhener specializes in Microsoft Data Platform, SQL Server, AWS/Azure and Microsoft BI Stack.
Steve holds a degree Computer Information Systems and Software Development from Champlain College in Burlington, VT, and is graduate of the MBA Program in Information Technology from University of Redlands in Redlands, CA.

Steve is known in the SQL Community as a co-organizer of SQL Saturday in Los Angeles event, co-leader of LA Data Platform (fka SQLMalibu) User Group, frequent SQLSaturday speaker, and President and Co-Founder of Data Driven Technologies, Inc 501.c.3. non-profit.

Steve lives in Los Angeles, CA. When not dealing with data, he is fixing a house, and playing an XBOX with his 2 kids.

Identify Profiles Actually In-use to Make Database Mail Migration Efficient

Introduction According to Microsoft, Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results and can also include files from any resource on your network. This article is going to discuss […]

2021-04-27

725 reads

Hacking the DTSX (SSIS XML file) to Change Defaults

Introduction According to Microsoft, DTSX is an XML-based file format that stores the instructions for the processing of a data flow from its points of origin to its points of destination, including transformations and optional processing steps between the origin and destination points. In a nutshell, when you are creating your SSIS package, the SQL […]

5 (1)

2021-03-25

2,367 reads

Syncing your SQL Server database backups to an AWS S3 bucket

Introduction "Sometimes" just having all the database backups in one place is not enough. In fact, most of the time, putting all the eggs in one basket is a bad idea. You want to have some piece of mind that during the time of crisis, all your database backups are restorable. This is probably why […]

4 (1)

2021-02-11

2,379 reads

Boost performance of your SQL Server tables with a TURBO button

Introduction Performance, performance, performance. While performance in SQL Server can be achieved with code improvement and proper infrastructure maintenance, both tasks require an effort. Code reviews and deep index analysis would take time, but sometimes the obvious is right in front of you. Let's talk about HEAP tables, aka tables with no clustered indexes that […]

2.13 (8)

2020-12-08

7,027 reads

Block user objects from being created in a master database

Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]

5 (7)

2020-11-10

3,330 reads

Blogs

Daily Coping 17 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

SSRS Migration Question

By CiyonAart

So I have a SQL 2017 server that has the two Report Server Databases,...

What is the specific job of the SQL Developer position?

By AllanLloyd

I knew about the position of SQL Developer through an introductory newspaper. I found...

update final code where not contain x then null if not contain x and another cod

By ahmed_elbarbary.2010

i work on SQL server 2012 I face issue i can't update table replacement...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers