(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 […]
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
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 […]
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 […]
Reset root password on Galera Cluster (Percona or MariaDB)
(Kedar Vaijanapurkar) We have known methods to reset MySQL root password but in this post we’ll see how that works for a Galera Cluster; may […]
Changing Visual Studio keyboard shortcut for Comment and Uncomment
(Steve Endow) A very handy feature in Visual Studio is the Comment / Uncomment editing option.
Database Blob Auditing Policy using .NET C#
(Vitor Faria Tomaz) We have a good example on how to use C# to create an Azure SQL database with the Microsoft Azure SQL Management […]
Introduction To SET STATISTICS IO On SQL Server With Examples
(NEERAJ Sharma) You might already seen plenty of articles on the same topic, but today we will see all this with simple explational and an […]
SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
(Pinal Dave) A few months ago, I wrote a blog which tells us reasons about why we should use tools provided with the product rather […]