(Ike Walker) The upsert (or merge) is a useful statement in SQL, but the syntax in MySQL is not self evident. If you search the MySQL manual for “upsert” you’ll probably get this page. If you search for “merge” you’ll probably get the page on index merge optimization or the merge storage engine. Non
Author: SSWUG Research
Creating a custom context menu using jQuery
(Arpit Jain) Hello readers, in this article I’m going to tell you a very amazing thing. You can customize your website by many ways but have you ever thought of creating your own customized right click menu. Yes! I’m talking about right click menu or context menu.
Logging Client-Side Errors With AngularJS And Stacktrace.js
(Ben Nadel) Last year, at cf.Objective(), I was watching Elliott Sprehn give a presentation on Production Ready JavaScript. In part of the presentation, he was talked about client-side errors and recommended that everyone log client-side errors to the server.
DB2 Tips n Tricks Part 11 – Concealing Business logic in Database – OBFUSCATION of DDLs
(Harishkumar Baburao Pathangay) Conceal/Mask/Hide your critical business logic in Database using Obfuscation of DDLs.
System Statistics Gathered in Exadata Mode – When Are They Relevant?
(Christian Antognini) The aim of this post isn’t to explain what the “exadata mode” is. Hence, if you don’t know what it is, before continuing reading have a look to this post published on Kerry Osborne’s blog.
SQL Server’s MERGE Statement
(Jason Annable) This is definitely a function that DBAs and BI professionals should pay attention to. It’s a powerful command that came out in the 2008 version of SQL Server and it makes it easier to pull data from a variety of sources and fully audit everything that’s changing. I’m absolutely lovin
SSWUGtv News: Steve nearly destroys the studio with a light saber! Also, take a trip to mars, the solar system’s biggest volcano, and space internet!
Video Programming for IT Professionals
Fixing SQL Server error in-row data RSVD page count is incorrect
(Brady Upton) I ran DBCC CHECKDB (Integrity Checks) in my maintenance plan and I also ran it manually, but I keep getting the error “The In-row data RSVD page count for object “table_name” , index ID 0, partition ID 58037252456448, alloc unit ID 58037252456448 (type In-row data) is incorrect.” How c
MySQL Fabric – Sharding – Shard Maintenance
(Narayanan Venkateswaran) Let us start by listing the scenarios in which we will need to perform shard maintenance. In addition to periodic maintenance operations the following situations might mandate performing shard maintenance.
Query Acceleration for Business using Informix Warehouse Accelerator
(Whei-Jen Chen, Nigel Campbell, Martin Fuerderer, Frederick Ho, Holger Kirstein, Keshava Murthy and Ramanathan Sivaguru) IBM Informix Warehouse Accelerator (IWA) is a state-of-the-art in-memory database designed to exploit affordable innovations in memory and processor technology and trends in novel