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.
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.
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
The NSE7_OTS-7.2 Practice Questions page is designed to help students and IT professionals prepare...
Comments posted to this topic are about the item The Vector Data Type
Comments posted to this topic are about the item What Power BI DirectQuery does...
What is the vector data type in SQL Server?
See possible answers