A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement in either situation is bad. In a perfect world, a DBA will be productive and not spending most of their time “putting out fires.” (And fires are never a good idea on a flight!) DBAs … Read more
Today I got a bit closer to a meaningful definition of automation as it applies to the software development process. I’ve been turning this concept over in my head for a while, which is partly related to the dreaded question of licensing. Why should licensing an automation product be related to the number of users? … Read more
If you are a Star Trek fan, you’ve seen the future of medicine, or at least how the writers imagine it will be. Painless, needleless injections are given by hypospray devices, right through clothing with no chance of cross-contamination. The medical tricorder provides an accurate diagnosis in seconds. Broken bones, illnesses, and injuries are quickly … Read more
If you have worked with databases long enough, you probably have many frightening stories to tell about things that have gone awry on the job or problems that were difficult to solve. Accidently dropping a table or trying to fix an issue with the CIO standing right in your cube, repeatedly asking if you’ve fixed … Read more
“There are only two hard things in Computer Science: cache invalidation and naming things”Phil Karlton I’m terrible at naming things. I recently wrote some quick code to reproduce a design problem and demonstrate several options for solutions, and later realized that I’d named my objects dbo.Foo, dbo.FooFoo, and dbo.Wat. But I feel strongly about a … Read more
NASA recently named a facility in honour of Katherine Johnson, the mathematician who performed the calculations for space flights in the 50s and 60s. She was one of the “human computers” whose stories were made famous by the movie Hidden Figures just a few years ago. Until that movie was released, the contributions of these … Read more
In the years before joining Redgate, I was a SQL Server database consultant. I spent a lot of time doing SQL Server health checks, query tuning, and ETL (extract, transform, and load) development. Every customer was different and getting to the resources I needed to do the job at each shop varied as well. I … Read more
Communication is the foundation of DevOps. Grant Fritchey tells the tale of a project that failed because of previous communication and trust issues between the DBA and development teams. … Read more
I’ve been speaking a lot on the topic of DevOps lately, and there’s a question I like to ask. What is the purpose of your organization? I get all kinds of answers. “We make software that delights our customers and makes their jobs easier.” “Our company makes low-cost widgets. “ “We make the best gizmos … Read more
I hear from a lot of database administrators who are worried about being automated out of a job. These kinds of worries are not new. Over the course of my career, I’ve seen CTOs outsource large groups of IT jobs to different regions around the world to save money. IT has long been regarded as … Read more
In the past, I was very proud that I’d meticulously defended my projects against scope creep, but I was missing the point. The real reason organizations should undertake projects is to achieve value. What should be the priority, then, defending against scope creep or value-based delivery? The agile movement fundamentally understands this. Its core principles … Read more
If only there were a ‘single version of the truth’ in data and data analytics. Unfortunately, data and everything that derives from it is subjective: it cannot be disentangled from our cultural biases. We can only find the version of the truth that fits the evidence and our cognitive map of the world we live … Read more
Delta Airlines recently announced that they have implemented the first fully biometric terminal in the US, at Hartsfield–Jackson Atlanta International Airport F Terminal with plans for Detroit late 2019. This means that, instead of scanning boarding passes and looking at passports for international flights at the checkpoints, the airline can just scan each passenger’s face … Read more
Data science is so hip today that everyone is doing it. Everyone is showing off their ‘data science muscles’ by how much data they can lift and in what amazing ways the lifting is done. However, only some are showing that they can work in a smart way, and even fewer are showing common sense. … Read more
In September, thousands of IT professionals, developers, and trainers descended on Orlando, FL, for Microsoft’s Ignite conference. This was Microsoft’s chance to make big announcements about artificial intelligence, Azure, SQL Server 2019, DevOps, and much more. The keynotes were live-streamed, and all the sessions are available for streaming on demand. From a distance, there was … Read more
In my view, data security is an abstract concept, just as abstract as money, religion and fascination – all devised by humans. And anything that is human-made can be human-destroyed. When it comes to IT and data security, history has proven that pretty much anything can be cracked, taken, reshuffled, altered, refurbished, reheated and re-served. … Read more
Recently, I thought about the difference between a career and a job. Technically, a job is one employment agreement out of many that span a career. A career could be database administration, while a job could be the time employed at one company. The difference between these could be considered in another way, however. If … Read more
Being an entrepreneur isn’t for everyone; by the same token, being an employee is not either. There are serious pros and cons to each side that affect one’s stress level, work/life balance, and personal fulfillment. People don’t so much choose to be an entrepreneur as they are called to be one. Entrepreneurs generally know from … Read more
I was recently asked if I thought getting a Microsoft certification was valuable. I see quite a few benefits. Certifications might help your company become a Microsoft Gold Partner, and certification may be a selling point when assigning consultants to engagements. For me, the big benefits have been about learning new features and getting to … 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
