I lost two hours re-creating ETL logic I had broken. Here is why ETL version control matters, especially when a team works on the same project.
SQL SERVER – Latest expressor Data Integration Platform Posts
My latest three posts on the expressor data integration platform: Datascript Modules, 5 tips for better data with expressor Studio and the 3.2 release review.
SQL SERVER – Introduction to expressor Datascript Modules
With expressor 3.3 you get Datascript modules, reusable script files you can share across projects. See how they work in a one-to-many example.
SQL SERVER – Running SSIS Package in Scheduled Job
How to run an SSIS package on a schedule with a SQL Server Agent job, step by step, after my earlier post on running it from the command line.
SQL SERVER – Management Studio and Browser in Same Application – SSMS Browser
The SSMS Browser opens with CTRL+ALT+R, right inside Management Studio. Split it next to a query window, handy when you travel with a single laptop screen.
SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD
Connecting with Windows Authentication by SQLCMD needs the -E switch, not a username and password. Here is my fun chat with my old friend DJ about it.
SQLAuthority News – Restart Remote Computer – Shutdown Remote Computer
Remote desktop on Windows 7 hides the shutdown option. From the command prompt, shutdown /r restarts and shutdown /s shuts down the remote computer.