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.
With Windows Server 2008/R2, along with Windows 7 OS, approaching EOL (End of Life) in mid-January, it is time to start prepping your infrastructure for upgrades. Microsoft announced last year that if you migrate your SQL 2008-2008 R2 environment to Azure, they will...
Azure Backup Service has risen from just being a simple flat file backup solution to an all in one sandbox for all your backup service needs. From BMR (Bare Metal Restore) to SQL databases, Azure Backup now gives you one centralized location to manage your data and...
With the release of SQL Server 2019 comes many new and exciting features, we can't wait to share the ones that made our top five list! Overall there were vast improvements in the database engine, security, database recovery, and several other areas. TempDB bottlenecks...
The worst call/email to receive, as a sysadmin, is that users are reporting their files "looking funny," only for you to see your client's file server was hit with ransomware. You start saying a prayer hoping your backups that ran overnight were successful, as you...
There may be a situation where you want to remove a node out of an Availability Group (AG) may be due to testing, something wrong with the server and need to build a new one, running out of space on that server so you can move files around, move the server to a...
There are several scenarios where you might need details to re-build TSAMP. If TSAMP did not start properly after an upgrade or even while troubleshooting, the option to open a case with IBM and get root cause analyzed takes time. In many of these scenarios, it's just...
While I've covered this topic in detail, and blogged about a specific backup performance problem, I've never talked about this at the basic level. What is a Backup? A backup is a binary image of the entire Db2 database. It is, therefore, the size of the entire Db2...
One of the most common missed configuration settings in SQL Server is the cost threshold for parallelism. By default it is set to 5, meaning that when SQL estimates that the cost of a query will be greater than 5 running a serial plan, SQL will split the plan into...
There may be a situation when you need to move one of your servers that is part of an Availability Group to a different data center and the IP address for that server will change. In this example, we will be moving a DR node from one data center to another and change...
MongoDB is one of the world's most popular object-oriented NoSQL databases. But like any other database, MongoDB has specific places where it flourishes and areas where it falters. The Question: To Use Or Not To Use Some of the best ways to utilize MongoDB is when...