Featured Database Articles
Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service. Join Arshad Ali as he discusses round-robin and distributed tables, and how to create them. He also discusses how partitioning works in SQL Data Warehouse and looks at the impact of choosing the right distribution key. As a bonus Arshad shows you how to leverage PolyBase to quickly and easily import or export data from SQL Data Warehouse.
Join Marcin Policht as he provides a comprehensive overview of the different backup options applicable to Azure SQL Server VMs with database files stored on VM disks.
There may be a time when you want to move a table from one file group to another. It's easy if it contains a clustered index. Read on to learn more.
When all else fails it may be necessary to tell Oracle that index access is the way to go. Read on to see what parameter is used, how to set it, and what surprises you may find after you do.
Using NOLOGGING is a time-saver, some say, but is it really? Read on to see why it may not be and how it can get you into trouble.
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.
Vendors now offer Database as a Service (DBaaS) as part of a bundled solution of managed IT services. Delegating database management services to an external provider may have many benefits, but delegating database administration services has many hidden dangers. In this article, we focus on how delegating data modeling to an outside service can cause problems when making application updates, changing business rules or doing performance tuning.
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.
Big data applications were once limited to hybrid hardware/software platforms. Now, recent advances are allowing applications like these to be integrated with and federated into operational systems. In particular, IBM's DB2 for z/OS Version 12 delivers new features and functions that allow the DBAs to design, define and implement very large databases and business intelligence query platforms that fulfill some big data expectations.