Using CLR Integration in SQL 05 for Writing Stored Procedures
With SQL 2005 you can harness the power of a higher-level language to not only do more with stored procedures, but also save time by already knowing a popular .NET language.
Real-Time Ambition: Reaching the Potential of Event Processing
Complex event processing (CEP) software delivers on the promise of real-time insight, but is the technology too green for mainstream success? CEP was once available only to big financial institutions and government agencies that could afford custom development projects. That's no longer the case, as off-the-shelf products and implementations have proliferated.
SQL Server 2005 Express Edition - Part 1
Marcin Policht offers an overview of choices offered in the SQL Server 2005 product line, as an introduction to a new series on the Express edition.
Stop SQL Injection Attacks Before They Stop You
This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.
Pop Rivett and the Expanding Log
When your database transaction log is out of control, there is only one man who can tame it.
XML not boring! New workbench
Robyn Page and Phil Factor almost dispel the myth that XML is boring, with their radical new SQL Server XML workbench.
Certification Rumors and Tips
Should you get certified? How should you do it? Brandie Tarvin brings us some tips on what might work and dispels some of the myths and rumors about certification.
SQL Server 2000 SP3a Support is Ending
Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.
Debugging Stored Procedures in Visual Studio 2005
This article walks through the basics of debugging stored procedures using Visual Studio 2005. It covers breakpoints, watches and stepping through code.
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers