Voice of the DBA

Category: Editorial

  • How Did I Do?

    I made a number of predictions for the opening keynote at the PASS Summit. I wrote the predictions a week before the event, making my own guesses about what might be revealed. I was busy in pre-conference sessions on Monday and Tuesday, so I had to write something well in advance of the event. I was flying home yesterday, so I had no chance to watch the keynote until later, so this is a look back after catching up Wednesday evening at home.

    How did I do?

    With the Ignite conference taking place this week, I had guessed that SQL Server 2019 would release there and then be a part of the Summit keynote. I was right. On Monday, as I was taking a break during the SQL in the City Summit, I saw that SQL Server 2019 had been released. A milestone, and perhaps one that I think changes the data platform. It’s an inflection point, and I agree with this tweet from Distinguished Engineer, Slava Oks. Rohan Kumar did announce it at PASS as well, so maybe half credit here?

    I didn’t mention Hyperscale yesterday, as I wasn’t sure what I knew as NDA and what was possible. The demonstration of Azure Arc, and Hyperscale for PostgreSQL, is pretty cool. While I used to think Hyperscale was only for the largest of the large databases, I now think that many smaller, 2-4TB systems (I can’t believe I think of that as small), might consider moving to Hyperscale and preparing for future growth into the low single digits of TBs. BTW, Azure Arc is amazing. I knew about it previously, but didn’t expect it this year. I did mention Azure Stack deploying on premise, and I think the Azure Arc covers this, so 1 1/2 right.

    Azure Synapse was something I didn’t expect. I have been looking at Big Data Clusters as a game changer with the relational platform. Synapse combines the Azure SQL Data Warehouse and Data Lakes into a platform. Since these were both the places where we first got compute separated from storage, this makes sense. Both of these platforms seemed similar to me, so combining them and letting customers drop structured and unstructured data.

    The Edge is a bigger deal than I thought. This was mentioned as a private preview during Build, and I should have guessed this would move to public preview. This as one of those areas that I haven’t been as focused on and wasn’t sure about information I’ve gotten under NDA, so I didn’t include this. Certainly a miss here, but I do think the demo in the keynote with Zeiss and making decisions from sensor data is something more organizations will do. Sensors generate too much data and trying to move all that across a network to the cloud doesn’t make sense. Train models and let some low power SQL Server Edge engine make a few decisions without moving data.

    There was more in the keynote, and it’s worth watching. If nothing else, I think both the opening Ignite keynote and the opening Summit keynote are inspiring for us as data professionals. You can dream about possibilities and truly see that data is an important asset that Microsoft is empowering us to make better decisions about based on analytics.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.

  • Republish: Logging Tables

    My second pre-con at the PASS Summit, so I’m re-running Logging Tables. Tomorrow, I’ll be back.

  • Republish: Custom Schemas

    Pre-con one at the PASS Summit. A busy day for me, so I’m re-running Custom Schemas

  • A Mindset Shift

    I’ve been working with people at Microsoft for nearly two decades in different circumstances. It’s been interesting to me to work with developers, Microsoft consultants, and community people across the lifetime of SQLServerCentral, especially the last 5 years. For a long time, I never wanted to work there, but I’ve started to think I might find it to be an interesting company in the last couple years.

    There are two good articles that talk about the ways that Microsoft has changed. The first is from the high level culture perspective and tries to explain how the mindset has changed. If I hadn’t been witness to it, I wouldn’t believe it. These changes really happened, and they were amazing to me. I’ve been going to Redmond for 15 years, often working with a couple groups and since Satya Nadella took over, I’ve seen these changes get implemented. I’ve watched teams grow and change, and learn to re-frame the way they look at their work. I think it’s been a change for the better.

    The second one is a little more technically detailed, and perhaps more interesting to anyone that would like to get their organization to adopt DevOps. There are some specifics with tools, but really read about the mindset changes and the feedback they use to improve software. I think too many managers think automation and features are all you need to implement and forget that quality, experimentation and learning are keys to this working well. Make sure you point those out to managers if you pass this along.

    Not everyone at Microsoft made the transition. Some left, some were probably asked to leave. New people came, but plenty adapted, altered their mindset, and have bought into the way that the company has evolved. They’ve certainly gone from a company I wouldn’t want to work for because of the stacked ranking and competition to an organization I’d now consider employment within. That’s if they want someone remote in Denver.

    I’m proud that Redgate is also moving in this type of direction. We’ve learned a lot from DevOp and we’re learning that culture is important. We hire those that work well with us and help us build better tools for software developers in a team culture. Those that don’t want to work with a team, work in a DevOps flow, and be accountable for their autonomy will probably move on. That’s fine. We’re learning who we are and implementing that into our staff. I’ve tried to do the same in my life, know who I am and be that. I hope you can do the same.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.