I caught this post about a career presentation from Kendra Little and it resonated a bit with me. The summary of the post (it's a bit long) is that there is valuable work that supports and benefits a team of people, called glue work. However, glue work isn't necessarily technical and it isn't necessarily recognized as valuable by management. In fact, it might unintentionally lead you from a career in engineering to one in project management. I haven't been someone who has been marginalized in po...
Jan 08, 2025•3 min•Season 11Ep. 3
For the last few years, we've seen no shortage of cloud migration stories and felt pressure from management who wanted to migrate our systems to the cloud. It seems that almost everyone I speak to has a story of having to move a system out of their owned or leased data center into a public cloud from some vendor. A lot of this is the movement of VMs from one place to another, which has me scratching my head. If we're just running VMs, surely we can do this cheaper in our own data center. Perhaps...
Jan 06, 2025•3 min•Season 11Ep. 2
Read the rest of The Learning Plan for 2025
Jan 03, 2025•4 min•Season 11Ep. 1
I was chatting with a friend recently about routines and some of the helpful or silly things we do. I mentioned that when I played adult baseball, we often had Sunday morning games and a routine of mine was to drive to town, stop at a 7-11, and get a large cup of coffee and an apple fritter. It was a comforting habit that I still have today, often stopping when I have a morning flight to do the same thing in the way to the airport. Only in Denver though, not when I'm flying out of other cities a...
Dec 20, 2024•3 min•Season 10Ep. 121
I went to San Francisco for Small Data SF , a conference sponsored by Mother Duck. The premise of the event was that smaller sets of data are both very useful and prevalent. The manifesto speaks to me, as I am a big fan of smaller sets of data for sure. I also think that most of the time we can use less data than we think we need, especially when it's recent data. That often is more relevant and we end up with contorted queries that try to weight new or old data differently to reflect this. Mayb...
Dec 18, 2024•3 min•Season 10Ep. 122
When I was younger, I had a variety of jobs, but in most of the positions I had to work hard for stretches. Really hard, as in more than 8 hours a day or 40 hours a week. Often as I was starting a new position, it took some time for me to develop some understanding, some skill, and some muscle memory. In some jobs, especially in restaurants, I also had to build the physical skills to be on my feet for many hours. In technology, I've often found myself unsure of how to approach a new position, aw...
Dec 16, 2024•4 min•Season 10Ep. 125
I was asked this question recently: is it more likely that AI will replace humans or assist them in their work? It's a good question. If you think about the way AI is being hyped in 2024, many people think AI is, or will soon be, replacing people and we need less of them in work. I guess the simplified view is that AI can do the jobs of many people, but I'm not sure the world is that simple. What I think is more likely is that AI becomes a lever that assists a few people in getting more work don...
Dec 13, 2024•4 min•Season 10Ep. 119
It seems there's quite a dichotomy in the technology workforce. On one hand I hear about the Great Resignation where many employees are leaving their jobs because of RTO (return to office) mandates or some other dissatisfaction with their job. On the other, I've seen quite a few people who were laid off and are struggling to find new positions. On the third hand, there is no shortage of companies who report they are struggling to find and hire talented people for some positions. I don't quite kn...
Dec 11, 2024•3 min•Season 10Ep. 124
I was listening to someone at Microsoft talk about their product recently. I can't disclose which one it was, but lots of people use this product and are impacted by changes. The particular thing that caught my attention was that the presenter noted there was a breaking change in the new version for some people. This wasn't a huge change or one that would affect a lot of people, but it was a breaking change for a few. Another attendee asked this question: I would tend to do xxx instead of what y...
Dec 09, 2024•3 min•Season 10Ep. 123
I was watching a video called Microservices are Technical Debt . In it, the person being interviewed said that a lot of people really have a distributed monolith. That caught my eye since I've worked with a number of customers who are trying to adopt microservice architectures for their applications. I think this is less a performance/scaling choice than a reworking of their software development teams, and I'm not sure they will end up with a better system. What is a distributed monolith ? I am ...
Dec 06, 2024•3 min•Season 10Ep. 120
There are lots of software development methodologies. This page lists a few, among them waterfall, agile, iterative, rapid, and more. What's been interesting to me is that the process of deciding what to code and then whether it works doesn't change much between different ways of building software. Instead, the cycle time between when we ask a client what to do and when we deliver it changes. The more agile/lean we are, the lower the cycle time. The more waterfall-ish, the larger the cycle time....
Dec 04, 2024•4 min•Season 10Ep. 118
I've been very pleased with the direction of SSMS the last few years. As it's been separated from SQL Server releases and gets updated more often, I think the changes from v17 though v20 have been improvements. There are still issues, but it's been better. Now we finally have SSMS moving to a modern shell with the v21 preview and I'm excited to see how this changes the future of our tooling. However, the PM for SSMS, Erin Stellato, posted a note on LinkedIn recently asking why people don't read ...
Dec 02, 2024•3 min•Season 10Ep. 117
Thanksgiving is tomorrow in the US and it is supposed to be a holiday when we give thanks for our blessings in life. My wife usually has everyone in our family tell what they are thankful for this year. I also see many people posting things they are grateful for during the month of December. Last month I was lucky enough to have dinner with Bob Ward and we were talking about some of the things we'd seen in travels, often some stressful times for ourselves or others. We've seen many people get up...
Nov 27, 2024•2 min•Season 10Ep. 116
I was a bit of a math nerd in high school and college. Some of you might have been as well, but I took advanced math all through high school, culminating with AP Calculus as a senior with 11 other kids (of about 320). In college, I started with Calculus III freshman year and went on to take 7 more semesters of various high level maths. One of those classes included analyzing data with linear regression, which we did with hand calculators and formulae. At SQL Saturday Pittsburgh 2024 , I watched ...
Nov 25, 2024•4 min•Season 10Ep. 115
Read the rest of New SQL Server 2022 Functions
Nov 22, 2024•3 min•Season 10Ep. 114
In most of the organizations I've worked for or consulted with, patching was always a challenge. Patching hasn't usually been given a priority and is often skipped when operations staff is busy. This has resulted in lots of un-patched, or slowly patched systems. I assume this is one reason Microsoft continues to release RTM-GDR patches because some people won't patch at all unless there are critical fixes. I also know that much of IT management sees patching systems like patching parking lots. N...
Nov 18, 2024•3 min•Season 10Ep. 113
Microsoft constantly releases new features and products in the data platform space. Many of us have seen the SQL Server product grow in new ways, some of which are very useful to us. As an example the changes from log shipping to clustering to Availability Groups has improved our HA/DR options as well as the capabilities available to us in different situations. With that in mind, I saw someone recently that wanted to deploy SQL Server on Kubernetes, which is something that could be a very intere...
Nov 15, 2024•4 min•Season 10Ep. 112
Recently I was watching a presentation on how to scale performance in your SQL Server environment and one of the suggestions was setting up Availability Groups (AGs) and having read-intent connections that would query the secondary and not the primary. It's not a bad idea, and the SQL Native Client (and other drivers) support this and make it easy to implement. The pattern of using multiple connections in an application, one for reads and one for writes, has been suggested often. However, in pra...
Nov 13, 2024•3 min•Season 10Ep. 111
I assume most of you work with others in a team. Even if you are the data specialist and others work on different technologies, you still have a team. How long has your current team been together in this form? Have you had a stable team that might have grown, but the rest of the individuals and roles/responsibilities stay the same? Or has your team changed makeup, roles, responsibilities, or something else? I don't see a lot of organizations that change their team structures often. There may be ...
Nov 10, 2024•3 min•Season 10Ep. 110
Recently I had a friend traveling who is not very tech savvy. This person has traveled before and has a routine, but in this case, they were struggling to get an airline's mobile app to work. They also struggled with the website, and just before the trip, they were thinking to cancel because they didn't have a ticket in their hand before driving to the airport. This turned out to be a login issue, and between friends and the airline's customer service, they were able to print out a ticket at hom...
Nov 07, 2024•4 min•Season 10Ep. 109
Today is the first day at the PASS Data Community Summit and I'm in Seattle where I'll get to open the conference and introduce the Microsoft keynote. I'm sure the keynote will be full of announcements on something, but what? I'm writing this a little over a week before the event, and I have no idea what Microsoft will do. Actually, by the time you read this I may have some ideas as there was a practice session yesterday, but I can't tell you anything. NDA, and really, by the time I got somethin...
Nov 05, 2024•3 min•Season 10Ep. 108
For a long time I've felt that my recommendation for people wanting to enter technology wasn't to go to college and get a degree, but rather start to learn on your own and get an entry level job (help desk, tech support, etc.) and start to work in the industry. That's a good way to both experiment and understand what you're considering undertaking as a career, as well as limiting your investment. It's also nice to get paid to learn something. College is great, but it's also expensive. I find tha...
Oct 31, 2024•3 min•Season 10Ep. 107
Your management gets a great demo from a cloud vendor and decides that the organization needs to implement the new service/application/etc. quickly. Your team tries to comply, furiously learning and experimenting with integrations, software changes, infrastructure configuration, and more. Things get deployed are working. Clients and management are happy with the new capabilities and you breathe a sigh of relief. After a bit of time there's a security issue and all of a sudden there's blame pouri...
Oct 29, 2024•4 min•Season 10Ep. 106
There's an article at Forbes about the Five Things Business Leaders Should Know about Databases . Disclosure, it's by my boss, but I think it's still a good read. These are points we've learned from research and work with customers and prospects at Redgate Software. These points come from you, as well as from executives with whom we work, but there are so many people in organizations who don't think about the complexity of data, so it's a good one to pass along. The five things are (if you don't...
Oct 27, 2024•3 min•Season 10Ep. 105
For much of my career as a younger person, I was mostly concerned with salary at a job, along with the opportunities for my career. I really wanted to know how much money would hit my bank account and cared most about that. I also wanted to know if I would learn something or get a better title or work with a technology that might help me in the future. That drove me through quite a few jobs in my 20s and 30s, leaving some for more money and more opportunity. As I got a family, I became more conc...
Oct 24, 2024•4 min•Season 10Ep. 104
I own a Tesla, which is essentially a computer on wheels. Much of the way the car works is driven by software, which I love. New features have appeared and minor fixes come through in the same way that they do for apps on my mobile device. It can be annoying to wait for an update to install, which has happened when my wife or I start the update remotely and don't realize the other is planning on driving. Fortunately, I can set these to run overnight from my phone and they mostly disappear into t...
Oct 22, 2024•3 min•Season 10Ep. 103
My wife and I have been thinking about some new audio equipment. We've been a little unhappy with our Bose soundbar because of the software flakiness and sporadic network connectivity issues. In looking around, I saw a Sonos product, but after reading a bit about the company's recent history, I decided to look elsewhere. Sidebar: if any of you have recommendations that aren't high-end $$$$ audio, let me know. Read the rest of Tech Debt Perils...
Oct 20, 2024•3 min•Season 10Ep. 102
At the Small Data conference recently, one of the talks looked at hardware advances. It was interesting to see a data perspective on hardware changes, as many of us only worry about the results of hardware: can I get my data quickly? In or out, most of us are more often worried about performance than specs. However, today I thought it might be fun to look at a few changes and numbers to get an idea of how our hardware has changed, in the march towards dealing with more and more data. Big data an...
Oct 17, 2024•6 min•Season 10Ep. 101
These days algorithms rule much of the world. From how supply chains are managed to how vehicles run their engines to the media that many of us watch on the various streaming services. I assume that most of you know that algorithms drive what you see on social media, on YouTube, and even the search results you get, and what you see might be different than what I see. There is a constant search for a perfect, or at least, very targeted way of getting you what you want. Or at least what the algori...
Oct 15, 2024•4 min•Season 10Ep. 100
I'm hosting a webinar tomorrow with this same title: The Role of Databases in the Era of AI. Click the link to register and you'll get some other perspectives from Microsoft and Rie Merritt. However, I think this is an interesting topic and decided to try and synthesize some thoughts into an editorial today, partially to prep for tomorrow and partly because I'm fascinated by AI and how it will be used in the future. Read the rest of The Role of Databases in the Era of AI...
Oct 13, 2024•4 min•Season 10Ep. 99
