Skip to content
DBAle 25: DBAle as a Service (DBAleaaS) episode artwork

Oct 29, 2020 56 min

DBAle 25: DBAle as a Service (DBAleaaS)

from DBAle Hosted by Redgate Software

Our DBAle hosts celebrate this milestone quarter century by sampling Bonnie Scotland's finest brews, provided by the French. Chris tells Chris exactly where he can shove his SQL Server Databases as they talk acronyms: IaaS, PaaS, DBaaS, RDS and AWS. While, in The News we take off with sky high ICO fines, Monitoring RDS and the importance of Aardvarks in Redgate's recent 21st birthday. So, grab yourself a beer and tune in – cheers.

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

DBAle 25: DBAle as a Service (DBAleaaS)

0:00 56:01
of matches

Transcript Auto-generated, may contain errors

Thank you very much. Why would you do that? Oh, okay, well, you know, I'm not even going to do the internet. I'll let you do it this time.

Well, after you. One of these days, you're going to have to do the introduction. Hello there, everybody, and welcome to yet another DBAO, another episode of Chris takes the Mickey of anything that I say. It's not hard.

But it is the, it's actually the DBAO quarter quell or the 25th, well, I can't even say anniversary, but the 25th episode of DBAO, we have now been doing DBL for just over two years. Okay. Two years, Chris. Two years?

Does he feel like two years? Yes. Okay. That's maybe longer, actually.

It feels like an eternity. Well, I'll tell you what, in any case, hello there, everyone, and welcome to Rekge DBAO, the podcast that's all about beer and data. And we, of course, as always, are your incandescent hosts, meet the wonderful, the mysterious, magical, creast of an win. I'm Chris.

And he's another Chris. Yeah. Anyway, I should insert lift music here. Welcome to the podcast.

It's nothing but 50 minutes of uninterrupted elevator music. Fourth floor, menswear. Anyway, today's theme is actually not elevator music. Sorry, this is a weird thing, but elevator music is one of those things that you don't really get in the UK, right?

No, you make a good point. Except, except if you go to Alton Towers hotel, the adventure hotel, when you go up in the lifts, the lights kind of dim and go bright and they play adventure music. So it feels like you're on your way to some mysterious adventure like Dun Dun Dun. That's a very different type of elevator music, though.

Like, that's not what people think of elevator music, but you and I have a very good understanding of what the concept of, well, apparently you don't. But I have a good understanding of what the phrase elevator music means despite the fact that in the UK, there's no second elevator music. I have genuinely been in a lift and elevator. I mean, yeah, that's the other thing we're calling it, elevator, right?

Yes, but it's a lift, of course. Don't at me on Twitter about this one. It is a lift and I will not hear anything else about it. But I have genuinely been in a lift in an elevator in the United States listening to, I think it's the girl from Ipanema.

Yeah, that I've definitely done that. That's the last thing. The thing was I genuinely couldn't believe it. So I was in this lift with probably a good five or six people and I looked up from my phone and just went, oh, and stared at the ceiling where the speaker was and all of a sudden I have five or six people just staring at you thinking, oh dear, oh gosh, there's something not quite right about this one.

Anyway, no, today's theme. I'll argue with that. Today's theme is actually not elevator music. No, it is actually, well, it's not really a theme.

We've got a good title, DBL as a service or DBL as for short. And actually, the theme is where can we put our SQL Server databases? Now, this is something that comes up an awful lot at Reiki Towers, particularly when we're training new salespeople for Reiki, when we're talking to them to help them understand what Reiki helps with, we have to first get them to understand the scope, the domain, what a database is and teaching a bunch of new starters over the course of two weeks first, what a database is and how to do continuous integration and delivery with it. That's a big gap to cover in two weeks.

And one of the biggest problems we struggle with is actually getting across the concepts of where can we put our SQL Server databases? So that's what we're going to have a chat about today, right, Chris? Sounds good to me. All of the weird and wonderful cloud-based offerings largely, because I'm pretty sure people already clued on the on-premise thing.

I don't think you have to go back to your much detail. I don't know. I think the did you just say on-premise? Yeah.

On-premises, sir, on-prem. Sure, for on-premises, not on-premise. On what premise do you, sir? Anyway, no, no, no, on-premise.

Anyway, we can't talk about this without a lovely refrigerator. You've muted yourself. How did you mute yourself? I hit the mute button.

And then I muted myself. Stop, stop, mute, unmuting yourself. Next, next we'll have Louise, producer Louise, unmuting herself and saying hello. And not that any of these good people would like to hit that.

I'm sure they would, but I don't know that she will. Cue Louise. Hi, guys. And there she is.

Fabulous. Hi, so Louise is here skulking in the background taking notes and probably having a beer herself, one would hope. But Chris, naturally, we can't do this episode without a refreshment. And today, we have yet another donated refreshment.

