A Polished Way to Run SSIS Child Packages With a Script Task

The SSIS Execute Package task works well for running child packages from a master package, and in many cases using it will fit your needs. But what if you are looking for something more powerful? Maybe you want to dynamically populate variables in the child package without dealing with master/child package configurations and their restrictions. …

Continue reading ‘A Polished Way to Run SSIS Child Packages With a Script Task’ »

Speed Up SQL Agent Jobs by Preventing Simultaneous Runs

I’ve seen the time it takes a SQL agent job to complete on a resource-limited system increase tenfold when running alongside another job compared to when it’s run individually. I’ve also seen several jobs run simultaneously without any hiccups. Parallel Processing is a good thing, and your goal when scheduling SQL agent jobs should be …

Continue reading ‘Speed Up SQL Agent Jobs by Preventing Simultaneous Runs’ »

A Framework for SSIS ETL Development

The following is a brief generalized overview of a framework I developed on one of my projects for ETL processing using SQL Server Integration Services (SSIS). It is meant to provide an organized, consistent, centrally configured and managed, and disaster-recovery and audit friendly environment in which SSIS ETL processes can be developed and executed. This …

Continue reading ‘A Framework for SSIS ETL Development’ »

Use SQLjobvis to Help Optimize SQL Agent Jobs and Schedules

When do my jobs run? How long are my jobs taking to complete? It’s often helpful to visualize what’s going on with your scheduled SQL Agent jobs to answer these types of questions. SQLjobvis from SQLsoft is a tool I like to keep handy to help me answer some of these questions. SQLjobvis is a …

Continue reading ‘Use SQLjobvis to Help Optimize SQL Agent Jobs and Schedules’ »

Tools to Compare and Merge Code Better in TFS Source Control

Do you use source control? Whether it’s TFS or another of the many good source control options available, there are likely times you have needed to compare or merge code within your source control system. Sometimes I’m reviewing something my team is getting ready to release to production. Other times I have a local copy …

Continue reading ‘Tools to Compare and Merge Code Better in TFS Source Control’ »

SSIS – Faster, Simpler Alternatives to the SCD Transform

Many of the tables in your databases contain dimensional data – descriptive information about objects that can be grouped and organized at a higher level than an individual transaction. And most of these dimension tables are sure to fit one of the definitions of a slowly changing dimension. When loading data into these tables using …

Continue reading ‘SSIS – Faster, Simpler Alternatives to the SCD Transform’ »

SSRS – Tame Your Report Date Selection Parameters

Dates are likely the interactive parameters that are included most often in SSRS reports.  What’s happening now?  How does that compare to what happened then?  These are some of the questions we ask, and date parameters help us to answer them.  Often I see date parameters being used in a way that works, but does …

Continue reading ‘SSRS – Tame Your Report Date Selection Parameters’ »

SSMS – Distinguish Your Dev Environments With a Little Color

There comes a time in every man’s life when he must cross the boundaries of common sense, when he must go against society’s norms to accomplish something great, when he must… run sql code in Sql Server Management Studio (SSMS) directly against a production server.  We all do it.  We all have valid reasons to …

Continue reading ‘SSMS – Distinguish Your Dev Environments With a Little Color’ »

Migrate TFS to a New Server – This Update Path IS Possible

The Scenario – Why Migrate TFS? The officially recommended and supported way to move from an older version of TFS to a newer one is to do an in-place upgrade of your existing installation. There are many reasons, however, why you may prefer an option to migrate your existing TFS data to a new server. …

Continue reading ‘Migrate TFS to a New Server – This Update Path IS Possible’ »

SSMS 2012 Feeling Intellisense-less? dbForge Can Help

When I first begain working in SQL Server Management Studio (SSMS) 2012, I noticed one thing right away – intellisense seems to be much less reliable than it was in SSMS 2008. It doesn’t seem to “intellisense” anything most of the time. So off I go to search google, looking into what might be wrong. …

Continue reading ‘SSMS 2012 Feeling Intellisense-less? dbForge Can Help’ »