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
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers