Deep Learning theories have been around for many decades, but solutions have not always been practical due to hardware constraints. In this article, Shree Das explains how GPU Acceleration can help organisations take advantage of Deep Learning to speed up training of neural networks.… Read more
Oracle sometimes generates smaller archived redo logs than you might expect based on the size of the online redo logs. In this article, Jonathan Lewis explains how Oracle uses online redo logs and why there might be a discrepancy in the archived log size.… Read more
Do you cringe while scrolling through social media? When have you ever felt better after scrolling? If you feel like social media is a net-loss for collective mental health, you’re not alone. We post in superabundance with flailing emotions. We flaunt our duck-faced selfies with smooth-faced filters until we don’t even look human. We hammer … Read more
Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to date. In this article, Greg Larsen discusses what should be considered when developing a backup plan.… Read more
To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In this article, Joe Celko reviews normalizing databases including commonly used normal forms.… Read more
SQL Developer is a popular free tool for working with Oracle databases. In this article Srinivasan Suresh explains several features of SQL Developer that can make you more productive.… Read more
Redgate has recently opened the 2021 State of Database DevOps Survey. Whether or not your organization does DevOps, I would love for you to take the survey. The survey will require around 15 minutes of your time, but I think it’s a great investment as it will benefit the whole community of database administrators, developers, and … Read more
There are a handful of options when backing up SQL Server databases. A DBA must understand the differences and come up with a plan that protects the organisation’s data. In this article, Pamela Mooney explains service level agreements, recovery models, and some strategies to ensure that the data can be restored quickly.… Read more
Dino Esposito continues his series on git. In this article, he explains how to initialize a repository, track files, and revert to a specific revision.… Read more
The database is often left behind as organisations embrace DevOps. In this article, Robert Sheldon explains how to successfully bring databases into DevOps, especially when dealing with legacy databases.… Read more
I attended a training session at Redgate this week by Chris Spalton. Chris’ session topic was “An Introduction into Planning User Research.” Chris pointed out that there’s much more to User Research, but that planning the research is particularly important as it is the foundation for everything you do later. If you’re a database administrator … Read more
One of the most important responsibilities for a DBA is to ensure that a database can be restored in case of corruption, a dropped table, or another disaster. In this article, Greg Larsen explains the different types of backups available with SQL Server.… Read more
More organisations are adopting DevOps, but what happens as the codebase grows? In this article, Siddharth Rao gives advice on how to implement continuous deployment at scale.… Read more
Conventional wisdom says that communication is the critical for success in just about any aspect of life, be that personal relationships or within teams or corporations. Of course, miscommunication can cause all sorts of problems. Communication has changed drastically over the past few centuries due to technology. We’ve gone from the ability to speak mostly … Read more
You can use Xamarin to develop .NET apps to run on iOS or Android instead of Windows. In this article, Julio Sampaio demonstrates the Uno Platform. You can build cross-platform applications using Uno which has even more options.… Read more
Database administrators can never stop thinking about security. In this article, Fabiano Amorim shows how data can be revealed through error messages when views are used to secure rows.… Read more
Securing data is not always easy to do, but it should be the top responsibility for database administrators. From protecting the physical servers to preventing copies of backups files from getting into the wrong hands, there is a lot to consider. In this article, Pamela Mooney covers what DBAs need to think about when securing their organisation’s data.… Read more
Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of better quality, quicker to change, and cost less? Grant Fritchey explains some of the secrets of doing Continuous Integration for Databases to relieve some of the pain-points of the Database Delivery process.… Read more
Well tuned storage is essential for SQL Server performance. In this article, Robert Sheldon explains the metrics that are important to watch. … Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
