(Mosha Pasumansky) The September CTP of Katmai (speculated to be released during PASS) is expected to be the first Katmai CTP to contain significant improvements in the OLAP engine. The most important one (which is, in my opinion, is also the most important AS Katmai feature) is changes to the query
Other News
The ‘SQL Server:SSIS Pipeline’ performance object does not appear in the ‘Performance object’ list after you install Integration Services from a 64-bit version of SQL Server 2005
Consider the following scenario. You install Microsoft SQL Server 2005 Integration Services from a 64-bit version of Microsoft SQL Server 2005. In System Monitor, you try to add the SQL Server:SSIS Pipeline performance object. In this scenario, the SQL Server:SSIS Pipeline performance object does no
Attaching and Detaching databases in SQL Server
There are a lot of options available to the database developer/DBA to move the databases from one instance to another instance. Backup and restore is one of them, copying them over using DTS or SSIS is another one, having your DDL and DML copy scripts is yet another way to do it. One of the popula
How to Create a Database Connection by using the Business Data Catalog Definition Editor
(Jo-Anne West) Learn how to create a database connection for the Business Data Catalog in Microsoft Office SharePoint Server 2007 with the Microsoft Business Data Catalog Definition Editor tool for Microsoft Office SharePoint Server 2007.
A Clean Exit
(Jim Mischel) The fundamental problem is that once the main program starts the logging thread, that thread runs essentially forever because there is no clean way to shut it down. Calling Thread.Abort will in most cases cause the thread to exit, but it’s hardly a clean way to do things. Thread.Abort
Legacy SQL Server Application Upgrades
Featured Article(s) Tips for using SQL Server 2005 Merge Replication (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 Merge Replication. I Can Hear the Users Now: "We Want (More) Reports!" Egad. Building reports and writing the applications to produce them, get them to the users and let them tweak them with parameters and […]
What Is Your SQL Server Day All About?
Featured Article(s) Understanding the SDLC phases of a Software Project [Part II] In the earlier part in this series we have had a look at the basics related to this topic and a few phases of SDLC. In this part we will discuss some other phases of SDLC in the sections that follow. RSS To Get SQL Server Results? Yes. […]
Oracle 10g/11g – OLAP, CUBE and ROLLUP
(Venkatakrishnan J) If you had gone through the list of features in Oracle 11g, one of the most important advancements/features in the BI space would be the introduction of Oracle OLAP as part of the DB optimizer (in the form of MV query rewrite). But for users who do not have the luxury of using Or
Web Vocabularies (Sample Chapter)
(Sas Jacobs) As XML grows in popularity, the number of XML vocabularies used within various industry and community sectors increases. These groups use XML to store database information, exchange structured information, and even describe concepts. (pdf)
Using AJAX For Rich Web Pages
(Rick Leinecker) Creating web pages with rich content yet nimble response is the holy grail of web development. For years, desktop applications have performed user interface operations with almost no perceptible delay, but web applications have been at the mercy of the speed of the Internet connecti