(Terry Voss) A client recently asked me to prepare to train someone on SQL Server Reporting Services for their latest project. The project was a Visual Studio 2005 Beta 2 Windows Forms project, with an ASP.NET project also involved. Knowing that Reporting Services in Visual Studio 2003 is a Business

(Adam Machanic) In SQL Server 2005 sp_configure ‘allow updates’ has been deprecated from SQL Server. What is the equivalent code of sp_configure ‘allow updates’ in SQL Sever 2005? (R)

In Microsoft SQL Server 2000, when you use SQL Profiler to capture SQL Server traces, you may notice that the TextData column is empty for the following events: • SP:StmtStarting • SP:StmtCompleted • SQL:StmtStarting • SQL:StmtCompleted

(Paul Sanders) This paper provides an introduction to the Unified Dimensional Model (UDM), including the basic end-user model, and a brief overview of the architecture and security models.

(Sérgio Fontes) In this series of articles I want to analyze and describe database and query development for web solutions, as development technology we will use SQL and Microsoft SQL Server 2000 as the database engine. After making a small trip on the SQL basics we are read to take a look on T-SQL

When you try to use the Database Maintenance Plan Wizard to create a maintenance plan in Microsoft SQL Server 2000, an event that is similar to the following event may be logged in the Application log: Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208

(Simon Galbraith) Most skilled professionals—be they butchers, bakers or software makers—take pride in selecting their own tools of the trade. Why is it then that developers and DBAs in large corporations often are not afforded the same professional courtesy or opportunity? The tools they use are ju

(Jeremy Kadlec) I recently spoke on SQL Server performance tuning at CFUNITED, a conference focusing on Cold Fusion, where I found a large number of developers who use SQL Server every day. In my presentation, I offered a variety of free tuning tools that attendees were not aware of. Here I’ll share

(Mike Gunderloy) By now you probably know that there are a lot of fancy new high-end features coming in Microsoft SQL Server 2005. But in its quest to conquer the data center, Microsoft hasn’t forgotten the end user. In fact, there are more new features for desktop users and business analysts than e

After you apply Microsoft SQL Server 2000 (64-bit) Service Pack 4 (SP4) to an existing clustered instance of SQL Server 2000 (64-bit), the Full Text resource fails when you install a new clustered instance of SQL Server 2000 (64-bit). This problem occurs in both the default instance and the named in