Leo Peysakhovich

  • Interests: Camping, Skiing

SQLServerCentral Article

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)

You rated this post out of 5. Change rating


21,980 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating


29,827 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating


9,803 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating


13,470 reads


A New Word: Proluctance


proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

10 reasons why IT certifications are still important


As someone who has spent over 20 years in the Software/Data Engineering area and...

Know Thy Platform


IT and data professionals, I implore you – know thy platform. All of it....

Read the latest Blogs


what does this error mean?

By water490

I was running a SP and I got this.  This is the first time...

how to properly index?

By water490

I am not sure how to decide on how I should index my tables...

Software Updates, Outages, Processes, and Protocols

By Ryan Booz

Comments posted to this topic are about the item Software Updates, Outages, Processes, and...

Visit the forum

Question of the Day

Filestream on Linux

I want to implement a Filestream table on SQL Server 2022 running on Linux. Can I do this?

See possible answers