Database Management & Programming News, Articles & Tutorials for Database Administrators
Setting A Logon Security Message In Oracle 03/27/2017
Many enterprises are requiring user notification of session monitoring at login, at both the server and database level. Read on to see how to enable this feature and provide custom text.
Can Automated Data Integration Set Data Scientists and Developers Free? 03/23/2017
Data integration often splits the data science community into two factions: those who automate and those who prefer manual coding. While automated tools are still sometimes viewed with suspicion by data ‘purists’ who favor SQL or other programming or scripting languages, even the most hardened coders can benefit from automated data integration systems.
Getting Started with Azure SQL Data Warehouse - Part 3 03/20/2017
Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.
Big Data DBA Support Strategies 03/16/2017
The Database Administrator (DBA) is usually a technical professional who supports one or more hardware and software platforms that provide application solutions. However, technical details such as SQL tuning, hardware and software upgrades, and database designs tend to be tactical in nature. It is essential that the DBA also maintain a strategic outlook to get ahead of potential problems. Lockwood Lyon addresses two of these strategies: knowing application breaking points and preparing for future enhancements to big data applications.
Unified Audit Trail in Oracle 12c 03/13/2017
The new Unified Audit Trail in Oracle 12c can provide advantages over the older audit trail. Read on to see how to configure it and how to test the policy.
Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services 03/09/2017
One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. Derived from the combination of two terms - Development and Operations, it represents a new approach to building synergy between these two seemingly conflicting types of activities. In this article, we will focus on using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, we will rely on Visual Studio Team Services.