To continue the previous post, this article demonstrates ways to do Upsert (update and insert) and how MERGE statement in SQL Server 2008 (or later) can be more efficient to perform the two operations at once.First we'll create a table for this … [Continue reading]
Live Cyber Attacks Map
A live cyber attacks map from various companies may give you a different outlook on Internet security.Fire Eye Cyber Threat MapNo longer available The explanation from Norse Security's website: "Every second, Norse collects and analyzes … [Continue reading]
How to Add ID Attribute in Genesis Main Content
With the upgrade of Genesis Framework to responsive design, there's a particular id attribute on the web content that's deprecated when you use HTML5. If you take a look at /genesis/lib/framework.php file from Genesis core, you will see that the … [Continue reading]
Perform Update, Delete and Insert using Merge Statement
In SQL Server, a better way to perform insert, update, or delete operations on a target table based on the results of a join with a source table is by using one MERGE statement.UPDELSERT using MERGE statementIt's more efficient as you're … [Continue reading]
How to Find Windows 8 or Windows 8.1 Key
As part of windows 8 upgrade to 8.1, if you do a fresh install of Microsoft Windows 8.1 using Windows 8 key, one issue you may run into is you may not have your Windows 8 product key handy. If you still have your old system running, you might be able … [Continue reading]