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.
2007-07-10
1,831 reads
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.
2007-07-09
3,077 reads
This article discusses: How SQL injection attacks work, Testing for vulnerabilities, Validating user input, and more.
2007-07-09
4,547 reads
When your database transaction log is out of control, there is only one man who can tame it.
2007-07-06
2,611 reads
Robyn Page and Phil Factor almost dispel the myth that XML is boring, with their radical new SQL Server XML workbench.
2007-07-06
3,684 reads
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.
2007-07-05
9,796 reads
Next Tuesday, support for SQL Server 2000 servers on Service Pack 3a ends, so be sure you are moving to SP4.
2007-07-05
3,363 reads
This article walks through the basics of debugging stored procedures using Visual Studio 2005. It covers breakpoints, watches and stepping through code.
2007-07-05
4,532 reads
Migrate to SQL Server 2005 and maintain, edit and develop your data transformation services (DTS) packages using the SQL Server DTS Designer.
2007-07-05
4,915 reads
With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.
2007-07-04
2,503 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Comments posted to this topic are about the item One more reason to use...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers