home articles news code blog links search

		Updated version of Expressmaint utility now available An updated version of the Expressmaint utility (1.5.0.0) is now available. This version adds two new database operations for updating database statistics and a new switch to control whether to continue multi database operations if they fail for one or more databases. It also includes a fix for a bug in SMO with the Reorganize method which generates incorrect TSQL for indexes with a non default fill factor. More >> Updated release of Vista SQL 2005 Service Manager available A new build of SQL 2005 Service Manager for Vista is now available (2.0.0.5). This releases adds compatability for SQL 2008 RC0 and filters the SQL Agent service from being managed for SQL 2008 Express Edition More >> Updated releases of SQL 2005 Service Manager available A new build of SQL 2005 Service Manager is now available for XP, Windows 2003 and Windows 2008 (1.0.0.13). This releases adds compatability for SQL 2008 RC0 and filters the SQL Agent service from being managed for SQL 2008 Express Edition. Updated sourcecode is available from the Codeplex site. A new build for Vista will be available shortly. 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/2008 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 Ltd 2008. Contact webmaster

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