Featured Articles: "Using a View to Mask Multi-Server SSIS Package Configurations" and "T-SQL Useful Links"

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.)...

 

Using a View to Mask Multi-Server SSIS Package Configurations

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:

1. In SSDT, under package properties, click Configurations.
2. In the Package Configurations Organizer, check Enable package configurations, and click Add.
3. Under Configuration type, select SQL Server.
4. Under Connection, click New to create a new Connection manager if a connection manager of type "Native OLE DB\SQL Server Native Client 11.0" doesn't already exist. Select the database that hosts the configuration table and view.
5. Under Configuration table, select the view (not the table) created above.
6. Under Configuration filter, choose any name that will uniquely distinguish this package from other packages. Avoid any server-specific references.
7. Click Next and complete the wizard.

 

 

 

T-SQL Useful Links

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:

Common Table Expression

• CTE and hierarchical queries
• CTE: Coolest T-SQL Enhancement - interesting blog by Brad Schulz.

CTE Performance

• Umachandar Jayachandran ideas
• MS Feedback Suggestion by Adam Machanic 

CTE syntactic sugar

• MSDN related thread
• Another related thread by Umachandar Jayachandran

CTE versus Temp Table

• MSDN Thread by Umachandar Jayachandran
• MSDN thread by Adam Haines

  

 

Thanks to Jason Brugger and to Naomi N for these fantastic award-winning contributions!

   - Ninja Ed

Comments

• Anonymous
  December 09, 2013
  interesting article watchnflliveinhd.com/watch-dallas-cowboys-vs-chicago-bears-live-hd

• Anonymous
  December 09, 2013
  Jon, Yes, very interesting. Regarding the Cowboys and Bears game, are you using SQL Server to capture relevant data into a database system? Have you figured out how to use your streaming service to automate data-point telemetry from the commentary track?