Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Database Management & Programming News, Articles & Tutorials for Database Administrators

Featured Database Articles

Dynamic Data Masking on Azure SQL Database 10/23/2017

Azure SQL Database’s Dynamic Data Masking (DDM) feature limits the exposure of sensitive information to non-privileged users. DDM can mask either the full value or partial value in a column. This method can also mask Social Security and Credit Card Numbers without making any changes to the application. Read on to learn more.

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.

Database Tips

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.







Recent Headlines
Oracle
Oracle's TEMP Tablespace 10/12
Tracking Rollback Progress in Oracle 09/25
Oracle's Newest PL/SQL Feature 'ACCESSIBLE BY' 09/14
more...
MS SQL
Dynamic Data Masking on Azure SQL Database 10/23
Azure SQL Database Long-Term Backup Retention 10/05
9 New Features with SQL Server 2017 10/02
more...
MS Access
more...
DB2
Database as a Service: An IT Strategic Direction 10/16
Database as a Service: Defining Quality 09/18
Database as a Service: Choosing a Provider 08/17
more...