(Marco Russo) BI Developer Studio does a lot of automatic changes when you change something. Each dimension is stored in a separate file, but many of the dimension informations are copied into cube files. When you modify a dimension which is already used by one or more cubes in the same project, the
Other News
Centralized Asynchronous Auditing with Service Broker
(Mladen Prajdiæ) Service Broker is a new feature in SQL Server 2005. It is an integrated part of the database engine and it provides queuing and reliable direct asynchronous messaging between SQL Server 2005 instances only. In the future this is planned to be extended to non-SQL Server instances. Th
Web Client Software Factory
(Fritz Onion) One of the first steps in building a long-lived ASP.NET project is to define standards for how to use the many features of the platform. Without such standards, it is easy for the project to degenerate into a jumble of different development techniques and styles. One developer may use
Oracle’s 11g Launch Impresses
(Doug Henschen) I’m just back from Oracle’s 11g launch event in midtown Manhattan, and I have to say I came away impressed. The database is at the center of Oracle’s world, and company president Charles Phillips strutted the vendor’s stuff — with his usual low-key swagger — on topics ranging from th
Building a report in XML Publisher
(Ruud Bloemen) Last week I made my first steps with XML-Publisher 5.6 Desktop and I am very pleased with the simplicity you can create a report in such a short time. When you follow these instructions you can see it yourself. After you have installed the XML-Publisher 5.6 Desktop you open Microsoft
Data integration and composite business services, Part 2: Providing a single view of your customer through service integration
(Mary Taylor and Li (Tony) Wei) This article is the second in a series of articles that address data integration in the development of Composite Business Services (CBS). The ability for a company to provide a “single view of the customer” is critical for effective SOA transformations. WebSphere Cust
MySQL as universal server
(Giuseppe Maxia) MySQL is the most popular open source database server in the world. As such, it must be enough to satisfy the needs of most of its users. But users don’t have only needs. They have wishes. And they wish to have a more powerful, more feature rich database server, and that’s why MySQL
SQL Server DBAs Visionary?
Don’t Miss The Latest SQL Server Show, SelectViews > Watch here – this week’s show is about understanding SSIS. What is "Vision" And Do You, As A DBA, Participate? Last week I posted a request for questions to be included in our survey of database professionals. One of the question suggestions I received (Thanks Jeremy!) was about vision. Specifically, do […]
What’s in a URI?
(Brian Sletten) When you think about the success of the Internet, your mind probably goes to the vast libraries of digital content: explosive social networks linking gamers, grannies, geeks, and gamblers; torrents of email, both wanted and unwanted; the ability to find out who “that guy” was in “tha
Are you running ODBC applications? Then here’s a nice APAR for you.
(Willie Favero) For all those ODBC applications running around out there, and you know who you are, here’s an APAR you’ll love. I know that everyone who deals with ODBC is always looking for any method they can find to improve ODBC’s performance. This is also another excellent example of why it’s im