<\/p>\n\n\n\n
There was a mention of Git integration that slipped by too quickly to digest\u2026 Perhaps there will be more to see in this space soon\u2026<\/p>\n\n\n\n
Erin demonstrated the capacity to have your query tabs in SSMS in a location that suits you with many options to choose from (top, side, etc).<\/p>\n\n\n\n
Vertical tabs is what Erin landed on (and that look really cool, honestly!)<\/p>\n\n\n\n
Anna must have been up for the challenge today, or perhaps had a few extra quad shot espressos and utters, “you’re going down!” <\/p>\n\n\n\n
Erin next showcases the new Copilot capabilities by asking Copilot:<\/p>\n\n\n\n
\u201cWhat do I need to consider if I change the Compat Mode?” <\/p>\n\n\n\n
Copilot pulls together some of the common things to consider before making changes to compat level.<\/p>\n\n\n\n
Erin points out that \u201cI’m not going to change it in Production…\u201d <\/p>\n\n\n\n
She\u2019s going to \u201cSave to Markdown file\u201d so that she can have her team review the detail and talk about next steps <\/p>\n\n\n\n
Anna – “Let’s GO!”<\/p>\n\n\n\n
In haste, Bob, comments that Copilot could possible know about Virtual Log Files (VLFs) and Erin is quick to make Bob eat his words. \u201cIt absolutely knows virtual log files…\u201d<\/p>\n\n\n\n
Erin\u2019s prompt is \u201c\u201d and Copilot once again comes through and produces the output showing the number and size of the VLFs as included in the DMV.<\/p>\n\n\n\n
But wait, there was a disruption that mimics an alien abduction\u2026 the lights flicker and sudden the projector resets and SSMS in now displaying Dark Mode!<\/p>\n\n\n\n<\/p>\n\n\n\n
I unison, Anna and Erin resound, “we have dark mode”<\/strong><\/p>\n\n\n\n<\/p>\n\n\n\n
Shireesh Thota (Corporate Vice President, Azure Databases, Microsoft) takes the stage.<\/em><\/p>\n\n\n\nShireesh once again decides on the winner and\u2026 Surprise, surprise, Bob once again came up short against his nimble opponents.<\/p>\n\n\n\n
Bob gets a consolation prize, and the show goes on\u2026<\/p>\n\n\n\n
Every except for Shireesh Thota (Corporate Vice President, Azure Databases, Microsoft ) leaves the stage.<\/em><\/p>\n\n\n\nSQL Server enabled by Azure Arc<\/h3>\n\n\n\n<\/p>\n\n\n\n
Shireesh shares details some of the things that Azure Arc can do for us. Including managing your SQL estate with improved observability, enhanced business continuity and governess. Also includes the ability to use defender and EntraID for on prem servers.<\/p>\n\n\n\n
SQL Server Managed Instance improvements<\/h2>\n\n\n\n Gives you:<\/p>\n\n\n
\n
\n32 tb \/ 500\u00a0dbs\u00a0<\/li>\n\n\n\n Lower storage latency\u00a0<\/li>\n\n\n\n Improved storage perf\u00a0<\/li>\n<\/ul>\n<\/div>\n\n\n Build new AI dev\/apps <\/h2>\n\n\n\n Vector search capabilities in CosmosDB<\/p>\n\n\n\n
<\/p>\n\n\n\n
Azure databases for building in the cloud What are we doing in our database platforms and databases for building applications. <\/p>\n\n\n\n
13 million database in azure (8:50 AM)<\/p>\n\n\n\n
Azure SQL DB<\/h2>\n\n\n\nVarious Announcements<\/h3>\n\n\n\n
\nAnnouncement GA – SQL DB serverless auto-pause delay to 15 minutes<\/li>\n\n\n\n Native JSON type & aggregations in SQL DB<\/li>\n\n\n\n Preview \u2013 Data virtualization in SQL DB<\/li>\n\n\n\n Preview \u2013 SDK-style SQL Projects in VS<\/li>\n<\/ul>\n<\/div>\n\n\nHyper Scale Elastic Pools is also now Generally Available, providing for better performance at a lower cost as show by the sticker price in the following 2 slides:<\/p>\n\n\n\n<\/p>\n\n\n\n<\/p>\n\n\n\n
Native vector (type and functions) Muazma & Davide Demo<\/h3>\n\n\n\n Muazma and Davide were invited on staged to show how developers can use the new vector types and functions in to build intelligent applications.<\/p>\n\n\n\n
Muazma Zahid (Principal PM Manager, Microsoft) and Davide Mauri (Principal Product Manager – Azure SQL DB) come out on stage.<\/em><\/p>\n\n\n\nThe scenario that unfold is Davide is working with Contoso Insurance to build them a chatbot so that agents can more naturally explore the data about the customers through chatting with the bot to keep the customers happy and loyal. Davide emulate the agent asking about a customer he is about to meet with and the bot responds based on Davide\u2019s access, of course protected with Row Level Security (RLS) adn Data Masking to show the agent only <\/strong>information about the customers that he is allowed to see and only those customers assigned to him.<\/p>\n\n\n\nThe bot is answering by gathering data behind the scenes using SQL again the structured data. Davide asks the about about the fact that the solution is using Operational RAG where data is inserted into the SQL database as transactions as processed and are available to the chatbot to answer queries.<\/p>\n\n\n\n
Information on a past complaint from the client was that they were upset about an unexpected increase in premium. This was accomplished with Similarity Search which is part of the new Vector Search capabilities. The dba developer a stored procedure that internally connects to openAI, transforms the query into an embedding, a vector, and then uses vector distance and new vector type to do similarity search.<\/p>\n\n\n\n
Very impressive!<\/p>\n\n\n\n
\u00a0<\/p>\n\n\n\n<\/p>\n\n\n\n
<\/p>\n\n\n\n
One last question to the chatbot opened the door to the next demo with Muazma and Aditya, which is, \u201cIs there anything that can help to lower his claim.\u201d<\/p>\n\n\n\n
The chatbot responded indication that there is a \u201cSafety Score\u201d program to help lower their premiums based on their driving habits!<\/p>\n\n\n\n
Aditya joins Muazma on stage and confirms that Hyperscale for Azure SQL Database has her back.<\/p>\n\n\n\n
As customers that sign up for the Contoso Safety Score program, data from automobile IoT device will be streaming into the system in real time, and they project 1 trillion rows in 1.5 years. Aditya analyses the dataset and confirms that there are 1 trillion rows in the tracking table in the Contoso Safety Score database, and performance is not an issue. Hyperscale supports databases up the size of 128 TB.<\/p>\n\n\n\n<\/p>\n\n\n\n
Muazma also asks about multiple reads and writes and talks about Hyperscale being able to have 20+ replicas for reads and writes go to the primary replica so write performance isn\u2019t affected by reads.<\/p>\n\n\n\n
With that, Muazma calls Asad onto the stage.<\/p>\n\n\n\n
Asad talks about Azure being the One Data Platform for you AI application<\/p>\n\n\n\n<\/p>\n\n\n\n
Asad make a few more Announcement on products becoming Generally Available or enter Preview, before introducing Shireesh back on stage to once again lead the conversation.<\/p>\n\n\n\n
Shireesh talks about a customer story with Docusign using both Azure SQL Database Hyperscale and Cosmos DB<\/p>\n\n\n\n
<\/p>\n\n\n\n
Mark Brown is then invited on stage to Demo Azure Cosmos DB Vector Search to Build a Semantic Cache for LLMs.<\/p>\n\n\n\n<\/p>\n\n\n\n
SEMANTIC CACHE <\/p>\n\n\n\n
Mark did a great job showing that by creating a semantic cache, requests that are semantically similar to previous searches can be answered without hitting the LLM, but instead are answered by the semantic cache, in turn saving time and money.<\/p>\n\n\n\n
GA \u2013 Dynamic Autoscal in Cosmos DB has resulted in customers seeing a 15 \u201370% on cost savings <\/p>\n\n\n\n
<\/p>\n\n\n\n
Claire is invited on stage and she shows 2 performance benefits of building AI applications on Azure PostgreSQL flexible server<\/p>\n\n\n
\n
\nCreating text embeddings<\/li>\n\n\n\n Searching these text embeddings<\/li>\n<\/ol>\n<\/div>\n\n\n<\/p>\n\n\n\n
Claire uses Azure local AI and embedding runs locally within the Postgres Server. She then compare local AI with remote Azure Open AI service. She compares the performance of both of these side by side and the results show that the local ai embedding is 9 times faster than using the remote AI extensions.<\/p>\n\n\n\n
Claire then shows how to improve search performance by usings Azure\u2019s new DiskANN Vector search over the regular HNSW (the open source, state of the art, vector search index) search. Unsurprisingly, the next generation of DiskANN being shown outperformed HNSW \u2013 it was 50 times faster!<\/p>\n\n\n\n
Microsoft Fabric<\/h3>\n\n\n\n Now this is a Microsoft Data Platform Community event… with less than 10 minutes left in this Microsoft led Keynote, and we finally hear about Fabric, and just one slide. It\u2019s clear that they know their audience!<\/p>\n\n\n\n<\/p>\n\n\n\n
Demo \u2013 Bob & Connor Show: Query Performance using Fabric-mirrored SQL DB<\/h2>\n\n\n\n<\/p>\n\n\n\n
After Bob and Connor adorn Shireesh with a Texas branded shirt, Bob gets right down to business with Connor asking him what he\u2019s been up to, and Connor\u2019s response is elegant… \u201cI make SQL go fast \u201c.<\/p>\n\n\n\n
Connor talks on being focused on delivering the next version of Fabric<\/p>\n\n\n\n
He talk on the fact that like SQL, Fabric uses a Front End node and requests go to back end nodes for scale and performance.<\/p>\n\n\n\n<\/p>\n\n\n\n
Connor went on to say that he\u2019s be working on batch mode optimization in the following functions which result in 70% faster execution. And more batch mode optimization is coming! These Batch mode improvements help on all platforms and SQL Server vNext will include these optimizations.<\/p>\n\n\n\n<\/p>\n\n\n\n
Bob fired up SSMS and ran some queries leveraging some of these newly improved batch-mode optimized function to demonstrate that the queries we indeed running faster and the query plan\u2019s clustered scan showed that they were indeed running in batch mode.<\/p>\n\n\n\n
For this demonstration, Bob Mirror SQL from an OLTP system into compressed Delta Parquet files in Fabric and returned his results in 8 seconds \u2013 1 TB of data comprising 196 million rows<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
In this blog we will be covering all the news and announcements from the 2024 PASS Data Summit Keynote as live as we can get it captured. (And later will refine as much as we can, as capturing the details as they happen can be quite tough!) Intro Steve Jones from Redgate welcomes all of……<\/p>\n","protected":false},"author":59127,"featured_media":104440,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[159205],"tags":[159221,4162,159220,159219,4151],"coauthors":[7590],"class_list":["post-104405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-conferences","tag-azuresql","tag-microsoft","tag-passsummit2024keynotes","tag-passsummit2024posts","tag-sql-server"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/104405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/59127"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=104405"}],"version-history":[{"count":10,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/104405\/revisions"}],"predecessor-version":[{"id":104454,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/104405\/revisions\/104454"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media\/104440"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=104405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=104405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=104405"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=104405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/image.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/image.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/image-1.jpeg\")
<\/figure>\n\n\n\n![\"A](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/a-person-in-a-black-shirt-description-automatical.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-2.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-3.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-4.jpeg\")
<\/figure>\n\n\n\n![](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-5.jpeg\")
\u201cThat was sad… \u201c was Erin Stellato\u2019s initial response.<\/p>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-6.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-7.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-8.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-9.jpeg\")
<\/figure>\n\n\n\n![](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-10.jpeg\")
<\/h2>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-11.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-12.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/image-4.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-14.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-15.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-16.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-17.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-18.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/word-image-104405-19.jpeg\")
<\/figure>\n\n\n\n![\"A](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/a-group-of-men-on-a-stage-description-automatical.jpeg\")
<\/figure>\n\n\n\n![\"A](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/a-screen-shot-of-a-presentation-description-autom.jpeg\")
<\/figure>\n\n\n\n![\"A](\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/2024\/11\/a-screen-shot-of-a-computer-description-automatic.jpeg\")
<\/figure>\n\n\n\n