home articles news code blog links search

		Websites  |  Presentations  |  Events sqldbatips.com blog The blog for this site SQL Server Community Microsofts SQL Server Community site Search Google Newsgroup Archives Googles archive of the public SQL Server newsgroups UK SQL User Group Forums, UK SQL events, Neil Pike's FAQ and blogs ASPFAQ Massive amount of content on SQL Server as well as ASP SQLTeam.com Excellent articles, forums and blogs covering all aspects of SQL Server SQLDTS.com The Data Transformation Services resource on the web Tibor Karaszi's SQL Server pages Excellent site featuring articles, code samples and newsgroup FAQ SQLXML.org All you need to know about SQLXML and using XML in SQL Server sqldev.net Lots of extremely useful articles, code and presentations PASS Home Page PASS is the definitive, global community for SQL Server professionals SQL Server Home Official Microsoft site for SQL Server - huge amounts of information straight from the source www.sommarskog.se Indepth articles including the definitive "The curse and blessings of dynamic SQL" Vyas' SQL Server Home Superb articles, code samples, interview questions, an invaluable resource SQL-Server-Performance.Com Excellent articles and forums focussing on performance related issues SQLSecurity.com All things SQL security related SQL Server Support Centre Portal for all SQL Server Knowledgebase content, webcasts and downloads www.ExtremeExperts.com Articles, tips and tricks, code snippets, tools on programming SQL Server 2000 Connections Largest collection of ADO and ADO.NET connection strings on the Internet www.nigelrivett.net Code samples and articles covering SQL Server, ASP and Visual Basic tkdinesh.com Excellent SQL Server FAQ Umachandar's Technical Resources Tons of extremely useful scripts and other resources Steve's SQL Page Presentations, articles and code samples from Steve Kass SQL Server Magazine Covering all relevant SQL Server hot topics, tips, tools, and more SQL Server Professional Offers insightful articles, undocumented techniques, and links to additional useful content Back to top Building a DDL Audit Solution using SQL Server 2005 Keeping track of schema changes has always been challenging. This presentation demonstrates an effective and performant DDL audit mechanism using the new Event Notification infrastructure built into SQL Server 2005. An overview of the available audit methods is exhibited with in depth analysis of event notifications including performance and security implications. View Presentation Download Presentation and Code Auditing Events in SQL Server 2005 Finding out who did what and when within SQL Server has always been difficult without third party tools – until now. With the arrival of SQL Server 2005, DBAs now have a variety of tools and techniques to capture and react to server events. This session will explain these new features including DDL Triggers, Event Notifications, SMO Trace API’s and SQL Agent WMI Integration and demonstrate scenarios where they can be employed to help audit and troubleshoot SQL Server 2005. Code samples are included in the downloadable zip file View Presentation Download Presentation and Code Examining DDL Triggers and Event Notifications in SQL Server 2005 Originally presented at the PASS Community Summit 2004, this presentation demonstrates the use of DDL Triggers, Event Notifications and WMI Events in SQL Server 2005 and their use as an audit and change tracking mechanism. Code samples are included in the downloadable zip file View Presentation Download Presentation Really Hacking SQL Server 2000 Originally presented at the UK SQL Server User Group, this presentation demonstrates some of the many ways SQL Server can be attacked and how you can reduce the risks of attack View Presentation Download Presentation Troubleshooting Blocking in SQL Server 2000 Originally presented at the UK SQL Server User Group, this presentation demonstrates some of the tools and techniques to understand and troubleshoot blocking issues View Presentation Download Presentation Back to top Back to top	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