More and more companies are using data warehouses as a way of consolidating business critical information. And more and more of these companies want the warehouse available 24 hours a day, 7 days a week. This presents interesting challenges for the DBA involved in ETL processing. Longtime author Leo Peysakhovich brings us one solution for this problem.
2008-03-06 (first published: 2007-03-19)
8,759 reads
Business Intelligence Architect Bill Pearson continues his subseries surrounding components of the Analysis Services dimensional model. In the second half of this article, we extend our focus on dimensions to include property settings for Cube Dimensions.
2008-03-06
2,556 reads
This next post from MVP Simon Sabin examines one of the major improvements in performance of search.
2008-03-06
1,574 reads
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
2008-03-06
32 reads
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
2008-03-06
41 reads
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
2008-03-06
40 reads
This is the eighth article in a continuing series, and this installment discusses the Data Steward Coordinator.
2008-03-06
1,436 reads
In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.
2008-03-05 (first published: 2007-03-13)
6,726 reads
This article explains how to import text files using SSIS in those cases where the text files have different formatted data on different rows. The solution recommended involves minimal coding and is highly maintainable.
2008-03-05
8,863 reads
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
2008-03-05
36 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers