Creating a Database in SQL Server 2000
Sunday, February 10th, 2008“>When you create a new database, you are really just making a copy of the model database. Remember
SQL Server
VB.NET and SQL Server 2000: One Controlling Part of a Transaction
Sunday, February 10th, 2008“>This article is excerpted from Chapter 6, “Transactions,” of Sams’ .NET Enterprise Design with Vis
Relational Databases 101
Sunday, February 10th, 2008“>IntroductionMany of my readers come from backgrounds that don’t include formal training on the bes
Normalizing Name Data in SQL Server
Sunday, February 10th, 2008“>My article titled "String Manipulations with SQL Server 2000" gives a quick overview of
Integrating Microsoft SQL Server 2000 OLAP and Microsoft Office, Part 1: Creating an Excel PivotTable Report with an OLAP Cube
Sunday, February 10th, 2008“>Introduction to the SeriesThis is the first tutorial of a new series, Integrating Microsoft SQLSer
My Baby Done Wrote Me a Letter (Using SQL Mail)
Sunday, February 10th, 2008“>E-mail isn't my favorite technology any more. Much of the work and allof the junk I have to p
Filtering, Sorting, and Summarizing Data in Crystal Reports
Sunday, February 10th, 2008“>In this chapter Introduction Filtering the Data in Your Report Learning to Sort Records Workin
Maintaining Transactional Replication
Sunday, February 10th, 2008“>In previous articles of this series, I showed you how to plan fortransactional replication, how to
Installing and Configuring SQL Server Reporting Services
Sunday, February 10th, 2008“>As we discussed in Chapter 1, Reporting Services is dependent on ASP.NET version 1.1 hosted on IIS
Working with Analysis Services Cubes in SQL Server
Sunday, February 10th, 2008“>After you have populated your dimensional database (as discussed in theprevious article in this se