Exploded Pie Chart for Analysis Services Data
MSAS Architect Bill Pearson leads the hands-on creation of an exploded pie chart based upon an Analysis Service data source.
2009-07-16
2,446 reads
Additional Articles
William Durkin, Serial Red Gate Beta Tester
In this article sponsored by Red Gate, read about a beta tester's experience with new versions of SQL tools.
2009-07-16
1,595 reads
Downloading a file over HTTP the SSIS way
This post shows you how to download files from a web site whilst really making the most of the SSIS objects that are available. There is no task to do this, so we have to use the Script Task and some simple VB.NET or C# (if you have SQL Server 2008) code
2009-07-15
2,999 reads
Testing with Profiler Custom Events and Database Snapshots
We've all had them. One of those stored procedures that is huge and contains complex business logic which may or may not be executed. These procedures make it an absolute nightmare when it comes to debugging problems because they're so complex and have so many logic offshoots that it's very easy to get lost when you're trying to determine the path that the procedure code took when it ran. Fortunately Profiler lets you define custom events that you can raise in your code and capture in a trace so you get a better window into the sub events occurring in your code.
2009-07-15
2,305 reads
Service Pack 2 Uninstall Not Possible for SQL Server 2005
You probably already know that SQL Server 2005 SP2 has been released. This is a good thing if you are in need of one of the changes that are included in this service pack. In a previous tip, SQL Server 2005 - Service Pack 2, we took a look at what was to be included in this second service pack for SQL Server 2005. The question that you often face is should I install this service pack. One thing to note before you install SP2 is that there is no way to uninstall it once it is installed.
2009-07-14
2,824 reads
Top five tips for SQL Server developers
Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more.
2009-07-14
7,765 reads
Database Mirroring in SQL Server 2008
Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.
2009-07-13
3,451 reads
Transfer Logins Task and Transfer Database Task in SSIS
The Transfer Logins and Transfer Database tasks can be used in combination to easily and efficient migrate databases and users across different SQL Servers.
2009-07-13
2,220 reads
How To Enable User-Defined Hierarchies in SQL Server Analysis Services (SSAS)
I have a requirement to provide users with the capability to define their own reporting hierarchies for sales data. For instance they had a report which broke down sales by the four regional VPs then by office. Later they created regions, assigned VPs to each region, then assigned offices to each VP. Now they want to be able to create a number of other scenarios and choose which one when they run a report. Can you provide some suggestions on how to do this?
2009-07-10
3,043 reads
Partitioned Table and Index Strategies Using SQL Server 2008
The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.
2009-07-10
3,009 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Alamat BCA KCP Modernland Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Alamat BCA KCP Cikande Telp:0821°8200°203
Telp/Wa 628218200203 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok...
Alamat BCA KCU SERANG Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Pangeran Diponegoro No.14, Kotabaru, Kec. Serang, Kota Serang, Banten 42112
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers