In an ever changing SQL Server environment, efficient management and monitoring is critical. In this webcast we describe the differences between Azure DB and on-premises SQL Server database environments and show how these are managed differently...
This is the final part of a series of tips on implementing a slowly changing dimension type 2 in SQL Server Integration Services (SSIS). In this final part we will introduce a solution for dealing with intra-day changes.
In this tip we look at a way to detect if a folder is write protected. This can be an issue when trying to write out data from SQL Server to the file system or even accessing database files that might be in a write protected folder.
The solution is to convert a SQL database sample into a tabular model sample by making changes in such a way that it looks as if the data model has gone through all the stages of the data warehouse and is ready to be used with a tabular analysis services