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,760 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,732 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,870 reads
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
2008-03-05
36 reads
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Jl. Metro Pondok Indah No.10 Lt 2, RT.3/RW.17, Pd. Pinang, Kec. Kebayoran Lama, Kota...
Tlpn/wa0853.7373-7551 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL,...
Comments posted to this topic are about the item There's Too Much to Learn
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers