2005-08-09
1,507 reads
Design and Theory
2005-07-22
2,242 reads
2005-06-20
2,014 reads
Three Vs: Best Practices for a Unified Business Intelligence Infrastru
This article presents a broad set of guidelines to define the value, voice and visibility for a unified BI project.
2005-06-16
2,324 reads
2005-06-10
2,058 reads
2005-05-20
1,740 reads
ENTERPRISE METADATA FRAMEWORK
Over the past few years, I’ve had the opportunity to discuss enterprise metadata to a wide variety of audiences and much of this conversation is captured in this “Best Practices” implementation framework. The model has evolved over the past few years as our program continues to do the same. Of course, this summary can only be a few pages long so the depth of the content here will be a tad shallow but you should be able to get the basics from the diagram and the description that follows. Figure 1 provides the new framework and the content follows to describe each section.
2005-05-19
1,821 reads
BUSINESS METADATA: HOW TO WRITE DEFINITIONS
Many errors and accidents are made/caused by misunderstandings of the meanings of terms used.
How many times have you been in a meeting when the words you heard being said did not match what you thought they were?
Many business decisions are made (and later regretted) due to a misunderstanding of the data, and what the data element used in a report is signifying. Some of these accidents and misunderstandings are large enough to be reported in the media. In prior papers I refer to the Mars Lander episode, where the unit of measure was assumed and not made explicit, miscalculations were made and the equipment was lost. Our businesses are filled with many such examples, although not as costly perhaps, are still quite impactful to the business.
2005-05-16
2,414 reads
2005-05-11
1,736 reads
2005-05-05
1,454 reads
Blogs
Deploying an Updated Model with SQL Compare 16
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Forums
Adding and Dropping Columns II
Comments posted to this topic are about the item Adding and Dropping Columns II
Leveraging DuckDB for OLAP Workloads: The Fabric Modern Data Platform
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
More Documentation is Needed
Comments posted to this topic are about the item More Documentation is Needed
Question of the Day
Adding and Dropping Columns II
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers