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
Whenever I teach database topics to a class of beginners, someone inevitably says that Microsoft Excel is a database. Excel is an amazing tool with built-in functionality for financial calculations, statistics, and more, but it’s not a database. It’s great for keeping track and organizing small amounts of data, but it doesn’t meet the requirements … Read more
A very common tenet used when building out a DevOps style approach to automated deployment is the concept of failing fast. You want to identify issues with the changes in your code and structures as early as possible to protect the production environment. One of the most common methods to meet this requirement is setting … Read more
It doesn’t matter if you become an “accidental DBA” or are actively looking for a database administrator position, you may need to do some research to find the servers now in your care. In this article, Pamela Mooney provides some advice about what to track down first.… Read more
Classifying the data within an organization is not just something nice to do. It’s critical for complying with regulations such as The General Data Protection Regulation (GDPR), California Consumer Privacy Act (CCPA), The Health Insurance Portability and Accountability Act (HIPAA), The Australian Privacy Act, and a host of other privacy laws enacted throughout the world. … Read more
Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains what to expect when interviewing and how to prepare.… Read more
Think of online conferences in the same way you would an in-person event … and then think again. Here at Redgate, there’s a strong emphasis on learning and development that continues in this new world where COVID-19 has stripped away the chance for us to meet face-to-face safely. As Redgate’s Events Marketing Manager, it’s been … Read more
Containers have already transformed the way application development works, but adoption has been slower for databases. Finally, the revolution is beginning. In this post, Kendra Little shares the two ways in which containers will dramatically change the way teams develop and deploy database changes.… Read more
Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives some advice for those who would like to be a DBA.… Read more
Many are finding the quarantine a net gain for mental health. Here’s why… The FOMO has been eliminated. There is no longer a “fear of missing out”. For the first time in memory, that type of FEAR is gone. There are no events, no places to be, nowhere to go…everyone is in the same boat. Our worlds are … Read more
I gave a session for the recent PASS Marathon entitled “Modern T-SQL for Better Performance.” During the session, I talked mostly about windowing functions. These functions introduced in 2005 and 2012 not only make writing T-SQL code easier, but often it’s better performing as well. In many cases, they can help you avoid self-joins and … Read more
Books are usually meant to be read in an analogue fashion. Start at page one and keep on going until the book is done. Some people take an early peek at the end of mysteries to see how they turn out, but isn’t that cheating? In today’s digital world, it isn’t easy – at least … Read more
While individual buzzwords will come in and out of fashion, the ideas at the heart of DevOps aren’t going anywhere. Like any good buzzword, DevOps may mean different things to different people. There are several good definitions of DevOps out there. My favorite definition comes from @IanColdwater, who defined DevOps in terms a teenager would understand: Devops … Read more
The PASS organization announced last week that the 2020 Summit, originally planned for Houston this November, will now be held virtually. This is bittersweet for me, since going to the Summit has been the highlight of almost every year since 2003. I had decided, however, that I would not attend in person this year unless … Read more
We’ve lived in our current home for 30 years and have managed to accumulate a lot of possessions. We have closets, drawers, cabinets and a storage shed filled with things, many of which we don’t remember buying or receiving in the first place. I haven’t quite gotten into the Marie Kondo way of organizing yet, … Read more
This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This year, 971 database professionals from around the world responded. Here are some of the key insights from the survey: Estates are growing more than ever Companies who reported over 1,000 SQL Server instances grew 9% … Read more
A lot of folks have taken advantage of more time at home recently to pick up new skills and hobbies. In my case, I have started learning more about 3D printing. I bought an entry level 3D printer about a year ago to have something fun to do with my grandson during the summer. The … Read more
Most of us have found our lives turned upside down in recent weeks as we try to shelter in place, work from home, or care for our families. There are many ways to cope with the situation. On Facebook, I see my friends talk about cooking and baking, watching hours of streamed content, trying to … Read more
Everyone has been impacted in some way from the Covid-19 pandemic, whether it is missing out on holiday travel and events, being isolated from loved ones, facing economic issues, or contracting the virus. In the best of scenarios, buying groceries and supplies has turned into a scavenger hunt, while, in the worst, people are truly … Read more
I’ve been working from home for several years, so I’m used to it. Many people who have never thought of doing this have found themselves working from home the past few weeks. Companies who have never given their employees a chance to work remotely are finding that it’s possible. Setting up remote workers is not … Read more
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
