sqlservercentral.com
Power and Deception of CTEs
01.12.2008 00:14
sqlservercentral.com
A performance problem with a CTE based stored procedure, opened the developers eyes to a whole new world
World
Programming Languages
Configuring Transport Encryption in SQL Server 2005 Express Service Broker Conversation
01.12.2008 00:14
sqlservercentral.com
In the recent installments of our "SQL Server 2005 Express Edition" series we have been discussing mechanisms that facilitate authentication of distributed systems participating in Service Broker conversations. This article discusses use of digital certificates in encrypting their content on the transport level.
World
Programming Languages
SQL Server Index Basics
01.12.2008 00:14
sqlservercentral.com
Given the fundamental importance of indexes in databases, it always comes as a surprise how often the proper design of indexes is neglected. It often turns out that the programmer understands detail, but not the broad picture of what indexes do. Bob Sheldon comes to the rescue with a simple guide that serves either to remind or educate us all!
World
Programming Languages
English