home articles news code blog links search

		Updated releases of SQL 2005 Service Manager available New builds of SQL 2005 Service Manager are now available for Vista (2.0.0.3) and XP, Windows 2003 and Windows 2008 (1.0.0.12). These releases add a fix for Analysis Services and SSIS discovery. Updated sourcecode is available from the Codeplex site. More >> Updated releases of SQL 2005 Service Manager available New builds of SQL 2005 Service Manager are now available for Vista (2.0.0.2) and XP, Windows 2003 and Windows 2008 (1.0.0.11). These releases add SQL 2008 and Windows 2008 compatability. Updated sourcecode is available from the Codeplex site. More >> SQL 2008 November CTP now available The November Community Technology Preview (CTP) version of SQL Server 2008 is now available. Links to the CTP releases of SQL Server 2008 Books Online (BOL) and SQL Express are available at the bottom of the download page. This release is packed with new features including Backup Compression, Resource Governor, TSQL intellisense in SSMS, Filestream, Geospatial support, Change Tracking, Data Collection and Performance Warehouse enhancements and Transparent Database Encryption. Go try it out! More >> SQL 2005 DDL Audit Sample Applications The SQL 2005 DDL Audit Samples are a collection of sample applications for configuring DDL (Data Definition Language) auditing on one or more SQL Server 2005 instances. These applications were first presented at the PASS 2006 Community Summit in my presentation Building a DDL Audit Solution using SQL Server 2005. They build on top of the Service Broker and Server Event Notification infrastructure available in SQL Server 2005 to provide a means of collecting all server and database DDL events in a central database for viewing and reporting. Full source code is provided for all sample applications More >> Sorting SQL Project Files in SQL Server Management Studio When you have a lot of SQL files in a SQL Server Management Studio (SSMS) Project it can become difficult to find the file you are looking for as the order that they are displayed in the Solution Explorer is the order they were added to the project. The utility descriped in this article allows you to add menu items to sort the SQL files in a SSMS Project More >> Download Reporting Services Linked Report Generator Reporting Services Linked Report Generator is a .NET Windows Forms application that enables automatic generation of linked reports to any number of Reporting Services folders based on a single base report. This can be useful where you have a hierachical folder structure and need to deploy the same report to multiple levels of the folder hierachy at the same time. More >>	Most popular code sp_grantexec Grant execute on all procedures in a database sp_SQLLitespeedmaint Maintenance plan behaviour but using SQL Litespeed sp_diskspace Space used,free and percentage using FSO sp_top_waits Find the top waits over the past minute expressmaint TSQL Custom backups for SQL2005 Express Edition Most popular articles Download Reporting Services Scripter Easily script SQL Server Reporting Services SQL 2005 Service Manager A SQL 2005 version of the SQL Server Service Manager Automating Database maintenance in SQL 2005 Express Edition Part II How to automate database backups and maintenance in SQL 2005 Express Edition Automating Database maintenance in SQL 2005 Express Edition Part I How to automate database backups and maintenance in SQL 2005 Express Edition Download Reporting Services Linked Report Generator Easily generate Linked Reports

© Copyright sqldbatips.com 2008. Contact webmaster

home | news | articles | code | blog | links | search