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.
2008-12-01
2,512 reads
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!
2008-12-01
6,724 reads
2008-12-01
136 reads
2008-12-01
927 reads
2008-12-01
980 reads
Data warehousing author and expert, Vincent Rainardi, brings us a new article that looks at one of the most frequently used dimensions in Analysis Services.
2008-11-28
18,809 reads
Troubleshoot SQL Server Reporting Services (SSRS) issues such as configuration, report designs and importing and exporting report data using Excel.
2008-11-28
4,130 reads
New features in SQL Server 2008 Reporting Services mean improved charting and increased memory. Learn more about SSRS performance upgrades in SQL 2008.
2008-11-28
4,708 reads
Calculate the Running Total for the last five Transactions on an Iterative basis
2008-11-27
5,166 reads
MVP Brian Knight shows how you can use precedence constraints to control the flow of your SSIS packages.
2008-11-27
5,115 reads
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers