Database Management & Programming News, Articles & Tutorials for Database Administrators
Tracking Rollback Progress in Oracle 09/25/2017
Large transactions can take considerable time to rollback once they are stopped. Read on to see how to monitor rollback progress from another session.
Overview of Azure Data Lake 09/21/2017
Azure Data Lake stores petabytes of data and analyzes trillions of objects in one place with no constraints. Data Lake Store can store any type of data including massive data like high-resolution video, medical data, and data from a wide variety of industries. Data Lake Store scales throughput to support any size of analytic workload with low latency. Read on to learn more.
Database as a Service: Defining Quality 09/18/2017
Application and database definitions are now spread among multiple firms across multiple platforms. Business rules are implemented in (potentially) many places, and many support staff skills are not under your control. This raises the complexity of the application and increases the risks of failure during application changes, maintenance or upgrades. This article addresses how to measure and maintain the quality of your application when you take advantage of database as a service (DBaaS).
Oracle's Newest PL/SQL Feature 'ACCESSIBLE BY' 09/14/2017
Running procedures and functions outside of the package context can cause issues, especially with dependencies. Read on to see how ACCESSIBLE BY can prevent 'unauthorized' access to procedures and functions.
Selecting WordPress Metadata 09/11/2017
It pays to get a solid handle on how metadata is stored and retrieved in WordPress. In today’s article, we’ll learn how to fetch metadata from the wp_postmeta table using the versatile $wpdb object.
Network Configuration of SQL Server Always On Availability Groups in Azure 09/04/2017
Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, we will focus on the networking aspects of clustered deployments of SQL Server 2016 in Azure.
Understanding Azure Data Factory – A Cloud Based Integration Service 08/28/2017
Azure Data Factory is a cloud based data integration service. This helps you to define, schedule and manage data pipelines to transfer and transform the data from disparate on premise and cloud data sources. Read on to learn more.
Oracle's 'Parallel Query Allocate Buffer' Latch 08/21/2017
Parallel query buffers can be numerous and, as a result, may wait for an allocation latch. Read on to see why larger parallel degree settings are more likely to encounter this latch.
Database as a Service: Choosing a Provider 08/17/2017
Providers of database as a service (DBaaS) promise to handle database tasks, including hardware acquisition, database management software installation and configuration, database definition, performance tuning, and backup and recovery. While this service can greatly shorten the time-to-market of a new application, there are certain risks inherent in delegating database management to an outside provider. In this article we address the risks, how should they be mitigated and what questions need to be addressed when choosing a DBaaS provider.
Oracle's Autotrace Can Lie to You 08/14/2017
Execution plans can be very helpful when diagnosing problems but be careful how you generate them as autotrace can lie to you. Read on to see how to generate reliable execution plans.
Purging Old Database Mail Items 08/03/2017
Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail.
What Mail Items Have Been Sent With Database Mail 08/03/2017
Have you ever wondered how much database mail you have sent in the past day or week? What about those database mail items that were not successfully sent. In this tip, Greg Larsen shows you how to review the database mail items that have been processed by SQL Server.
How to Find Out Which Database Object Got Deleted 07/03/2017
Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.
How to Read a Transaction Log Backup 07/03/2017
The transaction log backup is stored in SQL Server proprietary format, just like the transaction log itself. Even though the transaction log backup is in a special format, Microsoft has provided us with the fn_dump_dblog() function to read transaction log backups. This function is undocumented, so you should use care when using this function in a production environment.
How to Generate a Restore Script 06/01/2017
There are multiple ways to accomplish a database restore. But if you wanted to restore a database from a script how might you accomplish that task quickly and accurately?
How to Read the Transaction Log File 06/01/2017
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
Setting Variables in Calling T-SQL Code While Using sp_executesql 05/04/2017
In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.
Where is my SQL Server Configuration Manager? 05/04/2017
If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.
Displaying Backup or Restore Progress 04/03/2017
Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.
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.