Alexzander Nepomnjashiy

This article is a continuation of “Microsoft SQL Server 2000 command line utilities (Part 1),” which began our discussion of how to use the Microsoft SQL Server 2000 command line utilities, and what are they used for. . Most of these utilities are primarily used for diagnostic, configuration and data migration purposes, rather than for […]

This first article in a series of two, discusses how to use the Microsoft SQL Server 2000 command line utilities, and what are they used for. Just to be clear before I start, these utilities are primarily used for diagnostic, configuration and data migration purposes, rather than for database server administration. Please find below all […]

This article describes a well-known concept, (Data Mining algorithms, built into Microsoft SQL Server 2000 Analysis Services) and what I would like to see in the final "Yukon" SQL Server release (i.e. my expectations in a field of new / improved data mining algorithms). What do we know already? According to SQL Server 2000 Books […]

This article explains how to create a SQL Server event alert. It also introduces a second type of alert—performance condition alerts—which are used to monitor SQL Server performance. SQL Server performance condition alerts help the DBA monitor performance for internal SQL Server objects (for example, Log Cache Hit Ratio/sec or Page Splits/sec). SQL Server performance […]

In my previous articles we discussed the SQL Server Agent subsystem and one of its components, alerts. In this the fifth article in the series, we discover that the DBA can select among two types of alerts: SQL Server event alerts and SQL Server performance condition alerts. My next article, “Creating alerts on database server […]

This article is the fourth in a series focusing on alerts and errors within the SQL Server Agent subsystem. In this article I am going to detail how to recover from SQL Server 1105 / 9002 errors. This article will also describe monitoring and recovery procedures for SQL Server databases. I am also planning to […]

This article is the third in my new series that focuses on alerts and errors within the SQL Server Agent subsystem. In this article I am going to describe how to create a specific alert for “Could Not Allocate Space” 1105 errors. I will be making reference to my previous article, which described creating custom […]

This article marks the beginning of a new series that will focus on alerts and errors within the SQL Server Agent subsystem. A pre-defined set of demo Alert templates is included in every Microsoft SQL Server 7.0 installation, and the opportunity exists to create a variety of custom alerts. This initial article in the series […]

Now we continue covering Microsoft SQL Server command line utilities as started in Part 1 of this article. Let’s jump right in … Replupd – Part of the SQL Server replication subsystem, Replupd is used for transferring replication parameters from previous versions of SQL Servers (v6.x). Scm – A utility used to start/stop SQL Server […]

In my latest article, I’m going to briefly touch on thirty useful administrative command line utilities for Microsoft SQL Server 7.0. The tools described below primarily serve for diagnostics, configuring and migration, rather than for database server administration. Some of these tools (for example Bcp, Distrib and Osql) have complex syntax (set of command line […]

In my latest article, I’m going to briefly describe some useful database server administrative utilities for Microsoft SQL Server 7.0. Most of them have a graphic interface, although some of them also have text clones (more on these in my next article). Client Network Utility – A Microsoft SQL Server 7.0 client configuration utility that […]

Analysis is usually accomplished with tools that are built on the base of attendant technologies. Let’s briefly describe two of the most popular technologies – Online Analysis Processing (OLAP – the online operating analysis) and Data Mining (mining for hidden information dependences and tendencies). OLAP The resources of the operating analysis are based on the […]