By Ken Spencer – Many people overlook SQL Server Profiler in SQL Server 2000 and 7.0 as a Web development tool. Because one of Profiler’s functions is to monitor and report the various performance levels of your SQL Server database, you can use it to look at how your Web applications interact with t

Voss Software Development announces ItemAction version 2.0! Now with Access DB and SQL Server support, even more options, and cleaner setup. Flexible and affordable task management with special features for bug-tracking, helpdesk, and timesheet. Full Visual Basic Source Code Available.

From SQLTeam – When you create a pivot table you rotate rows to columns. This produces a resultset that facilitates trend analysis. In the example shown in this article I show how to use a pivot table to display the number of transactions that occur per hour per day. Before we get to that, though, l

Like most SQL Server service packs, the latest service pack by Microsoft for SQL Server 2000 is simple to install. Don’t let this deceive you though. A step mishap can leave your system in an inconsistent state and cause major problems when users begin to hit it again. This article will provide y

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of XML for SQL Server added Updategrams and Bulk load functionality as well as a host of other features to the SQL Server 2000 base.

By Curt Aubley – Whether you’re sleuthing server-performance problems, determining how to tune your system, or sizing a server for new applications, the first step is to learn how to leverage your OS’s native performance tools. As Windows NT 4.0 became more popular and IT professionals creatively us

Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.

Intermec Technologies Corp. is now shipping its popular 5020 family of handheld data collection computers pre-loaded with Microsoft Windows CE 3.0 and SQL Server 2000 Windows CE Edition (SQL Server CE). Intermec is among the first to market with a Windows CE 3.0-based device with an embedded SQL Ser

By Brian Moran – SQL Server Profiler is a great tool for the DBA’s arsenal, but the tool presents some difficulties. Read Brian Moran’s commentary to find out what they are and how to overcome them.

If you see a priest outside your cubical, beware! He could be trying to read you your last rites. If he hasn’t showed up yet, don’t worry, he’ll be over shortly because the production DBA is dead or will be shortly.