Again, if anybody feels like donating refreshments to DBAL, then please do feel free to get in touch because, you know, we're a big fan of this whole charity thing and we're willing to accept. We're just, we're like a beer. But today, we have some beers from, and I'm going to have to get this one right. So this is Robert.

Robert is one of our best listeners, one of our most frequent listeners, one of the nicest people you'll ever meet, met him loads. And in fact, we've already had one of Robert's beers on a previous episode. In fact, after sequel bits last year, of course, we couldn't do that this year. sequel bits wasn't in person.

So what did he do? Well, he went ahead and sent us some beer anyway. In fact, he sent us some beer from the Drygate Brewing Company, whom he highly recommends, and we would highly recommend Robert as well. So go and follow him on Twitter at sequel bobscot, SQL, B-O-B-S-C-O-T, sequel bobscot.

Yeah, thank you. Thank you for me for our second donation. I actually chatted to him for a little bit at bits recently. Fantastic.

So I already said thank you in, well, not really in person, not in person anymore, but as in persons you can get during a pandemic. Exactly. And it also turns out you were right. It is not on premises.

I hate it when I'm right, too. Thank God it doesn't happen that often. No Wikipedia has broken wrong. Oh, well, I always like Wikipedia as a source at least.

So we've actually got a different one each, right? So Bob actually sent us two different beers, a purple one and a green one. Yeah, each should point out. And I already drank the purple one, but we decided upfront that it wasn't just because I couldn't control myself and have to drink it.

So you've got the purple one and I got the green one and they're both from the Drygate Brewing Company who are based in Glasgow and have been operating since 2014. So Glasgow is in Scotland for anyone who doesn't know. Scotland is a wonderful, magical place. It's one of the decoyments.

It is a country located in Europe, FYI. I said, didn't specifically say the United Kingdom, because who knows at some point down future my people are listening to this. Here's a message to anyone Scottish listening. Run, run now, save yourselves.

Jump, this ship is sinking anyway. So I got the bare face Lager. So it is a Lager. And yeah, I've not really actually read the can yet, but they openly admit the beer steals it.

Zesty Rome hops from the USA and has notes of fruit and honey, which balance the powerful bitter bite. So yeah, proper Scottish Lager. So I got that. What have you got?

I have the purple one, glad IPA, a retro India pale ale. What makes it retro? No, no. It says it's a stripped back golden IPA, which sounds interesting to me.

Unfussy and unapologetic. In any case, I buy classic American craft beers in the 70s and 80s. Oh, nice. Well, I've actually had the purple one.

I enjoyed it whilst watching the first episode of the Great British Bake Off, which is currently going. Fingers crossed for my, are you watching British Bake Off Chris? Of course. Fabulous.

Who's your favourite? Oh, I like them all at the moment now, actually. Yeah, it's pretty hard. Of course, everyone loves Lotti.

A big fan of Lotti, absolutely. Not my favourite, but a big fan. Quite like Laura, but my absolute favourite is going to be bitter. Really?

Oh, OK. I love the beak. Mine is Emin, just because I think she's brilliant. I'm just going to do it.

And then she does it perfectly. Anyway, oh, that's a baker. A whole lot of really good. Really good now.

I'm really liking the cast. It was not a cast. I don't know what it is. Would you call them?

The contestants. Yeah. Because of their contestants, right? Exactly.

Well, so it's a point of the don't start with 13 different. Bakers doesn't. That would be clever. Mr.

Tripp, never mind. So anyway, it's time to get this particular show on the road. Get those buns in the oven and bake. It's time for us to open up our beers.

So let's go ahead, Chris. Are you ready? Ready? Ready?

Three, two, one. I didn't hear yours. I heard mine very clearly. I heard yours.

You got a glass of corn too. I do. It's got hearts on it. Look.

Chris and I can see each other over Zoom. We're recording this on Zoom because actually the audio quality is surprisingly unbad. But there we go. Maybe we should, as a bonus feature, release the video.

Nobody wants to see that, Chris. I'm literally sat here in the darkness because now it gets dark at 5pm. We're wearing spirited away hoodie and no trousers. You can't see.

I'm at the table. So I've bought this very badly as you'll be able to see if you're a free user. If you want the video for DBL 25, the limited golden cough IPA. See what I did there.

Edition. And that's what I'm actually going to call it. Then it's just let us know. Send us a tweet.

That would be at, because Chris, not that he ever uses Twitter. So tweet me at plant-based SQL and I will send you the recording free of charge unless you want to provide beer. In which case, I can't say because I'm not a, wait, is that like a contractual obligation not to accept bribes or something? Yeah.

Yeah. We can't accept anything over 50 pounds. I think. Oh, well, okay.

Well, as long as it's beer, then we're fine. See, this is why it's worth while doing a podcast with your boss, because you can just ask them. We also start something much in does, because that's what everyone does now. Well, I would love some merchandise.

Create a Patreon page. Can you do that? No, we can't do that because we're sponsored already. But I definitely think some merch wouldn't go amiss.

And maybe running another competition for said merch. I'm just saying words. And if Louise, you happen to hear these things and think they're a good idea, then I'm just saying it's almost Christmas and 2020 has not been a fun year. Hey, every day is Christmas when we're around.

Hey, is that because Chris, is it's because I'm fat and jolly and have a beard? Yes. Right. Fair enough.

Anyway, so we've been rambling on now for goodness knows how long I can't even see a recording counter. But what I can do is I can say it's time for us to talk about our theme. And our theme is where can we put our SQL server databases? So I'll tell you when you can shut your SQL server down.

That's a normal. So normally, at this point, when we're starting with someone who's completely green, is we have to explain to them what an instance is. I mean, that's kind of, well, no, the first lesson we teach is literally computing fundamentals. So we talk about what is a server, the client server model.

We talk about, you know, what happens and this is really cool. One of the ways that I explain visual studio and SQL server management studio as IDEs. One of the ways I use that is talking about web browsers, because everybody knows at least Internet Explorer and Chrome. And some people know Firefox and there's other browsers that people know.

And I always talk about them as being IDEs, like SSMS, like Visual Studio, and connecting to websites like, you know, www.google.com will be pretty much the same whether you access it from Google Chrome or Internet Explorer after Internet Explorer falls over itself and then warns you about a security hold that's not there. But you can use both SSMS and Visual Studio to make database changes. So that's how it's playing. That's a clever idea.

That's a clever idea. Thank you. And then people kind of get it because they go, Oh, so the database is actually still exist behind the scenes. And they don't actually exist as part of SQL Server Management Studio once we close Management Studio, SQL Server doesn't die.

Yeah, that's only piece of my method. I just say that SSMS is like Spotify and that Visual Studio is like Outlook and people get very confused. I'm quite confused myself. How is it like Spotify?

I was because it falls over occasionally and you right click and then it hangs for 15 seconds. No, it's because it's got a new favorite music in it. Like a database? What a database is.

I'm so confused. Oh, well, yeah. So effective. Oh, my gosh, we didn't even talk about the beer, by the way, and I have just taken a swig of this bare face Lager and it's absolutely delicious.

Drygate Brewery Glasgow, you have made a lifetime fan. I've had two of your beers and they are absolutely impeccable. So if any of you are in Glasgow, I don't know what the lockdown restrictions are there. But if you can get your hands on some of this drygate brewery beer, then do because nobody, nobody does a beer or a whiskey.

Nobody does a beer quite like the Scottish. I'll tell you that. No, does a whiskey like the Scottish? Well, what?

I agree, but I didn't want to, I didn't want to lose, I don't know, the Irish contingent of our listeners just by saying that because then I'm going to get lots of hate mail on Twitter like, now Irish whiskey is better. You shouldn't be worried about the Irish listeners. It's the, the Kentucky based listeners where you got the concern about. Also, yeah, our premium users can see the look on Chris's face when he takes that sip of beer.

Another thing that we talk about a lot and you can't really see through the audio, but you can't hear a premium user and get our video for you. We use stop saying premium user. The quality of the phone on top is amazing. Okay, if you say so.

It is a very big shape. Look, see, see, you can't really see it very well. No. But you can hear a premium user.

Stop saying no, we won't. No, there is no such thing as a premium user. Nobody, nobody would want to be a premium user. I don't even know who listens to this.

Like, there's, I know at least three people who listen. So hello to those three people. Hello, Chris's mom. She doesn't listen anymore.

Oh, really? I gave up after like episode three. She was like, oh, you just talk about databases. I was like, yeah, that's kind of the point.

Anyway, back to SQL Server databases. So you've got your SQL Server, right? So we've explained to our new starters, hey, this is a server. This is how computing works, you know, light switch on off.

And they have one of these, usually when I'm explaining it like that people have that like bold moment where they go, oh, I get it because when I sign up to a thing, I give my name and my email address and blah, blah, blah. And then it goes somewhere. Wow. Anyway, that's another subject.

That's what we start talking about. Take a mask again, go back a few episodes. You're fine. So back to the point, Chris.

So back to the point. So we talk about servers and we talk about one instances. And once people get the head around one instances, so an installation of SQL Server, they're like, oh, okay, so you can have it installed potentially multiple times on the same server and have multiple instances. And then obviously the default or named instance, you got a whole bunch of different options there, but they get it.

It's a program. It's installed on a server. So let's talk the first option that we have beyond on premises. And that of course is.

