(Steve Endow) I’ve developed many Dynamics GP Visual Studio Tools AddIns that depended on one or more SQL scripts.
Other News
Data Merging
Merging data change has been a common practice for a long time. Microsoft even created a full on Merge command allowing you to perform Insert/Update/ Delete data changes in a single command. What is interesting to me as a consultant is how often I come across web applications that have no concept of merging data. Applications are written passing sets […]
Branded for LIFE: the Mark of a Highly Effective Professional
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
Using the SSIS Merge Join to Synchronize Tables – Part 2
November 2014 Using the SSIS Merge Join to Synchronize Tables – Part 2 By Rocco Mastrangelo This article is Part 2 of a two-part series that describes how to keep two database tables synchronized using the Merge Join transform within Microsoft SQL Server Integration Services (SSIS). This solution is particularly useful for any ETL process that requires refreshing a target...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
jQuery and JavaScript Coding: Examples and Best Practices
(Alex Holt) When used correctly, jQuery can help you make your website more interactive, interesting and exciting.
Migration of Java web application from Google App Engine to IBM BlueMix
(Roman Kharkovski) A couple of years ago I wrote an app that runs on the Google App Engine (GAE). This month I had to add a couple of new features to the app and decided to port it to the IBM BlueMix.
You don’t really need ORDER BY do you?
(Kenneth Fisher) You see dozens of blog posts and articles about how the order of a result set is not guaranteed without an ORDER BY clause and here is my contribution to the subject.
SQL SERVER – Filtering CPU Bound Execution Plans with Extended Events
(Pinal Dave) Let me take a tour to what are we talking here from a scenario point of view. Prior to SQL Server 2012, tracing the execution plan is an all or nothing approach.
Getting the Second Last Thing You Copied
(Peter Vogel) You copy something in Visual Studio and, before you can paste it you realize that you need to copy something else. Or, worse, you copy something, forget what you’re doing, copy something else, go to paste … and realize that you’ve lost that first thing you wanted.
WPF Shapes – Line
(Richard Carr) The one hundred and nineteenth part of the Windows Presentation Foundation Fundamentals tutorial begins to look at the two-dimensional drawing features of WPF. This article describes the Line class.