Author: Database Journal

Feed: Databasejournal.com - Feature Database Articles. Author: . For every timeless adage there is at least one mistaken thought that can become 'truth' simply by virtue of being repeated. Oracle is no exception to this phenomenon especially when single-column Primary Key indexes are involved. The conventional 'wisdom' discounts the use of histograms on such an index as unnecessary, and this presumes that the primary key has no 'holes' and has a continuous range of data. Very often reality flies in the face of that assumption; even with triggers and sequences, it is highly unlikely to find an unbroken, gap-free data ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . What is the current identify column value in my table? You probably have an identity column defined in some, or a lot of your SQL Server tables.  But do you know how to check the identify value information for one of your tables?  If not, then here is how you do it.   To check the last identity value information for your table you can run the following command: DBCC CHECKIDENT ( 'yourtable', NORESEED ); Where yourtable  is set to the table in which you what to check the identity value information.  ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . If you compress your database backups you can save a ton of disk space. But by default compressed backups are not created. In order to create a compress SQL Server database backup when your default is not compressed you need to add the "WITH COMPRESSION" option to your BACKUP command. Not a big deal to do, but if you want to always create a compressed backup it might be better to change the default backup type to be compressed. By doing that all our backup command that forget to add the "WITH ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . News Via RSS Feed Featured Database Articles Posted April 2, 2019 By Rob Gravelle Top 10 Database Diagram Tools for MySQL Database Diagram Tool: QuickDBD QuickDBD is an online service that lets you Define your schema in one pane and then generates a diagram accordingly. You can then save your diagram in a variety of formats as well as collaborate with others online, but you'll need to create an account in order to do that. The free level gives you 1 public diagram and 10 tables. Paid plans are $7 for a ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . In a recent article (Using Azure Resource Manager Templates To Provision Azure SQL Databases) published on this site, a sample Azure Resource Manager template was presented that provisions a new logical server hosting a single Azure SQL Database instance. Template-based provisioning simplifies deployment and promotes principles of DevOps and Infrastructure as Code, making it the recommended method for implementing cloud-based services. However, its benefits extend beyond initial implementation, since you can apply it to configuring and maintaining existing Azure SQL Database instances. In this article, you are provided with an example of ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Your production database environment stores personally identifiable information in an encrypted form, limits access to these fields and masks them when displayed. However, some types of data encryption create potential performance problems as well as security issues. Your data may be at risk unless you mask it effectively. The State of Database Security The European Union’s General Data Protection Regulation (GDPR) became effective worldwide in May 2018. It applies to any company that obtains data from any customer in the European Union and provides for extremely harsh penalties for companies that breach ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Oracle has provided very useful tools and views to aid the DBA in database management> This includes a number of offerings dealing with the subject of space. One such view is DBA_TABLESPACE_USAGE_METRICS, which provides a 'thumbnail' view of overall size and used space. Unfortunately, this view doesn't accurately report such usage for the UNDO tablespace in version 12.x, a result of the definition of the view that hasn't changed for several versions. Oracle, between versions 11 and 12, decided to change how datafiles were identified in the FLAG column of GV$FILESPACE_USAGE. Let's ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Introduction Create, Read, Update and Delete operations are pivotal for any database application. These DML (Data Manipulation Language) statements can become risky to do, especially if you are new to databases and do not know how these statements work. Today you will learn about CRUD operations as well as how to put them into Stored Procedures so that the data manipulation is on the database side and not executed from the application. Stored Procedures As the name implies: A Stored Procedure is a procedure that is stored. In layman’s terms this means ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Microsoft first introduced backup compression in SQL Server 2008. With backup compression you can speed up our backups, while making your backups smaller. While this sounds good, keep in mind compression doesn't come for free. SQL Server requires more CPU to compress a backup then not to compress a backup. The reason compressed backups run faster is because the backup blocks are compressed therefore more of your database can be writing to a backup file with each I/O operation. Because less I/O is performed your backups run faster, and they are smaller ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Have you ever wondered how much progress SQL Server has completed while rebuilding or creating an online resumable index?  If so, then there is SQL Server system view that will show you how much progress has been completed on your resumable online index rebuild or creation operation. The system view is named sys.index_resumable_operations. This view will show the progress completed on your online resumable index rebuild operation, if you are running Azure SQL Database, or SQL Server 2017. If you are running the Community Technical Preview (CTP) of Azure SQL Database or ... Read More