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
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers