The issue When migrating the solution I’m currently working on to Azure eight months ago I was initially looking at transferring the SSIS packages that performed the ETL. We...
2020-05-07 (first published: 2020-04-27)
295 reads
My next tip is to test your BI solution with the volume of data that you are expecting. This is...
2019-03-13 (first published: 2019-02-25)
1,937 reads
In this article I’m going to show you how I build my time dimensions. There are lots of different ways...
2019-02-26 (first published: 2019-02-04)
3,878 reads
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)
3,979 reads
In this article I’ll discuss making your data warehouse better. I’ll admit that this is a pretty obvious aspiration, but...
2019-02-11
840 reads
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,041 reads
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,889 reads
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,822 reads
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,338 reads
My first data warehousing tip is to store fact data at the leaf level. If you aggregate your fact data...
2018-12-10
302 reads
By Steve Jones
There is a nice article at Harness.io on their use of feature flags and...
By James Serra
There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
Hello, I have long-term task, which came one year ago, and just now I...
Comments posted to this topic are about the item LOGON Trigger Count
Comments posted to this topic are about the item Invisible Downtime
I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?
See possible answers