Why is it such a cliché to complain about our parents? You hear it from friends or in films all the time…”damn, I have to go to my folks for dinner. It’s gonna be rough.” It’s a tale as old as time. As our parents age (and retire), they inevitably participate in the world less. They interact with the world far … Read more
Machine learning projects often stall when it's time to deploy. Shree Das introduces Kubeflow for data scientists, an end-to-end solution for ML projects.… Read more
SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this article, Sergey Gigoyan provides his favorite questions for interviewing SQL Server developers.… Read more
When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect performance. In this article, Uwe Ricken demonstrates how to measure PFS contention.… Read more
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.… Read more
Every year, folks make resolutions and set goals for the new year. It would be interesting to have some real numbers comparing success in 2020 to a typical year, but I bet that many of us have failed or at least had to postpone plans and goals. I had no idea that my trip to … Read more
The SQL Server error log is a great source of information for DBAs for monitoring errors and the operation of the server. Greg Larsen explains the details and how to configure the SQL Server error log.… Read more
Python has become a popular language because of it’s simplicity and vast library support. In this article, Julio Sampaio demonstrates how to get started creating Python apps in Visual Studio.… Read more
Organizations can take advantage of pre-built services to build their own software faster. In this article, Hitendra Patel demonstrates how an organization can provide authentication services for a web-based application.… Read more
This year has been difficult for most of us, and it’s almost over. The lives of people throughout the world have been turned upside down. Many of us, myself included, already worked remotely, but now face a multitude of new challenges. When confronted with the looming crisis in March, Redgate thought first about the safety … Read more
Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.… Read more
To stay competitive and bring value to customers, organisations are adopting DevOps, but finding people experienced in DevOps can be challenging. Robert Sheldon has ten tips to help managers attract and retain DevOps talent.… Read more
Feature branching and pull requests are two important concepts when using Git. In this article, Kendra Little explains these patterns and even provides a video to demonstrate.… Read more
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
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
