By Russ Whitney – When you’re choosing between relational reporting and OLAP for data analysis, remember that the two tools are different. Relational reporting can provide solid data for decision makers, but OLAP addresses the human side of the equation.

Learn about the installation, implementation, and behavior of HTTP connectivity in SQL Server 2000 Analysis Services Service Pack 3.

(Peter Galli) Microsoft Corp. has pushed back the release of the next version of SQL server, code-named Yukon, which will now ship in the second half of 2004 rather than the first half as previously expected. Paul Flessner, the senior vice president of Microsoft’s Windows Server division, told se

By Kevin Komiega – Database-archiving specialist Princeton Softech says that the latest version of its archiving software, Archive for Servers 5.2, meets auditing, reporting, business and legislative compliance requirements for relational database content that is archived and managed by EMC Corp.’s

It sounds like “Yukon” Beta 1 is still 30 to 60 days out (and will be a closed beta with prearranged participants, anyway). But that won’t stop Microsoft from talking turkey about its next version of SQL Server, at the TechEd conference. We’ve been conversing since last fall with Randy Hollow

A conflict has been discovered between SQL Server 7.0 clustering and MDAC versions 2.5x and later. See this support article for details.

By Vyas Kondreddi – Everything you need to know about searching datetime data (date and time values, also known as temporal data). This article discusses how the date and time values are stored in SQL Server, and shows you how to search and extract data from these datetime columns, with complete exa

I want to test a connection from Microsoft Visual Basic version 6.0 to SQL Server. I tried to conduct the test through the SQL-DMO VerifyConnection property but was unsuccessful. Listing 1, which follows, shows the code I used. Where did I go wrong?

Join Bill Pearson as he further develops intermediate concepts using MDX in Analysis Services. In this tutorial, Pearson works with hierarchical relationships in leveraging MDX to meet analysis needs.

After you upgrade to SQL Server 2000 Service Pack 3, the SQL Server query optimizer may incorrectly estimate the cost for queries that involve a predicate that uses a NOT EXISTS () construct. The estimate will be too high, and results in poorly performing queries as compared to SQL Server