Voice of the DBA

Tag: syndicated

  • SQL Server Engineering in Austin

    I was lucky enough to attend SQL Saturday Austin 2025 a little over a week ago in conjunction with some work at the Redgate office. The opening keynote at the event was given by Conor Cunningham, who is an architect at Microsoft and runs the engineering team in Austin for the Data Platform. His talk was very interesting and engaging. This was about half the room below.

    20250503_090655

    I’ll describe the talk, which was great, but I’m probably mis-stating something. Keep in mind I’m writing this a few days later from memory.

    One of the interesting things Conor talked about was the engineering process in Redmond. The main thrust was that they work in 6 month planning cycles. Work gets submitted, voted on, works through groups, and as a result, most of the things approved are related to more revenue in some way.

    Good for Microsoft, not something many of us love.

    In Austin, they tackled things differently. You can see the outline in the image below. Conor hired a few engineers here, usually out of college, and they work on new features. Things that are too small to make the list in Redmond, but this also helps grow/train engineers on how to write production quality code.

    20250503_091036

    What do they work on? He had a few slides, but IS [NOT[ DISTICNT was one. He described this a bit, but the cool thing was a bunch of the SQL 2022 features were from Austin. String_Split with the ordinal, the bit functions, and a bunch more.

    20250503_091842

    Basically all the cool features I appreciated, including DATETRUNC, came from this small team. I am very glad they exist.

    He also delved into the challenges of doing remote work. Building SQL Server is a non trivial procss, and they’ve been working to try and make this easier. They refactor code, they try to break things out so engineers can get quicker feedback, write more tests, etc. to make their software engineering easier.

    20250503_094728

    He also talked about their work with hardware manufacturers and some of the optimizations he’s done with CPU and the ATX instructions to make SQL Server a little faster. For some types of queries, they’ve great improved the speed of internal SQL Server processing.

    It was a great talk and quite entertaining. Hopefully some of you will see it elsewhere, or he’ll do it again in Austin and you can come.

     

  • A New Word: Lookaback

    lookaback– n.  the chock of meeting back up with someone and learning that your mental image of them had fallen wildly out of date – having grown up or gotten old, fallen apart, or pulled themselves together – which shakes your faith in the accuracy of the social puppet show that runs continuously inside your head.

    Most of the time I’ve run into someone after time away, they are similar to what I expect. They’re older, or they’re heavier (as am I) or something, but it’s within the realm of what you might expect after the length of time.

    I had lookaback a few times in the last few years, though and it’s a bit jarring. I had someone I knew that went through a rough stretch and they had gained a lot of weight. Like 150lbs more than when I saw them. More than the weight, however, their outlook on life, being a bit depressed and without a light in their eyes was a lookaback shock.

    I have lookaback at times with kids I’ve coached, where I see them years later as young adults and I keep this image of a 12 or 13 year old that is now in their twenties, more mature, and much more grown up. It’s a contradiction in my head, as I still keep a glimpse of that younger person.

    Lookaback can be positive or negative, and I keep hoping when it happens it’s a positive experience.

    From the Dictionary of Obscure Sorrows

  • Speaking at the NYC Lunch and Learn–May 23

    In a couple of weeks, I’ll be in New York City for the Redgate DevOps Devour Hour Lunch and Learn. This is at the Industrious office at 730 3rd Avenue, which is a neat location near the tip of Manhattan.

    This is a half day event, from 12-430, with a short happy hour afterwards. I’ll be there, along with Kendra Little and Erik Darling, talking a variety of different topics.

    • The SQL Server Performance Tasting Menu – Erik
    • A Tale of Two Clouds: What I Learned from Migrating from Azure SQL MI to Amazon RDS for SQL Server – Kendra
    • Designing Zero Downtime Database Deployments – me

    I’m excited to head back to NYC, which is always a fun trip for me. Even more exciting, Erik and Kendra are people who always get me to think with their views of how to work with databases effectively.

    My session will be a mix of tech demos and tips/tricks on how to better make changes to your database systems without interrupting customers.

    You can register today and I’ll see you in a few weeks.

  • SQL Saturday New York City 2025 is Back!

    After missing last year, SQL Saturday New York City is back in 2025. I’m excited to go to the event and honored to speak there. I love visiting New York and I’m looking forward to the trip, as is Mrs Way0utwest, who is coming along for a little vacation. Hopefully we’ll find a fun show to see Saturday night.

    There is a precon this year from Andreas Wolter, longtime SQL Server Program Manager  at Microsoft. It’s on practical performance tuning and troubleshooting, and you can register and attend on Friday.

    Saturday has a great schedule the includes a wide variety of topics. Data virtualization, Power BI, development in a 24/7 environment, Cost optimization, and of course, a lot of Fabric. I’ll be talking about the Data API Builder, which is a cool piece of tech to quickly get those CRUD apps going.

    Pass the word, and come into the city on May 11 for a fun event. Register today and I’ll see you later this week.