I mean, which was the first one? Like, what was the first pop just virtualize the server? Oh, yeah. The one that really, really doesn't work is a, what do you call it when you say like the house spell?

But yes, I as, I as, yeah, it's a mixture of valves that just doesn't go together. Unless it's like, the problem is you've got like too many valves in a row, right? I as, no, it just doesn't work. You need like to remove one of the A's or something.

So it's like A's. If you if you had an E to the end of the A's between it and the S, it could just be someone really excited agreed to something. Yes. What if it's like, well, is Plaid spell?

I know AID played plaid. Plaid. No, it doesn't work. Infrastructure as a service.

It's a pretty straightforward option, right? You just take your computer and you put your computer somewhere else. Exactly. So instead of the bare metal, instead of the air conditioning and the actual blades and the rent for the warehouse and the x, y, z, we just wrap all that up into one charge and get someone else to do it.

Exactly. And who's got good options for that? Well, who? Basically anyone, right?

I mean, there's a million and one vendors who will give you racks a somewhere, including rack space, including rack space. Yeah. Microsoft and I mean, sure, even Apple probably had an arm somewhere that allows you to spend on infrastructure services. That's really interesting.

Hang on. Let me just tippity tap on my magical mechanical keyboard and just go Apple rent VM. Maybe Cloud Mac rental. Doesn't look like it.

Oh, yeah. Like any vendor who basically gets a massive string of service service from HP or IBM or someone puts in a room somewhere and then rates out on any time to people. Yeah. It's not too hard of business to set up.

So you could you could start that off as quite a small company, really? And I think there are quite a few and rent out VMs. Why not? I suppose the big three that we end up talking about mostly because again, we're dealing with SQL Server here.

So generally people using SQL Server that we deal with on a regular basis generally have some kind of in with Microsoft. I mean, what Microsoft published published their profits for Q3 2020 and came in at like $38 billion with Azure up like 20. No, LinkedIn was up like 20. 21 billion?

Maybe it was a year that was up 21 billion. LinkedIn, LinkedIn revenue was up and profit was up. And and as your profit was way, way up. And I think that's because people are realizing that they don't want to have to go in and maintain physical machines anymore.

So they just go, right, tell you what, we'll lease a machine. And this is the interesting thing. Yeah, I feel like it doesn't really make much sense for you, right? Like, why would you buy a server and then have to worry about the overhead stuff that when you could just rent it out?

No, I don't replace that this. Well, especially if you're a, you know, you're a kickstart company, you don't really want big upfront expenditure. Yeah. What you want is something that you can just spin up and you need strict class back.

You can very quickly, derivative it. Yeah, it makes a lot of sense. And yeah, of course, you naturally tend towards the big dogs as well, because there's ways economies of scale, having just said that anyone could set this up and there's lots of small vendors, you know, economies of scale really benefit you here. If you just have a hell of a load of servers out in the middle of the Arctic desert or Antarctic desert summer.

Yeah. Then that's perfect. And yeah, the idea, like where you can put all these machines that the rent is basically nil pooling as cheap as possible. So yeah, it's, it's an interesting one.

Well, I think that, so just to talk about the kind of three main cloud providers that we come across, then that's, I mean, that's pretty much as yeah, Microsoft Azure or Azure or Azure or yeah, I actually prefer saying Azure. I think it sounds, I think it sounds a bit daring with us. It's like, it's Microsoft Azure, you know, where is it? It's Azure Azure Azure.

It's a bit more daring. It sounds like a tiger, like a character around like a really cool like he-man or thundercats or something like quick get after Azure. Asia. That's what it's not called.

Asia Azure Azure. Azure as a red. Yeah. So Microsoft Azure Azure Azure and then you've got the company that for some reason loves their TLAs, their three-layer acronyms.

That of course is Amazon with their EWS. So Amazon Web Services. Yes, indeed. The richest man in the world probably knows what we're saying right now.

I see you echo. Don't you listen to me? It's okay. She's asleep.

Anyway, so you got AWS and then also Google Cloud as well as it's pretty much up and coming. I mean, I probably personally deal more with people who are hosting their virtual machines in Rackspace, more often than I'll deal with people who are hosting in Google Cloud. But I definitely think it's like, so the big three are really good, but you know, Rackspace has been doing what they've been doing really well as well. I wouldn't.

I wouldn't discount them by any means. No, absolutely not. So yeah, so basically infrastructure as a service. And what you get is you install your SQL Server instances on virtual machines, right?

So SQL Server installed on a virtual machine. You don't worry about the hardware. You don't have to worry about the electricity, the air conditioning, nothing like that. And basically, you can, this is, it's how much control you want.

That's the real key here, right? If you want to control the, I don't know, the temperature of your machine, stay with on-premises, because you're the one who can then stick at the monitor and go, right, 72 degrees Fahrenheit. It's perfect. I like it.

