Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Leo Peysakhovich

SQLServerCentral.com profile

   Items 1 to 20 of 34    Older >>
 

An Automated Process to Archive Big Tables

Many databases have large tables with hundreds of millions of rows. However, many of these tables are simply keeping a log or history data that can be archived and kept outside the user database in a special archive database.   Read more...
By Leo Peysakhovich 2013/07/10 | Source: SQLServerCentral.com | Category: archiving
Rating: |  Discuss |   Briefcase | 6,523 reads

Process Support Database Framework

Do you use or need a database process framework? Read on to see if this is something that might help you build better database software processes.  Read more...
By Leo Peysakhovich 2012/01/26 | Source: SQLServerCentral.com | Category: framework
Rating: |  Discuss |   Briefcase | 3,532 reads

Data Distribution - Part 2

In the second part of this series, Leo Peysakhovich provides a mechanism for tracking real time data changes.  Read more...
By Leo Peysakhovich 2010/10/14 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 4,267 reads

Data Distribution - Part 1

The start of a new series from Leo Peysakhovich that looks at some of the issues with moving data around between systems and ensuring that it is in sync between them.  Read more...
By Leo Peysakhovich 2010/07/26 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 6,763 reads

Log shipping and A Control Mechanism

Longtime author Leo Peysakhovich has implemented a log shipping mechanism that can recover from failures and give you control over how it works. Read on if you want to implement your own version of log shipping and have control over all aspects of the process.  Read more...
By Leo Peysakhovich 2010/07/01 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 5,445 reads

The New Reality of an Audit Trail

With a continuation of his last article on auditing, Leo Peysakhovich enhances his solution to capture more details using XML.  Read more...
By Leo Peysakhovich 2009/07/08 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 6,069 reads

A Generic Process to Convert XML Data - Part 2

Continuing with his series on loading and transforming XML data, Leo Peysakhovich shows how to create the generic process to perform the convesions.  Read more...
By Leo Peysakhovich 2009/07/10 (first published: 2008/08/26) | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 12,628 reads

A Generic Process to Convert XML Data - Part 1

Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.  Read more...
By Leo Peysakhovich 2009/07/03 (first published: 2008/08/25) | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 16,164 reads

Error Handling in Nested Procedures and Logging Custom Errors

Longtime author Leo Peysakhovich brings us a new article on error handling when you have procedures nested inside each other.  Read more...
By Leo Peysakhovich 2008/07/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,930 reads

Loading a 24x7 Data Warehouse

More and more companies are using data warehouses as a way of consolidating business critical information. And more and more of these companies want the warehouse available 24 hours a day, 7 days a week. This presents interesting challenges for the DBA involved in ETL processing. Longtime author Leo Peysakhovich brings us one solution for this problem.   Read more...
By Leo Peysakhovich 2007/03/19 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 8,682 reads

Identifying Unused Objects in a Database

Longtime author Leo Peysakhovich answers one of the most common questions seen in discussion areas around the world: how do you identify unused objects?   Read more...
By Leo Peysakhovich 2006/09/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 22,250 reads

An Error Handling Template for 2005

One of the big complaints in SQL Server development has been error handling. SQL Server 2005, however, substantially enhances its capabilies in this area and Leo Peysakhovich brings some code that provides a template for adding error handling to your application.   Read more...
By Leo Peysakhovich 2006/03/14 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 17,908 reads

Manipulating Data in TEXT Type Columns

For many SQL Server 2000 DBAs working with text columns in T-SQL is no different than any other datatype. But there are some tricks when you work with very large values that you need to know. Leo Peysakhovich brings us some advanced queries that you might need if you work with large XML documents as he does.   Read more...
By Leo Peysakhovich 2005/12/07 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 16,338 reads

How to find that job is running?

Have you ever wanted an easy way to determine if a job is running for automated checks? This might not be an easy way, but Leo Peysakhovich provides a way that works and corrects an error in Books Online.   Read more...
By Leo Peysakhovich 2005/10/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 27,371 reads

An Audit Trail Generator

Auditing is becoming more and more important in many SQL Server environments. DBAs are being tasked with setting up, maintaining, and reporting on audit data. Author Leo Peysakhovich brings us one of his solutions to automatically generate an audit trail for your data.   Read more...
By Leo Peysakhovich 2005/10/10 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 22,398 reads

Automate New Logins Creation

There are times when a new application or time period requires the creation of a number of logins for your clients. This can be a time consuming process, but Leo Peysakhovich brings us a way to make this go quickly.   Read more...
By Leo Peysakhovich 2005/07/19 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,807 reads

Long Running Jobs

SLQ Server has a fantastic job scheduling system, but there are some times that things go wrong. Leo Peysakhovich brings us another great article that looks at a way to check if your job engine is running and how to restart it. Practical code included in this one.   Read more...
By Leo Peysakhovich 2005/05/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,418 reads

Controlling Unusually Long Running Jobs

The SQLAgent scheduler in SQL Server 2000 is an amazing tool that allows you to schedule many different kinds of jobs with a great deal of flexibility. However, it doesn't have great facilities for handling jobs that may take longer than expected. And about which you'd like to be notified. Leo Peysakhovich brings us his code and technique for detecting when a job step runs long.   Read more...
By Leo Peysakhovich 2005/05/09 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,077 reads

Performance Tips Part 2

SQL Server 2000 is a self tuning, self balancing application that performs wonderfully under a wide variety of loads and conditions with a minimal of administrative tuning. However there are some things that you can do when building T-SQL code and working with SQL Server to maximize performance. Leo Peysakhovich brings us part two of his series looking at some different scenarios and how you can structure your code for better performance.   Read more...
By Leo Peysakhovich 2005/03/17 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 11,451 reads

Performance Tips Part 1

SQL Server 2000 is a self tuning, self balancing application that performs wonderfully under a wide variety of loads and conditions with a minimal of administrative tuning. However there are some things that you can do when building T-SQL code and working with SQL Server to maximime performance and assist the query optimizer in selecting the best query plans. Leo Peysakhovich brings us the first part of his series looking at some different scenarios and how you can structure your code to achieve   Read more...
By Leo Peysakhovich 2005/03/08 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 16,309 reads
   Items 1 to 20 of 34    Older >>