The interest in dynamic data warehousing (DDW) is growing significantly. A sure sign that the virtual brand has reached take-off speed is claims by bloggers that they did not get enough credit for coining the concept, viral brand or idea. For example, Dan Linstedt recently went on what he described as a "rant" about "dynamic data warehousing."
2007-07-03
2,137 reads
Check out our Top 10 tips on Analysis Services 2005 that will help you navigate through the features and functionality of this priceless Business Intelligence tool.
2007-07-02
4,883 reads
Get a free copy of Two Minute SQL Server Stumpers, Vol. 1 from End to End Training.
2007-06-29
2,515 reads
In this article, we will examine some rarely explored areas that concern foreign keys; in particular, we will look at disabled and un-trusted foreign keys.
2007-06-29
3,287 reads
In this series, Brian Knight shows you an actual difficult business problem to solve, gives you hints about how to solve it and then lastly shows you step-by-step instructions how to solve it if you want the help. n this video of the series, Brian demonstrate how to unpivot data that may arrive from the mainframe and load a many to many table with SSIS.
2007-06-28
2,119 reads
This article contains information about the things we have learned while working with Federated Databases. Before beginning it is necessary to define the terms being used. Included in this article is one solution in production that is using federated servers and Distributed Partitioned Views.
2007-06-27
1,732 reads
This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers. Load-balanced querying ensures that readers of OLAP cubes can consistently query for the latest aggregations throughout the day and distribute the load of all queries among the available servers. This scale-out querying architecture optimizes cube processing time, increases the frequency of cube update, and makes processing more robust as you can afford more frequent processing and transparent error recovery.
2007-06-26
2,630 reads
2007-06-25
3,585 reads
The SQL Server Tables and Exchange Web Services sample demonstrates a powerful integration of Microsoft® Exchange Server 2007 and Microsoft SQL Server™ 2005 features. This integration enables you to provide data from both Microsoft Exchange and SQL Server to client applications so that the data appears as if it were stored in SQL Server. As you will see, this creates some exciting development scenarios.
2007-06-22
1,640 reads
One thing that people typically want to do is always execute a particular task regardless of whether a checkpoint file exists or not. In this video, Jamie shows you how to create a package that can conditionally skip a checkpoint if it's in place.
2007-06-21
1,319 reads
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Wa:082374977784 Komplek, Ruko Kemang Pratama, Jl. Kemang Pratama Raya No.1A Blk AN, RT.004/RW.001, Bojong...
Comments posted to this topic are about the item What Did Healthy Look Like?
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
How many types of DML triggers are there?
See possible answers