I don't know why I went marginally Australian there. Anyway, but you have full control of the underlying operating system, the instance, it's, you've got the manual backups, your recovery, you can, you can, you have full administration control, right? Yeah. I mean, you have a lot of control with the end, but yeah, you can do literally what you want with.

Yeah. As long as you don't want to, you know, without any RAM, then you're fine. Yeah. A lot of problems that you might have.

So what's more typical is if you have a config that isn't standard or doesn't fit in the templates that say Microsoft or whatever will give you, because that's one limitation with that offering. You can basically get this size VM. You don't get to say, but I want to two core 360 gigabyte RAM VM. Why won't you give me that?

Yeah. Well, I mean, that's a pretty, this is a pretty standard shift, right? Is that you go for an on-premises to your SQL server on your VMs hosted in AWS, hosted in Azure, hosted in Google Cloud, hosted in Rackspace, and you even control the OS, right? So you could be running Linux and SQL server on Linux on that box.

But it's up to you. So what's the next step beyond that? Pause. Pause.

Pause. I hear a lot of people say Pause. Pause. Pause.

Pause. Yeah. No, please. Wait, is it Mexico that uses pesos?

Mexican peso? I want to say yes. Luis, Luis has chined in in the chat with a yes. So Chris is going to use his funky mechanical keyboard as well.

I have no doubt. But Lu has already confirmed to us that it is indeed yes. I feel like there's somewhere else in the world that uses pesos. Is it Spain?

You see, right? Spain used to. Is it the Philippines Philippines? Americans and the Philippines.

Yeah. Oh, thank you. Thank you very much. I'm going to take my leave right now by drinking some more of this lovely lager.

Anyway, as platform as a service. Platform as a service is like a step up, right? So instead of leasing the actual machine from the provider, what we do is we go a step up and we lease just the database. So that effectively means yes, thank you.

Give me a single database and I'm going to build stuff in it. I can choose all the objects, the tables, the procedures, the functions of use. You think I have, but it's still technically cloud counts as platforms and service and we'll get to that even though even it was a later introduction. So we'll get there.

But yeah, so you've got platforms and service. So we've got on-premises, infrastructure as a service, you have a machine in the cloud and that is hosted by someone else and you choose what operating system, how powerful the server is and it's still your own programs on it. Platform as a service is literally just that you get the platform, so the database and you build it out from there, your tables or procedures, functions, views, etc, etc. But that database exists in the cloud and you get a connection string to that database, right?

Yes. Yes. Thank you for confirming. I appreciate that.

Yes, that is what happens. And yeah, economies of scale kind of really work out from here for Microsoft, but it's now they can make a massive VM and put a massive instance and just share out the individual pieces that they need, and also then they can actually install an operating system that they think is the cheapest to run, which might actually not work with what they were usually using. So maybe they should develop an eversion SQL server that runs on Linux instead of Windows and then pretend that they will release that version of SQL Server for Linux because that's what they were really offering and not because it made sense for their Azure offering. But I'm just wondering, I'm just thinking about it.

The interesting thing to bear in mind though is that a lot of people associate associate the platform as a service offerings as being SQL Server itself, just a platform as a service version. There are quite a few subtle differences though as to why a platform as a service or database as a service basically doesn't count as, you know, doesn't count as a SQL service specifically. So it's not technically platform as a service, but it can also be known as database as a service. And the interesting thing about that, of course, is the other service, not DB as a service, DB as a service.

But the interesting thing about that is that, of course, you now don't look after the backups and the recovery necessarily. So that's a really interesting one. So there are two main providers of platforms, the service SQL Server, NS SQL, and that of course is, I'll take this one. So it's as you're obviously AWS, AWS offers a service called RDS or AWS RDS relational database service service.

And basically you just again, you release a database. The one strength I would argue that's quite nice from the AWS RDS side is that you actually can get proper dock back files from an RDS SQL Server database, which means if you spit that back file out onto an S3 bucket, a secure S3 bucket, there's nothing stopping you from, I don't know, then using that in some kind of provisioning process, not that Redgate would have invested interest in that. But I wonder what the post that links up to someone having already set up a system that grabs back up a mouse into SQL clone, I'd be rather than here. Well, Chris, you know, as far as I know, only one such a blog post exists.

No, actually there's loads and probably better ones. But yes, plant-based SQL.com does have one of those blog posts anyway. You won't let me do that the whole premium member's name, but you can't go and block post on everything. Double standards.

It's true. It's true. But that being said, the interesting thing about platforms of service is that obviously you've got the built-in backup and recovery with RDS, you do get the ability to spit out a dock back file. But effectively, you only have control of what's in the database realistically.

