Data Warehousing Tip #6 – Use a consistent unknown member key
In this article I’ll be discussing the benefits of using a consistent unknown member key across your data warehouse. And...
2019-02-18 (first published: 2019-01-28)
4,012 reads
Chris Jenkins' Blog
Data Warehousing Tip #5 – Use surrogate keys
My fifth data warehousing tip is to always use surrogate keys for your dimension and fact tables.
Surrogate keys are keys...
2019-02-07 (first published: 2019-01-18)
3,067 reads
Data Warehousing Tip #4 – Trust your instinct
My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if to you...
2019-01-21 (first published: 2019-01-14)
2,908 reads
Data Warehousing Tip #3 – Build thin slice
My third data warehousing tip is to build thin slice. Deliver subsets of valuable functionality. Get feedback and buy in,...
2019-01-16 (first published: 2019-01-07)
2,840 reads
Data Warehousing Tip #2 – What your data warehouse should be
I’ve seen data warehouses that nobody trusts, or are just too complex for end users to report on. Users will...
2018-12-28
1,366 reads
Data Warehousing Tip #1 – Store fact data at the leaf level
My first data warehousing tip is to store fact data at the leaf level. If you aggregate your fact data...
2018-12-10
320 reads
Reducing the size of the distribution database & improving transactional replication performance: Part 3
Part 1 of this series of articles looked at the intricacies of SQL Server transactional replication, and made the observation that the...
2014-10-27 (first published: 2014-10-20)
6,821 reads
Reducing the size of the distribution database & improving transactional replication performance: Part 2
The impact of having data sitting in the distribution database that doesn’t need to be there can be significant. The...
2012-11-26
4,083 reads
Reducing the size of the distribution database & improving transactional replication performance: Part 1
In this series of blog posts I will looking at issues regarding the size and performance of the distribution database as...
2012-11-08
18,944 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers