Error configuration in SSAS
In SSAS, there is an Error Configuration object that is central to the management of data integrity errors.
The following picture...
2011-10-12
2,434 reads
James Serra's Blog
Sometimes temp tables can be your best friend
Here is a quick example of when using temporary tables will give you a big performance gain. I recently was...
2011-10-10
880 reads
Denormalizing dimension tables
When building a SSAS cube, you typically have a star schema containing dimension tables and fact tables. For dimension tables,...
2011-10-07
2,242 reads
Microsoft’s Data Warehouse offerings
If you are the decision maker in your company and you are tasked with purchasing one or more servers to...
2011-10-05
1,300 reads
Want to browse the web faster?
In our day-to-day activities, browsing the web is one of the most important aspects of our job. Whether researching for...
2011-10-03
801 reads
Microsoft SQL Server Reference Architecture and Appliances
Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and...
2011-09-30
3,768 reads
Consultants: 1099 or W-2?
As a consultant or contractor, you can sometimes be faced with the decision when taking a new contract of whether...
2011-09-28
1,888 reads
What is a Microsoft Regional Director?
First off, they don’t work for Microsoft. A Microsoft Regional Director (RD) is an unbiased third-party evangelist of Microsoft products and...
2011-09-26
1,464 reads
Microsoft Partner Network explained
I’m sure in your travels in the field of IT, you have seen or heard of companies being called a...
2011-09-23
1,478 reads
Miss 24 Hours of PASS ? No problem, all videos are online
All the videos for the sessions at 24 Hours of PASS are available for free. Check the session schedule for...
2011-09-22
555 reads
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers