Azure DWH part 18: Working with SQL Server Analysis Services
In this new article, we will learn how to create a cube extracting data from ADWH.
2020-05-22 (first published: 2017-10-09)
2,248 reads
In this new article, we will learn how to create a cube extracting data from ADWH.
2020-05-22 (first published: 2017-10-09)
2,248 reads
In this article, we will show how to create reports in ASDW using SSRS
2017-03-27
1,377 reads
In this new article, we will show how to use the SSIS term lookup transformation tool.
2016-04-27
1,746 reads
2013-10-25
2,038 reads
2014-09-12 (first published: 2011-12-22)
3,079 reads
2005-02-18
IF ISDATE(CAST(DATEPART(YEAR, GETDATE()) AS CHAR(4)) + '-02-29') = 1 BEGIN PRINT 'Leap year' END ELSE BEGIN PRINT 'Not a leap year' END
2005-01-19
Hi, Happy New Year There are two very basic options. The first is to generate a DTS package that performs all the tasks you need, alternatively, you could split the tasks into smaller DTS packages and schedule them as ‘Jobs’ (under management folder (if using 2000)). In both options you have a precedence order so […]
2005-01-05
I just looked up the original request and it says that there are 3000 users. I agree with the previous statement of IloveSQL that with this number of users who are the domain users you will be MUCH better off granting access to the domain user group, like a global group / groups. Please, read […]
2004-09-28
To delete records from PROD for matching records in AUDIT, given the constraints I listed in the original post.
2004-03-09
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
It’s a great question. Let’s say you want to capture stored procedure completions. But,...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers