Database Management & Programming News, Articles & Tutorials for Database Administrators
5 Advantages of Load Balancing For IT Companies 10/20/2016
As an IT company, it is crucial that you maintain uptime and monitor the performance of various processes. By making database load balancing a key element, you can ensure that your processes and websites run smoothly.
Basic DB2 Application Tuning Strategies 10/17/2016
Assume you’ve been given a directive by IT management to "tune" things. What strategies are available and how do you judge which ones are best? Considering the current economic climate, can any be implemented on a shoestring budget? Can any of these tasks be assigned to resources with basic DBA skills and still be productively accomplished?
A New Way To Pattern Match In Oracle 12c 10/13/2016
Oracle 12c offers a new way to match patterns in your data, the MATCH_RECOGNIZE function. Read on to see the syntax and the function in action.
Top 6 MySQL DBA Mistakes 10/10/2016
To err is human, or so the saying goes. Unfortunately, in the world of IT, innocuous mistakes made early on can lead to really daunting problems down the road. In today’s article, we’ll go over a few of the most common DBA mistakes to avoid. Some of these relate specifically to MySQL, while others may be applicable to any RDBMS.
Azure SQL Database - Implementing Azure AD Authentication 10/06/2016
Marcin Policht focuses on the specifics of using Azure Active Directory to authenticate to Azure SQL Database.
Reading and Searching a Large Error Log File 10/03/2016
SQL Server’s undocumented extended stored procedure, called “xp_readerrorlog”, can read both the SQL Server ERRORLOG and the SQL Agent log files. Read on to learn more.
Microsoft's SQL Server Database Is Heading to Linux 03/08/2016
Next year, Microsoft plans to release a version of its hybrid-cloud-friendly database software for the open-source operating system.
More Database News...