What is Analysis Services in SQL Server 2005?
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
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
Red Gate is looking to expand upon their ever-growing list of extremely helpful tools and asking for help from you DBAs out the real world. They have a survey with 20 questions on Security Tools and 5 people will be chosen to win a goodie bag. I have no idea what's in the bag, but it should be interesting.
2007-06-21
2,771 reads
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
Comments posted to this topic are about the item The Journey to Change
Comments posted to this topic are about the item Check Azure SQL DB Space...
Comments posted to this topic are about the item The Cloned Database Size
I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:I now run this command:
DBCC CLONEDATABASE(sandbox, sandbox_clone); GOWhen I examine the database file properties, what do they show? See possible answers