loader from loading.io

Summit Reflections

Voice of the DBA

Release Date: 11/16/2021

Teams Security Issues show art Teams Security Issues

Voice of the DBA

At some point during my career sharing files and links in email became a security concern. There were all sorts of malware problems and issues that spread throughout organizations because someone unknowingly clicked on or forwarded a malicious item. At a couple of large organizations, we had to turn off email for days while we cleaned out systems. Fortunately, antivirus and other types of scanning software improved to prevent most of these problems. It seems that not all developers learned the lessons of the past. inside it based on link sharing in the chats. One of the issues is that the...

info_outline
A New Language show art A New Language

Voice of the DBA

In my life, I've mostly dealt with people that speak English. I tried Latin in high school and Japanese in university, but I wouldn't say I learned a lot. This past year I've been working on Japanese (konichi wa) and French (Bonjour) on a regular basis, but I'm still fairly uni-lingual. At least compared to many of the people I've met in my travels that speak multiple languages. I'm mostly just trying to read a bit, and that's quite hard. In my career, I haven't met many technologists that only know one programming language. Even the SQL professionals know a little C# or a scripting language....

info_outline
Coding for the Future show art Coding for the Future

Voice of the DBA

about some code. In this case, it was the start of a for loop, but with two things in it that I didn't like. The code is shown here: for ($i = 2011; <= 2021; ++) { Both the starting point and the ending condition were problematic for me. This code is used in a scheduling application, to populate a dropdown that I used regularly. It's always worked, since about 2017 or 2018, and I had no reason to even think about the algorithm. I assumed the code was something like this: Read the rest of

info_outline
What Were Your 2021 Wins show art What Were Your 2021 Wins

Voice of the DBA

sent me a prompt just before Christmas that asked me to write a post on my 2021 wins, using the #2021wins hashtag. I thought it was a neat idea, and before I left for my final vacation. I primarily had work items in there, though a couple of work-related things. To me, while 2021 was disappointing in some ways, it was still a great year for me in many ways, and I've tried to keep that in mind. Not focus on things that didn't go well but those that did. It's the first week of the new year, and many of you are likely starting to look forward at work and in your career. You might have made...

info_outline
Challenging Trends show art Challenging Trends

Voice of the DBA

I was studying for the DP-900 exam recently and in one of the Microsoft resources, I ran across this quote: "Historical data is equally important, to give a business a more stabilized view of trends in performance." This was in context of looking at database performance, but it would apply to any part of your business. The world has changed dramatically in the last two years. In early 2020, at this point, I was finalizing work and from work. I managed to get the last sabbatical before the world shut down and most people didn't see the value of one during a pandemic. I returned from...

info_outline
Data Cleanup show art Data Cleanup

Voice of the DBA

The end of the year is when I do a little data cleanup. Not a lot, but some. Work slows down, with no major deadlines, so I'm able to spend a bit of time organizing myself. I usually go through my downloads and documents folders, deleting files I don't expect to use. I ensure that my jobs removing older log and temp files are running, especially on the laptops. A lot of disuse in 2021 had a few of them filling disks with more files than I had expected. In a few positions I've had as a DBA, this was a time when we'd look to archive away some older databases, and even some data. It was rare, but...

info_outline
Looking Back at 2021 show art Looking Back at 2021

Voice of the DBA

Today is my last day of work for 2021. I'm off to a family vacation for the rest of the week to enjoy time together and celebrate the New Year. I wanted to take a look back at the year before I leave and give you a few thoughts on various data-related topics. The big news for those Microsoft data platform people is that SQL Server 2022 is coming. No idea when, and without public CTPs, I think it might be a 2022 H2 release, but Microsoft committed to the naming. There have been a number of talks, at Ignite, the PASS Data Community Summit, and the SQL Server and Azure SQL Conference. I had the...

info_outline
Wellness Week show art Wellness Week

Voice of the DBA

I work for a great company, one that I feel cares about me as more than a "resource", gives me opportunities (with responsibility and accountability), and has some nice benefits. I actually used one of those last week. I get a volunteer day every year, where I can spend time with a charity and get the day off. I used mine to volunteer for . During the last two years, Redgate has approached the pandemic and remote work with the idea that we need to be reasonable with each other. We need to understand that some employees might have more people in their homes during work hours and may need to...

info_outline
The Challenge of Edge Security show art The Challenge of Edge Security

Voice of the DBA

We know that our organizations will adopt and use more devices over time. Given the growth of cheap computing, frameworks for managing devices, and the desire for more data, I expect some of those devices will collect data, or even contain databases. use is growing, and we will see more devices that contain it (or another database platform), which means we have a larger attack surface area for that data. There was a recent report on a vulnerability in edge devices used by AT&T that was detected as part of an attack. The attack used a known vulnerability based on default credentials. The...

info_outline
The Tech of My Youth show art The Tech of My Youth

Voice of the DBA

I saw a note recently that .  There was a time I had a number of Panasonic products, from music players to telephones. My wife had them as a client and got a few swag items in the early 2000s. However, I don't often buy electronic appliances, and I haven't seen the Panasonic brand name in some time. As I approach the end of one year and the beginning of another, I find myself nostalgic for brands that I used to seek out. I read a biography of , founder of Sony a long time ago and I admired their products. At some point, I had a rack of Sony gear in high school, including the double...

info_outline
 
More Episodes

This is the second year that the annual PASS Data Community Summit has been virtual. Last year, as a pandemic gripped the world, I thought we might never see another one. I'm glad we have one this year, and I look forward to going back to a live, in-person Summit in 2022. That being said, this year's event has been better than I expected in many ways, mostly because of spatial.chat.

I can remember walking through the hallway of the Washington State Convention center and seeing Taiob Ali coming the other way. We stepped to the side of the hallway and had a chat among hundreds of people walking by. I thought about that in the Community Zone when he and I, with a couple others, were talking with each other in a group, away from others that were also in the room. We could see their avatars, but we were far enough away in the virtual space that our conversation didn't upset others.

Read the rest of Summit Reflections