Database Management & Programming News, Articles & Tutorials for Database Administrators
Database as a Service: An IT Strategic Direction 10/16/2017
Is DBaaS a possible strategic direction for your company’s IT infrastructure? In order to determine this, there are several issues you must address. This article lists the most common risks that require mitigation before embarking upon delegating all or most of your database storage and management to an outside firm.
Oracle's TEMP Tablespace 10/12/2017
Big tables can be cached automatically by Oracle as long as certain criteria are met. Read on to see how to configure this feature and what might be standing in your way.
Troubleshooting MySQL Performance Issues Using the Slow Log and Performance Schema 10/09/2017
With so many causes and solutions of a database slowdown, you might expect to be spending the night at work, instead of in your warm bed. To avoid that cursed fate, read on to learn two ways to get at the root cause of slow MySQL performance using a couple of built-in MySQL features: The Slow Log and Performance Schema.
Azure SQL Database Long-Term Backup Retention 10/05/2017
Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. In addition to Point-in-Time Restore as well as Geo-Restore and Active Geo-Replication, you have the option of implementing long-term backup retention of Azure SQL Database.
9 New Features with SQL Server 2017 10/02/2017
Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features.
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.
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.