(Shan Nawaz) Starting with 12c, Oracle supports creating different type of indexes on same column(s). MySQL supported this kind of indexing mechanism and glad that Oracle also supports it. Generally indexing the same column is considered a performance bottleneck because it slows down inserts and up
Author: SSWUG Research
Use UUIDs as Keys
(Joe Van Dyk) If data integrity is critical for your systems, you should be using UUIDs for keys. True, they take up a bit more space in storage and memory and aren’t quite as fast. But since UUIDs are by definition unique, your data is more likely to be consistent.
DB2 Tech Talk: Adopt BLU Acceleration the Faster Easier Way
(Cindy Russell) Learn from IBM Labs experts as they take you through a scenario of using DB2 tooling to speed and ease the process of adopting the game-changing BLU Acceleration.
C# LINQ: Saving JSON Data to SQL Server Database using JSON.NET and SqlBulkCopy
(Brij) In this post, we will add JSON data to Sql Server tables using ASP.NET Web API, JSON.NET and SqlBulkCopy. The data is posted using jQuery ajax to web api which accepts JObject type argument, parse data, arrange data in the required table structure and save to database.
SSWUGtv News: This week we’re talking about the USB 3.1, Talking Robots, and a Single 3D lens
Video Programming for IT Professionals
Understanding the importance of key length with the SQL Server asymmetric encryption algorithms
(K. Brian Kelley) I’m trying to use SQL Server’s built-in encryption and I see there are three different options available for an asymmetric key, corresponding to key length. What’s the impact of the key length?
Why jQuery
(Marla Sukesh) As a web developer JavaScript is the most obvious thing we use for client side scripting. Many developers preferjQuery instead of pure JavaScript for client side scripting, but the question arises is how JavaScript is different from jQuery and why should we use it. In this article we
Tools for SharePoint User Experience (UX) Design: Scamping
(Adrian England) Scamps should be the first stage of designing a SharePoint site (or any other site for that matter) when the content that is displayed on each page needs to be defined.
The ConcurrentBag Collection
(Richard Carr) With the introduction of the parallel task library, which simplifies parallel programming, the .NET framework was extended with several thread-safe collections. One of the simpler such collections is ConcurrentBag.
C-MOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support
(Tanel Poder) So, how many of you do hate the dialog below?