Featured Database Articles
One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings, is considerably quicker access to newly developed capabilities. In this article Marcin Policht focuses on row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).
There is a lot of buzz around SQL Server 2016. It will not be too long until SQL Server 2016 will be fully baked and ready for shipping. As always there are a ton of new features and in this article Greg Larsen explores 10 of those new features.
Arshad Ali shows you how to create filters, publish dashboards to the Datazen server and create drill-through dashboards.
Oracle's PL/SQL provides a results cache, and it works fairly well. Problems can arise when multiple sessions are using it. Read on to see what those problems are.
UNDO is a key part of any Oracle transaction, and Automatic Undo makes undo management easier for the DBA. Read on to see how it works and why most undo-related errors are a thing of the past.
If it weren't for the Hakan Factor, bitmap indexes wouldn't exist. Read on to see what the Hakan Factor is and how bitmap indexes use it.
Big data applications store huge amounts of data in a massively-parallel storage array and use sophisticated analytical software to return solutions to SQL queries. With multiple applications accessing enterprise data, we now need mechanisms to guarantee that the data is easily available. Here, we discuss a few common techniques to ensure that a big data application does not cause bottlenecks in mission-critical processes.
Most large companies have one or more big data applications, which provide fast access to large stores of customer and sales data. As the IT organization grows new job categories and new tasks are added to the mix. These include big data hardware and software support, business analysts who use analytics to probe and explore the data, and managers who must supervise and prioritize job tasks.
As the holiday season approaches, your organization can expect more BI activity as you take advantage of a significant increase in customer interactions. The smart IT organization should be proactive and prepare now for larger data volumes and more analytics activity by tuning their big data application for high performance.