And that's, you know, only includes the database scope features. But the good thing is, obviously that comes with the availability offered by AWS or by Azure. And funnily enough, Amazon and Microsoft are both pretty good at building out their infrastructure. So the chances of me building a SQL Server instance on a machine, say, in my house, and that being available 100% of the time versus Microsoft or Amazon doing that, well, hmm.

And that's the major benefit here, right? Instead of worrying about looking after the instance itself, instead of worrying about looking after the server itself, instead of worrying about all that stuff, I just worry about the thing that ultimately benefits my customers. And that is the database, which is used by my application, my web app, the whatever, to provide a consistent, gosh, I remember the word service to my end users. And that's it.

We don't worry about the event. We should also say that Google also does the class. Does it? Does it?

No, is that new? That's new to me. But, you know, they did announce that. They did announce that.

Yes, I remember. That being said, you did also mention that you didn't think that I missed a step. And quite rightly, between our SQL Server on Azure VMs and our Azure SQL database, there is, of course, one additional step. And that is, of course, Chris.

And managed instance. I mean, it's kind of similar to RDS, right, though. I think I'm like, dear, we get an instance level rather than DBL. It is kind of similar to an RDS, yes.

But obviously, Microsoft wanted to make sure that they had kind of every level of offering. So there is also a managed instance as well. So it's still much like, as your SQL database is automatically patched and upgraded. It supports most of the instance scoped features.

It has high availability because you're relying on Microsoft. And the interesting thing is you actually have full control of the instance. So instead of controlling lots of individual databases, you get the hosted installation of SQL Server, and you can just put on the databases that you need. Wow, I'm bound.

It's, yeah. Well, I think that, like, it's a lot easier for companies to kind of go lift and shift with that, especially if you've got an established project and you want to take it into a cloud environment, doing a whole instance that's much more straightforward. Whereas a firm point, if you've got like a new project and the odds are, spin up as your DB would probably make more sense. These days you want to go down the Microsoft's route wherever you can if you're creating a new project from scratch.

So you don't want to have a share, since it's just the same thing. Yeah. No, that's absolutely true. And if you're trying to lift and shift this kind of monolithic archaic workload into Azure, then you might actually require more rewrites than you're really willing to do by trying to shift everything into a SQL database.

But gradually breaking that down into said microservices is absolutely something that I think a lot of people are doing at the moment. And so there's two more things on this. But one is like Microsoft were offering quite a lot of benefits to doing that whole lift and shift as well. So for example, extended support onto 2008, 2008 when that happened.

So you get 2008, 2008 or two supported for longer than you usually would. And you know, if you did want to do this, then we have good friends at Kavio, for example, who are experts in this. So it's, you know, we definitely could point you in the right direction. Yeah.

So if you're looking at potentially lifting and shifting your workload, into something, well, into Azure specifically, then definitely check out Kavio, C-O-E-O, who will obviously be more than happy to help talk you through the various options that you have available. But there is one other thing that we should mention before we go on to kind of our final segment as well. And we've talked about a couple of things here. So we've talked about virtual machines, infrastructure as a service, platforms as a service as your SQL database, as your SQL managed instance, and also RDS SQL server.

But one thing we haven't mentioned is elastic pools. And of course, elastic pools is a really interesting concept as well. And that exists within the Azure stack as well. And that is basically a collection of databases that are databases to service.

And the idea is that whilst you have full control of this pool of databases, they're automatically scaled where you have unpredictable usage, you're able to kind of scale the ability between those, or share the resources between those databases, so that one can scale up and scale down as necessary. And it creates this kind of web of databases that meet your needs as and when they scale based on the application based on which database they're using. The elastic scaling element of that is really key. And that is another huge benefit from going to the cloud.

And some of you just can't be with on-premises is kit, right? Like if you, let's say you launch a new video game and it requires a database in the backend, or to be honest, it requires just servers. If you have elastic scaling, then you have your launch date, that's when you have your key in other users, you scale to the capacity by blowing through Microsoft's capacity. Expand out as much as you need and then shrink back down when you use a grace base inevitably calms down a bit post release.

Personally, I've been really interested to find out how Among Us did it because obviously Among Us went from being a game that literally no one had heard of a couple of months ago, and now it's one of the biggest games in the world. And trying to play it at peak time is almost impossible. It's based on kind of a very straightforward concept, and it's like a team of three developers working out of a shed or something. But now you've got like major YouTubers playing it and streaming it, you've got people, you've got hundreds of thousands, hundreds of thousands of millions of people playing this game.

I'm really interested in how they scaled out. They're in the streams. It's like a really interesting example to talk about when you talk about software. I'm going to go on a tangent here, but I think it's an interesting one.

But because like a lot of the events are very traditional developed, I think it kind of makes sense. They're very big projects compared to a lot of kind of enterprise applications. And so they'll often have huge problems when they have release because release is a scheduled thing launch happens, you have like this massive patch that comes in, and the classic one is like Call of Duty, I don't know, whatever's popular with the kids these days, it gets released and you have this huge influx of players. And it's amazing to me how often you still get reports of day one multiplayer problems, because they don't have the elastic scaling in place.

I mean, it's like when you get results day for exams and all of a sudden the service for university admissions falls over or anything. I understand a little bit more because I think university admissions website is probably not where there's a huge amount of developers who are motivated to work in agile ways. Yeah, but at the same time, they kind of know when their main influx of users is going to come, like it's not like it's not published two years ahead of the day. Yeah, but like if they're on a traditional system, then they've got to get budget to get the extra service in.

And I only need to have that capacity for that peak point. It's true. And not to worry about it. Because yeah, you think about a massive video game publisher, they should probably have realized by now that they have a big spike on launch day.

Yeah. And yeah, if you have on premise kit, you have to buy all the kit for your peak time if you need to service that user, if you have elastic scaling in place, then you don't need that. You just scale up to your peaks, which is really cool. That's true.

And again, microservice infrastructure and all the joins you get with containers, all of this stuff goes really well and really nicely together. So you basically spin up other services and when you need them. Yeah, no, it's true. It's true.

So that's cool. And elastic pools, as we were talking about, still falls under databases of service really. So you still got as your SQL database and that's the most interesting instance. Oh gosh.

Last thing on this tangent, but like again, like a comparison to video games and how video games are shifting away from what's full to agile development and how that's perceived in the market is really interesting being to look into. Sorry, Gary on Chris. So without a talk, we know about on-premises, we know about infrastructure as a service, platform service, and database as a service. And it's all about generally the levels of virtualization that we're willing to accept.

And of course, the loss of control that we're willing to accept when it goes through kind of the how much control you have, why don't have control over the machine or the instance, et cetera, et cetera. So you give that up, but you gain something that can just be leased and a cost that can ultimately be saved. But that brings us now time full circle to our favorite segment, of course, we put that segment to bed. It's now time for new EWS.

It's in the news. I just got that. You're welcome. So there's, yeah, I mean, there's this what three three pieces of news we want to cover.

Now it's worthwhile us doing data breach monthly and me handing over to you because you're the one who's been looking into this. And then I'll cover the other ones as well. All right. So I'll be, well, you want to start with day three.

Data breach monthly. Everyone's here for data breach monthly. We know they love it. We know you love it listeners.

So you might have seen the news about British Airways, the fine from the oncio, being stripped back down from 183 million to a mere 20 million, 20 million pounds, which is still a massive fine. The reduction in fine is, well, I'll go in a second. Actually, the original fine. So this came from virtual credit card skimming.

So someone managed to put in place a virtual redirect on credit card details and could effectively digitally skim credit card details for quite a lot of people. It was about 244,000 people got caught by us. So third party code was ultimately responsible, not BA code. I think they implemented, I think it was a chat bot.

And remember, it was the mage cart system that we were talking about quite a while ago that was responsible for it? But anyway, so they have this virtual credit card skimmer on their website, the long-term issue is done. And they found out about it. They didn't tell anyone about it.

And it's all the great companies do. Standard. And then they did eventually get caught or it got found out. And so, yeah, the ICO leveraged just massive fine, which was the biggest in history.

It's 100 million pounds. And of course, then, there's a pretty good response from BA once the ICO were involved. So they very quickly stepped things up. And also the revenue kind of took a massive hit for some reason.

I can't really think what that was. As a result, the ICO lowered their fine to 20 million, which is, yeah, I mean, it's still the largest fine ever issued by the ICO. Part of me is like, oh, they should have got their comeuppance. The other part of me is looking, yeah, I mean, I kind of see why it does make sense.

So yeah, that's it from me for date for each news. Yeah, really interesting, really interesting on the finds there. But the point is, is that even through a pandemic, regulation still has teeth, right? And even the regulators in South Africa have basically said, yeah, we're not giving anyone a break for Poppia.

Like, we don't care that there's a pandemic on, we're still going to levy fines and we're going to be harsh. Basically, the South Africa regulators have been like, no, this is still happening. It's still very much happening. You've got to be compliant, even though we're going through this, sort it out.

And it's really, really interesting to see how that's happened. I also found the response from the A pretty interesting piece. They come for legal reasons and they basically say, yeah, okay, we accept that one. But they as good as it.

So they said that they can see where the ICO was coming from, which is a very interesting way of saying, okay. Yeah, well, okay, are bad. Oops. No, fair enough.

And there's only two more exciting pieces of news for us to share with these gentle listeners before we allow them to continue with their day. I'm sure you're all up to something really nice. And here's a quick reminder. Remember to drink enough water, stay hydrated.

Remember to give yourself a break during the day. And just remember to tell yourself how much you mean to yourself as well. I'm pretty awesome. Chris, you're pretty awesome.

Lou, even though you're on mute, you're pretty awesome. We're all awesome. So keep reminding yourself how much you matter because it's really important. That is really exciting.

Chris, you are not awesome. I only are awesome. Chris, I'm cool. Okay, that's fair enough.

I'll give you that. But at the same time, there is two pieces of news that's really exciting to share. The first of these is we'll go with the slightly more, hey, I really care about my server's root. So really exciting news from RekHQ.

And that is that we have now released SQL Monitor version 11. And one of the main highlights of this includes, obviously, given that we've been talking about database as a service, platform as a service. One of the main highlights of Monitor version 11 is support for AWS RDS SQL Server. So completing that support for the AWS stack as well.

It's a really cool piece of work. It's been exceptionally hard. The developers have been working their back sides off. And it's, you know, it really is going to be very, very exciting.

So that V11 is something that actually, depending on what date, I say it's been released, depending on what date you're listening to this, it's been released. But it's, if you're listening very, very soon, if you're a really avid fan of DBA, then it's probably coming like imminently, it's something that you can expect to see very, very soon. And it's like I said, really exciting. So if you're interested in seeing what SQL Monitor V11 has to offer you, go ahead to the website, check it out.

Keep your eye on the release notes. If it hasn't been released yet, it should be any moment, basically. And for me, if you go to monosod.rent.com, that's our public facing demo site. And we basically always have a latest version running there.

So once it's released, it'll be there and you can click out and play around as much as you like. I also did a webinar that was released yesterday at time of recording. So that is Tuesday, the 27th of October, with some of the development in going through some of the wonderful new features of the version 11 release. Absolutely.

RDS, tempDB, performance improvements, and a new documentation site. I'm really impressed, actually, by the new tempDB monitoring features. Those have already been released to monitor.rent.rent.com. So anyone who's listening, you can go there and drill down into instance level and go down to tempDB.

Brand new, really, really interesting. Definitely go and have a look at that. But yeah, monitor V11, tons of functionality. Very, very exciting to come.

So go ahead, check out the webinar that Chris mentioned. If you go to the Redgate website and go to the community page, the Redgate hub, you'll be able to find our online events, including that recorded webinar, which you can then grab a copy for yourself. Go ahead and check out monitor.rent.rent.com to have a play around with monitor yourself. And of course, do feel free to download a free trial and see how it works on your service for yourself.

It's a wonderful piece of technology that really gives you the insights that you need. Me and Chris, of course, happy to help anyone out who wants it as well if they do get it up. Yeah, absolutely. And feel free to get in touch as well, dbl.rent.rent.rent.com, or you can tweet us or anything.

Just let us know if you want to hand and we'll be more than happy to help out. The final piece of news that we have, though, as well, is that it's Redgate's beat or this week in the last week. It has been Redgate's 21st birthday. So we just want to wish a very, very warm, happy birthday to Redgate.

Been around for 21 years since 1999, a long time ago with our first ever product, Olive Vark. So yeah, very long time in the making. But as always, a pleasure to work for a wonderful company with wonderful people and hopefully a company that will continue to go from strength to strength. So happy, happy birthday to Redgate to everyone working at Redgate.

Ironically, right, literally, like in the middle, smack bang in the middle of my birthday and Chris Kurzweil's birthday as well in October, literally right in the middle, I turned 29, Chris turned 31, just pointing that out. I was going to be a director of U-turn to 20, I turned 43. No, no. So yeah, Redgate, in the space of two weeks, I was 29, you were 31, and Redgate was 21.

So Redgate's the youngest of the three of us at the very least. And the record can lead in drips, I'm just curious to that. Yes, absolutely. Cheers, unfortunately.

As our premium users will now see, I am down one bit. So we done. But that is that is DBL 25, the quarter quell, the 25 months of continuous constantly listening to Chris's ridiculousness over and done with. So thank you all for staying with us for these past 25 episodes.

Here's to another 25 as well. If you're interested in listening to something a bit spookier for Halloween, do please feel free to check out some of our past episodes, my personal favorite, servers that go bump in the nighttime, a great Halloween episode of DBL as well. But for now, it's thank you so much for me. Happy birthday to Redgate.

Go check out SQL Mitre 11. And of course for now, Chris, cheers. Cheers.

Frequently asked questions

How long is this episode of DBAle?

This episode is 56 minutes long.

When was this DBAle episode published?

This episode was published on October 29, 2020.

Is there a transcript available for this episode?

Yes, a full transcript is available for this episode. You can read the complete transcript on the episode page.

Can I download this DBAle episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.