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,225 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)


25,193 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,759 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,435 reads


Daily Coping 21 Sep 2020


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

Daily Coping 18 Sep 2020


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

Optimize for Unknown for Inline Table-Valued Functions


I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Read the latest Blogs


Insert Trigger

By Barcelona10

Hi All, I have table A that has 2 columns(col 1,col2). I would like...

Searching for orphaned DB files on the SQL server

By martin.tydor@gmail.com

Comments posted to this topic are about the item Searching for orphaned DB files...


By ramyours2003

What is the use of DEA tool in sql ?  how can we  install...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers