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.

SQLServerCentral Article

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

738 reads

SQLServerCentral Article

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,531 reads

SQLServerCentral Article

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,926 reads

SQLServerCentral Article

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,044 reads

SQLServerCentral Article

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,396 reads

Blogs

What are those new buttons under tab order in Power BI?

By

If you’ve visited the Tab order area of the Selection Pane in Power BI...

Last Week Reading (2021-11-28)

By

?? Press SynapseML: A simple, multilingual, and massively parallel machine learning library Microsoft just...

About blogging

By

A friend wants to get started and write a blog, and so asked me...

Read the latest Blogs

Forums

SQL Agent Driving Me Nuts

By davidcb

Been given a new server running Win 2019 & SQL 2019 unable to run...

Update alias or update tablename when from clause is specified

By R.P.Rozema

I would like to ask your opinions and recommendations on how to properly write...

T-SQL query combine rows into a single column

By RDBoy

  Hi all, I'm a newbie to T-SQL. Please can you help me with...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers