Live Blog Day 3: PASS DATA COMMUNITY SUMMIT
I’m attending the PASS Data Community this week in Seattle and, mainly as a record for myself so I can look back and see how the event has gone, but also to share the experience with others who may be thinking of attending events like this in the future I’m going to try and live blog each day.
If you are going this year, I have a session called “Driven by the 9s” which I’m delivering on Friday. I’m also moderating three sessions throughout the week too. You can read more about the conference this week https://passdatacommunitysummit.com/
Day 3 Summary
With the pre-cons completed, Day 3 is the first full day of the conference proper. If you don’t want to read the whole day, I have decided to include a summary section here
- SQL Server 2022 is now generally available aka.ms/sqlserver2022
- SQL Server Pay-as-you-go licensing model
- Linked feature for Azure SQL Managed Instance
- Backup portability with SQL Server 2022
- Azure Synapse Link for SQL Server – generally available
- PostgreSQL integration to COSMOSDB
- 40% of attendees are first-timers at the summit.
- Key will start at 8 am PST, delivered by Rohan Kumar, CVP of Azure Data at Microsoft.
- I’m Moderating Micheal Johnson’s session “The Accidental Administrator’s Guide to Power BI”
Live Blog Day 3 Wednesday 16th November
Times are shown in GMT and PST (GMT/PST) and reverse chronological order. If you want to read the whole day, start at the bottom and read up.
We went offline for for while after the key note. I did manage to take in Brent Ozar’s session on parallel query plans in SQL. I have just finished moderating Micheal Johnson’s session “The Accidental Administrator’s Guide to Power BI” which I thought was excellent. All in all a good day. Signing off now, going to a drinks reception and then some sleep. I’ll be back tomorrow for day 4
17:30/09:30
That’s the keynote done. People are heading off to sessions. I’m going to get a coffee.
17:13/09:13 Rohan Talking about community
And sharing Hugo’s story. A very heart video was played about Hugo Kornelius and his battle AML (Cancer). #TeamHugo you can read more about Hugo’s story here aka.ms/teamhugo
Demo: Azure Synapse Link + Power BI + Microsoft Purview
Patrick showing some cool stuff if Power BI and the combination of the above technologies.
17:13/09:13 Governance
Governance will be very important for businesses looking to become “data-driven”. Cue Microsoft Purview and some of the new features coming in Purview too
17:13/09:13 Analytics Time
Lots of interesting announcements in the data lakehouse space.
17:09/09:00 COSMOSDB
And ProgreSQL, Azure Synapse Link for SQL Server is generally available
17:00/09:00 Rohan back on
Talking about the best place to run your SQL Server workloads. SQL + Apps Migration Factory Offer
16:50/08:50 Bob and Conor on next
Talking performance enhancements. What is the right Degree of Parallelism (DOP) to use for a query? SQL Server 2022 will attempt to set it on the fly. Interesting stuff coming on lock escalation too. Lindsey also came on.
16:50/08:50 Rohan back on stage
With a customer case study from Mediterranean Shipping Company
16:41/08:41 Bob and Anna on stage
Showing off some of the new features, Lots of banter but mixed with some serious business, too, including Purview integration. Pay-as-you-go billing and license. Showing Managed Instance Link. Showing the failover and fallback features too.
16:39/08:39 SQL Server Pay as-you-go licensing model
Which can be applied to your on-premises SQL Server too.
16:39/08:39 SQL Server 2022
Discussing different organisations and their ability or inability to migrate to the cloud. Different businesses and organisations face different challenges
16:35/08:35 SQL Server 2022
Rohan is talking about SQL Ledger and the new security features. SQL Server 2022 is very closely linked to SQL Server Manage Instance in Azure. Synapse Links and Purview integration being talked about. Azure AD integration is built-in to SQL Server 2022.
16:31/08:31 SQL Server 2022
Talking about the different deployment options you have for SQL Server. Looking back at different SQL Server releases. SQL Server 2022 is Generally Available.
16:30/08:30 Microsoft 365 Dynamics 365 and the Power PLatform
Are all built on top of the Microsoft Intelligent Data Platform
16:22/08:22 Data Challenges
In a data-driven world, there are lots of challenges facing data professionals. More chat about the Microsoft Intelligent Data Platform. Analytics need to be a core part of the product experience. Talking about Synapse Link now. Governance is next. Data governance is much more than creating a catalogue. The volume of data is something that needs to be considered. Asynchronous governance can be a problem. scanning twice a day can leave several hours where you are not compliant.
16:20 /08:20 Rohan Kumar is now on the stage
Rohan is now on the stage with a very big welcome from the crowd. Discussing how the pandemic has changed organisations’ work and the PASS summit is no different.
16:15/08:15 Rohan Kumar is on the stage
Oh no, he’s running late…
16:15/08:15 Shout to the sponsors
Shout out to the sponsors. Thank you for supporting the event.
16:09/08:09 The lights have gone down
We might be about to start. For the first time in three years. 40% of attendees are first-timers at the summit. It’s also hybrid, so people are attending online too. 377 speakers delivering sessions this week.
16:00/08:00 – The crowds are gathering
I’m joined by Martin Catherall, who is also blogging, and the room is filling up.
15:30/07:30 Keynote room
So I’m set up in the keynote room, and rehearsals are underway…We’ll be starting soon 
14:22/06:22 Let the show begin
Right, I think it’s time to get ready for the day.
13:00/05:00 Early Start
Today I’m volunteering as a volunteer blogger for the keynote speech and I’m moderating a session later in the day.
The keynote today starts at 8am, the abstract is taken from the conference website
Join Microsoft’s Rohan Kumar and senior Microsoft engineering leaders for a keynote delivered live from Seattle. We’ll showcase how Microsoft’s Intelligent Data Platform, including databases, analytics, and governance can seamlessly integrate to transform your data estate.
Rohan is the Corporate Vice President, of Azure Data at Microsoft. So I think we are excited to hear what Rohan has to say.
Later in the day, I am moderating a session for my good friend Micheal Johnson. Michael is delivering his at 2:30 PM – 3:45 PM PST (10:30 PM – 11:45 PM GMT) in Tahoma 5 room. The talk is titled “The Accidental Administrator’s Guide to Power BI”
09:30/01:30 – Jet is lagging around
So for the second day, I am awake early. I did manage to go to bed a little later yesterday. I’m still up early. I did manage to go back to sleep.
Useful Links
You might be interested in the following links including some of the new SQL Sever 2022 documentation and links:
- SQL Server 2022 is no generally available aka.ms/sqlserver2022
- Get SQL Server 2022 SQL Server 2022 aka.ms/getsqlserver2022
- Decks for SQL Server 2022 2 aka.ms/sqlserver2022decks
- Docs for SQL Server 2022 aka.ms/sqlserver2022docs
0 Comments