Continues the discussion of database object names. Breaks down the names of UDFs and stored procedures and shows exeamples....

Completing the sequence of articles on application level tracing this article shows how to clean up the data in the AppSession AppSessionTrace and AppSessionMeasurement tables with the udf_AppSession_Purge stored procedure. The first four articles in this series have been about writing trace information to the AppSession AppSessionTrace and AppSession....

Giving SQL Server database objects such as tables views stored procedures and user-defined functions the proper name is important. The name makes the function easier to find and to understand its purpose....

This article describes you how to work with multiple-child aggregations reviewing different versions of the query to see which aggregation gives the best performance....

This article describes how to create Microsoft SQL Server tables that reside in an integrating third party application written in Dexterity and how to grant permission to those tables....

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

This Article is about SQL Server Reporting Services architecture cool features innovative uses performance tips new features in SQL Server 2005 Reporting Services and Business Intelligence opportunities in SQL Server 2005....

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....

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

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....

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...

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....

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...

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....

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....