Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform ,however, it does not process large dimensional datasets...
2013-09-11
42 reads
Here’s an example of using T-SQL to process a Slowly Changing Type 1&2 Dimension . Note: SSIS has an SCD transform...
2013-09-11
1,132 reads
There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle Poolet summarizes it beautifully – “consider the data warehouse...
2013-09-11
27 reads
There is an ongoing discussion/debate regarding the handling of NULLS in a data warehouse, however, the following article by Michelle...
2013-09-11
734 reads
I wrote a post about creating a Filetable, which just covered the basics of how to build one. How do...
2013-09-11
1,092 reads
Good news everybody. October 1st is no longer the day that the MCM was prescribed to die. The Microsoft Certified Master is now on life support until December 31st,...
2013-09-11
6 reads
Good news everybody. October 1st is no longer the day that the MCM was prescribed to die. The Microsoft Certified...
2013-09-11
712 reads
Everyone, thank you for attending the SQL PASS Virtualization Virtual Chapter presentation entitled “SQL Server High Availability Options After Virtualization”...
2013-09-11
684 reads
It’s been emphasized over and over that the costs of operations within an execution plan, and the estimated costs of...
2013-09-11
1,735 reads
In this post we will look at a complete end to end routine for encrypting, storing, decrypting data in SQL...
2013-09-17 (first published: 2013-09-11)
3,874 reads
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers