Hello there everyone and welcome back to Redgate DBL, the podcast that's all about database development and beer drinking. And Chris. And Chris. But primarily...
Chris. Beer drinking. And a bit of database development. And Chris.
As you may have guessed, and hopefully if you've been listening to other episodes, please listen to other episodes. You will know by now that I am Chris. And my name is also Chris. This is apparently a feature that we missed out last time.
We did, yes, absolutely. I listened back to DBL 10. And I was listening and I just thought, oh no, we didn't do the one thing that differentiates us as a podcast. I like how you're not even going to pretend it was a public outcry, a missed feature.
Was you re-listening to the episode? Yes, it... Well, I mean... We've got to get those numbers up somehow.
The 3000 listens is basically just me. You don't become number 300 in the Bolivia without some serious work in the education. We've got 300 in Bolivia. No, no, last time I checked.
327 or something, wasn't it? A round of that. Anyway, what we got in store for you today, well, we have a rather special ale, but I shall leave that for just a moment, something that we found. I want to wait.
I want to know. You're going to have to wait. Oh. In any case, today we're going posh.
Oh! Er, pass the butter, Marjorie. Er, so for anyone in the States that was just Chris talking normally? Yeah, this is true.
This is my affected podcast, but it's bit er, this is how it normally speaks to now. Yeah, I think I could drum it on a posh accent, but I won't be able to tell the difference. This is true. But we are going posh in the sense that we are talking about PowerShell.
And more specifically, when it comes to talking about PowerShell, we will be talking about... Chris, that's a terrible drum roll, please stop. There's a good drum roll. DBA tools.
Whoo! DBA tools. Posh DBA tools. Posh DBA tools.
Indeed, they are posh, my goodness. We've got a lot to speak about, so hopefully we'll have time for it all. But before we begin, a massive, massive shout-out to the one person who without... Without whom, I believe is the correct phrasing, without whom, this episode would not be possible.
And that, of course... It's Chris's mum. And that, of course, is Rob Soul, the sequel DBA with a beard. Definitely the nicest beard I've ever seen on anyone ever, sorry, Chris.
And just generally a most wonderful human being. So if you're not already following him on Twitter, seeing the amazing things that he does with PowerShell on his GitHub, or anything like that, attending his sessions, I definitely, definitely recommend that you check him out, because honestly, the man is a genius. Yeah, seconded and generally just a really great guy. Also, shout-out to your mum.
I mean, I'm sure she'll appreciate it. Hi, mum. Again. In any case, let's get cracking with, obviously, the most important thing about today's show.
And that, of course, is... Chris. The beard, you're right! This is turning into that movie, Rubab, where everyone just said Rubab.
Or Pokemon. Oh, you can only say your name. Yeah. Oh, but why don't you go?
We... Anyway. The beard. So I managed to find this particular beard online.
I paid a pretty penny for it, you won't remind me, seeing. A whole five pounds. A whole five shillings. But effectively, I couldn't pass up this opportunity.
I love the fact that people in the UK were resistant to move away from shillings and tuppets and sixpence into the new system of 100 pennies into a pound, because they thought it would be too complicated. In the same way, we still use ounces and stones. And feet and inches. And miles.
Because the other one is too complex. I run in... I run in kilometers, but I drive in miles. Anyway.
Metrics system plug, go. Go, metric system. In any case, what we got for us this week is actually from the Firestone brewery, which is actually Firestone Walker, I believe. Nothing to do with the tyres.
No. So I'm going to take it like rubber. No. Good.
But effectively, what we've managed to procure for ourselves is a Firestone double barrel, ale, or DB. Hey, it's a DB ale. Hey! If any one of you has wondered what a smile sounds like...
It's been unable to contain himself since revealing this. Yeah, this is true. About a week and a half now. I've just been smiling with glee.
Yeah. In any case, it is a... According... What I'm going to do is actually read out.
I'm sure what Firestone would like you to know about the beer, and that is that it is the trailblazing flagship beer that started it all back in the day for them in 1996. It's partially fermented in their patented Firestone Union oak barrel brewing system. It quickly took the central coast by storm and set the pace for future beers to come. It's regarded as a California classic, which is great for us because we're always talking about the data privacy legislation, like the California Consumer Privacy Act, the Kakpah, and also we have an office out in sunny California as well.
That's a deena. Indeed. So, this particular beer is about five percent, and there's lots of hops and malts and all sorts included, but I tell you what, the best way to trial it is, of course. Trialing it.
Actually, trying it. Yes. So let's go ahead and pour. Glue, glue, glue.
Oh, it's a really pretty colour. Oh, this has got way too much head. Stop. Double fail.
No, it's a double hail. Hey. That's awful. It's definitely got the caramel colour.
Definitely. See that to me looks like the sort of point that you would expect to see on a picture. Yeah, yeah I get that. Come in and try our fantastic DBA.
And then that picture. You know, I'm really sorry guys. I have completely forgotten that this is a podcast and not television. Although that's probably just as well.
You don't really want to look at my face over and over again. Yeah, like that. That's an interesting, lots of lip smacking going on. That's a really interesting flavour.
Hmm. Yeah, 100%. I really like the hops as well, the hoppy flavour to it. Yeah, really nice.
Fantastic. Well, a resounding four thumbs up there from the Chris's for the Firestone DBA. That was a layer I didn't put any thumbs up. Do you want to put them up now?
No, it's your one. Thumbs up. Oh, alright. Well two thumbs up from this Chris certainly for the Firestone DBA.
Yeah, no, I like it. It's like an English ale without the bitter edge. You kind of feel like there's a bitter edge coming, but it's very smooth. I like it.
I feel like there's a bitter edge coming. Like with PowerShell. No, a shell has a bitter edge. No, no, it definitely doesn't.
It's a wonderful tool and everyone should be using it. Especially DBA's. So, Chris, what was your first ever interaction with PowerShell? What was your first experience of PowerShell?
Well, about two weeks ago when you told me we should do a podcast or about PowerShell. And then I had a moment of what? I mean, remember, the fake story that we worked on together. Do you want to tell that one instead?
I have a fake story. It's a fake story. Come on, you've definitely worked with PowerShell. I know you've touched it before.
I have worked with PowerShell. PowerShell is nice. I'm somewhat okay at running someone else's PowerShell script. I can reasonably successfully hit that play button and let it run.
Well, absolutely. It's always handy when people have put those scripts together for you. Certainly the commanders that you need to do certain actions is a whole host. Easier than actually putting it together yourself.
So certainly my experience of PowerShell has resolved a lot around the commandants that we can get from, for instance, the ones we use for a game on a day-to-day basis for SQL change automation, for SQL provision. But also just using something like DBA tools as well. And actually, to be fair, I hadn't used DBA tools except for the masking functionality, spoiler alert. Don't worry, this isn't Game of Thrones, which I don't think anyone's going to really think that a spoiler.
But I have used the masking before, so I did know roughly how it worked. But again, thanks to the wonderful Rob, we actually have a slightly better idea of what you can accomplish. Sorry, my mind's blown. There's masking in Game of Thrones.
Yes, absolutely. I've never seen an episode of Game of Thrones. I assume it's something to do with masking royalty, like masking royalty information in databases. You are so out of the loop.
I mean, I am looking forward to Avengers. That's one thing we can all agree. No one should be sharing spoilers about. We can always find something to spoil each other.
Well, hopefully we're not going to be spoiling anything for our listeners this time around, because actually, this is all just wonderful information that we want to come along and sprinkle over them with, like, fairy dust. That's a very, very weird image. It is. Just get that picture of me and my tutu out of your head.
Oh. Silence. I think I just killed Chris's last brain cell. So, yes, today we're going to be talking about DBA tools, PowerShell.
So, for anyone who doesn't know, Chris, do you want to give us a summary of what DBA tools is? Well, I guess stuff from the ground up. PowerShell, a great way of automating a lot of the stuff we tend to do that is especially quite repetitive. You know, I need to move folder A to location B, maybe I have to do it over and over again.
Well, now I'm right. PowerShell's scripted to it. Very handy, especially for Windows users, Linux users probably a bit more savvy when it comes to this kind of thing. This is true.
You look like you're about to say something, though. No, no, I'll let you do your butt. My butt. My butt is, of course, that effectively what DBA tools is, is a community project.
Everyone coming together to put into PowerShell everything that database administrators need on a day-to-day basis to do exactly what you just said. And that is to take something that, until recently, has been a major headache for us, something that we do over and over and over again. And there's no kind of easy, single, repeatable way of doing it. Like how every morning I come into the office, I grab my glass of water and I unplug all of the cables that Chris's desk.
That's why my laptop doesn't turn on. You, Chris. In any case, that's something that we go out and say as a company, as a red gate, we always talk to people about, you know, try and make your life simpler, actually bring about good process and use the right tools for you and have the right people do the right things because then you have a standardized repeatable. It's not just about making your life easier.
It is also about exactly what you said. Repeatable, you know, if you do a monotonous task over and over and over again, the odds are over time, you're going to lose attention to detail when it comes to that task. Like not saying hello, we're Chris and Chris. Exactly.
You just let the ball drop. It happens naturally. This is true. Any which way that we can make this a more standardized repeatable process, first of all, going to make our lives easier, our peace of mind better.
We're going to be able to focus on other more important stuff and also make the process that's self more rigorous. So with that in mind, DBA tools, what can we do with DBA tools? What's a good place to start so we can find out what we can do? God, well, it's almost like you've seen my list.
Well, actually the one thing that Rob showed us that I don't think he thought was something amazing that you can do with DBA tools. But actually you can just find the necessary commands that you need. Just use something like find-dBA commands. I think it is.
Find-dBA commands. Yep. Where you can actually effectively find certain commands of the over 500 commands that they provide for you. And it can actually enable you to find the specific ones related to the task you're trying to do.
So if you want to look for a specific tag like backing up or backing up and restoring these sorts of things, then you can very, very quickly and easily navigate your way through this sheer volume of amazing stuff you can do to find just the commands that are necessary for you to do that task. That sounds pretty useful. It is pretty useful. It definitely beats my system which is to ask Chris.
Well, my system is to ask you. Oh dear. Recursive loop. Yes, I was just about to say that.
I was just about to say that. I was just about to say that. Oh dear. Oh dear.
So that's kind of one of the more basic things that you can do with DBA tools. Obviously we're not actually talking about how you can use them to carry out some of these tasks. But speaking of those tasks. Speaking of those tasks, I think one of the kind of most, again, basic things that you can do with DBA tools, but something- Well, obvious.
Sorry, not basic. No, I shouldn't say basic because there's a lot of time and effort that goes into this. The DBA tools power show is effectively, it's completely free. It's a free and exceptionally powerful way of doing all of these things.
So I should, you're quite right. So obvious. One of the more obvious things that you should enable us to do is to back up and restore. Yeah.
I mean, how many times do we speak to people about backing up and restoring? More than I ever want to. Well, I mean, that's not really great measure because you just don't like talking to people. No, but especially about backup and restore jobs.
Yeah, that's fair. As far as titillating topics of conversation go, that ranks somewhere near the bottom of my list. Titillating tip-top topics of tantalizing- Talking. Talking.
So, effectively, what you can do with the DBA tools power show is, of course, backup and restore. It's a very easy, robust way of carrying that out. You can restore it in over the top. Instead of you having to go through and be like, right, let's right-click, backup, do all this setup.
It's all very straightforward. And it's one very, very simple command. Backup. Restore it.
Run some checks. Backup some restore jobs. In my mind, they're one of those things that you just kind of want to set and forget. It's tedious work.
No one enjoys doing it. So, send and forget, you want to assist them so that you can set it, it'll schedule the backup jobs, and then it'll schedule restore jobs because, of course, the only way to verify backup is taking correct is to work, Chris. Leave the company before someone has to restore it. Yes.
Schedule the restore jobs, and then jobs are good. This is true, and obviously, there are a bunch of third-party tools out there as well, which are kind of specific for this. We had mentioned that. We had mentioned that, yeah, from being a Redgate podcast, but obviously there are a number of tools that you can.
So, Redgate has a SQL backup tool. We didn't need SQL Backup, bro. So, you can schedule, you can restore, and get notified if one of the resource fails. Yes.
But if you're not using said third-party tooling, then you could indeed be using the native SQL Server backups, which are also pretty damn good. And you can use the DVA tools PowerShell to actually achieve that as well in a nice, easy-to-use way. Sounds great. Now, it's interesting that you should have picked up there on stuff that you put on your server and kind of leave there.
Obviously, a database is more than the sum of its parts. It's not just tables installed procedures and functions and views. It's also a bunch of other stuff, like agent jobs, security, users and logins, et cetera. Now, anyone who's ever had to migrate between servers knows what a headache that can be.
And the number of times we've spoken to people who have said, well, actually, we're undergoing a server migration, and something went wrong, and we need to check that things have imported over correctly. And effectively, it's just causing one of the biggest headaches I think I've ever seen from any of our customers ever. Yep. I think that's for it.
Especially going from, say, 2008 to 2008, let's say, 17. Well, with 2008, actually... A lot of people had to do last year. Well, I mean, it's still ongoing to this year as well.
Oh, yeah. It still won't stop. Well, 2008 is end of life for support, I think, this year. Oh, this is probably something I should have looked up.
Last year. Was that last year? Where has time gone? Yeah, I know.
Oh, well, in any case, obviously a lot of people are looking to move from 2008 to newer, actually supported technology. So, 2014, 2016, 2017, 2019, goodness only knows what else. But, of course, being able to do that is not the easiest job in the world. Well, fear not, gentle listener.
I was pretty feared. You looked a feared. Well, fortunately, DBA tools has a very, very simple server migration functionality. And I use the term simple in this sense because, actually, it's darn simple.
And, again, this is something that Rob Radis threw actually gave us a quick demonstration of. But it's so easy to just basically say, take this database over here, migrate it over to here, and it just did it. It was so simple. It just moved everything.
Everything? Everything. There's no forgetting about little bits. It takes everything into account and migrates it over just beautifully.
Very handy. Indeed. And, certainly, it's one of those things that, as I say, people we speak to on a database, they've been saying, oh, it's a massive headache for us. If you're looking at doing a server migration, definitely take a look at actually being able to do that with the DBA tools power shell.
I believe it's start-dba migration. So, it's definitely worth having a look at when, especially when you need to move your servers, Chris. That happens a lot. Does it?
Yeah. Wow. How often? It makes a server migration a whole lot easier when you've got a big van to put the servers in.
Exactly. Oh, dear. Chris, is there anything that you want to add to that? I mean, obviously I've kind of hogged the limelight as is definitely not my tendency to do it.
One thing I really liked was the ability to monitor and specifically monitoring specific users. Ooh. Yes. Do tell.
Let's say that we are interested in, actually, migration is a pretty good use case. I want to move a whole bunch of users from environment A to environment B. How do I environment D? Ooh.
Okay. Environment A to environment one. Okay. I can deal with that.
Yep. And I want to make sure that I'm not moving over users just because they already exist. Okay. For example, a user gets created.
He is given access where he needs. Then he leaves the company. No, one notifies me. So he's still got access to environment A.
Okay. Maybe he doesn't actually need it in environment one. True. Probably doesn't need it full stop.
That's true. What I can do is set up a monitoring job for a user and try their activity. And essentially see if that is an active user or not for that specific environment. If they still need access for it, we can see how many times they access it and still migrate them over in a week's time or so.
So in some instances, I know you can't take my rights away on that particular server because I need them and then you can say, well, actually, do you really? Yeah, except on a much larger scale. Now, my tendency for this is usually to just say, no, I'll not move anyone over and add them back in when they request it. That doesn't always work.
You do have a tendency to just break things sometimes, especially if you've got a large scale environment, that can be a bit of a headache. But, process like that, really useful. Nice. Fantastic.
Well, whilst you were looking at, obviously, your kind of main area, as it were, I know you're a fan of monitoring and security and that sort of thing. I love watching things. I need an adult. I was, of course, looking at the one thing that, stop it, stop back.
Oh my goodness. I was, of course, looking at the one thing that I am obsessed with and something that I know Kendra Little has actually been saying. When it comes to data masking, we need to figure out what masking will impress Chris. Corgi masking, absolutely.
I'm a big shout out to Stormzy there. Bananas. Okay. Don't work out what you and Kendra both like.
I mean, I've never asked her if she likes bananas, but we both do love Corgis. But of course, the thing that I love the most is, of course. Sorry, one second question. What would you say that dog's name was?
Stormy. Okay, just checking. Yeah. Definitely not Stormzy, which is a well-known, is he a trap artist?
I don't know what that means. Okay, that's fair. But yes, Kendra has sent me some. I have in my mind a picture of someone designing traps.
Oh, dear. You're really out of touch. I want that as a job. Okay.
Well, on that note, I've been looking at what you can do when it comes to masking with GBA tools as well. And actually, it's really interesting because what it will allow you to do is effectively point to GBA tools at a database and you can effectively invoke it to create this kind of masking plan, if you will. It's a big long JSON string. Oh, I love big long JSON strings.
Oh, he broke me there. You completely throw me off my train of thought. Yeah, so it creates this big long JSON string, which can be nicely formatted and effectively allows you to go through and specify different masking rules for different columns. Cool.
Now, what that means in practice is that you can choose specific masks for specific columns, like names should become names, ages should be randomized, set as numbers, et cetera. Dogs should become famous rappers. Dogs should become famous rappers, exactly. And effectively, this is useful because it allows us to keep our data looking as realistic as possible, and that's something that we've spoken about before as well.
Okay, so compare and contrast then. What to Microsoft's static masking in SQL Server Management Studio? Yeah. So that's actually quite an easy one.
DBA tools is definitely more extensible and flexible in terms of the masks that it offers and actually it offers things like deterministic masking as well, which certainly you can't do in the preview of Microsoft's static masking functionality. So when it comes to ensuring that certain values are always masked to the same mask value, so Chris always gets masked to Dave. Well, then Chris should always be masked to Dave. It's probably not a good example.
You probably do things like, I don't know, company names, for instance, for testing purposes. But that's certainly something that I know I saw Chrissy actually post about online and Chrissy has one of the people who helps contribute and run DBA tools effectively. I saw that she added deterministic masking, and the turnaround on that was ridiculous as well. It was requested, and then a few weeks down the line, Bish Batchmosh, there it was, and it does a damn good job of it.
It creates this data dictionary mapping the old value to the new value, but certainly it creates this kind of key pair map. So it's really, really good for allowing you to keep things looking as realistic as possible, but ultimately not reversible and completely sanitized. So it's a really good way of getting started with static masking as well. Sounds good.
What else have you got for us, Chris? Well, there were a couple of things that blew me away as well, and the first of those was actually a corgi named Stormzy. Stormy? It's named Stormzy, not Stormzy.
So one of the things that blew me away was actually the cross-platform support. So you can actually run DBA tools on PowerShell Core. Cool. So that means you can run it on Linux, yeah?
Yeah, you can run it on Linux, you can run it on Mac, I think. It's based on .NET Core. This wonderful, weird world we live in where you now have DBAs running on Macs. I mean, DBA might be using a Mac, but of course, in that sense, they probably have SQL Server on Linux.
Who knows? The world is your oyster. You can have SQL Server on whatever you like. Personally, I have it in the back of my van for migrations.
Yeah, air quotes, migrations. Nothing to do with the UK customs, please. I have no idea what you mean, and I'm legally changing my name to Pablo. Pablo, Chris.
Pablo, Chris. Keba. One thing I really liked was the ease of deployments for other those groups. Makes that a bit more painless.
Oh, that was seamless. It was quite funny because Rob actually spun up. He spun up a couple of Linux containers running SQL Server and managed to pop an availability group just onto them in the blink of an eye with a very small script. Honestly, I blew my mind.
I feel like we've gone through quite a lot of topics here. We've got a light touch. Is there somewhere to go if we want more information? Oh, well, it's funny.
You should ask Chris in a pass. I mean, the bit of paper you put in front of me says that. There's no paper. There's lots of paper.
We're surrounded. Look at all these notes. Right after it says make joke about the imaginary paper you've got in front of you. Oh, darn it.
Rumbled again. I would have gotten away with it too if it weren't for you meddling, Chris. You see, that's there as well. Bad accent.
And on that note, something that we've discussed in the past is of course the SQL Community Slack channel. And why it is an invaluable resource for anyone who needs help with SQL Server in general. There's a bunch of amazing channels on that particular Slack community whether you like talking about, oh, I don't know, beer. Not cool, yes beer and podcasts.
Or whether you like talking to people and getting input from the wider community on best practice. But also there is support for DBA tools on the SQL Community Slack channel. So if you join the DBA tools channel, then you'll be able to ask a bunch of questions, get help if you need, get a bunch of feedback, make recommendations for functionality, all of these sorts of wonderful things. And it's all available at your very fingertips for free.
And I think once again, Shout out to Rob. Big shout out to Rob. Thank you so much. Great, great help.
And certainly will lead to me using DBA tools quite that bit more. Yep, I believe he's got a whole bunch of demos already recorded and ones that he continuously delivers as well. This is true. So if you can go to any of his sessions, definitely check those out.
Don't attend any of my sessions because they won't be very cautious. And they're awful. I mean, awful is kind of a very subjective view. Okay, some people think they're awful.
Corgies like them. Especially if you get their name right. I, I, anyway, I'll just, I'll bite that bullet. So moving on, Chris, it's probably time for your absolute favorite segment of all.
A list of Corgies names that I get correct. Or the news. Was that trap? No, I'm not going to try and imitate any kind of track music.
Probably for the best. Okay, let's go on to the news. So Chris, what amazing fantastical stupendous super inspiring news do you have for us today? Surprise, surprise.
I've got a roundup of data breaches. Oh, yay. But never ending source of interesting news. It's funny.
And guess who's in the news again this week, month? Wait, what? Guess who's in the news this week, month? This week, month.
Has it been a week, month for news? Yes, yes. Is it, well, we've already spoken about Myspace. Is it Bebo?
It is not. Is it? No, I give up. The book of faces.
Once again. Oh, dear. Yep. Essentially, some bright spark from a organization called UpGuard has.
What's UpGuard? Oh, dear. No, to listen to his beer is now finished. As it should be.
Not judging. Just pointing it out. Thank you. Continue.
So yes, Company called UpGuard discovered this essentially too old. I guess you could say archived. There's maybe a strong word. Servers found on a cloud infrastructure environment that was just open to the public.
Fantastic. Containing some personal information, surprise, surprise. One of these servers was from a third party. I believe they're called Kulfura.
Essentially, they were called Kulfura. Essentially, a huge amount of personal data collected on there. That third party given license to you by Facebook storing that information and then just leaving it exposed on. That was very interesting.
The more interesting one, I think, is the second server. So there was a Facebook game. Okay. You know how on Facebook are games?
Yes, because that's basically what I did at university. Not only have to program them, just playing them. Did you ever play a game called At the Pool? No.
I've done this. What is this game? It's hugely popular at the PWM. Essentially, there was a backup found that related to this particular Facebook game.
So players of the game would create a sub account within At the Pool for that little Facebook application. Play the game and quit or whatever. Do whatever they did. But the credentials that they stored on there, along with the rest of the Facebook ID, was included within this backup file.
Oh. Including passwords stored as plain text. What? You can use your At the Pool account.
Not at the Pool account? Oh, no. But seriously, people tend to not change their passwords. As we've spoken about before.
Exactly. As a result, it's only getting access to this trivial example. It doesn't really matter. But a lot of those users probably using the same passwords.
So that means in effect, access to other areas as well. True. Yeah, that was an interesting example. And again, Facebook can never get out of the data breach news, it seems.
Well, the problem with Facebook always being in the data breach news is that there's so much data. And so many third parties involved. There is so much Facebook. There is a lot of Facebook.
And that's the problem. Example number two. From this week. News month.
News month. Week, month news. Yes. Company called Bounty.
Like the chocolate. Yeah, but not the chocolate. No. This is a pregnancy and parenting club.
So new mothers or expecting mothers go on to the site and get information. Oh, I think I read about this one. Yeah. They were fined £400,000 by the ICO in the UK for illegally sharing personal information.
Essentially, a brand of about 14 million people signed up to this particular service. How many? 14 million. One or four million.
That includes only the mothers but the children as well. Oh, okay. Yeah. And they signed up to the service, service collects their personal information.
And without their consent, then redistributed that out to other companies. Sky and Equifax being two of the leading providers there. Oh, wow. And the big note there is that personal information was taken and then shared on without consent.
It's a data breach not in a sense of someone leaving something they shouldn't have turned on or some hardcore hacker, Ella Angelina Jolie, breaking into a production server simply an organisational misstep. Well, it's whatever is unconcented, right? You don't consent for your data to be exposed to attackers. You don't consent for your data to be processed in any way other than you consented to.
You don't consent for it to be used in pre-production. You don't consent for it to be shared with third parties. But the unlawful selling on of that information to other providers so that it can be exploited. For commercial gain is in itself a data breach.
Absolutely. And that's exactly what the ICO found. So that's an interesting example. I'm glad the ICO are aligned with me.
It's not going to stop me sharing all of your personal information with every company I can find. At Red G underscore Chris. Exactly. The third interesting news article I thought I'd find.
Gosh, this just goes on and on. This is a fairly small one. But it's fairly interesting. Yahoo have put aside 90 million pounds of funds, specifically an anticipation of upcoming lawsuits against them for data breaches between the years of 2013 and 2016.
Yahoo. Exactly. Yahoo. Hey, that was awful.
I think that's interesting. Why have they done that though? Well Yahoo, data breach. Yes.
That was big news. Ongoing lawsuits. It's ongoing. This isn't one lawsuit.
This is expectation of lots of people going to see this. A class action lawsuit. So 90 million pounds is what they put aside. How much is that dollars?
There's $120 million as a time of quick googling. Well, if anyone can rely on it. That is $125 million as of now. I...
As $124 million. I'm surprised at the irony. Yahoo it instead of googling it. Yes, true.
We shouldn't actually use that as a verb anymore. Maybe we should be binging it instead. Oh. Oh, now we're getting a bit uncomfortable for me.
I'm going to stick to my googling. That's it from me for the news. Have you got any news for us this week, Chris? I have some news.
I'm shocked. It's almost like I asked that question knowing the answer. You're shocked knowing that I have something to say given that I'm such a shy, retiring individual. Yes.
And you told me you had news. I do have news. I promise you are. Yes.
And it's more news of a kind of half amazing news and half personal news. You're brilliant. How did you know? No.
Massive belly. That's the beer. No. In the past couple of weeks, I actually submitted my very first sessions, although I should caveat that, I was actually submitted my first separate solo independent sessions to pass Summit.
Oh. Yeah. In Seattle in 2019, later in 2019. You're going again?
Oh, hopefully. Fingers crossed. Fingers crossed. Yes.
So I can meet some of our wonderful DBL fans and obviously, make fans et cetera in the United States of America. It'd be fantastic. But yeah, I submitted two sessions. The first of those being shift your culture left, actually identifying some of the cultural changes that people need to make to teams, which will enable them to put in place a good DevOps practice, I how culture fits into DevOps.
So very, very interesting there. And also another one, which is of course my obsession, which is data masking. No, which is data masking. And actually how to get started.
How do we figure out what we need to mask and how we're going to mask it? So the first steps to building a masking plan, whether or whether we're using, obviously, Redgate Data Mask of a SQL Server or SQL Provision at wider length, or whether you're looking at the DBA tools masking or even if you're looking at Microsoft's static masking as well. So those were submitted. So fingers crossed.
They get accepted. I haven't heard anything as of recording. They've probably published the list and I've just completely missed out. They threw it out and went, no, this is rubbish.
I'm getting rid of that. But I'm rooting for you. Oh, thanks, Chris. That's one vote.
That leaves me at my end. There's any voting. Oh, that's good. Yeah.
I didn't imagine you would. But speaking of past, there is something really, really interesting that's actually coming up next month that I think is really, really interesting for us to share with the listeners of DBA. Is it really, really interesting? Well, I would say it's really, really interesting if not really, really, really interesting.
How interesting would you say it was on a scale of failure to really? Really? Really, really. Okay, this does sound interesting.
It's pretty interesting. Maybe you should read out your bit of paper. It's true. Hang on, let me rustle it.
So introducing data privacy week, navigating the new world. It is a joint venture, a week of online events between both pass and red gate where we're basically going to be looking at how the shape of how the data privacy landscape has changed over just the last year or so, certainly how it affects data professionals as well. Hey, there's a trust in it. Tell me how it's changed.
Well, no, you're going to have to tune in to find out. Okay, then. Tell me how to tune in to find out. So let me just read you the important bit and this is the bit that will really draw you in, Chris.
So I think it's really important to read this out because it really sums it up nicely and that is from Europe's GDPR launch to updated legislation the world over the global data privacy landscape has seen big changes over the last 12 months, joined red gate and pass for a week of events designed to help SQL server teams navigate this new world. That was some really good reading, that Chris. Thank you. So it will comprise of a bunch of amazing online events such as our kind of the GDPR effect tails from global data privacy and we've actually got some fantastic speakers there such as Kellen, DBA, Kevlar.
We've got Grant Fritchey, Hamish Watson and yours truly. Of course. Then we've got Hal Pass, address their global data privacy concerns. There's also things like the new world of data privacy which will be our kind of key note, the 10 steps you can take to be data compliant worldwide.
And then this will kind of all come to a head and we'll be offering up kind of a fantastic selection of resources to help everyone out there in the community. Now, if you're particularly interested in kind of hearing a bit more about how this has changed, how it's relevant to you, how it's easier location we can find out more information about this. There is Chris. I'm glad you asked.
And knowing how you like it, I'm going to give it to you like that. So, H. That was really bad out of context. HTTP colon forward slash forward slash, www dot red dash gate dot com forward slash data privacy week or one word or you can put a dash between them.
It doesn't matter. We'll go to the same place. All the options. www dot red dash gate dot com forward slash data privacy week.
Was HTTP or HTTPS? I think either. HTTPS probably. We're very secure here at Redgate.
I hope so. I would hope so. So, I think Chris, actually, this has kind of brought us round into a neat little package for this month's DB ale. Do you have anything to add?
No. Although please don't refer to me as your neat little package ever again. And on that note, thank you so much for tuning in, gentlemen. I hope you have a fantastic rest of the month.
We look forward to seeing you at data privacy week. And remember, if you want to get in touch with us, maybe suggest some beers or to... Topics. Or some topics for us to discuss.
Running our ideas. I never have any ideas I rely on, Chris. But if you want to get in touch, remember you can just email us. Or what is probably easier, just send us a tweet.
I'm at redg underscore Chris. I don't know, I have a Twitter account, but... And you're at Kurzwell, Chris? I think so.
Tweet probably me because I will probably see it. But tweet us both or use the hashtag DBAL 2019. And we will incorporate your wonderful suggestions into future DBL episodes. I too hope you have a perfectly pleasant time.
Indeed. Indeed. Thank you very much, Chris. Cheers.