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

Data Encryption Using Always Encrypted in SQL Server 02/19/2018

The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.

Modern Enterprise Data Integration 02/15/2018

There has always been a need for some IT users to access data from multiple operational systems across the enterprise. In a process called data integration, companies developed a centralized IT solution that presented data from across the enterprise in a single application. However, with the advent of big data applications, there is now too much data across the enterprise to transport and store in a single place. Data integration had to be re-defined in order to access separate data stores in-place with available access in real-time.

Using Oracle's DBMS_PROFILER to tune PL/SQL 02/12/2018

Troubleshooting and tuning PL/SQL packages, procedures and functions can be a daunting task.  Read on to see how DBMS_PROFILER can make that job easier.

Best New Features of MySQL 8 02/08/2018

Even though there is no official software release to download and use yet, the list of features for MySQL 8.0 was officially announced. Rob Gravelle talks about it and shares some of the exciting enhancements it contains.

Azure Cosmos DB Partitioning 02/05/2018

One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review the partitioning options.

How to Enable Transparent Data Encryption 02/01/2018

By default, SQL Server does not encrypt data in a SQL Server database in an encrypted format. When SQL Server 2008 was introduced, Microsoft implemented Transparent Data Encryption (TDE). When TDE is enabled on a database SQL Server will encrypt the database as data is written to the disk. Read on to learn more...

How to Move a TDE Encryption Key to Another SQL Server Instance 02/01/2018

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database.

Oracle's Unified Auditing, Part II 01/29/2018

It may not be obvious, but some aspects of Unified Auditing only register audit trails for privileged users.  Read on to see which areas won't generate audit trails for conventional users.

How to Implement Dynamic Data Masking in Azure SQL Database and SQL Server 01/22/2018

Anoop Kumar shows you the SQL Commands (T-SQL) to secure PII/PHI data using the SQL Server Dynamic Data Masking (DDM) feature and explores DDM's built in functions to mask all critical data elements. DDM restricts unauthorized users from accessing critical data with no changes in the application.

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.

Database Tips

How to Enable Transparent Data Encryption 02/01/2018

By default, SQL Server does not encrypt data in a SQL Server database in an encrypted format. When SQL Server 2008 was introduced, Microsoft implemented Transparent Data Encryption (TDE). When TDE is enabled on a database SQL Server will encrypt the database as data is written to the disk. Read on to learn more...

How to Move a TDE Encryption Key to Another SQL Server Instance 02/01/2018

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database.

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.







Recent Headlines
Oracle
Using Oracle's DBMS_PROFILER to tune PL/SQL 02/12
Oracle's Unified Auditing, Part II 01/29
Static Registration and the Oracle 12.2 Listener 01/11
more...
MS SQL
Data Encryption Using Always Encrypted in SQL Server 02/19
Azure Cosmos DB Partitioning 02/05
How to Move a TDE Encryption Key to Another SQL Server Instance 02/01
more...
MS Access
more...
DB2
Modern Enterprise Data Integration 02/15
Supporting Operational Systems in a Big Data World 01/16
Using Real Memory to Enhance Performance in Db2 12/18
more...