Databases : SQL Server

This article presents code to compute a trimmed mean in SQL. The trimmed mean is a more robust version of the simple mean (SQL AVG() aggregate function). It is a useful tool for summarizing ill-behaved real world data.

Updated: 02/28/2005

Microsoft SQL Server Health and History Tool

The Microsoft SQL Server Health and History Tool is designed to allow you to collect information from instances of SQL Server, store this information, and run reports against the data in order to determine how SQL Server is being used. It appears to capture configuration data and store it on a regular basis.

Updated: 02/28/2005

The Daily Database Build

Continuous integration is a popular concept in software development right now. One of the key components of this is making sure you always have a clean build of your program. This can also be applied to database development. This article shows how to build a cheap, simple series of scripts that will let to rebuild a development database at the click of a mouse.

Updated: 02/28/2005

SQL Server 2005 Webcasts

Microsoft is providing a series of 15 WebCasts on SQL Server 2005. They'll do 15 WebCasts the week of December 6th, 2004 to all introduce the new features for developers. Starting in January 2005 they'll do one webcast per week on specific developer topics.

Everyone who attends a WebCast will receive a copy of the Beta 2 Resource Kit and the Beta 3 Resource Kit when it ships. Also, the first 1500 people that watch 5 or more WebCasts will also receive a special, limited edition SQL Server 2005 WebCast T-shirt. Additionally, all WebCast viewers will be entered into a competition to win an XBOX, one for each day of the week (Contest rules).

Updated: 02/28/2005

Reading a Trace File using C# in SQL Server 2005

SQL Server 2005 includes Server Managed Objects (SMO) which is a managed API to SQL Server. These are primarily used to administrative tasks and replaces DMO. One of the features of this is the ability to programmatically read trace files. This article walks through the code needed to read a trace file.

Updated: 02/28/2005

PASS 2004 Presentation: Profiler and Trace in SQL Server 2005

You can download my presentation from PASS 2004 here. Included is the presentation, all demo scripts and the database I used to deliver the presentation. If you want to recreate the environment you'll need SQL Server 2005 Beta 2 or later and Visual Studio 2005 or later installed. I'll be writing some articles based on the presentations over the next few weeks.

Updated: 02/28/2005

Automatically Process SQL Server Trace Files

This article and sample code explains about small utility to process SQL Server trace files. If you use scripted traces to generate trace files there's no automated way to get these into a SQL Server table. I wrote a little .NET utility to do it for me that I'm calling ClearTrace. Currently it's a command line utility and is still considered beta. In the future I plan to rewrite it as a service and add better error checking.

Updated: 02/28/2005

Separator First Formatting (SFF)

The latest issue of Coding-in-SQL describes a method for formatting T-SQL statements with the separators in front. Separator First Formatting (SFF) makes T-SQL easier to read and easier to maintain.

Updated: 02/24/2005

SQL Server 2000 Gains on Oracle

SQL Server 2000 has the potential to threaten Oracle's database dominance. Learn why in this in-depth analysis.

Updated: 02/23/2005

SQL Server 2005 Beta 2 Transact-SQL Enhancements

This Article gives you the lowdown on the newest enhancements to T-SQL covering recursive queries, DRI support, performance and error handling.

Updated: 02/20/2005

SQL Server Listings

Total: 42

Displaying: 31 - 40

Pages: << 1 2 3 4 5 >>