(Luis Soares) MySQL 8.0.1 has just been released with a wonderful set of features across the board. Specifically in replication, there is plenty of new […]
Featured Content
Except and Intersect Operations
We recently talked about the logical Semi Join operation and the Anti Semi Join operation, and demonstrated method to generate those logical joins using traditional […]
Performance Comparison
One of the things I like to do when a new version of a database engine is released is to compare the performance of different […]
Basic SQL Joins
One of my favorite things to ask during an interview for a developer who is going to be working with databases is to enumerate the […]
Query Comparison
From a conversation we were having in the comments from last week I was comparing the query plan produced from using different ways to retrieve […]
Calling All Chief Data Officers
Many thanks to Brian Moran for sharing a bit of information from Gartner – about Chief Data Officers; is this in your future? It’s interesting […]
Other News
O365/ SharePoint Online – Getting User Image URL Without Callback In JSOM
(Prasham Sabadra) In this article, I’ll share one little finding, which I recently found. This is related to the current user profile image, which we […]
You Can Continue To Process An Express.js Request After The Client Response Has Been Sent
(Ben Nadel) When I first starting digging into Express.js, my mental model tended to conflate the concept of the Express.js request with the concept of […]
SQL SERVER – How to Change Database Compatibility Level?
(Pinal Dave) After watching my free webinar the most popular question, which I receive is about Database Compatibility Level.
Temporarily Disable a Generated Always As Identity Column
(Dermot O’Neill) Oracle Database 12c allows you to define a column to be an IDENTITY column.
12.2 Some Cool Partitioning New Features (Big Wheels)
(Richard Foote) I previously discussed just how easy it is to convert online a non-partitioned table to be partitioned with Oracle Database 12.2.
AJAX CRUD in Grid using JQuery DataTables in ASP.NET MVC 5
(Ehsan Sajjad) In this post, I will be addressing this problem and we will learn that how can implement CRUD using JQuery DataTables in one […]
ProxySQL Rules: Do I Have Too Many?
(Tibor Korocz) In this blog post we are going to take a closer look at ProxySQL rules. How do they work, and how big is […]
Taking Control of Gravity on Unity3D
(Gavin Lanata) One of the most fun things to play with in Unity is gravity. Even when things go wrong, it’s more than amusing to […]
How to manipulate data during import in SSAS Tabular vNext
(Siddharth Mehta) Data is not always in the exact desirable format from the source system. Modulating data in-flight during the import process, reduces the need […]