(Neeraj Nagpal) 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.
Other News
Run SQL Server as a domain account for network access
(Serdar Yegulalp) Like many services, SQL Server and the SQL Server Agent can run in a variety of account contexts. By default, both SQL Server and the Agent are installed in the Local System Account context. However, Microsoft notes in one of its own discussions that the Local System Account is pro
Control site appearance with ASP.NET 2.0 themes
(Tony Patton) Last week we examined ASP 2.0 master pages and discussed how you can use them to centralize a site’s layout. Developers often confuse themes with master pages, but the two elements are quite different. Master pages allow you to control the general layout of a site or a group of pages w
Making a case for enterprise open source
(David HM Spector) Being a good technologist you probably even have Linux machines in your house that you use to keep your skills up to date. You see lots of potential, you’ve waited patiently for management to wake up and smell the open source coffee, and you even can think of some great test deplo
Oracle9iR2 Segment Level Statistics
(James F. Koopmann) Detection of which tables or indexes are being accessed the most will allow you to fine tune memory structures and access methodologies. Let’s take a look at Oracle’s segment level statistics and determine which objects are being accessed the most by our applications.
ASP.NET Does AJAX
(Bill Hatfield) ASP.NET has made the Web a powerful platform for enterprise application development. ASP.NET 2.0 and Visual Studio 2005 extend that power dramatically. But Microsoft developers are already hard at work on the next version of ASP.NET. And this time its not just server-side code. A new
SQL Server 2005 SP1 Due in a Couple Weeks
(Alex Woodie) Microsoft’s new database, SQL Server 2005, has been on the shelves for just a couple of months, but by the end of April, the first service pack should be available. SQL Server 2005 Service Pack 1 (SP1) will add support for mirroring, a crucial ingredient in high availability environmen
WebSphere Message Broker V6, Best Practices Guide: Bullet Proofing Message Flows
(Geert Van de Putte and Dean Keister) If you do not know what you are trying to accomplish, the task is even harder to do. If you do not know how to do the task, it is even more difficult. How many times have you started to develop a solution before understanding the requirements — input data format
Using SQLite in Python
(Peyton McCullough) SQLite is a small C library that implements a self-contained SQL database engine. This article examines pysqlite, one of a number of libraries in Python, that is used as an interface with SQLite.
Oracle Bi-Directional Data Replication
(Vincent Chan) Data availability is an important factor to the success of any businesses. In a distributed environment, Oracle Streams improves data availability and accessibility by sharing and replicating information to multiple sites quickly and reliably. Oracle Streams was introduced in Oracle 9