Slowly Changing Dimensions
When designing a data warehouse, how you handle changes to dimensional data over time is the most important decision to make. It...
2012-02-03
1,214 reads
When designing a data warehouse, how you handle changes to dimensional data over time is the most important decision to make. It...
2012-02-03
1,214 reads
Ok, I know that creating a time dimension down to the millisecond is extremely rare. After all, we are talking...
2012-02-01
1,260 reads
While using a cube in SSAS is usually a great source for reporting, it is not always the best choice....
2012-01-30
2,332 reads
Here is a situation I ran into recently concerning using a fact table in SSAS. This experience may help you out if...
2012-01-27
1,270 reads
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,327 reads
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
901 reads
If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD. You...
2012-01-20
885 reads
There are some FANTASTIC videos of the sessions from SQLInspire New York 2011. I highly recommend that you check out...
2012-01-18
530 reads
In previous SSIS versions as the developer you were responsible for configuring all of your logging options, such as what...
2012-01-16
1,214 reads
I have been fortunate the past few months to be working on a HP ProLiant DL980 G7 Server. This is...
2012-01-13
945 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
If you run this code it creates a 2 row cursor loop. Within the...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers