(Andrew Zanevsky) SQL Server Profiler is a veritable treasure trove when it comes to helping DBAs optimize their T-SQL code. But, the surfeit of riches (I’m reminded of the Arabian Nights tale of Aladdin) can be overwhelming. I recently had one of those “sinking” feelings when I first tried to m

(Joe Foley) Can the computer be a helpful business intelligence assistant rather than a guard protecting a massive collection of data? Can it answer the constant stream of both important and small questions that are faced in every business day, by every business person? The answer is that your

(Leo Peysakhovich) Last month I had an interesting task to deal with. It had to do with the way our business views the data. In many cases my company is using MS Access as the way to access the data from tables and then save user filtered, ordered, or grouped reports in various formats. I am not say

(D J Nagendra) Replication is the process of sharing data between databases in different locations. Using replication, we can create copies of the database and share the copy with different users so that they can make changes to their local copy of database and later synchronize the changes to the s

(Rudy Limeback) have three tables — table1, table2, and table3. All three contain information on a daily basis. I have written SQL statements to summarize the information of each table based on certain columns in the respective tables. Can I write an SQL statement where in it should perform th

(William E. Pearson, III) In this article, we will explore another tool that MSAS offers for the enhancement of cube processing, the Optimize Schema option. This option can assist us in significantly reducing a cube’s processing time. Optimize Schema attempts to identify unnecessary joins between ou

(Chris Sully) This series of articles is going to examine some of the issues around building a traditional B2C shopping cart e-commerce site using ASP.NET (VB.NET) and SQLServer. Some of the key functional areas are therefore: –shopping basket –customer registration (and login) –customer

(Christopher Kempster) The role of DBA is undoubtedly an important one, but many DBAs tend to be somewhat blasé about backup and recovery. This e-book attempts to bridge the knowledge gap and provide working scenarios, policy/procedure and best practice for database backup and recovery. (pdf)

(Bruce Szabo) Microsoft has provided so many great tools and at times they have helped solve many issues. There are cases though where the tools do not behave exactly as one would expect. There is nothing more frustrating than finding a tool that is supposed to help, actually causing an error or beh

(Matt Nunn) This document provides an overview of new features for database development in Microsoft SQL Server 2005.