Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
Indexes are Good for Performance Generally speaking, DBAs and developers spend a fair amount of their performance time trying to find which indexes to add to a database to improve performance. If a specific query is having performance problems, one of the strongest...
These are the ten most important commands to know as a DBA working in a Linux environment. This is not specific to any Linux distribution or single database platform necessarily, however, I have added some really good links specific to MSSQL Server running on Linux at...
One of the new features introduced by Microsoft in SQL Server 2017 is the new DMF sys.dm_db_log_info. It helps to take a look at the structure of the transaction log file without using the undocumented DBCC LOGINFO. As we all know, Transaction Log Files are internally...
My top metric for analyzing database performance is index read efficiency. This metric essentially shows how well indexed a database is for the workload that runs against it. Index read efficiency is calculated by taking the rows read and dividing them by the rows...
1. Sign Up for Azure Visit https://signup.azure.com and follow the steps to sign up for Azure. Requirements Microsoft Account Mobile Phone Credit Card 2. Visit the Microsoft Azure Portal Once completed with signing up head on over to the portal Visit:...
SQL Server DBAs use Transaction Log backups for point-in-time recovery of a database in the full recovery model. It truncates the log file and prevents it from growing too large and consuming a lot of disk space. Before SQL Server 2017, these backups were scheduled in...
What is Runstats? Runstats is a utility in Db2 that is used to collect statistics about the data in Db2 tables and indexes. This statistical information is critical to Db2 database performance. Runstats is executed on a table by table basis, so scripting it is quite...
Personally, I am biased. As the team lead for Db2 services here at XTIVIA, I think Db2 and other enterprise database software have significant advantages over some of the open source or free options out there. Decades of time invested and spent solving the problems of...
The most concerning issue with SQL Server merge replication is that it is not adequately designed to scale past a very small amount of subscribed instances. From a DBA's perspective, we find merge replication the least desirable of the Microsoft replication...
Sometimes when you're looking at Db2 Queries, you may notice question marks in your queries, like this: SELECT partnum, sum(quantity) as QUANTITY FROM orderitems oi INNER JOIN orders o ON oi.orders_id = o.orders_id where o.field3 is null and o.timeplaced is not null...