Featured Database Articles
SQL Server 2016 introduces the Real-time Operational Analytics feature, which allows you to run both transactional/operational and analytics workloads on the same system. Read on to learn how to create a filtered, non-clustered columnstore index.
Marcin Policht focuses on the specifics of using Azure Active Directory to authenticate to Azure SQL Database.
There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server.
Oracle 12c offers a new way to match patterns in your data, the MATCH_RECOGNIZE function. Read on to see the syntax and the function in action.
The right statistics and histograms can provide improved performance for queries and reports. Read on to find out about Oracle’s new Hybrid histogram.
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.
Assume you’ve been given a directive by IT management to "tune" things. What strategies are available and how do you judge which ones are best? Considering the current economic climate, can any be implemented on a shoestring budget? Can any of these tasks be assigned to resources with basic DBA skills and still be productively accomplished?
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.
Early data warehouse implementations began as collections of financial and customer data that accumulated over time. Modern warehouses have evolved into complex and elegant enterprise analytics platforms, hosting a broad collection of multiple data types, queried by advanced business intelligence software. As the warehouse environment becomes more valuable, capacity planning becomes critical. In this article we present several strategies for managing data warehouse capacity planning and performance tuning.