Database Management & Programming News, Articles & Tutorials for Database Administrators
Real-time Operational Analytics in SQL Server 2016 - Part 2 09/19/2016
Arshad Ali discusses the different design considerations for leveraging the Real-time Operational Analytics feature of SQL Server 2016, covering the different scenarios where it fits or does not fit, and how to get started with it for disk based tables.
Automating Data Warehouse Support 09/15/2016
As budgets tighten, how can database administrators keep up with the rapidly-changing new technology environment? The solution: automation. In this article we discuss various ways to automate common processes and relieve the infrastructure staff from repetitive tasks, so that then can concentrate on more urgent priorities.
The Oracle Bug That Could Bite You Has No Teeth 09/12/2016
In a previous article Oracle declared bug 24390197 shouldn’t be; it’s the normal behavior for locally managed tablespaces with system-managed extents. Read on to see the details.
Selecting the Top N Results by Group in MySQL 09/08/2016
A common business requirement is to fetch the top N rows of each group, for example, largest cities for each country. Unfortunately many solutions utilize non-MySQL vendor-specific functions. Rob Gravelle covers a couple of approaches that will work with MySQL.
Azure SQL Database - Azure AD Authentication 09/06/2016
One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, we will provide an overview of this functionality.
Masking Your Data with SQL Server 2016 09/01/2016
There are times when you want some users to see part of a column value but not the whole thing, but you want other users to see the complete column value without any masking. The new SQL Server 2016 Dynamic Data Masking feature will allow you to define these different kinds of masking rules.
Microsoft's SQL Server Database Is Heading to Linux 03/08/2016
Next year, Microsoft plans to release a version of its hybrid-cloud-friendly database software for the open-source operating system.
Oracle MySQL 5.7 Database Nears General Availability 10/19/2015
More Database News...