Database Management & Programming News, Articles & Tutorials for Database Administrators
Getting Started with Azure SQL Data Warehouse - Part 4 04/20/2017
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.
Does NOLOGGING In Oracle Really Save Time? 04/17/2017
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.
Database as a Service: A Practicum 04/13/2017
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.
Working with WordPress Result Sets 04/10/2017
Whether you’re fetching a single row or an entire result set, WordPress offers plenty of array types to work with. Read on to learn how to employ WordPress’ $wpdb’s get_row() and get_results() methods.
Backing Up SQL Server Databases Hosted on Azure VMs 04/06/2017
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.
How to Move a Table to a Different File Group 04/03/2017
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.