(Bobby Curtis) Ever since I have been working with Golden Gate, I have always installed and configured Oracle Golden Gate under a separate OS users. In most installations, I use a user named “ggate” (makes it easier to identify). As I’ve been setting up a new environment to do some testing, I ran
Author: SSWUG Research
Measuring Code Improvements in ASP.Net
(Bradley Braithwaite) Reviewing code is hard. Even if you have read the following books several times, it’s still hard.
Regular Expressions: (13) Using the Replace Methods
(Ged Mead) So far in this series, I’ve looked at how you can use Regex patterns to search through text and find matches. Sometimes, you’ll want to do more than this. For example, you may want look for matches and, if any are found, replace the matched content with something else. That’s where the
Set database constraints using SQL Server Management Studio Table Designer
(Robert Sheldon) Adding database constraints to a table is an important part of the table-creation process. For most tables, you’ll likely define a PRIMARY KEY constraint, but other types of database constraints might also be needed, such as UNIQUE, FOREIGN KEY, CHECK or DEFAULT.
SSIS Basics: Using the Merge Join Transformation
(Annette Allen) SSIS is able to take sorted data from more than one OLE DB data source and merge them into one table which can then be sent to an OLE DB destination. This ‘Merge Join’ transformation works in a similar way to a SQL join by specifying a ‘join key’ relationship. this transformation ca
MERGE Error UPDATE or DELETE Same Row More Than Once
(David Dye) When running a MERGE statement I have received the error:
JavaScript Soup
(John Papa) Are you up an expert on Grunt, Bower, Angular, Knockout, Durandal, Breeze, Moment, Toastr, Backbone, Spin, Ember, React, Sencha, Dojo, Bootstrap, Pure, and MintyZebraWaffles.js ? (Okay, that last one was made up.) But don’t worry, I’d wonder about your quality of personal life if you wer
Change dataset to xml
(Matthew Oh) Before we improve our web service, we practice our little xml conversion from dataset.
SSWUGtv: How do you maximize the benefits of attending a conference? Laura Rose has some great tips!
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.
Implementing SQL Server Row and Cell Level Security
(Daniel Farina) I have SQL Server databases with top secret, secret and unclassified data. How can we establish custom SQL Server data classification schemes for implementing “need to know” access to data in specific tables? Check out this tip to learn more.