home articles news code blog links search

		Updated version of Expressmaint utility now available An updated version of the Expressmaint utility (1.8.0.0) is now available. This version adds a fix for including databases that have not yet started for Express Edition and also adds SQL Authentication support More >> Updated version of Expressmaint utility now available An updated version of the Expressmaint utility (1.6.0.0) is now available. This version adds fixes for databases with apostrophes in their name and for errors if no report file is specified for backup operations More >> 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 >> Database Audit Specifications in SQL 2008 This series of articles describes the new Auditing features available in SQL Server 2008 Enterprise Edition. It covers the three new audit objects Server Audits, Server Audit Specifications and Database Audit Specifications and presents sample code and walkthroughs for configuring auditing using SQL Server Management Studio. This article presents a detailed look at the new Database Audit Specification object. More >> Server Audit Specifications in SQL 2008 This series of articles describes the new Auditing features available in SQL Server 2008 Enterprise Edition. It covers the three new audit objects Server Audits, Server Audit Specifications and Database Audit Specifications and presents sample code and walkthroughs for configuring auditing using SQL Server Management Studio. This article presents a detailed look at the new Server Audit Specification object. More >> Server Audits in SQL 2008 This series of articles describes the new Auditing features available in SQL Server 2008 Enterprise Edition. It covers the three new audit objects Server Audits, Server Audit Specifications and Database Audit Specifications and presents sample code and walkthroughs for configuring auditing using SQL Server Management Studio. This article presents a detailed look at the new Server Audit object. More >> Server and Database Auditing in SQL 2008 Overview This series of articles describes the new Auditing features available in SQL Server 2008 Enterprise Edition. It covers the three new audit objects Server Audits, Server Audit Specifications and Database Audit Specifications and presents sample code and walkthroughs for configuring auditing using SQL Server Management Studio. This article presents an overview of the new audit objects and their relationship with each other. 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 >>	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 Server 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