Here’s a TSQL optimization tip: it seems like a single SELECT statement is faster than multiple SET statements. SET @foo1 = 0 SET @foo2 = 0 SET @foo3 = 0 ... is slower than one SELECT like: SELECT @foo1 = 0, @foo2 = 0, @foo3 = 0 [via Jason Lautzenheiser [http://dotnetjunkies.com/WebLog/harpua/archive/…
A Practical Implementation [http://www.net-security.org/article.php?id=722] of a Real-time Intrusion Prevention System for Commercial Enterprise Databases…
New HTTP Endpoints Create SQL Server 2005 Web Services [http://www.developer.com/services/article.php/3390241] > So what is an HTTP Endpoint? You may have heard that it is SQL Server 2005’s means for creating Web services, but it actually is much more. An HTTP Endpoint also…
YukonXML.com [http://www.ss2005.com/] is a new SQL Server 2005 Community Web site.…
A few days back, my friend Pankaj was enquiring about a particular case where he needed to automate the backup (in the form of SQL scripts) of all SQL Jobs (schedules) on a SQL Server (2000). DTS doesn’t support automatic scripting of SQL Jobs from what I could tell.…
SQL Server 2005 (Yukon) Beta 2 is now available for MSDN subscribers [http://msdn.microsoft.com/subscriptions] and SQL Server 2005 Express Beta 2 [http://lab.msdn.microsoft.com/express/sql/] have been released as well. Also a good read is the Comparison of MSDE with SQL Server Express [http:…
Log Parser [http://www.logparser.com/] is a free command-line tool from Microsoft that lets you run SQL queries against a variety of log files and other system data sources, and get the results out to an array of destinations, from SQL tables to CSV files.…
Exporting data to a XML file in SQL Server 2005 [http://www.sqldbatips.com/showarticle.asp?ID=23] using a VB.NET stored procedure (now that SQL Server supports the new CLR integration). Must read!…