The easiest ways to maintain and manage slowly changing dimensions is using Slowly Changing Dimension Transformation in the data flow task of SSIS packages. Arshad Ali provides you with the steps needed to manage Slowly Changing Dimension with Slowly Changing Dimension Transformation in the data flow task.
Marcin Policht explores some of PowerShell's SSIS-specific automation capabilities by demonstrating the process of configuring an already deployed package in order to carry out a parameterized package execution.
Often overlooked, recursion offers developers an option that leads to clean, efficient solutions. Frank Solomon explains the ways SQL Server 2012 recursion works, and uses them to unpack an integer into its multiple-of-two additive components.
When you write TSQL code what kind of coding style do you use? Do you have a consistent way to comment and format your code? Does your organization provide standards for how you must code your TSQL? Join Greg Larsen as he discusses some of the coding styles you should consider when writing your TSQL scripts and stored procedures.
The new SQL Server 2012 Sequence Object can be used to generate unique numbers that can be automatically incremented based on an increment value. Greg Larsen discusses the different features of the sequence object and how you can use it to generate sequence numbers.
PowerShell lets you directly reference methods and properties of .NET Framework classes, which while not as straightforward and database administrator-friendly as cmdlets, give you considerably more power and flexibility. In this article, we will describe how this capability can be leveraged in order to manage SQL Server 2012 Integration Services.
Marcin Policht presents the fundamental principles of PowerShell in the context of SQL Server 2012. Join him as he steps through its initial setup and configuration, and reviews specific management areas where its advantages can be realized.
Developing a backup procedure that makes sure you can do restores should be one of your top priorities as a DBA. In this article Greg Larsen discusses some of the concepts to consider when developing, building and testing a backup strategy.