We featured two great articles on the home page of TechNet Wiki, gold medal winners from the October TechNet Guru contest (October seems a long time away, but judging takes a few weeks, etc.)...
By Jason Brugger December 8, 2013
SSIS Package Configurations allows property values which are particular to a given SQL Server instance to be customized for that instance without modification to the underlying package. To quote SQL BOL, "SQL Server Integration Services provides package configurations that you can use to update the values of [package] properties at run time." If unfamiliar with package configurations...
Here's an excerpt:
Next, complete the Package Configuration Wizard and specify the view as the configuration source:
By Naomi N December 8, 2013
This article will share collection of links in regards to various aspects in Transact-SQL language I acquired over the years and saved in links.txt file. Many of these links come very handy answering various questions in SQL Server related forums. Categories: Select Top N Rows per Group, Performance Optimization, EXECUTE vs sp_ExecuteSQL, SQL Server Internals, Dynamic Search...
Here's an example section:
CTE syntactic sugar
CTE versus Temp Table
Thanks to Jason Brugger and to Naomi N for these fantastic award-winning contributions!
- Ninja Ed