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
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

Supporting Operational Systems in a Big Data World 01/16/2018

Lockwood Lyon explores the aspects of data modelling that are essential during application development in order to make the application data valuable to an organization.

Static Registration and the Oracle 12.2 Listener 01/11/2018

It may not be an easy switch to the 12.2.0.1 listener if you have static registration configured.  Read on to see why.

Ransomware Attacks Against MySQL and How to Avoid Them 01/08/2018

In February of 2017, hundreds of MySQL databases were erased and replaced with a ransom demand. Rob Gravelle explores how databases were compromised and offers a few best practices for protecting your own MySQL installations from malicious entities.

Azure Cosmos DB Consistency Levels 01/04/2018

The majority of traditional database management systems are responsible for making sure that any changes to their data are consistently reflected in the results of subsequent queries. Azure Cosmos DB extends the range of consistency options by providing support for bounded-staleness, session, and consistent prefix models.

Has Your Database Been Backed up in the Last 24 Hours? 01/02/2018

As a DBA your #1 responsibility is to make sure that each of your SQL Server databases are backed up. This tip provides a couple of TSQL scripts that will identify the last backup of each database.

How to Change the Default Backup Directory 01/02/2018

When you install a SQL Server instance you have the opportunity to identify the default location for your instance database backups. Overtime you might decide you want to change the default location for database backups. This tip shows you two different ways to change the default location for your database backups.

Oracle's UNDO Tablespace and Autoextend 12/26/2017

Oracle's UNDO tablespace should be simple to manage but using Autoextend may not be the wisest choice.  Read on to see why.

Step by Step Guide to Migrate SQL Server Data to SQL Server 2017 12/21/2017

This step by step approach explains how to assess your SQL Server migration using DMA. Learn how to understand the behavior of your existing version and what changes need to be made to migrate to a newer version of SQL Server.

Using Real Memory to Enhance Performance in Db2 12/18/2017

As many enterprise applications mature, the increases in customers, functions, features and transaction rates require scaling up. Adding memory can sometimes be the cheapest and most convenient option. In this article, we review how features in Db2 for z/OS version 12 can use additional real memory to reduce transaction times and more efficiently use CPU and other resources to meet critical application needs.

Oracle's Bulk Collect and Limit Can Be A Problem 12/14/2017

Using Bulk Collect with the Limit clause may not process all of the data in the result set.  Read on to see why and how the problem can be avoided.

Database Tips

Has Your Database Been Backed up in the Last 24 Hours? 01/02/2018

As a DBA your #1 responsibility is to make sure that each of your SQL Server databases are backed up. This tip provides a couple of TSQL scripts that will identify the last backup of each database.

How to Change the Default Backup Directory 01/02/2018

When you install a SQL Server instance you have the opportunity to identify the default location for your instance database backups. Overtime you might decide you want to change the default location for database backups. This tip shows you two different ways to change the default location for your database backups.

How to Turn on Instant File Initialization 12/04/2017

Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages. Read on to learn more...

Quickly Restricting Database Access 12/04/2017

There may be times when you need to perform maintenance against a database that requires you to keep normal database users from connecting to your database while the maintenance is being performed.  You want to stop users from connecting right away, but you want the database to be in a state that you can perform maintenance.  Read on to learn how.

How Much Data Has Changed Since Your Last Full Backup 11/02/2017

Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.

What to Do When You Get a “Cache is Out of Date” Error Message 11/02/2017

Learn how to fix the “cache is out of date” error message when SQL Server Management Studio starts up.

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.







Recent Headlines
Oracle
Static Registration and the Oracle 12.2 Listener 01/11
Oracle's UNDO Tablespace and Autoextend 12/26
Oracle's Bulk Collect and Limit Can Be A Problem 12/14
more...
MS SQL
Azure Cosmos DB Consistency Levels 01/04
Has Your Database Been Backed up in the Last 24 Hours? 01/02
How to Change the Default Backup Directory 01/02
more...
MS Access
more...
DB2
Supporting Operational Systems in a Big Data World 01/16
Using Real Memory to Enhance Performance in Db2 12/18
IBM Db2 for z/OS: Version 12 New Features 11/16
more...