Leo Peysakhovich

SQL Server Alerts

SQL Server Alerts provide a great way for the server to notify a DBA that some event has occurred, usually something bad that they need to fix. However alerts can also be used to drive business logic processes and enable some types of actions to be safely performed without requiring extraordinary rights by a user. Author Leo Peysakhovich brings us some ideas on how we can use alerts to implement business logic processing.

5 (4)


21,198 reads

Lookup Table Design

Designing a SQL Server database is a challenging task. Making decisions about how to build tables, their relations, etc. can be a full time job for any DBA helping to build an application. Lookup tables are a part of just about every application that you work with or build a back end for. Leo Peysakhovich brings us an article on database design that deals specifically with lookup tables.

3 (4)


24,937 reads

DTS Parallel Processing

SQL Server DTS is an amazing ETL tool. Parallel processing is not only possible, but author Leo Peysakhovich shows us how he does it in this article about his index rebuild process. By bundling DTS into SQL Server for free, Microsoft gave us a platform for not only ETL, but also many basic tasks that all DBAs are stuck working on. Read on to see if parallel processing of index rebuilds is something you can use.


9,757 reads

Every DBA Should Know Which Databases are be Backed Up

Do you know which of your databases are being backed up? Everyone answers "Yes", but I'm sure that there are times that someone creates a new database and you don't know about it. I know in my job, with hundreds of servers, it happens. Here's a technique for keeping track of those databases from Leo Peysakhovich.

4 (1)


13,433 reads


What Agent Jobs are Running??


Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC


When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020


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

Read the latest Blogs


Simple cast question

By Mark Eckeard

This is for SQL Server 2016.  Table called tblTest has a column called TestNumber...

Secondary replica is down at moment

By vivekinmadar

Hi Team , We have three node cluster setup where the one primary server...

SQL 2016 vs SQL 2008R2 float to numeric Difference:

By inayatkhan

Hi, we are upgrading from SQL server 2008 R2 to SQL server 2016 between...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers