Implementing Type 4 Slowly Changing Dimensions in SQL Server
Learn about a Type 4 Slowly Changing Dimension in this article by Dinesh Asanka.
2026-09-16
3,691 reads
Learn about a Type 4 Slowly Changing Dimension in this article by Dinesh Asanka.
2026-09-16
3,691 reads
Learn about using classification as a technique to prepare your data for additional machine learning analysis.
2026-07-15
1,021 reads
Learn how to add the geometric mean in Power BI to your calculations.
2026-07-06
1,180 reads
Learn how you can add a harmonic mean calculation in Power BI.
2026-06-16 (first published: 2026-06-15)
1,028 reads
We can get data in all sorts of formats in the real world. In this new article from Dinesh Asanka, learn how to use scripting to import data from individual Excel cells.
2010-04-28
16,670 reads
Integration Services has a lot of features to enable to you perform ETL operations on data moving into SQL Server. Longtime author Dinesh Asanka brings us an article on
2009-01-14
12,275 reads
Longtime author Dinesh Asanka brings us a short tutorial on importing your data from Excel 2007 into a database using Integration Services.
2008-10-24
15,888 reads
Longtime SQL Server author Dinesh Asanka brings us a new article on backing up an Analysis Services database.
2008-07-17
15,608 reads
SQL Server 2005 has added many new T-SQL commands, one of which is the OUTPUT command. Longtime SQL Server author Dinesh Asanka brings us a short look at how you can use this command.
2008-06-06 (first published: 2007-07-09)
16,377 reads
This review of RedGate's new SQL Multi Script tool that aids you in deploying a script across multiple databases.
2008-03-20
3,628 reads
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers