Flawed Data Integration

These days we often have multiple applications that need to exchange data in use by customers. Steve shares a few thoughts on his recent experiences.

Moving on but not far test

During my technical career, I’ve changed companies several times. I even worked as an independent contractor for three years. One thing I have never done before was switch departments and roles within one company. That’s about to change in a couple of weeks as I move from Simple Talk Editor and DevOps Advocate in Marketing […]

A SQL Server Patching Shortcut

This post on SQL Server patching illustrates a quick and simple way of safely extracting SQL Server installation files in advance of patching a SQL Server instance.

Installing SQL Server 2016

Greg Larson walks through the GUI installation process for SQL Server 2016 and explore these new installation options.

Installing SQL Server 2005

RE: cursor query does not work

Not sure if this is it but, your cursor should be declared STATIC since the underlying data is being modified during execution. STATIC ensures a buffered copy is used for the cursor loop. Try: DECLARE prob_cursor CURSOR STATIC LOCAL FOR ...

RE: Security related to DTS/RS

More information on how to setup and secure Reporting Services can be found on Microsoft's site: Reporting Services Technical Resources You'll probably be most interested in the whitepapers at the bottom of the page. As far as securing DTS packages, here is another link to look at: INF: Managing Permissions for DTS Packages in an […]

RE: Reference tables and performance

The bulk load process described by David has advantages, but the one issue I see is that the select distinct part filters duplicates from the load batch without respect to the existing data in the target table. If the original "duplicate" row is existing data then that step will still fail with a unique constraint […]

RE: The SQLServerCentral.com Move

oh joy... can't wait to do my move at the end of next month...luckily for me, I will also be moving the 400lb dell rack with my 3 servers, kvm, 2 switches, 19" monitor and various other ... stuff  double the estimate and add 2 hours... could do that.. I prefer the "42" estimate.  No […]

RE: Error Log

You could try something like this, create a global variable (g_PackageLog for example) and give it a value including the fully qualified path and then in an ActiveX script:Function MainDIM sLogsLog = DTSGlobalVariables("g_PackageLog").Value & Month(Now) & Day(Now) & Year(Now) DTSGlobalVariables.Parent.LogFileName = sLogMain = DTSTaskExecResult_SuccessEnd FunctionEveryday the package runs it would get a new file name containing […]