(Douglas Reilly) Kent Tegels is the man behind the Enjoy Every Sandwich blog on the SqlJunkies.com web site. He is also an instructor for DevelopMentor, teaching courses on .NET and SQL Server, with emphasis on SQL Server 2005. He is one of the co-authors of Beginning ASP.NET Databases Using VB.NET,

(Brian Walker) This tip continues the system stored procedure series with a routine to perform crosstab operations. (R)

(Don Schlichting) In the preceding articles of this series, Lock Granularity, Transactions, and ACID were introduced. Common lock types, such as Shared, Exclusive, and Update were explored, as well as using SP_Lock to obtain current system lock information. In this article, the normal internal SQL l

Microsoft SQL Server 2000 Analysis Services may unexpectedly close when all the following conditions are true: • You process a cube by using Analysis Manager or a custom Decision Support Object (DSO) application. • The cube contains one or more custom dimension security definitions for a role.

(Greg Robidoux) Running backups and restores is a pretty straightforward process, but issues do arise on occasion. The following is a list of five common problems and steps to help you resolve them. (R)

(Joe Chang) One of the most difficult database operations to scale-up on high-end server systems is the network call. In fact, without special precautions, a high call volume database application can have severe negative scaling on large systems. It is suspected that this problem is more pronounced

(Serdar Yegulalp) You can authenticate to SQL Server using either a native SQL Server user account or a Windows domain account, such as Active Directory. All too often, a SQL Server administrator who simply wants to get things up and running will use SQL Server’s native administrator account (the sa

In Microsoft SQL Server 2000 Service Pack 3 (SP3), when you use Enterprise Manager to view SQL Server agent properties, the Mail Profile combo box that displays profiles is disabled. Additionally, when you try to use the xp_sendmail stored procedure from a DTS package, the operation may fail, and yo

(Deann Corum) In the first part of our look at securing distributed Windows apps, we covered how authentication and authorization are typically handled in Windows-based applications. Today, we’ll cover some very specific recommendations for locking down IIS and SQL, both of which are often a large p

(William Pearson) As practically anyone involved in business intelligence is aware, multidimensional databases contain aggregated information to support rapid query processing. The beauty of OLAP (Online Analytical Processing) is that it stores high-level summaries for virtually instant delivery to