loader from loading.io

A New Community Summit

Voice of the DBA

Release Date: 08/19/2021

Going Cloud Native show art Going Cloud Native

Voice of the DBA

I am constantly surprised at the migration of workloads to the cloud. It seems that many of the customers and clients that I speak with are moving some of their assets to the cloud. Some are moving the majority of their systems, and they are pushing to do this sooner than later, including database assets. I ran across that noted that while many companies love the on-demand provisioning of cloud resources, they don't always get improvement in their software performance. In fact, quite a few might experience worse performance, though often not horribly worse. Instead, what they often get is a...

info_outline
Growing and Keeping Up show art Growing and Keeping Up

Voice of the DBA

I keep busy. My wife and I tend to be type-A people, tackling lots of things and keeping very busy. We work hard, and often, a lot. Our spare time in the winter is spent with second jobs, coaching youth volleyball. My kids think that we can be a little unbalanced at times, not taking enough time off or getting away from work. I agree. They are better balanced in life than my wife and I. The thing I tell me self is that keeping busy and being driven has helped me have a great life and a great career. It's also created lots of stress, perhaps more than I should have. I thought about this balance...

info_outline
The Last SQL Server Service Pack show art The Last SQL Server Service Pack

Voice of the DBA

I wrote a few years ago, thinking that SQL Server 2016 SP2 might end all large updates. At the time, Microsoft was moving to a Cumulative Update process, with the aim of releasing small patches for each version every couple of months. They've done a good job of that, and SQL Server 2017 now has with more coming. With little fanfare, we got recently, with a long list of fixes.  Even Pedro Lopes notes for any version. That means I expect that in the next few years, I'll start to encounter people working with technology who have no idea what a service pack is or what those are used for....

info_outline
Choosing State Over Migrations show art Choosing State Over Migrations

Voice of the DBA

I ran across an article about . While I think that this article is a bit slanted because the author is building a tool, it does present some good reasons why people worry about migration-based approaches. This article also references . Everything we do in relational databases, and in some other platforms like Snowflake, is a migration script. If you run SQL Compare and get the differences, you are generating a migration script. It might contain lots of changes, but it's still a migration script. I wish I could write CREATE OR ALTER TABLE scripts, but that's not a part of the SQL specification...

info_outline
Location Data is Not Anonymous show art Location Data is Not Anonymous

Voice of the DBA

We are truly in the era of big brother and 1984, where any of us can be tracked if we use a mobile device. That's a scary thought and one that many people might not like. There are plenty of people in management that want to increase revenue or profits from the use of data, even if we might think their decisions are unethical or immoral. When there's money to be made, often they ignore other issues. There was that noted various public data, some sold by brokers, was used to track location and usage of a device by de-anonymizing aggregated data. The post ends with these statements: Read the...

info_outline
Do You Have a Talent Gap? show art Do You Have a Talent Gap?

Voice of the DBA

I have seen articles over the years that talk about a talent gap in companies, similar to . For a long time early in my career, it seemed anyone that went through a boot camp could get a job, and we had lots of unqualified people earning lots of money. I know I've run into my share of paper-CNE's, paper-MCSE's, and more in my career that took advantage of that talent gap. Over time it seemed that many companies stopped relying on certifications in hiring, but this didn't seem to help us find more qualified workers. We either were short of staff or still had plenty of people that couldn't do...

info_outline
Incident Review show art Incident Review

Voice of the DBA

Something will always go wrong with our software systems. Issues might happen regularly or rarely, but something is going to go wrong at some point and a client will complain. Often the way we handle these situations determines whether our customers continue to do business with us or look for an alternative. In my career, I've been a part of many incidents, lots of which were service outages for customers. I've attended some incidents as a technical person working to diagnose the issue. In other incidents, I've been a developer that has to fix code. During many, my role was as a manager trying...

info_outline
Making Software Decisions show art Making Software Decisions

Voice of the DBA

I work for a company that builds software. At Redgate, we are constantly debating what to build and how, and more importantly, how to structure something that is easy for our customers to use. There's a lot that goes into the process of building software, way more than I thought was important a decade ago. Today, even when I don't like the decision or the final result in a product, I know our process often produces good results. Recently Netflix started for their software. It's interesting in that they note that of all the ways they can make decisions, most of these involve few people. This...

info_outline
Thank a Mentor show art Thank a Mentor

Voice of the DBA

"The delicate balance of mentoring someone is not creating them in your own image, but giving them the opportunity to create themselves.” — Steven Spielberg I saw with the request that people tag a mentor that had helped them. Since then, a few people have posted their thanks to someone, and I've been tagged a few times. I'm honored that people think I've helped them somehow, as that's been a portion of my career for the last twenty years. I make an effort to do help others have a great career and become better at their jobs. Read the rest of

info_outline
To Infinity and Beyond with 1=1 show art To Infinity and Beyond with 1=1

Voice of the DBA

There is one thing that Aaron Bertrand won't get mad at me for doing and that's creating an infinite loop with a WHILE (1=1) pattern. He , noting that it's easy to create an infinite loop with code like this, something that never ends well. I have purposefully written infinite loops in the past. A long, long time ago Radio Shack would put out TRS-80s on display, and a few of us would type a quick BASIC program to perform some math work on the screen over and over with an infinite loop. It crashed at some point with an overflow, but for a period of time, it would look neat on the screen. Less...

info_outline
 
More Episodes

The PASS Summit has been an annual event for a lot of my career. I attended the first one in 1999 and most of the rest through the years. After last year's virtual Summit, I was concerned that we wouldn't have an annual event where the most, brightest, and friendliest data platform people came together. Redgate purchased the assets out of the PASS bankruptcy and has committed to future Summits. This year's Summit is virtual, and more importantly...

It's free, and you can register today

Read the rest of A New Community Summit