SQL Server General DBA

Scripts for Errorlog Monitoring of SQL Servers

The text for the batch file: errorlog_chk_1.bat ============ Text of the batch file ====================== @echo OFF @if not “%ECHO%”==”” echo %ECHO% rem ******************************************* rem Script : errorlog_chk_1.bat rem Author : Neeraj Nagpal rem Date : 02/01/2005 rem ******************************************* rem Set Local scope and call main proc. setlocal & pushd & Set RET= set SCRIPTNAME=%~n0 set […]

Monitor Your Database Servers with DTS, Part 2: Errorlog Monitoring of SQL Servers

In the first article in the series, I explained the setup of a report that ensures that backups are happening as per the backup policy. In this article, I will explain how to monitor SQL Server errorlog, leveraging the capabilities of DTS. Just in case you have not read the first article, in this series, […]

Scripts for Backup SLA Report

########## Bkp_sla_main.bat ###################### @echo OFF @if not “%ECHO%”==”” echo %ECHO% rem ******************************************* rem Script : Bkp_sla_main.bat rem Author : Neeraj Nagpal rem Date : 10/08/2004 rem ******************************************* rem Set Local scope and call main proc. setlocal & pushd & Set RET= set SCRIPTNAME=%~n0 set SCRIPTPATH=%~f0 set DBASQL=E:dbaSQL set DBAOUT=E:DBAout set DEBUG=1 if “%DEBUG%”==”1″ (set TRACE=echo) […]

Monitor Your Database Servers with DTS, Part 1: Backup SLA Report

It is difficult to keep track of critical things like backup, space, and error logs in large environments. Different database management tools from third party vendors can help you monitor these but the tools are normally expensive. There is an inexpensive alternative. In this series of three articles, I will describe how to monitor a […]

SQL PASS Community Summit vs. SQL Server Connections Conference

In the past, I have attended SQL PASS five times, and this past week, I attended my first SQL Connections conference. For those who have not been able to attend both, I thought I would describe some of the differences I found between the two. Two Different Focuses The SQL PASS Community Summit focuses on […]

Implementing the SQL Server Multiple Publishers and Central Subscriber Replication Topology

Introduction This article describes how to set up the following topology: where P1 and P2 are two different publishers and S is the central subscriber. This is a fairly typical requirement, e.g. the subscriber might be a head office and the publishers are each separate branch of a company. In this arrangement, data often needs […]

SQL Server Replication Across Domains and the Internet

Replication over the Internet or across non-trusted domains is usually performed using a virtual private network (VPN), and consequently the configuration is much the same as that used on a LAN. This article outlines what to do if such a VPN is not available. While it’s true that in almost all cases you wouldn’t consider […]

SQL Server 2005: The Replication GUI

This article describes the changes to replication from the point of view of the SQL Server 2005 GUI. In case you haven’t already been checking out the new version, ‘Microsoft SQL Server Management Studio’ is the new graphical replacement for ‘Enterprise Manager’. It’s probably true to say that unlike many other administrative tasks, most DBAs […]

Replicating Stored Procedure Execution

In OLTP environments, you often find batch jobs that move historical data to archive tables. In addition, there are often some batch jobs that purge historical data from the OLTP tables. These types of jobs can perform a lot of transactions and create additional overhead for the OLTP system, hurting overall performance, especially if you […]

Kerberos Protocol Transition and Constrained Delegation

That title’s quite a mouthful, huh! Let’s start by explaining what we’re actually trying to achieve here. Actually, before we start, let’s just say that this paper shows you how I implemented protocol transition and constrained delegation with SQL Server and IIS, and it is not intended to be an exhaustive study of the subject. […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |