loader from loading.io

Custom SQL Server on RDS

Voice of the DBA

Release Date: 09/20/2022

Visual Design for Safety show art Visual Design for Safety

Voice of the DBA

I drive a Tesla Model Y and love it. They're not for everyone and not for every situation, but I think it's the best car I've owned. My wife feels the same way, and if we had a need for two cars, we'd likely get another one. The car is fun, and I look forward to getting in and moving around town. If you have questions about owning an EV or a Model Y, please feel free to ask. The car isn't perfect, and there are things I wish I could change. There have also been a few recalls on the car, which is interesting for a Tesla. A few of these recalls meant that I got a software update a few days or...

info_outline
Am I Good At My Job? show art Am I Good At My Job?

Voice of the DBA

I was talking with a friend recently about some of their co-workers. In this case, they were complaining that another person couldn't do some tasks that my friend considered relatively easy things. Deal with an unusual restore situation, write some PowerShell to reconfigure servers, build somewhat complex (to them) queries, etc. Things that my friend thinks most database people should be able to do after a year of experience. However, my friend questioned whether they were evaluating co-workers appropriately. How can one tell? I might be able to tell if a coworker is better or worse at a task,...

info_outline
This is Why You Use Git for Scripts show art This is Why You Use Git for Scripts

Voice of the DBA

Git has become a fantastic tool for me, and many other technologists, over the last ten years. It's almost ubiquitous in most of my clients, and so many people are comfortable with it. Many others aren't, which is why I started a (and other Ops people) on my blog. Quite a few people asked me why I recommend git over a file share for storing code that a team of Ops people or DBAs might use. Why isn't a global file share a better choice in an organization? I think I have a few good reasons, but if you disagree, let me know in the discussion for this piece. Read the rest of

info_outline
Un-Stable Teams show art Un-Stable Teams

Voice of the DBA

I've always valued having a team of people I know and can work with. While I haven't had a lot of long-term jobs before Redgate, I have had a few positions that lasted more than a year and appreciated working with the same group for a long time. We might gain or lose a person, but overall, the structure of the team was the same day after day. This was a comfortable atmosphere, and I liked knowing who I was working with each day. At Redgate, we have had some stable teams of people, but in our engineering area, we move teams around. There is each December/January where engineers can choose to...

info_outline
Do You Have a Jeff? show art Do You Have a Jeff?

Voice of the DBA

In the (worth a read), there is a character called Brent, who is to go-to person for everything in IT. I don't know if this character was modeled after , but I always picture him when I re-read the book, and I suspect he was that person in previous positions. I've been that person as well, and it's both exciting, fulfilling, and very stressful. At , that person has been Robert C, who is my go-to person for many questions. In the DBA world, I think of . He's been a prolific and incredible author over the years on many things SQL-related and is a huge proponent of others learning to write...

info_outline
Ranomware vs. AI show art Ranomware vs. AI

Voice of the DBA

Ransomware has been a growing and shrinking problem in the modern world. Every time I think that some new defenses and protections are preventing ransomware from being a problem, I see another issue. Recently, I saw with an attack and a few friends have recently noted their companies were restoring systems after a portion of their network was locked down. With the advent of Rasnsomware-as-a-service, where criminals deploy software and then sell access to others, better detection and protection become more important. As with any software, criminal human operators will use the ransomware...

info_outline
Serious Software Glitches show art Serious Software Glitches

Voice of the DBA

Recently pointed out a podcast to me. , but it's for the Journal, which is on other platforms (I listened on Spotify). It's the story of a computer glitch in UK post office software, which resulted in quite a few local postmasters being criminally prosecuted, many convicted, and even a few committing suicide. It's a sad story, and it's complex, but there are some technology-related elements. First, the overall story is Fujitsu sold the UK a point-of-sale system for post offices. There was a computer glitch here, which incorrectly calculated lots of totals and showed postmasters owing more...

info_outline
How Often Do You Update SSMS? show art How Often Do You Update SSMS?

Voice of the DBA

I got a message recently that SSM S19.3 is out. I am wary of major versions, especially with a few add-in tools, but I have tended to try and update SSMS regularly when it patches, which is about once a quarter. As I checked my desktop, I saw I was still on 19.1 (my laptop was 19.2), so I downloaded and updated both machines. I wonder what the rest of you do. I know many of you have corporate rules and restrictions and you may not be able to update regularly, but in many places, I've worked, once software was installed, I could update it. Are you doing the same thing out there? Let us know in...

info_outline
Mind Over Milkshake (Thoughts Matter) show art Mind Over Milkshake (Thoughts Matter)

Voice of the DBA

Last year I went to in Wisconsin. It was a fun event, very community and family-friendly, and I enjoyed it. So much so that I recently went back to the Texas event in January. It's more developer-focused, but it does have some data related sessions. I recommend this conference if you're looking for some fun training and want to combine that with a family vacation. Your kids will love it. In any case, I watched a keynote talk that referenced an NPR article, called . It's an interesting look at how the food labels affected people's bodies. It's not definitive and I wouldn't make any drastic...

info_outline
A Great Place to Work show art A Great Place to Work

Voice of the DBA

I have had quite a few employers in my career. Of the ones that paid me for computer work, I'll say that there were 3 great ones (1 I owned), 2 average ones, and 3 poor ones. I've had a few other minor times or contract situations where I didn't really judge or care one way or the other. A lot of time is spent at work, but if it's days/week/(few months), I can deal with most situations. That being said, even at the poor places, I learned a lot and I grew, so I don't regret them or wouldn't want them removed from my past. There are always good and bad things about any job. As I tell my kids,...

info_outline
 
More Episodes

One of the challenges in moving to the cloud is achieving a similar level of performance to what you would get with dedicated hardware on-premises. The cloud is someone else's computer, and you are limited to the choices that the vendors allow you to rent. In many cases, you might even share the physical hardware resources with other customers, though many cloud providers have started to allow dedicated hardware reservations in the last few years.

One of the challenges of choosing a PaaS cloud database platform is that there are often restrictions that differ from a similar platform on-premises. This is often to ensure that one customer doesn't affect another, or that customers don't make changes that might prevent the vendor from supporting the system. Azure SQL Database gives us a database only, no instance features, though we do see a virtual master database.

Read the rest of Custom SQL Server on RDS