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.
This next post from MVP Simon Sabin examines one of the major improvements in performance of search.
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?
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?
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?
This is the eighth article in a continuing series, and this installment discusses the Data Steward Coordinator.
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.
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.
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers