Azure SQL Blog articles https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/bg-p/AzureSQLBlog Azure SQL Blog articles Wed, 17 Aug 2022 11:39:43 GMT AzureSQLBlog 2022-08-17T11:39:43Z SQL Insiders Series: Azure Advisor Signals – What are they | Data Exposed https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/sql-insiders-series-azure-advisor-signals-what-are-they-data/ba-p/3597439 <P><SPAN>SQL Insiders are working on creating Azure Advisor signals to improve the recommendations surfaced by Azure Advisor. In this episode of Data Exposed, Roberto Cavalcanti and Anna Hoffman will show you a few examples of the existing ones and ask you for your feedback on what other recommendations you would like us to create in order to improve cost, security, reliability, operation excellence, and performance.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM><SPAN class="style-scope yt-formatted-string">Resources:</SPAN></EM></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Introduction to Azure Advisor</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Get started with Azure Advisor</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>SQL Insider Series Playlist</SPAN></A></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A>&nbsp;and&nbsp;<A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A>!</SPAN></P> Tue, 16 Aug 2022 18:30:32 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/sql-insiders-series-azure-advisor-signals-what-are-they-data/ba-p/3597439 MarisaMathews 2022-08-16T18:30:32Z Start Planning Your Free, Azure Data Platform Training at Data Platform Summit 2022 https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/start-planning-your-free-azure-data-platform-training-at-data/ba-p/3596272 <P><A href="#" target="_blank" rel="noopener">Data Platform Virtual Summit 2022</A>&nbsp;(DPS 2022) is right around the corner! A FREE, global learning event for data professionals, DPS 2022 features a&nbsp;couple of learning formats including breakouts &amp; Data Gurukuls. This content will be delivered by Azure Data Engineering, partner organizations, community leaders, and Data Platform MVPs. From September 19 to 23, the event is fine-tuned for multiple time zones running as five editions, ANZ, APAC, INDIA, EMEA, and AMERICAS making it a truly global and inclusive learning event. This year at DPS 2022 the content will be delivered in 14 different languages other than English. Attendees will get to learn about the latest SQL Server and Azure Data innovations and gain deep technical skills to move ahead in their careers.</P> <P>&nbsp;</P> <P>Bob Ward and Buck Woody from the Microsoft Database Platform team will be leading the keynote showcasing how to “Create a Data Culture.”&nbsp; Microsoft Database Platform team members will be delivering over 65+ sessions at DPS 2022, a Women in Technology panel, and multiple Data + AI Gurukul sessions. You'll also get to visit the virtual expo hall where you can connect with our team across SQL Server, Azure SQL, Azure Arc-enabled data services, PowerBI, and more.&nbsp;</P> <P>&nbsp;</P> <P>Hear the latest from the teams who develop the tools you use every day, and engage in live discussions. Start planning which sessions you'll be attending with our quick reference guide:</P> <P>&nbsp;</P> <TABLE width="622px"> <TBODY> <TR> <TD width="239.375px"> <P><STRONG>Speaker(s)</STRONG></P> </TD> <TD width="381.625px"> <P><STRONG>Session Title</STRONG></P> </TD> </TR> <TR> <TD width="239.375px"> <P>Bob Ward &amp; Buck Woody</P> </TD> <TD width="381.625px"> <P>Keynote: Creating a Data Culture</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Anna Hoffman &amp; Marisa Brasile</P> </TD> <TD width="381.625px"> <P>Data Exposed Live: News Updates</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Collin Brian &amp; Kellyn Gorman</P> </TD> <TD width="381.625px"> <P>Make Azure the Future Home of Your Oracle Workloads</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Alexandra Ciortea &amp; Neel Ball</P> </TD> <TD width="381.625px"> <P>Modernize your Oracle workloads to Azure SQL - What's new?</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Pieter Vanhove</P> </TD> <TD width="381.625px"> <P>Protect your data from tampering with Ledger</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Dinakar Nethi</P> </TD> <TD width="381.625px"> <P>Multicloud and Hybrid readiness: Mission Critical capabilities from Azure-Arc enabled SQL Managed Instance - Part1</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Dinakar Nethi</P> </TD> <TD width="381.625px"> <P>Multicloud and Hybrid readiness: Mission Critical capabilities from Azure-Arc enabled SQL Managed Instance - Part2</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Venkata Raj Pochiraju</P> </TD> <TD width="381.625px"> <P>Manage on-premises SQL Servers with the power of Azure- “Arc-enabled SQL Servers”</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Des FitzGerald, Naveen Samba &amp; Sumit Sarabhai</P> </TD> <TD width="381.625px"> <P>SQL Modernization- Enterprise Requirements, Blockers, IPs, and Best Practices</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Mukesh Kumar, Narendra Angange &amp; Kapil Samant</P> </TD> <TD width="381.625px"> <P>Oracle to SQL/PostgreSQL Modernization- Enterprise Requirements, Blockers, IPs, and Best Practices</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Mukesh Kumar, Ashish Khandelwal &amp; Amethyst Solomon</P> </TD> <TD width="381.625px"> <P>Mainframe/Midrange to Azure Data Modernization- Enterprise Requirements, Blockers, IPs, and Best Practices</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Bob Ward &amp; Ajay Jagannathan</P> </TD> <TD width="381.625px"> <P>Overview of SQL Server 2022</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Kate Smith &amp; Derek Wilson</P> </TD> <TD width="381.625px"> <P>SQL Server 2022 IQP Deep Drive</P> </TD> </TR> <TR> <TD width="239.375px"> <P>David Pless &amp; Kevin Farlee</P> </TD> <TD width="381.625px"> <P>SQL Server 2022 Engine Deep Dive Part 1</P> </TD> </TR> <TR> <TD width="239.375px"> <P>David Pless &amp; Kevin Farlee</P> </TD> <TD width="381.625px"> <P>SQL Server 2022 Engine Deep Dive Part 2</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Venkata Raj Pochiraju &amp; Sasha Nosov</P> </TD> <TD width="381.625px"> <P>SQL Server 2022 – Azure integration to enable Hybrid solutions out of the box</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Perry Skountrianos &amp; Kendal Van Dyke</P> </TD> <TD width="381.625px"> <P>SQL Server 2022 “Goodies”</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Dhananjay Mahajan</P> </TD> <TD width="381.625px"> <P>SQL MI on Kubernetes</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Nikita Takru</P> </TD> <TD width="381.625px"> <P>What is Azure Arc-enabled data services</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Abhiman Tiwari</P> </TD> <TD width="381.625px"> <P>Data Replication in Azure SQL and Beyond</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Tejas Shah &amp; Amit Khandelwal</P> </TD> <TD width="381.625px"> <P>SQL Server on Linux &amp; Kubernetes! - From Zero to Hero</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Anshul Sharma</P> </TD> <TD width="381.625px"> <P>Overview of Azure Data Explorer</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Uri Barash &amp; Anshul Sharma</P> </TD> <TD width="381.625px"> <P>Observational Analytics with Synapse Data Explorer</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Avner Aharoni</P> </TD> <TD width="381.625px"> <P>Building highly concurrent applications with Azure Data Explorer</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Adi Eldar</P> </TD> <TD width="381.625px"> <P>Azure Data Explorer for Data Scientists</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Matthew Hicks &amp; Lakshmi Murthy</P> </TD> <TD width="381.625px"> <P>Industry aware analytics using Azure Synapse database templates</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Charles Feddersen</P> </TD> <TD width="381.625px"> <P>Building Scale-out OLTP with PostgreSQL Hyperscale (Citus)</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Sudheesh Narayanaswamy &amp; Shreya R. Aithal</P> </TD> <TD width="381.625px"> <P>Introduction to MySQL for the SQL Server user</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Bashar Hussein &amp; Siddhant Sawant</P> </TD> <TD width="381.625px"> <P>Improve database performance with Azure Database for MySQL - Flexible Server</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Shreya R. Aithal</P> </TD> <TD width="381.625px"> <P>Develop and deploy a MySQL application on Azure App Services.</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Sunitha Muthukrishna &amp; Vivek Gk</P> </TD> <TD width="381.625px"> <P>Copy and transform data in Azure Database for MySQL using Azure Data Factory or Synapse Analytics</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Avnish Rastogi</P> </TD> <TD width="381.625px"> <P>Migrate MySQL Databases from on-premises and other cloud providers to Azure Database for MySQL with near Zero Downtime</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Rahul Saha &amp; Neil DSouza</P> </TD> <TD width="381.625px"> <P>Building fault tolerant applications with Azure Database for MySQL</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Sai Kondapalli</P> </TD> <TD width="381.625px"> <P>Scale out database write performance in Azure Database for MySQL</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Avnish Rastogi &amp; Sai Kondapalli</P> </TD> <TD width="381.625px"> <P>Leveraging ARM, CLI &amp; Terraform to provision Azure Database for MySQL Flexible Server using private or public access</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Rohit Nayak, Sranavi Saluru &amp; Madhumita Tripathy</P> </TD> <TD width="381.625px"> <P>Protect your data in the cloud with the latest security enhancements for Azure SQL</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Sandra Marin &amp; Juliane Padrao</P> </TD> <TD width="381.625px"> <P>Prep for Exam DP-300 and the Azure Database Administrator Associate Certification</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Sandra Marin &amp; James Herring</P> </TD> <TD width="381.625px"> <P>Prep for Exam DP- 203 and the Azure Data Engineer Associate Certification</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Sandra Marin &amp; Shannon Linsday</P> </TD> <TD width="381.625px"> <P>Prep for Exam DP-500 and the Azure Enterprise Data Analyst Associate Certification</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Sandra Marin</P> </TD> <TD width="381.625px"> <P>Ask the Expert: Get Microsoft Certified</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Carlos Robles, Ajith Krishnan &amp; David Levy</P> </TD> <TD width="381.625px"> <P>How to migrate SQL Server databases to Azure</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Shireen Bahadur, Chuck Heinzelman, Rodrigo Souza, Jason Huang &amp; Wee Hyong Tok</P> </TD> <TD width="381.625px"> <P>Overview of Synapse Link</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Leo Li</P> </TD> <TD width="381.625px"> <P>Managed VNET in Cloud Scale Analytics: What's New &amp; Best Practices</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Mark Kromer</P> </TD> <TD width="381.625px"> <P>What's New in Azure Data Factory</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Ulrich Christ</P> </TD> <TD width="381.625px"> <P>SAP connectivity in Azure Data Factory</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Sudhir Raparla, Rajesh Setlem &amp; Scott Kim</P> </TD> <TD width="381.625px"> <P>Azure SQL availability and resiliency for modern applications</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Mariya Ali</P> </TD> <TD width="381.625px"> <P>What's new in Azure Synapse Analytics</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Charles Webb</P> </TD> <TD width="381.625px"> <P>What's new in Datamarts</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Srdjan Bozovic &amp; Mirek Sztajno</P> </TD> <TD width="381.625px"> <P>Azure AD authentication and Microsoft Purview access policies for SQL Server 2022 on Azure Arc-enabled servers</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Nellie Gustafsson &amp; Mark Hamilton</P> </TD> <TD width="381.625px"> <P>Massively scalable machine learning on Spark with Synapse ML</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Manish Sharma &amp; Sandeep Nair</P> </TD> <TD width="381.625px"> <P>Synapse Link for Cosmos DB Best practices</P> </TD> </TR> <TR> <TD width="239.375px"> <P>David Pless</P> </TD> <TD width="381.625px"> <P>SQL Server 2022 tempdb - The Uncontended</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Martin Lee &amp; Daniel Coelho</P> </TD> <TD width="381.625px"> <P>An in-depth look into Azure Synapse Spark</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Gaurav Malhotra</P> </TD> <TD width="381.625px"> <P>Unified data governance with Microsoft Purview</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Uros Milanovic</P> </TD> <TD width="381.625px"> <P>From bare metal to the SQL Managed Instance PaaS</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Attinder Pal Singh &amp; Balmukund Lakhani</P> </TD> <TD width="381.625px"> <P>Scale out read workloads with Azure SQL DB Hyperscale Named Replicas</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Denzil Ribeiro &amp; Balmukund Lakhani</P> </TD> <TD width="381.625px"> <P>Azure SQL DB Hyperscale - What's new and Beyond</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Richa Gaur</P> </TD> <TD width="381.625px"> <P>How to model and partition data in Azure Cosmos DB to achieve cloud scale</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Madhumita Tripathy &amp; Anton Fritz</P> </TD> <TD width="381.625px"> <P>How to protect your data when it travels from Azure Synapse to PowerBI and to office</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Morgan Oslake</P> </TD> <TD width="381.625px"> <P>Compute auto-scaling using serverless in Azure SQL Database</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Ogbemi Ekwejunor-Etchie</P> </TD> <TD width="381.625px"> <P>The roadmap for enterprise semantic models: from Azure Analysis Services to Power BI Premium</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Anton Fritz, Yael Biss &amp; Naama Tsafrir</P> </TD> <TD width="381.625px"> <P>Govern your sensitive data in Power BI with Microsoft Purview</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Arvind Shyamsundar</P> </TD> <TD width="381.625px"> <P>SQL Graph: best practices for easily modelling and querying complex data models</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Niko Neugebauer &amp; Uros Randjelovic</P> </TD> <TD width="381.625px"> <P>Azure SQL Managed Instance - the future of flexible cloud-based data centers</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Niko Neugebauer, Zoran Rilak &amp; Mladen Andzic</P> </TD> <TD width="381.625px"> <P>Cost optimization for workloads on Azure SQL Managed Instance</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Dani Ljepava &amp; Mladen Andzic</P> </TD> <TD width="381.625px"> <P>Enjoy Azure SQL benefits using your SQL Server and Managed Instance link feature</P> </TD> </TR> <TR> <TD width="239.375px"> <P>Aditya Badramraju &amp; Mohammed Kabiruddin</P> </TD> <TD width="381.625px"> <P>SQL Server in Azure Virtual Machines - Configuring for price-performance</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P><STRONG>Register today</STRONG></P> <P>Register for&nbsp;<A href="#" target="_blank" rel="noopener">Data Platform Virtual Summit 2022</A>&nbsp;today and be part of an amazing week of training convenient to your time zone.&nbsp;</P> <P>&nbsp;</P> Wed, 10 Aug 2022 20:01:30 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/start-planning-your-free-azure-data-platform-training-at-data/ba-p/3596272 MarisaMathews 2022-08-10T20:01:30Z Azure SQL News Update: August 2022 https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-news-update-august-2022/ba-p/3595656 <P>Today Data Exposed goes live at 9AM PT on <A href="#" target="_blank" rel="noopener">LearnTV</A>. Every 4 weeks, we’ll do a News Update. We’ll include product updates, videos, blogs, etc. as well as upcoming events and things to look out for. If you missed the episode, you can find them all at <A href="#" target="_blank" rel="noopener">https://aka.ms/AzureSQLYT</A>. This month we’ll recap all the updates and announcements in the database space July.</P> <P>&nbsp;</P> <P>You can read this blog to get all the updates and references mentioned in the show. Here’s the August 2022 update:</P> <P>&nbsp;</P> <P>By the way, this was a special episode, because we filmed it live, for the first time in over two years, from the studios on Microsoft campus in Redmond, WA! If you missed the live stream, you won’t want to miss this in-person action: <A href="#" target="_blank" rel="noopener">https://aka.ms/AzureSQLYT</A>. Here are some of the references from our awesome guests:</P> <P>&nbsp;</P> <UL> <LI>SQL Server 2022 (CTP 2.1 available!), Bob Ward <UL> <LI><A href="#" target="_blank" rel="noopener">https://aka.ms/sqlserver2022</A></LI> </UL> </LI> <LI>Azure SQL Database, Davide Mauri and Drew Skwiers-Koballa <UL> <LI><A href="#" target="_blank" rel="noopener">https://aka.ms/sqlprojsdkblog</A></LI> <LI><A href="#" target="_blank" rel="noopener">https://docs.microsoft.com/azure/azure-sql/database/local-dev-experience-quickstart</A></LI> </UL> </LI> <LI>SQL Server on Azure SQL VM, Mohamed Kabiruddin: <UL> <LI><A href="#" target="_blank" rel="noopener">Premium SSD v2 disks in Public Preview</A> for better price-performance in SQL Server on Azure VMs (4x IOPS and you can scale storage capacity, IOPS, and throughput per disk independently!)</LI> </UL> </LI> <LI>Microsoft Purview, Daniel Perlovsky <UL> <LI><A href="#" target="_blank" rel="noopener">Rich Text Editor</A></LI> <LI><A href="#" target="_blank" rel="noopener">Managed Attributes</A></LI> </UL> </LI> </UL> <P><STRONG>&nbsp;</STRONG></P> <P><STRONG>Product updates </STRONG></P> <P>We technically discussed this in the last update, but I wanted to make sure everyone saw the important announcement and that is <A href="#" target="_blank" rel="noopener">SQL Server 2012 has reached end of support</A>. Please see the blog to see the four options you have if you find yourself with SQL Server 2012 instances.</P> <P>&nbsp;</P> <P>The other big update (apart from the updates already covered by our guests) is the <A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/announcing-the-general-availability-of-premium-series-hardware/ba-p/3576737" target="_blank" rel="noopener">general availability of premium-series hardware</A> for Azure SQL Managed Instance. This new hardware is what led to the study by <A href="#" target="_blank" rel="noopener">Principled Technologies which shows how Azure SQL Managed Instance significantly outperformed Amazon RDS</A>. Offering between double and five times the performance depending on workload, the three SQL Managed Instances tested also offer better price/performance by as much as 90.3%. The new hardware is available across different service tiers and might offer you more storage and more memory per vCore if you need it.</P> <P>&nbsp;</P> <P><STRONG>Other database updates</STRONG></P> <P>Starting in 2022 we’re trying to keep you updated on what’s going on with other database services at Microsoft, as we understand that oftentimes you’re using more than one service. Here are the updates I gathered from July 2022.</P> <P>&nbsp;</P> <TABLE width="626"> <TBODY> <TR> <TD width="306"> <P><STRONG>Azure Database for PostgreSQL-Hyperscale (Citus)</STRONG></P> </TD> <TD width="320"> <P><STRONG>Flexible Server</STRONG></P> </TD> </TR> <TR> <TD width="306"> <P><A href="#" target="_blank" rel="noopener">General availability: Azure Database for PostgreSQL—Hyperscale (Citus) supports PostgreSQL minor versions</A> (11.16, 12.11, 13.7, 14.3)</P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">General availability: Citus 11 support for Azure Database for PostgreSQL - Hyperscale (Citus)</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Public preview: Cross-region read replicas for Azure Database for PostgreSQL – Hyperscale (Citus)</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Generally available: Basic tier updates for Azure Database for PostgreSQL – Hyperscale (Citus)</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Generally available: vCore compute options for Azure Database for PostgreSQL – Hyperscale (Citus)</A></P> </TD> <TD width="320"> <P><A href="#" target="_blank" rel="noopener">General Availability: Azure Database for MySQL - Flexible Server - On demand backups</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Public preview: Azure Database for MySQL - Flexible Server data encryption with CMK</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Generally available: New extensions for Azure Database for PostgreSQL – Flexible Server</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Generally available: PostgreSQL 14 with Azure Database for PostgreSQL – Flexible Server</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Generally available: Same-zone high availability for Azure Database for PostgreSQL – Flexible Server</A></P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P><STRONG>Videos </STRONG></P> <P>We continued to release new and exciting episodes this month. Here is the list, or you can just see the <A href="#" target="_blank" rel="noopener">playlist</A> we created with all the episodes!</P> <UL> <LI>Daniel Perlovsky: How to explore your data estate using the Microsoft Purview data catalog</LI> <LI>[MVP Edition] Wolfgang Strasser: Track your data supply chain using Azure Purview</LI> <LI>Aditi Gupta: Backup and Restore your Azure Database for MySQL - Flexible Server workload</LI> <LI>Pieter Vanhove: Bringing the power of blockchain to Azure SQL Database and SQL Server with ledger</LI> <LI>[SQL Insider Series] Stephen Giles: Azure SQL DB – Automating scale up and down</LI> </UL> <P>&nbsp;</P> <P>We’ve also had some great Data Exposed Live sessions. Subscribe to our <A href="#" target="_blank" rel="noopener">YouTube channel</A> to see them all and get notified when we stream. Here are some of the recent live streams.</P> <UL> <LI>May the 4<SUP>th</SUP> be with Azure SQL (News Updates): this was a Star Wars-themed episode and it was so fun! Check it out for costumes, themed demos and slides, and fun!</LI> <LI>Azure SQL &amp; SQL Server 2022: Intelligent Database Futures</LI> <LI>Azure SQL News Update: 2021 Year in Review</LI> <LI>Welcome to SQL Server 2022 Live!</LI> </UL> <P>&nbsp;</P> <P><STRONG>Blogs </STRONG></P> <P>As always, our team is busy writing blogs to share with you all. Blogs contain announcements, tips and tricks, deep dives, and more. Here’s the list I have of SQL-related topics you might want to check out.</P> <P>&nbsp;</P> <UL> <LI>Azure Blog, data-related <UL> <LI><A href="#" target="_blank" rel="noopener">Microsoft Cost Management updates – July 2022</A>, Michael Flanakin</LI> <LI><A href="#" target="_blank" rel="noopener">Track adversaries and improve posture with Microsoft threat intelligence solutions</A>, Tim Woolford</LI> <LI><A href="#" target="_blank" rel="noopener">Migrate and modernize with Azure to power innovation across the entire digital estate</A>, Kathleen Mitford</LI> <LI><A href="#" target="_blank" rel="noopener">Azure Premium SSD v2 Disk Storage in preview</A>, Aung Oo</LI> <LI><A href="#" target="_blank" rel="noopener">Microsoft joins Jakarta EE and MicroProfile Working Groups at Eclipse Foundation</A>, Julia Liuson</LI> <LI><A href="#" target="_blank" rel="noopener">Modernize with Azure Migrate</A>, Shiva Shastri</LI> </UL> </LI> <LI>Microsoft SQL Server Blog <UL> <LI><A href="#" target="_blank" rel="noopener">Azure Active Directory authentication for SQL Server 2022</A></LI> <LI><A href="#" target="_blank" rel="noopener">Azure Data Studio July Release with VS Code Updates&nbsp;</A></LI> <LI><A href="#" target="_blank" rel="noopener">Improve scalability with system page latch concurrency enhancements in SQL Server 2022</A></LI> </UL> </LI> <LI>SQL Server Tech Community <UL> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/sql-server-2022-community-technology-preview-2-1-is-now/ba-p/3582903" target="_blank" rel="noopener">SQL Server 2022 community technology preview 2.1 is now available</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/cumulative-update-30-for-sql-server-2017-rtm/ba-p/3572333" target="_blank" rel="noopener">Cumulative Update #30 for SQL Server 2017 RTM</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/upcoming-updates-to-sql-server-container-images-on-microsoft/ba-p/3573013" target="_blank" rel="noopener">Upcoming updates to SQL Server container images on Microsoft Artifact Registry aka (MCR)</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/odbc-driver-17-10-for-sql-server-released/ba-p/3572367" target="_blank" rel="noopener">ODBC Driver 17.10 for SQL Server Released</A></LI> </UL> </LI> <LI>Azure SQL Tech Community <UL> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/ms-dtc-for-azure-sql-managed-instance-extending-distributed/ba-p/3576839" target="_blank" rel="noopener">MS DTC for Azure SQL Managed Instance - extending distributed transaction support (private preview)</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/announcing-the-general-availability-of-premium-series-hardware/ba-p/3576737" target="_blank" rel="noopener">Announcing the General Availability of premium-series hardware for Azure SQL Managed Instance</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/resumable-restore-improves-sql-managed-instance-database/ba-p/3573367" target="_blank" rel="noopener">Resumable restore improves SQL Managed Instance database migrations experience</A></LI> </UL> </LI> <LI>Azure Database Support (SQL-related posts) <UL> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/bidirectional-transactional-replication-in-sql-managed-instance/ba-p/3584998" target="_blank" rel="noopener">Bidirectional Transactional Replication in SQL Managed Instance</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/testing-connectivity-against-a-managed-instance-using-a-cname/ba-p/3580337" target="_blank" rel="noopener">Testing connectivity against a Managed Instance using a CNAME</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-232-microsoft-reactor-identify-an-azure-sql/ba-p/3583527" target="_blank" rel="noopener">Lesson Learned #232: Microsoft Reactor- Identify an Azure SQL Performance Issue (Spanish Version)</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/resolve-elastic-query-issues-in-azure-sql-database/ba-p/3583451" target="_blank" rel="noopener">Resolve Elastic Query issues in Azure SQL Database</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-231-hands-on-labs-what-is-azure-sql-working-on/ba-p/3581046" target="_blank" rel="noopener">Lesson Learned #231: Hands-On-Labs: What is Azure SQL working on</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/improving-performance-with-auto-update-statistics-async/ba-p/3579907" target="_blank" rel="noopener">Improving Performance with AUTO_UPDATE_STATISTICS_ASYNC</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-230-microsoft-reactor-azure-sql-developer-and-dba/ba-p/3580025" target="_blank" rel="noopener">Lesson Learned #230: Microsoft Reactor -Azure SQL Developer and DBA Best Practices (Spanish Version)</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-229-hands-on-labs-connection-is-busy-with-results/ba-p/3578096" target="_blank" rel="noopener">Lesson Learned #229: Hands-On-Labs - Connection is busy with results for another command</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-228-using-sp-validatelogins-in-azure-sql-database/ba-p/3578169" target="_blank" rel="noopener">Lesson Learned #228: Using sp_validatelogins in Azure SQL Database</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/sql-error-code-40532-cannot-open-server-azuresqlserver1/ba-p/3567451" target="_blank" rel="noopener">SQL Error Code 40532 Cannot open server 'azuresqlserver1' requested by the login.</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-227-how-much-data-is-using-my-database-per-table/ba-p/3576658" target="_blank" rel="noopener">Lesson Learned #227: How much data is using my database per table</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-226-using-a-connectivity-retry-logic-with-sqlcmd/ba-p/3576436" target="_blank" rel="noopener">Lesson Learned #226: Using a connectivity Retry-Logic with SQLCMD command line</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-225-has-an-unresolved-reference-to-object-using/ba-p/3574781" target="_blank" rel="noopener">Lesson Learned #225: Has an unresolved reference to object using Linked Server or External Table</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-224-hands-on-labs-checking-the-performance-with/ba-p/3574602" target="_blank" rel="noopener">Lesson Learned #224:Hands-On-Labs: Checking the performance with Perf Collector Analyzer</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-223-hands-on-labs-how-to-improve-a-bulk-insert/ba-p/3574575" target="_blank" rel="noopener">Lesson Learned #223:Hands-On-Labs: How to improve a bulk insert process</A></LI> </UL> </LI> </UL> <P><STRONG>&nbsp;</STRONG></P> <P><STRONG>Events</STRONG></P> <P>We have several in-person and virtual events coming in the next couple months. Here are a few to put on your calendar and register for from the Azure Data team:<BR /><BR /><STRONG>August 8-12</STRONG><A href="#" target="_blank" rel="noopener"><STRONG>:</STRONG> Visual Studio Live!, Microsoft HQ</A><BR /><STRONG>September 19-22:</STRONG> <A href="#" target="_blank" rel="noopener">Data Platform Summit, Virtual</A><SPAN><BR /></SPAN><STRONG>September 24: </STRONG><A href="#" target="_blank" rel="noopener">Data Saturday Dallas</A><STRONG><BR />October 1: </STRONG><A href="#" target="_blank" rel="noopener">Data Saturday Atlanta</A><BR /><BR />And, if you can’t make it to our events, find new, on-demand Data Exposed episodes released every Thursday at <A href="#" target="_blank" rel="noopener">https://aka.ms/dataexposedyt</A></P> <P>&nbsp;</P> <P><STRONG>Microsoft Learn module of the month</STRONG></P> <P>Jumping the gun on the pick of the month, but in the case that any of you are newer to Azure SQL, it’s been a long time since I highlighted the <A href="#" target="_blank" rel="noopener">Introduction to Azure SQL</A> module. In this module, you'll start with a brief history of why and how Microsoft built Azure SQL. You'll then learn about the various deployment options and service tiers, including what to use for your organization, and when. These options include Azure SQL Database, Azure SQL Managed Instance, and SQL Server in an Azure virtual machine. Understanding what platform as a service (PaaS) encompasses and how it compares to a traditional SQL Server environment will help you understand what you do and don't get when you move to the cloud.</P> <P>&nbsp;</P> <P><STRONG>Anna’s pick of the month!</STRONG></P> <P>OK this month my pick of the month is a new thing I’m dipping my toes into on TikTok. The goal is to start sharing database tips in a short, consumable fashion while I walk my dog. Check it out, follow along, and let me know what you think! It’s running on TikTok (<A href="#" target="_blank" rel="noopener">https://www.tiktok.com/@analyticanna</A>), Instagram (<A href="#" target="_blank" rel="noopener">https://www.instagram.com/analytic.anna/reels/</A>), and Twitter (<A href="#" target="_blank" rel="noopener">https://twitter.com/AnalyticAnna</A>).</P> <P><STRONG>&nbsp;</STRONG></P> <P><STRONG>Until next time… </STRONG></P> <P>That’s it for now! Be sure to check back next month for the latest updates on <A href="#" target="_blank" rel="noopener">LearnTV</A>. We also release new episodes on Thursdays at 9AM PT and new #MVPTuesday episodes on the last Tuesday of every month at 9AM PT at <A href="#" target="_blank" rel="noopener">aka.ms/DataExposedyt</A>.</P> <P>&nbsp;</P> <P>Having trouble keeping up? Be sure to follow us on twitter to get the latest updates on everything, <A href="#" target="_blank" rel="noopener">@AzureSQL</A>.</P> <P>&nbsp;</P> <P>We hope to see you next time, on Data Exposed :)</img></P> <P>--Anna and Marisa</P> Thu, 11 Aug 2022 19:32:22 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-news-update-august-2022/ba-p/3595656 Anna Hoffman 2022-08-11T19:32:22Z Azure Synapse Link for SQL | Data Exposed https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-synapse-link-for-sql-data-exposed/ba-p/3591333 <P><SPAN>Azure Synapse Link for SQL is an automated system for replicating data from your transactional databases (both SQL Server 2022 and Azure SQL Database) into a dedicated SQL pool in Azure Synapse Analytics. In this episode of Data Exposed, Shireen Bahadur, Chuck Heinzelman, and Anna Hoffman will walk us through what Synapse Link for SQL is and how easily you can replicate data into your target dedicated SQL pool. </SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM><SPAN class="style-scope yt-formatted-string">Resources:</SPAN></EM></P> <P><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-synapse-analytics-blog/announcing-the-public-preview-of-azure-synapse-link-for-sql/ba-p/3372986" target="_blank" rel="noopener"><SPAN>Announcing the Public Preview of Azure Synapse Link for SQL </SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>What is Azure Synapse Link for SQL: What is Azure Synapse Link for SQL? (Preview)</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN> Get Started with Azure Synapse Link for SQL</SPAN></A></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A>&nbsp;and&nbsp;<A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A>!</SPAN></P> <P>&nbsp;</P> Thu, 04 Aug 2022 16:40:49 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-synapse-link-for-sql-data-exposed/ba-p/3591333 MarisaMathews 2022-08-04T16:40:49Z Prevent Data Exfiltration in Azure SQL Managed Instance https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/prevent-data-exfiltration-in-azure-sql-managed-instance/ba-p/3590381 <P>Data exfiltration is a technique that is also sometimes described as data theft or data extrusion, that describes the unauthorized extraction of data from the original source. This unauthorized extraction can be executed either manually or automatically by the malicious attacker.</P> <P>&nbsp;</P> <P>As part of your Network Infrastructure, you might have tightened your security to make sure you have all the bells and whistles to lock down your Azure SQL Managed Instance to be accessed only by your application and not exposed to the Internet or any other traffic. However, this doesn’t stop a malicious admin from taking a backup or creating a linked server to another resource outside your enterprise subscription for extracting the data. This action would be data exfiltration. In a typical on-premises infrastructure, you can lock down network access completely to make sure that the data never leaves your network. However, in a cloud setup, there is a possibility that someone with elevated privileges can export data or perform some other malicious activity targeting their own resources outside your organization, compromising your enterprise data. Hence, it is very important to understand the different data exfiltration scenarios and make sure that you are taking the right steps to monitor for and prevent such activities.</P> <P>&nbsp;</P> <P>Here are of the different exfiltration scenarios and the associated preventive actions and controls.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="NikoNeugebauer_0-1659550404072.png" style="width: 999px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/393143i31504245D0FC711E/image-size/large?v=v2&amp;px=999" role="button" title="NikoNeugebauer_0-1659550404072.png" alt="NikoNeugebauer_0-1659550404072.png" /></span></P> <P>&nbsp;</P> <H2><STRONG>Backups to Unauthorized Locations</STRONG></H2> <P>By default, Azure SQL Managed Instance has automatic backups that are stored on Azure storage, fully encrypted, keeping you compliant, and providing most of the functionalities that you would need. Additionally, Managed Instance also enables you to take your own COPY_ONLY backups where you get an option to take backups to a URL with the COPY_ONLY flag. This means that a malicious user can take a backup of the database to their personal storage account. Best practices to prevent this from happening are listed below.</P> <P>&nbsp;</P> <H4><STRONG>Preventive Actions</STRONG></H4> <UL> <LI><STRONG>Restricted Admin Access</STRONG></LI> </UL> <P>Follow the principle of least privilege to make sure that you always grant only the minimum necessary permissions to your DBAs and other privileged users on your Azure SQL Managed Instance.</P> <P>Below is an example of the permissions granted and denied for a restricted admin role:</P> <TABLE width="528"> <TBODY> <TR> <TD width="15"> <P><STRONG>Authorization</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P><STRONG>&nbsp;</STRONG></P> </TD> <TD width="281"> <P><STRONG>Permission</STRONG><STRONG>&nbsp;</STRONG></P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>CONNECT ANY DATABASE&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>SELECT ALL USER SECURABLES&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>VIEW SERVER STATE&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>VIEW DATABASE STATE&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY CONNECTION&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>VIEW ANY DEFINITION&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>VIEW ANY DATABASE&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY CONNECTION&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER SERVER STATE&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY EVENT SESSION&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>GRANT</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER TRACE&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY DATABASE&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY LINKED SERVER&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY LOGIN&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY ENDPOINT&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY DATABASE&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY CREDENTIAL&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY SERVER AUDIT&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER ANY SERVER ROLE&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ALTER SETTINGS&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>IMPERSONATE ANY LOGIN&nbsp;</P> </TD> </TR> <TR> <TD width="15"> <P><STRONG>DENY</STRONG><STRONG>&nbsp;</STRONG></P> </TD> <TD width="232"> <P>&nbsp;</P> </TD> <TD width="281"> <P>ADMINISTER BULK OPERATIONS&nbsp;</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>For your power users who need sysadmin access, here are some guidelines:</P> <UL> <LI>It is recommended to have all the privileged users in Azure SQL Managed instance have AAD server logins on the Managed SQL Instance. Preferably create an AAD Group as a sysadmin on the SQL Server.</LI> <LI>Set Azure AD conditional access on those accounts so that they can only be accessed from within certain regions, using specific devices, or similar.</LI> <LI>Enable Privileged Identity Management (PIM) to log onto secured jump boxes within the same virtual network as the SQL Managed Instance, followed by a connection to the Azure SQL Managed Instance.</LI> </UL> <P>Reference:&nbsp;<A href="#" target="_self">Start using Privileged Identity Management</A></P> <P>&nbsp;</P> <UL> <LI><STRONG>Use Transparent Data Encryption (TDE)</STRONG>&nbsp;</LI> </UL> <P>TDE helps protect Azure SQL Managed Instance against the threat of malicious offline activity by encrypting data at rest. It performs real-time encryption and decryption of the database, associated backups, and transaction log files at rest without requiring changes to the application. TDE is either enabled by using service-managed keys (where Microsoft manages the default key) or customer-managed keys (where you as a customer point to a key in Azure Key vault).</P> <P>&nbsp;</P> <P>COPY_ONLY backups are not possible because Microsoft manages the key. They can only work with customer-managed keys, which means that for someone to restore the backup, the target SQL instance needs to have access to the original key (TDE Protector) in Azure Key Vault. Azure Key Vault’s access policy is managed by Azure AD and hence it acts as security boundary by making sure that any Azure SQL instance which is not part of the Access policy is denied access, preventing data exfiltration.</P> <P>&nbsp;</P> <P>Reference:&nbsp;<A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/how-to-restore-across-different-sql-managed-instances-when-using/ba-p/3270090" target="_blank" rel="noopener">How-to restore across different SQL Managed instances when using TDE with Customer Managed Keys</A></P> <P>&nbsp;</P> <UL> <LI><STRONG>Assign service endpoint policies to control where the data may go</STRONG></LI> </UL> <P>Virtual network service endpoint policies for Azure Storage may be configured on the Azure SQL Managed Instance's subnet, granting you explicit preventive action over which Azure Storage resources may be accessed. When associated with the subnet, service endpoint policies will deny all connection attempts from within your subnet to all Azure Storage resources except those you have configured the policies to allow.</P> <P>Note: This feature is in public preview.</P> <P>Reference:&nbsp;<A href="#" target="_blank" rel="noopener">Configure service endpoint policies for Azure SQL Managed Instance</A><SPAN>.</SPAN></P> <P>&nbsp;</P> <P><STRONG>Controls</STRONG></P> <UL> <LI><STRONG>Setting Auditing Alerts</STRONG></LI> </UL> <P>You need to make sure that you have enabled auditing on the Azure SQL Managed Instance to capture all backup and restore activities. Auditing can write to your storage accounts or to Azure Monitor logs. By writing to Azure Monitor logs, you can create Alerts and notifications to make sure that you get alerted on all the backup and restore activities to or from unauthorized locations.</P> <P>Reference: <A href="#" target="_blank" rel="noopener">SQL Managed Instance auditing - Azure SQL Managed Instance | Microsoft Docs</A></P> <P>&nbsp;</P> <UL> <LI><STRONG>Azure Policy to enforce TDE</STRONG></LI> </UL> <P>Azure Policy enforces different rules and effects over your resources, so those resources stay compliant with your corporate standards and service level agreements. Azure Policy meets this need by evaluating your resources for non-compliance with assigned policies. A built-in policy called&nbsp;<STRONG>“SQL managed instance TDE protector should be encrypted with your own key” </STRONG>can be used to enforce the encryption of databases using customer-managed keys located in Azure Key Vault.</P> <P>&nbsp;</P> <UL> <LI><STRONG>Microsoft Defender for SQL - Threat Protection and Vulnerability Assessments for Data Exfiltration</STRONG></LI> </UL> <P>Microsoft Defender for Cloud provides a set of advanced SQL security capabilities, including vulnerability assessment and Advanced Threat Protection. These capabilities help track potential database vulnerabilities and protect from threats from applications and other usage anomalies. Threat Protection offers an option called “Data exfiltration” which will alert when any kind of exfiltration anomalies happen on the Managed Instance.</P> <P>&nbsp;</P> <P>References:&nbsp;<A href="#" target="_blank" rel="noopener">Microsoft Defender for SQL - Azure SQL Database | Microsoft Docs</A></P> <P><A href="#" target="_blank" rel="noopener">SQL vulnerability assessment - Azure SQL Database &amp; SQL Managed Instance &amp; Azure Synapse Analytics | Microsoft Docs</A></P> <P>&nbsp;</P> <H2><STRONG>Copying Data through Linked Servers</STRONG></H2> <P>Linked servers enable the SQL Server Database Engine and Azure SQL Managed Instance to read data from remote data sources and execute commands against remote database servers (for example, OLE DB data sources).&nbsp; A malicious user can exfiltrate data out of a Managed Instance by creating a linked server to another SQL Server instance. Below are some ways to prevent this from happening.</P> <P>&nbsp;</P> <P><STRONG>Preventive Actions</STRONG></P> <UL> <LI><STRONG>Restricted Admin Access</STRONG></LI> </UL> <P>Follow the principle of least privilege to make sure that you always grant only the minimum necessary permissions to your DBAs and other privileged users on your Azure SQL Managed Instance.&nbsp;</P> <P><STRONG>&nbsp;</STRONG></P> <P><STRONG>Controls</STRONG></P> <UL> <LI><STRONG>Setting Auditing Alerts:</STRONG>&nbsp;You need to make sure that you have enabled auditing on the Azure SQL Managed Instance to capture all linked server activities. Auditing can write to your storage accounts or to Azure Monitor Logs. By writing to Azure Monitor logs, you can create alerts and notifications to make sure that you get alerted on all the linked server activities.</LI> </UL> <P>Reference: <A href="#" target="_blank" rel="noopener">SQL Managed Instance auditing - Azure SQL Managed Instance | Microsoft Docs</A></P> <P><STRONG>&nbsp;</STRONG></P> <P>&nbsp;</P> <H2><STRONG>Outbound Calls through CLR Integration</STRONG></H2> <P>CLR enables scenarios in which code can access resources outside the server. A malicious user can exfiltrate data out from a Managed instance through the managed code.</P> <P>&nbsp;</P> <P><STRONG>Preventive Actions</STRONG></P> <UL> <LI><STRONG>Turn off CLR Integration<SPAN>:</SPAN></STRONG></LI> </UL> <P>Executing this query will disable CLR on Azure SQL Managed Instance</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="sql">execute sp_configure 'show advanced options', 1; GO RECONFIGURE; GO execute sp_configure 'clr enabled', 0; GO RECONFIGURE; GO </LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <UL> <LI><STRONG>Restricted Admin Access:</STRONG>&nbsp;Follow the principle of least privilege to make sure that you always grant only the minimum necessary permissions to your DBAs and other privileged users on your Azure SQL Managed Instance.&nbsp;</LI> </UL> <P><STRONG>&nbsp;</STRONG></P> <P><STRONG>Controls</STRONG></P> <UL> <LI><STRONG>Setting Auditing Alerts:</STRONG>&nbsp;Enable auditing on the Azure SQL Managed Instance to capture all sp_configure activities. Auditing can write to your storage accounts or to Azure Monitor Logs. By writing to Azure Monitor logs, you can create alerts and notifications to make sure that you get alerted on all the sp_configure activities happening on the SQL MI instance.</LI> </UL> <P><STRONG>&nbsp;</STRONG></P> <P><STRONG>Reference:&nbsp;</STRONG><A href="#" target="_blank" rel="noopener">It's just SQL: CLR in Azure SQL Database Managed Instance | Microsoft Docs</A></P> <P>&nbsp;</P> <H2><STRONG>Sending Data through Database Mail</STRONG></H2> <P>The Database Mail feature enables you to send emails directly from Managed Instance. A malicious user can leverage this feature to exfiltrate data out from the Managed Instance. The following are ways to prevent this from happening.</P> <P>&nbsp;</P> <P><STRONG>Preventive Actions</STRONG></P> <UL> <LI><STRONG>Turn off Database Mail<SPAN>:</SPAN></STRONG></LI> </UL> <P>Executing this query will disable Database Mail on Azure SQL Managed Instance:</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="sql">execute sp_configure 'show advanced options', 1; GO RECONFIGURE; GO execute sp_configure 'Database Mail XPs', 0; GO RECONFIGURE GO</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <UL> <LI><STRONG>Restricted Admin Access:</STRONG>&nbsp;Follow the principle of least privilege to make sure that you always grant only the minimum necessary permissions to your DBAs and other privileged users on your Azure SQL Managed Instance.&nbsp;</LI> </UL> <P>&nbsp;</P> <P><STRONG>Controls</STRONG></P> <UL> <LI><STRONG>Setting Auditing Alerts:</STRONG>&nbsp;Enable auditing on the Azure SQL Managed Instance to capture all sp_configure activities. Auditing can write to your storage accounts or to Azure Monitor Logs. By writing to Azure Monitor logs, you can create alerts and notifications to make sure that you get alerted on all the sp_configure activities happening on the SQL MI instance.</LI> </UL> <P>&nbsp;</P> <H2><STRONG>Reading Data from Audit Logs</STRONG></H2> <P>There could be scenarios where you write the audit logs to a storage account which you want to retain for long term or compliance purposes. As such you do not want anyone to tamper with those logs. The following are ways to prevent and control this from happening.</P> <P>&nbsp;</P> <P><STRONG>Preventive Actions</STRONG></P> <UL> <LI><STRONG>Locking storage firewall to Managed Instance subnet</STRONG>&nbsp;</LI> </UL> <P>Configure firewall rules to limit access to your storage account to only those requests that originate from the Managed Instance’s subnet.</P> <P>Reference: <A href="#" target="_blank" rel="noopener">Configure Azure Storage firewalls and virtual networks | Microsoft Docs</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <UL> <LI><STRONG>Assign </STRONG><STRONG>to control where the data may go</STRONG></LI> </UL> <P>Virtual network service endpoint policies for Azure Storage may be configured on the Azure SQL Managed Instance's subnet, granting you explicit control over which Azure Storage resources may be accessed. When associated with the subnet, service endpoint policies will deny all connection attempts from within your subnet to all Azure Storage resources except those you have configured the policies to allow.</P> <P>Note: This feature is in public preview.</P> <P>Reference:&nbsp;<A href="#" target="_blank" rel="noopener">configure service endpoint policies for Azure SQL Managed Instance</A>.</P> <P>&nbsp;</P> <P><STRONG>Controls</STRONG></P> <UL> <LI><STRONG>Storage Access Control</STRONG>: One of the security risks is exposing this storage account which contains your SQL Managed Instance Audit logs which can be subjected to tampering or deletions. Hence, it is very important to lock down this storage account so that only your SQL Managed instance has access to it and blocked from everybody else.</LI> </UL> <P>Go to the Storage account which contains your SQL Server audit logs and enable VNET endpoint on the storage account. Once you enable this VNET endpoint on the storage account, only SQL MI will be able to write to the storage account. You need to exclusively add other VNET\Subnets if you want to give whitelisted access to other privileged users or use SQL MI or query the audit logs accordingly.</P> <P>&nbsp;</P> <H2><STRONG>Transactional Replication</STRONG></H2> <P>Transactional replication in Azure SQL Managed Instance allows customer to replicate selected portions of data on a table level to other remote destinations, supporting the same Transactional Replication protocol. For this purpose, a storage on Azure must be used and this gives a potential attacker a path to extract the data, which should be prevented and controlled.&nbsp;</P> <P>The following are ways to prevent and control this from happening.</P> <P>&nbsp;</P> <P><STRONG>Preventive Actions</STRONG></P> <UL> <LI><STRONG>Restricted Admin Access</STRONG></LI> </UL> <P>Follow the principle of least privilege to make sure that you always grant only the minimum necessary permissions to your DBAs and other privileged users on your Azure SQL Managed Instance.&nbsp;</P> <P>&nbsp;</P> <UL> <LI><STRONG>Assign </STRONG><STRONG>to control where the data may go</STRONG></LI> </UL> <P>Virtual network service endpoint policies for Azure Storage may be configured on the Azure SQL Managed Instance's subnet, granting you explicit preventive action over which Azure Storage resources may be accessed. When associated with the subnet, service endpoint policies will deny all connection attempts from within your subnet to all Azure Storage resources except those you have configured the policies to allow.</P> <P>Note: This feature is in public preview.</P> <P>Reference:&nbsp;<A href="#" target="_blank" rel="noopener">configure service endpoint policies for Azure SQL Managed Instance</A>.</P> <P>&nbsp;</P> <P><STRONG>Controls</STRONG></P> <UL> <LI><STRONG>Storage Access Control</STRONG>: One of the security risks is exposing this storage account which contains your SQL Managed Instance Transaction Replication data which can be exported and can be replicated to a different destination. Hence, it is very important to lock down this storage account so that only your SQL Managed instance has access to it and blocked from everybody else.</LI> </UL> <P>Go to the Storage account which contains your SQL Server audit logs and enable VNET endpoint on the storage account. Once you enable this VNET endpoint on the storage account, only SQL MI will be able to write to the storage account. You need to exclusively add other VNET\Subnets where the Transactional Replication distributor and publisher are located or other VNET\Subnets, if you want to give whitelisted access to other privileged users or use SQL MI accordingly.</P> <P>&nbsp;</P> <UL> <LI><STRONG>Setting Auditing Alerts:</STRONG>&nbsp;Enable auditing on the Azure SQL Managed Instance to capture Transactional Replication configuration and published article activities. Auditing can write to your storage accounts or to Azure Monitor Logs. By writing to Azure Monitor logs, you can create alerts and notifications to make sure that you get alerted on all the transactional replication activities happening on the SQL MI instance.</LI> </UL> <P>&nbsp;</P> <P>&nbsp;</P> <P>In this article we have described some of the most popular&nbsp;Data Exfiltration methods and the respective preventive actions &amp; control mechanisms for each of them. This list is not complete yet and we shall be updating it in the future, but for now - start with protecting your and your customers data right away.</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 05 Aug 2022 10:50:59 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/prevent-data-exfiltration-in-azure-sql-managed-instance/ba-p/3590381 NikoNeugebauer 2022-08-05T10:50:59Z How to explore your data estate using the Microsoft Purview data catalog | Data Exposed https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/how-to-explore-your-data-estate-using-the-microsoft-purview-data/ba-p/3580252 <P><SPAN>Microsoft Purview is a unified data governance solution that helps you manage and govern your on-premises, multi-cloud, and software-as-a-service (SaaS) data. Once the Microsoft Purview data map is populated, data consumers and business users can explore the data catalog to find the information that allows them to complete their data-driven tasks. Learn more in this episode of Data Exposed with Anna Hoffman and Daniel Perlovsky.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM><SPAN class="style-scope yt-formatted-string">Resources:</SPAN></EM></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Intro to Purview</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>How to Search the Microsoft Purview data catalog</SPAN></A></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A>&nbsp;and&nbsp;<A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A>!</SPAN></P> Thu, 28 Jul 2022 16:00:00 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/how-to-explore-your-data-estate-using-the-microsoft-purview-data/ba-p/3580252 MarisaMathews 2022-07-28T16:00:00Z Track your data supply chain using Azure Purview | Data Exposed: MVP Edition https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/track-your-data-supply-chain-using-azure-purview-data-exposed/ba-p/3580233 <P><SPAN>Collecting data is one part of the story. To know your data estate is another part. Let's see how Azure Purview can help you to manage and govern your data estate, find relevant pieces of information, classify data assets and connect these pieces into the Azure Purview data map. </SPAN></P> <P>&nbsp;</P> <P><SPAN>One of the most important parts of your data knowledge is the information about your data relationships – the data supply chain. Join Wolfgang Strasser and Anna Hoffman in this episode of Data Exposed: MVP Edition to see the new Azure SQL lineage extraction in action and learn more about what is going on in your data estate.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM>Resources:</EM><BR /><A href="#" target="_blank" rel="noopener"><SPAN>Microsoft Purview Documentation</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Azure Purview – Dynamic SQL Lineage</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Azure Purview Data Bricks Solution Accelerator</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Microsoft/Azure Purview Quickstart video series</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Blog posts about Data Governance and Microsoft Purview</SPAN></A></P> <P>&nbsp;</P> <P><EM>About Wolfgang Strasser: </EM></P> <P><SPAN>Wolfgang creates solutions based on the Microsoft Data Platform in his day-to-day job as Data Consultant at cubido business solutions. Either using SQL Server, Azure SQL Database, or Data Lakes, building data models with Power BI and Analysis Services or implementing data analysis solutions - the data landscape is broading every day and used in many different customer projects. </SPAN></P> <P>&nbsp;</P> <P><SPAN>Wolfgang really enjoys to share his knowledge with the community at many national and international events and by publishing blog post on his own blog. For his community work, Wolfgang has been awarded with the Microsoft MVP Award for Data Platform in October 2015.</SPAN></P> <P>&nbsp;</P> <P><EM>About MVPs:</EM><BR />Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real-world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more:<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener noreferrer">https://aka.ms/mvpprogram</A></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;</SPAN><A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A><SPAN>&nbsp;and&nbsp;</SPAN><A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A><SPAN>!</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 26 Jul 2022 16:00:00 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/track-your-data-supply-chain-using-azure-purview-data-exposed/ba-p/3580233 MarisaMathews 2022-07-26T16:00:00Z Backup and Restore your Azure Database for MySQL - Flexible Server workload | Data Exposed https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/backup-and-restore-your-azure-database-for-mysql-flexible-server/ba-p/3578920 <P><SPAN>Imagine coming back after vacationing in Hawaii, all ready to show off the tons of pictures clicked there to friends/family, but only to find your phone malfunctioning. The horror! But thankfully the photos were backed up and you were able to restore them on your new device, all set to bask in the glory of Hawaii all over again. That's the beauty of backup and restore. </SPAN></P> <P>&nbsp;</P> <P><SPAN>Backup and restore is the cornerstone for any enterprise's business continuity and disaster recovery plans. The backup functionality offered by Azure Database for MySQL Flexible Server serves as a doomsday vault safeguarding your data. On the other hand, the restore functionality serves as a life jacket protecting from accidental data deletions and data corruption. In this episode of Data Exposed with Aditi Gupta and Anna Hoffman, learn more about how to use the fastest restore points and geo-redundant backups to fortify your server workloads. Also, get a sneak peek into one of our upcoming feature launches for taking on-demand backups.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM><SPAN class="style-scope yt-formatted-string">Resources:</SPAN></EM></P> <P><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-for-mysql-blog/restore-10x-faster-in-azure-database-for-mysql-flexible-server/ba-p/2895288" target="_blank" rel="noopener"><SPAN>Restore 10x faster in Azure Database for MySQL – Flexible Server - Microsoft Tech Community</SPAN></A></P> <P><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-for-mysql-blog/dial-up-azure-db-for-mysql-flexible-server-disaster-recovery/ba-p/2893965" target="_blank" rel="noopener"><SPAN>Dial-up Azure DB for MySQL Flexible Server disaster recovery plans with geo-backups and geo-restore - Microsoft Tech Community</SPAN></A></P> <P><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-for-mysql-blog/simulate-region-down-disaster-recovery-drills-with-stopped/ba-p/3262699" target="_blank" rel="noopener"><SPAN>Simulate region-down disaster recovery drills with stopped servers - Microsoft Tech Community</SPAN><SPAN>&nbsp;</SPAN></A></P> <P><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-for-mysql-blog/migrate-from-locally-redundant-to-geo-redundant-backup-storage/ba-p/3262461" target="_blank" rel="noopener"><SPAN>Migrate from locally redundant to geo-redundant backup storage for existing flexible servers - Microsoft Tech Community</SPAN></A></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A>&nbsp;and&nbsp;<A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A>!</SPAN></P> Thu, 21 Jul 2022 16:15:21 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/backup-and-restore-your-azure-database-for-mysql-flexible-server/ba-p/3578920 MarisaMathews 2022-07-21T16:15:21Z MS DTC for Azure SQL Managed Instance - extending distributed transaction support (private preview) https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/ms-dtc-for-azure-sql-managed-instance-extending-distributed/ba-p/3576839 <P>Today, Azure SQL Managed Instance supports <A href="#" target="_blank" rel="noopener">cross-instance distributed transactions</A>, meaning that you can run distributed transactions between multiple databases hosted on several managed instances.</P> <P>&nbsp;</P> <P>To extend the set of currently supported scenarios, we are working on enabling managed MS DTC for Azure SQL Managed Instance. This has been one of the&nbsp;<SPAN>top voted asks for Azure SQL Managed Instance on&nbsp;</SPAN><A href="#" target="_blank" rel="nofollow noopener noreferrer">Azure Feedback</A><SPAN>.&nbsp;</SPAN>The scope of this improvement can enable you to run distributed transactions between Azure SQL Managed Instance and other distributed transaction participants and that includes:</P> <UL> <LI>Azure SQL Managed Instance</LI> <LI>SQL Server hosted anywhere</LI> <LI>Relational Database Management Systems</LI> <LI>Other software that can participate in distributed transactions, such as MSMQ.</LI> </UL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SQL MI MS DTC diagram.png" style="width: 661px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/389318i4D7330A74FDE68D6/image-size/large?v=v2&amp;px=999" role="button" title="SQL MI MS DTC diagram.png" alt="SQL MI MS DTC diagram.png" /></span></P> <P>&nbsp;</P> <P>Running distributed transactions in a heterogenous environment can enable you to perform transparent migration of your databases from SQL Server; to entirely or partially migrate or modernize your existing solutions; and develop new applications with complex transactional patterns on Azure SQL Managed Instance.</P> <P>We’re happy to announce managed MS DTC is available today for <STRONG>private preview</STRONG>. It currently requires a new test instance to be created by following specific instructions. The purpose of the private preview is to validate the functionality meets your needs. We are interested in your feedback on the overall experience of running distributed transactions and your applications on managed instance!</P> <P>To participate in the private preview and try out the new functionality, apply by filling out <A href="#" target="_blank" rel="noopener">this form</A>.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Apply for MS DTC for SQL Managed Instance private preview" style="width: 331px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/389319i9449EA6946B2E64D/image-size/large?v=v2&amp;px=999" role="button" title="SQL MI MS DTC apply QR code.png" alt="Apply for MS DTC for SQL Managed Instance private preview" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Apply for MS DTC for SQL Managed Instance private preview</span></span></P> Tue, 19 Jul 2022 18:55:22 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/ms-dtc-for-azure-sql-managed-instance-extending-distributed/ba-p/3576839 sasapopo 2022-07-19T18:55:22Z Announcing the General Availability of premium-series hardware for Azure SQL Managed Instance https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/announcing-the-general-availability-of-premium-series-hardware/ba-p/3576737 <P>We’re excited to announce the general availability for the premium-series hardware generation for Azure SQL Managed Instance.</P> <P>&nbsp;</P> <P>Premium-series hardware generation in Azure SQL Managed instance offer industry-leading performance and price/performance amongst SQL Server cloud database services, providing a perfect platform for you to migrate more of your large database applications to the cloud.</P> <P>&nbsp;</P> <P>We're planning to announce the general availability for the memory optimized premium-series hardware generation in the fall of this year, so stay tuned for more updates.</P> <P>&nbsp;</P> <P><FONT size="6">Introduction</FONT></P> <P>Premium-series hardware generation is based on the latest generation of Intel® Xeon Scalable processors (3rd gen - Ice Lake) and offers more storage and more memory per vCore to meet the needs of your most resource-intensive database workloads.</P> <P>&nbsp;</P> <P>The following table summarizes the key technical details for the new premium-series hardware generations in SQL Managed Instance:</P> <TABLE> <TBODY> <TR> <TD width="133"> <P><STRONG>&nbsp;</STRONG></P> </TD> <TD width="220"> <P>Standard-series (Gen 5)</P> </TD> <TD width="250"> <P>Premium-series</P> </TD> </TR> <TR> <TD width="133"> <P><STRONG>CPU</STRONG></P> </TD> <TD width="220"> <P>Intel® E5-2673 v4 (Broadwell),</P> <P>Intel® SP-8160 (Skylake) and Intel® 8272CL (Cascade Lake) 2.5 GHz processors</P> </TD> <TD width="250"> <P><STRONG>Intel® 8370C (Ice Lake) 2.8 GHz processors</STRONG></P> </TD> </TR> <TR> <TD width="133"> <P><STRONG>Number of vCores</STRONG></P> </TD> <TD width="220"> <P>4-80 vCores</P> </TD> <TD width="250"> <P>4-80 vCores</P> </TD> </TR> <TR> <TD width="133"> <P><STRONG>Memory</STRONG></P> </TD> <TD width="220"> <P>5.1 GB per vCore</P> <P>Max 408 GB per instance</P> </TD> <TD width="250"> <P><STRONG>7 GB per vCore</STRONG></P> <P><STRONG>Max 560 GB per instance</STRONG></P> </TD> </TR> <TR> <TD width="133"> <P><STRONG>Max instance reserved storage</STRONG></P> <P>(depending on the number of vCores)</P> </TD> <TD width="220"> <P>General Purpose: up to 16 TB</P> <P>Business Critical<STRONG>:&nbsp;</STRONG>up to 4 TB</P> </TD> <TD width="250"> <P>General Purpose: up to 16 TB</P> <P><STRONG>Business Critical: up to 5.5 TB</STRONG></P> </TD> </TR> <TR> <TD width="133"> <P><STRONG>vCore price difference</STRONG></P> </TD> <TD width="220"> <P>-</P> </TD> <TD width="250"> <P>+15% over standard-series</P> </TD> </TR> </TBODY> </TABLE> <P><EM>Key characteristics for SQL Managed Instance hardware configurations</EM></P> <P>&nbsp;</P> <P>With the move to General Availability milestone, premium-series hardware generation is now available in most public Azure regions, including regions near you!</P> <P>&nbsp;</P> <P><FONT size="6">Industry-leading performance and value for SQL Server cloud database services</FONT></P> <P>In May of this year, Principled Technologies published a paper comparing the performance and price/performance of Azure SQL Managed Instance and AWS RDS for SQL Server across several database benchmarks. Here's the excerpt from the report:</P> <P>&nbsp;</P> <P><EM>Principled Technologies compared the cost and performance of three instances each of two managed cloud instance services: Azure SQL Managed Instance and Amazon Relational Database Service (RDS) for SQL Server. Across those three sets of instances using three common SQL Server database workloads— two for online transaction processing and one for data analysis—<STRONG>Azure SQL Managed Instance significantly outperformed Amazon RDS. Offering between double and five times the performance depending on the workload, the three </STRONG></EM><STRONG><EM>SQL Managed Instances we tested also offered better overall value, reducing price/performance by as much as 90.3 percent</EM></STRONG><EM>. </EM></P> <P><EM>These three Azure SQL Managed Instances could offer better overall value in two ways. First, their significantly better price/performance ratio shrinks cloud operating costs compared to their competitors in one-to-one comparisons. Second, these SQL Managed Instances could potentially reduce the number of instances an organization has to purchase to handle expected customer loads. </EM></P> <P>&nbsp;</P> <P>For more details, read the full report on <A href="#" target="_blank" rel="noopener">Three Microsoft Azure SQL Managed Instances offered better SQL Server performance and value than their Amazon RDS counterparts</A></P> <P>&nbsp;</P> <P><FONT size="6">Availability of Reserved Instance pricing</FONT></P> <P>We’re planning to provide the Reserved Instance pricing for the premium-series in Azure SQL Managed Instance later this calendar year. This will allow you to further improve the fantastic value you’re getting for your money with Azure SQL Managed Instance.</P> <P>&nbsp;&nbsp;</P> <P>For more details, please see the&nbsp;<A href="#" target="_blank" rel="noopener">SQL Managed Instance pricing page</A>.</P> <P>&nbsp;</P> <P><FONT size="6">Summary</FONT></P> <P>In this article, we introduced the general availability for the new premium-series hardware generation that make Azure SQL Managed Instance a great fit for more of your high-performance and memory-intensive database applications.</P> <P>Next steps:</P> <UL> <LI>Create your first premium-series SQL Managed Instance in one of the supported regions and enjoy the blazing-fast performance for your database workloads!</LI> </UL> <UL> <LI><A href="#" target="_blank" rel="noopener">Get started</A>&nbsp;with SQL Managed Instance with our Quick Start reference guide.</LI> <LI><A href="#" target="_blank" rel="noopener">Learn more</A>&nbsp;about Azure SQL Managed Instance capabilities and premium-series hardware generations</LI> <LI>Read the <A href="#" target="_blank" rel="noopener">report by Principled Technologies</A> comparing the performance and price/perf of Azure SQL Managed Instance and AWS RDS</LI> </UL> Tue, 19 Jul 2022 17:23:14 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/announcing-the-general-availability-of-premium-series-hardware/ba-p/3576737 Vladimir Ivanovic 2022-07-19T17:23:14Z Bringing the power of blockchain to Azure SQL Database and SQL Server with ledger | Data Exposed https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/bringing-the-power-of-blockchain-to-azure-sql-database-and-sql/ba-p/3573429 <P><SPAN>Establishing trust around the integrity of data stored in database systems has been a longstanding problem for all organizations that manage financial, medical, or other sensitive data. Ledger is a new feature in Azure SQL and SQL Server that incorporates blockchain crypto technologies into the RDBMS to ensure the data stored in a database is tamper evident. In this session of Data Exposed with Anna Hoffman and Pieter Vanhove, we will cover the basic concepts of Ledger and how it works, Ledger tables, and digest management, and database verification.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM><SPAN class="style-scope yt-formatted-string">Resources:</SPAN></EM></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Ledger Whitepaper</SPAN><SPAN>&nbsp;</SPAN></A></P> <P><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/ledger-now-generally-available-in-azure-sql-database/ba-p/3379658" target="_blank" rel="noopener"><SPAN>Ledger GA Announcement Blog</SPAN><SPAN>&nbsp;</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Ledger Documentation</SPAN><SPAN>&nbsp;</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Lenovo Case Study</SPAN><SPAN>&nbsp;</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>RTGS Case Study</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Ledger Demo</SPAN></A></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A>&nbsp;and&nbsp;<A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A>!</SPAN></P> Thu, 14 Jul 2022 21:01:07 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/bringing-the-power-of-blockchain-to-azure-sql-database-and-sql/ba-p/3573429 MarisaMathews 2022-07-14T21:01:07Z Resumable restore improves SQL Managed Instance database migrations experience https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/resumable-restore-improves-sql-managed-instance-database/ba-p/3573367 <P>Today we are announcing improvements that 1) Enable resumable database backup restores for Azure SQL Managed Instance in case of impactful system updates, and 2) Removal of the 36 hrs. limitation to hold off system updates once a migration from SQL Server to managed instance has started. These improvements apply to Log Replay Service (LRS), Azure SQL migration extension for Azure Data Studio, and Azure Database Migration Services (DMS).</P> <P>&nbsp;</P> <P><FONT size="4"><STRONG>About LRS</STRONG></FONT></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Log Replay Service (LRS)</A>&nbsp;is our implementation of the SQL Server log shipping to the cloud, and perhaps the most used feature for orchestration of migration jobs from SQL Server 2008-2019 to Azure SQL Managed Instance. LRS infrastructure powers Azure SQL migration extension for Azure Data Studio, and Azure Database Migration Services (DMS). Azure Blob Storage is used as an intermediary to store backup files from SQL Server, and LRS is used to restore these backup files on managed instance in <STRONG>NORECOVERY</STRONG> mode. Customers can add <STRONG>differential</STRONG> and <STRONG>log backups continuously</STRONG> to Azure Blob Storage, and these will be continuously restored on Managed instance. Once the last backup file has been restored, and manual or automated cutover initiated, the migration is complete.</P> <P>&nbsp;</P> <P><FONT size="4"><STRONG>How did it work before</STRONG></FONT></P> <P>&nbsp;</P> <P>When we initially launched LRS service a few years ago, we’ve implemented a limitation that halts all impactful system updates on managed instance for 36 hours. This was made so to prevent the migration jobs from being interrupted. Once 36 hrs. window has expired, and in case there was an impactful system update required, migration jobs would be interrupted and restarted from scratch by design.</P> <P>&nbsp;</P> <P>As managed instance was upgraded to support up to 16TB of data storage in 2021 (increase from 8TB for GP service tier when we originally launched the service), this made it possible for some very large workloads to be migrated. At the same time migrating a very large database of several terabytes to this service tier could go well beyond 36 hrs. due to which our system limitation in interrupting the migration because of the system update could be especially impactful in these cases. In addition, we have also introduced a maintenance window feature that allows scheduling of planned system updates, which provides a predictability of when the planned system updates will be applied.</P> <P>&nbsp;</P> <P><FONT size="4"><STRONG>Improvements introduced</STRONG></FONT></P> <P>&nbsp;</P> <P>With the recent updates to managed instance, we have made <STRONG>restore of backups on General Purpose service tier resumable in case of impactful system updates</STRONG>. Any backup restores in progress on this service tier will be suspended and automatically resumed following a system update. On Business Critical instances, backup restores will be suspended and automatically restarted following a system update. In addition, we have also <STRONG>removed the limitation to hold off impactful system updates</STRONG> for 36 hrs. once LRS migration has started. Customers can use managed instance <STRONG>maintenance window</STRONG> to <STRONG>predictably schedule planned system updates</STRONG>.&nbsp;The upper limit to continuously run a single LRS migration job has now been increased to 30 days.</P> <P>&nbsp;</P> <P><FONT size="4"><STRONG>How does this benefit you</STRONG></FONT></P> <P>&nbsp;</P> <P>This improvement provides the following new benefits:</P> <P>&nbsp;</P> <UL> <LI><STRONG>Improved flexibility</STRONG> <UL> <LI>Backup restores are not interrupted, but are automatically suspended and resumed after impactful system updates on General Purpose managed instance, and restarted after impactful system updates for Business Critical managed instance.</LI> <LI>Planned system updates can be scheduled outside your migration window using the maintenance window feature.</LI> <LI>LRS can run in&nbsp;continuous mode up to 30 days per single database migration job.</LI> </UL> </LI> <LI><STRONG>Improved security</STRONG>&nbsp; <UL> <LI>Critical (non-planned) system updates are applied as soon as available for improved security.</LI> </UL> </LI> </UL> <P>&nbsp;</P> <P><FONT size="4"><STRONG>Considerations and best practices</STRONG></FONT></P> <P>&nbsp;</P> <P>LRS migration in progress being suspended because of a system update might result in longer migration times. To make your migration time more predictable use <A href="#" target="_blank" rel="noopener">maintenance window</A> to configure a specific day/time for the system update to occur. Plan your migration start and completion outside of the scheduled maintenance window.</P> <P>&nbsp;</P> <P>Note that critical system updates, such are security patches, cannot be scheduled within the maintenance window. Although a rare event, deployment of critical system updates will result in prolonged migration times by design.</P> <P>&nbsp;</P> <P><FONT size="4"><STRONG>More choices to migrate to Managed Instance</STRONG></FONT></P> <P>&nbsp;</P> <P>As we are evolving Azure SQL Managed Instance as a fully managed database platform, we are introducing even more options for you to migrate to managed instance. In case that your migration requires databases on managed instance to be accessible in R/O mode as soon the migration has started, if you have a considerably lengthy migration for which maintenance window schedule is not appropriate, or if you require the best possible minimum downtime migration, alternatively consider using our new migration option <A href="#" target="_blank" rel="noopener">MI link</A>.</P> <P>&nbsp;</P> <P><FONT size="4"><STRONG>Closing remarks</STRONG></FONT></P> <P>&nbsp;</P> <P>We hope that our improvements in this space have further improved our services to you. For any comments or feedbacks, use the comments section below, or post your feature request at <A href="#" target="_blank" rel="noopener">Azure Feedbacks</A>.</P> <P>&nbsp;</P> <P>If you find this article useful, please like it on this page and share through social media. To share this article, you can use the Share button below, or this short link:&nbsp;<A href="#" target="_blank" rel="noopener">https://aka.ms/mi-lrs-resumable-restore</A>.</P> Fri, 15 Jul 2022 10:19:41 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/resumable-restore-improves-sql-managed-instance-database/ba-p/3573367 Danimir Ljepava 2022-07-15T10:19:41Z Azure SQL News Update: July 2022 https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-news-update-july-2022/ba-p/3571495 <P>Today Data Exposed goes live at 12PM PT on <A href="#" target="_blank" rel="noopener">LearnTV</A>. Every 4 weeks, we’ll do a News Update. We’ll include product updates, videos, blogs, etc. as well as upcoming events and things to look out for. If you missed the episode, you can find them all at <A href="#" target="_blank" rel="noopener">https://aka.ms/AzureSQLYT</A>. This month we’ll recap all the updates and announcements in the database space for June and July so far.</P> <P>&nbsp;</P> <P>You can read this blog to get all the updates and references mentioned in the show. Here’s the June 2022 update:</P> <P>&nbsp;</P> <P><STRONG>Product updates </STRONG></P> <P>You might think that the month after <A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-news-update-june-2022/ba-p/3451631" target="_blank" rel="noopener">Microsoft Build</A> would be a slow month for releases, but this year that is certainly not the case!</P> <P>Let’s start with Azure SQL Database. In public preview, we announced the ability to <A href="#" target="_blank" rel="noopener">enable new built-in server-level roles</A> in Azure SQL Database for permission management. These built-in server level roles are fixed, meaning they have a set of certain permissions assigned to it that cannot be changed. This is great because the server is a logical concept that previously was complex to manage permissions over the whole server. These roles will also come to SQL Server 2022!</P> <P>&nbsp;</P> <P>Earlier in June, we also announced <A href="#" target="_blank" rel="noopener">Microsoft Purview access policies for Azure SQL Database in public preview</A>. The new access policies feature provides data owners capability to author access policies through Microsoft Purview and then apply them to Azure SQL Database data sources individually or at scale.</P> <P>&nbsp;</P> <P>In general availability (GA) for Azure SQL Database, we announced <A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-database-hyperscale-named-replicas-feature-is/ba-p/3455674" target="_blank" rel="noopener">Named Replicas for Hyperscale</A>. This is an exciting one that allows you to have read scale on the fly with up to 30 read replicas that spin up in minutes. Earlier in the month, we also announced the<A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/announcing-general-availability-ga-of-active-geo-replication-amp/ba-p/3466710" target="_blank" rel="noopener"> GA of geo-replication and auto-failover groups for Hyperscale</A>, which enables transparent cross-region failover of Hyperscale databases.</P> <P>&nbsp;</P> <P>We also have an <A href="#" target="_blank" rel="noopener">interesting update for SQL Server 2016</A> (yes, you read that correctly). The Azure SQL Managed Instance team has released the public preview of the Link feature you’ve probably been hearing so much about in SQL Server 2022, but now supporting SQL Server 2016 so you can connect your instance to Azure SQL Managed Instance. This enables you to offload workloads to a read-only secondary hosted in Azure or migrate to Azure SQL Managed Instance altogether.</P> <P>&nbsp;</P> <P>Finally, and this is more of an in-case-you-missed-it than a true update, we recently released a customer story (and neat video) on Lenovo’s use of Azure SQL Database ledger capabilities. Ledger for Azure SQL Database allows you to take advantage of managed centralized blockchain capabilities very easily. Check out the <A href="#" target="_blank" rel="noopener">customer story and video</A>.</P> <P>&nbsp;</P> <P>On the SQL Server front, there was an important announcement and that is <A href="#" target="_blank" rel="noopener">SQL Server 2012 has reached end of support</A>. Please see the blog to see the four options you have if you find yourself with SQL Server 2012 instances.</P> <P>&nbsp;</P> <P>One more announcement on the governance front includes Microsoft Purview which announced the general availability of Microsoft Purview Data Estate Insights at the beginning of July. Sunetra Virdi from the Purview team came on to tell us about <A href="https://gorovian.000webhostapp.com/?exam=t5/microsoft-purview-blog/microsoft-purview-data-estate-insights-will-be-generally/ba-p/3397528" target="_self">the announcement</A> and how to <A href="#" target="_self">learn more</A>.</P> <P>&nbsp;</P> <P><STRONG>Other database updates</STRONG></P> <P>Starting in 2022 we’re trying to keep you updated on what’s going on with other database services at Microsoft, as we understand that oftentimes you’re using more than one service. Here are the updates I gathered from May 2022.</P> <P>&nbsp;</P> <TABLE width="652"> <TBODY> <TR> <TD colspan="2" width="288"> <P><STRONG>Azure Cosmos DB</STRONG></P> <P><STRONG>&nbsp;</STRONG></P> </TD> <TD width="194"> <P><STRONG>Azure Database for PostgreSQL-Hyperscale (Citus)</STRONG></P> </TD> <TD width="171"> <P><STRONG>Azure Database for MySQL – Flexible Server</STRONG></P> </TD> </TR> <TR> <TD width="139"> <P><A href="#" target="_blank" rel="noopener">Generally available: Improved Try Azure Cosmos DB for free experience</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Public preview: Azure Cosmos DB serverless container storage limit increase to 1TB</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Public preview: Continuous backup enhancements in Azure Cosmos DB</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><STRONG>SQL API</STRONG></P> <P><A href="#" target="_blank" rel="noopener">Generally available: Azure Cosmos DB Core (SQL) API Query Engine improvements</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Public preview: Azure Cosmos DB SQL API Go SDK improvements</A></P> <P>&nbsp;</P> <P>&nbsp;</P> </TD> <TD width="149"> <P><STRONG>MongoDB API</STRONG></P> <P><A href="#" target="_blank" rel="noopener">Public preview: Linux emulator with Azure Cosmos DB API for MongoDB&nbsp;</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Public preview: 16MB limit per document in API for MongoDB&nbsp;</A></P> <P>&nbsp;</P> <P><A href="#" target="_blank" rel="noopener">Public preview: Azure Data Studio MongoDB extension for Azure Cosmos DB</A></P> <P>&nbsp;</P> </TD> <TD width="194"> <P><A href="#" target="_blank" rel="noopener">General availability: Azure Database for PostgreSQL—Hyperscale (Citus) supports PostgreSQL minor versions</A> (11.16, 12.11, 13.7, 14.3)</P> <P>&nbsp;</P> </TD> <TD width="171"> <P><A href="#" target="_blank" rel="noopener">General availability: Azure Advisor support for Azure Database for MySQL - Flexible Server</A></P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Meredith Moore from the Cosmos DB team came on the show to tell us more about the new and improved free experience.</P> <P>&nbsp;</P> <P><STRONG>Videos </STRONG></P> <P>We continued to release new and exciting episodes this month. Here is the list, or you can just see the <A href="#" target="_blank" rel="noopener">playlist</A> we created with all the episodes!</P> <UL> <LI>[SQL Insider Series] Stephen Giles: Azure SQL DB – Automating scale up and down</LI> <LI>[Azure SQL Security] Ido Keshet: Database Protection with Defender for Cloud (Ep. 5)</LI> <LI>[MVP Edition] Ike Ellis: Seven tips in seven minutes for the SQL Developer</LI> <LI>Lior Kamrat: Azure Arc-enabled data services Jumpstart scenarios updates</LI> <LI>[SQL Insider Series] Nadia Ben El Kadi: SQL Migration tools, which one and when?</LI> <LI>[SQL Insider Series] Mike Bhatt: Exporting Azure SQL DB BACPAC file to Azure with Azure Automation</LI> <LI>[MVP Edition] Bjoern Peters: Migrating your database to Azure SQL - Preparation is everything</LI> </UL> <P>We’ve also had some great Data Exposed Live sessions. Subscribe to our <A href="#" target="_blank" rel="noopener">YouTube channel</A> to see them all and get notified when we stream. Here are some of the recent live streams.</P> <UL> <LI>May the 4<SUP>th</SUP> be with Azure SQL (News Updates): this was a Star Wars-themed episode and it was so fun! Check it out for costumes, themed demos and slides, and fun!</LI> <LI>Azure SQL &amp; SQL Server 2022: Intelligent Database Futures</LI> <LI>Azure SQL News Update: 2021 Year in Review</LI> <LI>Welcome to SQL Server 2022 Live!</LI> </UL> <P>&nbsp;</P> <P><STRONG>Blogs </STRONG></P> <P>As always, our team is busy writing blogs to share with you all. Blogs contain announcements, tips and tricks, deep dives, and more. Here’s the list I have of SQL-related topics you might want to check out.</P> <UL> <LI>Azure Blog, data-related <UL> <LI><A href="#" target="_blank" rel="noopener">Microsoft Cost Management updates – June 2022</A>, Michael Flanakin</LI> <LI><A href="#" target="_blank" rel="noopener">See how 3 industry-leading companies are driving innovation in a new episode of Inside Azure for IT</A>, Erin Chapple</LI> <LI><A href="#" target="_blank" rel="noopener">Supporting openEHR with Azure Health Data Services</A>, Matjaz Ladava</LI> <LI><A href="#" target="_blank" rel="noopener">Start skilling on Azure with these helpful guides</A>, Lanna Teh</LI> <LI><A href="#" target="_blank" rel="noopener">Find out why your SQL Server data belongs on Azure</A>, Peter Carlin</LI> <LI><A href="#" target="_blank" rel="noopener">Power hybrid and multicloud environments with Azure Arc data solutions</A>, Peter Carlin</LI> </UL> </LI> <LI>Microsoft SQL Server Blog <UL> <LI><A href="#" target="_blank" rel="noopener">Improve scalability with Buffer Pool Parallel Scan in SQL Server 2022</A></LI> <LI><A href="#" target="_blank" rel="noopener">Introducing the SQL Server 2022 blog series</A></LI> <LI><A href="#" target="_blank" rel="noopener">What's new with SQL Tools</A></LI> <LI><A href="#" target="_blank" rel="noopener">Recapping recent updates to client tools in SQL Server</A></LI> </UL> </LI> <LI>SQL Server Tech Community <UL> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/how-to-enable-and-run-sql-best-practices-assessments-on-multiple/ba-p/3567566" target="_blank" rel="noopener">How to enable and run SQL best practices assessments on multiple SQL Servers on Azure VMs</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/released-scom-management-packs-for-sql-server-rs-as-7-0-38-0/ba-p/3563336" target="_blank" rel="noopener">Released: SCOM Management Packs for SQL Server, RS, AS (7.0.38.0)</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/early-technical-preview-of-jdbc-driver-11-1-2-for-sql-server/ba-p/3535697" target="_blank" rel="noopener">Early technical preview of JDBC Driver 11.1.2 for SQL Server released</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/released-microsoft-data-sqlclient-5-0-preview-3/ba-p/3522399" target="_blank" rel="noopener">Released: Microsoft.Data.SqlClient 5.0 Preview 3</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/hotfix-microsoft-drivers-5-10-1-for-php-for-sql-server-released/ba-p/3518997" target="_blank" rel="noopener">Hotfix: Microsoft Drivers 5.10.1 for PHP for SQL Server Released</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2019-rtm-cu16/ba-p/3508246" target="_blank" rel="noopener">Security Update for SQL Server 2019 RTM CU16</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2019-rtm-gdr/ba-p/3508228" target="_blank" rel="noopener">Security Update for SQL Server 2019 RTM GDR</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2017-rtm-cu29/ba-p/3508211" target="_blank" rel="noopener">Security Update for SQL Server 2017 RTM CU29</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2017-rtm-gdr/ba-p/3508192" target="_blank" rel="noopener">Security Update for SQL Server 2017 RTM GDR</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp3-azure-connect-feature/ba-p/3508169" target="_blank" rel="noopener">Security Update for SQL Server 2016 SP3 Azure Connect Feature Pack GDR</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp3-gdr/ba-p/3508125" target="_blank" rel="noopener">Security Update for SQL Server 2016 SP3 GDR</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp2-cu17/ba-p/3508091" target="_blank" rel="noopener">Security Update for SQL Server 2016 SP2 CU17</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2016-sp2-gdr/ba-p/3508070" target="_blank" rel="noopener">Security Update for SQL Server 2016 SP2 GDR</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2014-sp3-cu4/ba-p/3508051" target="_blank" rel="noopener">Security Update for SQL Server 2014 SP3 CU4</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/security-update-for-sql-server-2014-sp3-gdr/ba-p/3508029" target="_blank" rel="noopener">Security Update for SQL Server 2014 SP3 GDR</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/temporal-encountering-error-13535-data-modification-failed-on/ba-p/3500970" target="_blank" rel="noopener">Temporal: Encountering Error 13535 Data modification failed on system-versioned table...</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/common-criteria-eal4-certification-for-sql19/ba-p/3488142" target="_blank" rel="noopener">Common Criteria EAL4 Certification for SQL19</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/how-it-works-workers-tasks-failed-logins-what-is-my-sql-server/ba-p/3478749" target="_blank" rel="noopener">How It Works: Workers, Tasks, Failed Logins - What is my SQL Server Doing?</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/sql-server-blog/sql-server-2022-public-preview-is-now-available-on-linux/ba-p/3460686" target="_blank" rel="noopener">SQL Server 2022 public preview is now available on Linux.</A></LI> </UL> </LI> <LI>Azure SQL Tech Community <UL> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/restoring-a-sql-managed-instance-database-backup-to-sql-server/ba-p/3556325" target="_blank" rel="noopener">Restoring a SQL Managed Instance database backup to SQL Server 2022 (Private Preview)</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-database-hyperscale-named-replicas-feature-is/ba-p/3455674" target="_blank" rel="noopener">Azure SQL Database Hyperscale Named replicas now GA</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/high-availability-in-azure-sql-mi-business-critical-service-tier/ba-p/3521212" target="_blank" rel="noopener">High Availability in Azure SQL MI: Business Critical service tier</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/gen4-hardware-deprecation-update-impacting-sql-database-sql/ba-p/3500926" target="_blank" rel="noopener">Gen4 hardware deprecation update impacting SQL database, SQL elastic pools and SQL Managed Instance</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/get-up-and-running-faster-with-the-new-post-database-creation/ba-p/3502499" target="_blank" rel="noopener">Get up and running faster with the new post-database creation experience on the Azure Portal</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/announcing-general-availability-ga-of-active-geo-replication-amp/ba-p/3466710" target="_blank" rel="noopener">Announcing General Availability (GA) of Active geo-replication &amp; Auto-failover groups for Hyperscale</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/migrate-amazon-rds-for-sql-server-to-azure-sql-managed-instance/ba-p/3464489" target="_blank" rel="noopener">Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance – Part 3 (Azure Data Factory)</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/user-assigned-managed-identity-umi-in-azure-ad-for-azure-sql/ba-p/3457113" target="_blank" rel="noopener">User-assigned managed identity (UMI) in Azure AD for Azure SQL</A></LI> </UL> </LI> <LI>Azure SQL DevBlog <UL> <LI><A href="#" target="_blank" rel="noopener">Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022 </A></LI> </UL> </LI> <LI>Azure Database Support (SQL-related posts) <UL> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-222-hands-on-labs-configure-troubleshoot-linked/ba-p/3570278" target="_blank" rel="noopener">Lesson Learned #222:Hands-On-Labs: Configure/Troubleshoot Linked Server Azure SQL Managed Instance </A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-221-hands-on-labs-activity-monitor-in-my-azure/ba-p/3569289" target="_blank" rel="noopener">Lesson Learned #221:Hands-On-Labs: Activity Monitor in my Azure SQL Managed Instance</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-220-hands-on-labs-activity-monitor-in-my-elastic/ba-p/3569140" target="_blank" rel="noopener">Lesson Learned #220:Hands-On-Labs: Activity Monitor in my Elastic Database Pool </A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-219-hands-on-labs-what-do-i-need-to-do-in-case-of/ba-p/3568139" target="_blank" rel="noopener">Lesson Learned #219:Hands-On-Labs: What do I need to do in case of high CPU wait time</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-218-hands-on-labs-what-do-i-need-to-do-in-case-of/ba-p/3567043" target="_blank" rel="noopener">Lesson Learned #218:Hands-On-Labs: What do I need to do in case of high LOG_RATE_GOVERNOR wait time</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-217-hands-on-labs-40197-the-service-has/ba-p/3566124" target="_blank" rel="noopener">Lesson Learned #217:Hands-On-Labs:40197-The service has encountered an error processing your request</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-216-hands-on-labs-how-redirect-connection-policy/ba-p/3565043" target="_blank" rel="noopener">Lesson Learned #216: Hands-On-Labs: How redirect connection policy type works</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-215-hands-on-labs-communication-link-failed-error/ba-p/3565011" target="_blank" rel="noopener">Lesson Learned #215: Hands-On-Labs: Communication link failed error message using ODBC.</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-214-hands-on-labs-how-to-manage-an-idle/ba-p/3564453" target="_blank" rel="noopener">Lesson Learned #214: Hands-On-Labs: How to manage an idle connection state issue</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-213-cannot-set-the-accesstoken-property-if-the/ba-p/3563343" target="_blank" rel="noopener">Lesson Learned #213: Cannot set the AccessToken property if the Integrated Security has been set</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-212-hands-on-labs-tcp-provider-the-semaphore/ba-p/3560990" target="_blank" rel="noopener">Lesson Learned #212: Hands-On-Labs:TCP Provider: The semaphore timeout period has expired</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-211-monitoring-sqlpackage-import-process/ba-p/3556382" target="_blank" rel="noopener">Lesson Learned #211: Monitoring SQLPackage Import Process</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/sql-server-performance-upper-and-lower-functions-and-database/ba-p/3553406" target="_blank" rel="noopener">SQL Server Performance: Upper and Lower functions and Database collation.</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/azure-sql-connectivity-error-10060-example-a-dns-resolution/ba-p/3553223" target="_blank" rel="noopener">Azure SQL connectivity error 10060 example : a DNS resolution issue.</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-210-hands-on-labs-a-transport-level-error-has/ba-p/3551590" target="_blank" rel="noopener">Lesson Learned #210: Hands-On-Labs:A transport-level error has occurred when receiving results.</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-209-hands-on-labs-10928-resource-id-1-the-request/ba-p/3551517" target="_blank" rel="noopener">Lesson Learned #209: Hands-On-Labs:10928-Resource ID:1.The request limit for the database is reached</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-208-hands-on-labs-10928-resource-id-2-the-session/ba-p/3551442" target="_blank" rel="noopener">Lesson Learned #208: Hands-On-Labs:10928-Resource ID:2.The session limit for the database is reached</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-207-hands-on-labs-40613-database-xyz-on-server/ba-p/3551405" target="_blank" rel="noopener">Lesson Learned #207: Hands-On-Labs: 40613-Database ‘xyz' on server ‘xyz2' is not currently available</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-206-hands-on-labs-the-timeout-period-elapsed/ba-p/3551382" target="_blank" rel="noopener">Lesson Learned #206: Hands-On-Labs: The timeout period elapsed prior to obtaining a connection</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/lesson-learned-205-best-practices-connecting-to-azure-sql/ba-p/3551299" target="_blank" rel="noopener">Lesson Learned #205: Best Practices connecting to Azure SQL Database and Managed Instance</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/how-to-restore-database-using-ltr-backups-with-powershell/ba-p/3518289" target="_blank" rel="noopener">How to restore database using LTR backups with PowerShell</A></LI> <LI><A href="https://gorovian.000webhostapp.com/?exam=t5/azure-database-support-blog/learning-from-expertise-10-why-no-restore-point-available/ba-p/3482699" target="_blank" rel="noopener">Learning from Expertise#10: Why no restore point available?!</A></LI> </UL> </LI> </UL> <P>&nbsp;</P> <P><STRONG>Events</STRONG></P> <P>We have several in-person and virtual events coming this month. Here are a few to put on your calendar and register for from the Azure Data team:<BR /><BR /><STRONG>July 19:</STRONG> <A href="#" target="_blank" rel="noopener">Microsoft Inspire, Virtual</A><BR /><STRONG>August 8-12</STRONG><A href="#" target="_blank" rel="noopener"><STRONG>:</STRONG> Visual Studio Live!, Microsoft HQ</A><BR /><STRONG>September 19-22:</STRONG> <A href="#" target="_blank" rel="noopener">Data Platform Summit, Virtual</A><BR /><BR />And, if you can’t make it to our events, find new, on-demand Data Exposed episodes released every Thursday at <A href="#" target="_blank" rel="noopener">https://aka.ms/dataexposedyt</A></P> <P>&nbsp;</P> <P><STRONG>Microsoft Learn module of the month</STRONG></P> <P>For this month, since Meredith came on to tell us how to get started with Cosmos DB, I wanted to highlight a module <A href="#" target="_blank" rel="noopener">Explore fundamentals of Azure Cosmos DB.</A> In this module, you’ll learn how Azure Cosmos DB provides a highly scalable store for non-relational data. After the module, you’ll be able to describe key features and capabilities, identify the APIs supported, and provision and use an Azure Cosmos DB instance. Check it out.</P> <P>&nbsp;</P> <P><STRONG>Anna’s pick of the month!</STRONG></P> <P>My pick of the month is a special episode of MVP Edition with Ike Ellis, <A href="#" target="_blank" rel="noopener">Seven tips in seven minutes for the SQL Developer</A>. If you use SSMS at all for anything, you do not want to miss this episode. Ike showed us so many tips and tricks that I had never seen before, leaving my jaw dropped and I had to watch it back a couple of times after. Don’t miss the free tips.</P> <P>&nbsp;</P> <P><STRONG>Until next time… </STRONG></P> <P>That’s it for now! Be sure to check back next month for the latest updates on <A href="#" target="_blank" rel="noopener">LearnTV</A>. We also release new episodes on Thursdays at 9AM PT and new #MVPTuesday episodes on the last Tuesday of every month at 9AM PT at <A href="#" target="_blank" rel="noopener">aka.ms/DataExposedyt</A>.</P> <P>&nbsp;</P> <P>Having trouble keeping up? Be sure to follow us on twitter to get the latest updates on everything, <A href="#" target="_blank" rel="noopener">@AzureSQL</A>.</P> <P>&nbsp;</P> <P>We hope to see you next time, on Data Exposed :)</img></P> <P>--Anna and Marisa</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 19 Jul 2022 17:44:47 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-news-update-july-2022/ba-p/3571495 Anna Hoffman 2022-07-19T17:44:47Z Securing supply chain systems with ledger in Azure SQL: Lenovo's story https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/securing-supply-chain-systems-with-ledger-in-azure-sql-lenovo-s/ba-p/3568969 <P>Supply chains are all about coordination among multiple (often disparate) participants and processes to deliver a complex product. Hence the success of a supply chain depends in part on the collaboration among the participants which requires trust in each other’s operations. A breakdown of the integrity of the supply chain can compromise the final product and have <SPAN>damaging operational, financial and brand consequences.&nbsp;</SPAN></P> <P>&nbsp;</P> <P>Some organizations are turning to distributed blockchain technologies to ensure the integrity in their supply chain systems. However, due to their distributed nature, blockchains&nbsp;are complex, introduce completely new programming languages and platforms, offer limited data management capabilities, and poor performance.​ Many supply chain systems use centrally managed data, and a distributed infrastructure of a blockchain is a heavyweight solution for such systems.</P> <P>&nbsp;</P> <P><STRONG>Ledger</STRONG> in Azure SQL brings the benefits of blockchains to relational databases, which are much easier and cheaper to deploy and maintain, provide rich data management capabilities, offer much better performance, and are more environmentally friendly, compared to distributed blockchain technologies.&nbsp;Ledger cryptographically links the current and historical data in a blockchain structure, to make the data tamper-evident and verifiable.​</P> <P>&nbsp;</P> <P>Ledger provides a great solution to ensure integrity in supply chain systems that use centrally managed data, allowing business partners to independently verify data integrity. One of the customers using ledger to reinforce the security of their supply chain is <STRONG>Lenovo</STRONG>.&nbsp;</P> <P>&nbsp;</P> <P>Watch the below video and read <A href="#" target="_blank" rel="noopener">Lenovo's case study</A> to learn more.</P> <P>&nbsp;</P> <P><IFRAME src="https://videos.microsoft.com/customer-stories/watch/xEenNHQerYdRyYqwdYLyXi" width="800" height="685"></IFRAME></P> <P>&nbsp;</P> <P>To learn more about ledger:</P> <UL> <LI>Explore the Azure SQL Database ledger<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener noreferrer">documentation</A></LI> <LI>Read the<SPAN>&nbsp;ledger&nbsp;</SPAN><A href="#" target="_blank" rel="noopener noreferrer">whitepaper</A></LI> <LI>Try the ledger&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">demo/sample</A>&nbsp;at GitHub</LI> <LI>Watch the <A href="#" target="_blank" rel="nofollow noopener noreferrer">Data Exposed episode (video) on ledger</A></LI> <LI>Listen to<SPAN>&nbsp;</SPAN><A href="#" target="_blank" rel="noopener nofollow noreferrer">the ledger podcast</A></LI> </UL> <P>&nbsp;</P> Tue, 19 Jul 2022 15:25:02 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/securing-supply-chain-systems-with-ledger-in-azure-sql-lenovo-s/ba-p/3568969 Jakub Szymaszek 2022-07-19T15:25:02Z SQL Insider Series: Azure SQL DB – Automating scale up and down | Data Exposed https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/sql-insider-series-azure-sql-db-automating-scale-up-and-down/ba-p/3560334 <P><SPAN>In this episode of Data Exposed: SQL Insider Series, Stephen Giles and Anna Hoffman will take a look at how to use Transact SQL and various methods to automate the Scaling of Azure SQL Databases.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM><SPAN class="style-scope yt-formatted-string">Resources:</SPAN></EM></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Job automation with SQL Agent jobs - Azure SQL Managed Instance</SPAN><SPAN>&nbsp;</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Scale resources - Azure SQL Database</SPAN><SPAN>&nbsp;</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Single database vCore resource limits - Azure SQL Database</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Job automation with SQL Agent jobs - Azure SQL Managed Instance</SPAN><SPAN>&nbsp;</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>SQL Insider Series Playlist</SPAN></A></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A>&nbsp;and&nbsp;<A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A>!</SPAN></P> <P>&nbsp;</P> Thu, 07 Jul 2022 16:00:00 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/sql-insider-series-azure-sql-db-automating-scale-up-and-down/ba-p/3560334 MarisaMathews 2022-07-07T16:00:00Z Azure SQL Security: Database Protection with Defender for Cloud (Ep. 5) | Data Exposed https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-security-database-protection-with-defender-for-cloud/ba-p/3555110 <P><SPAN>In this episode of Data Exposed with Anna Hoffman and Ido Keshet, learn about how defender for SQL (and defender for cloud) can address the top security concerns. We’ll introduce Defender for Cloud, and then focus on Defender for SQL – how it works, what does it protects, and announce the upcoming AWS/GCP support.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM><SPAN class="style-scope yt-formatted-string">Resources:</SPAN></EM></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Introduction to Microsoft Defender for SQL</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener">Defender for Cloud trial</A></P> <P><SPAN>To watch more episodes in the Azure SQL Security series, click <A href="#" target="_blank" rel="noopener">here</A>.</SPAN></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A>&nbsp;and&nbsp;<A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A>!</SPAN></P> <P>&nbsp;</P> Thu, 30 Jun 2022 16:00:00 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-security-database-protection-with-defender-for-cloud/ba-p/3555110 MarisaMathews 2022-06-30T16:00:00Z Seven tips in seven minutes for the SQL Developer | Data Exposed: MVP Edition https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/seven-tips-in-seven-minutes-for-the-sql-developer-data-exposed/ba-p/3554630 <P><SPAN>Come learn seven quick tips that will make you a better SQL developer in this episode of Data Exposed: MVP Edition with Anna Hoffman and Ike Ellis. Whether you use SSMS or Azure Data Studio, you will find value in this session. In seven minutes, you'll learn tips to be a more productive developer.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM>About Ike Ellis: </EM></P> <P><SPAN>Ike Ellis is the General Manager of the Data + AI practice at Solliance. He leads a team of data engineers, data scientists, data architects, and data analysts. He’s been a Microsoft MVP since 2011. He co-leads the Data Engineering – San Diego Meetup and the San Diego Power BI User Group. He’s spoken at PASS Summit, SQL Bits, SQL in the City, TechEd, and the Microsoft Azure + AI Conference. Ike is a data professional who enjoys learning, teaching, and implementing a wide variety of data solutions. Follow him on <A href="#" target="_blank" rel="noopener">Twitter</A> and catch his <A href="#" target="_blank" rel="noopener">YouTube videos</A>.</SPAN></P> <P>&nbsp;</P> <P><EM>About MVPs: </EM></P> <P><SPAN>Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more:&nbsp;<A href="#" target="_blank" rel="noopener">https://aka.ms/mvpprogram</A></SPAN></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A>&nbsp;and&nbsp;<A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A>!</SPAN></P> Tue, 28 Jun 2022 16:00:00 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/seven-tips-in-seven-minutes-for-the-sql-developer-data-exposed/ba-p/3554630 MarisaMathews 2022-06-28T16:00:00Z Restoring a SQL Managed Instance database backup to SQL Server 2022 (Private Preview) https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/restoring-a-sql-managed-instance-database-backup-to-sql-server/ba-p/3556325 <P>Restoring a backup file is the easiest way to copy a SQL Server database to another instance. It allows you to create a copy of your production database for easier troubleshooting or debugging of an issue, to provide a copy of a database to your end users or eligible third parties, or as a light-weight business continuity/disaster recovery solution to restore functionality on another instance of SQL Server. These are just a few use cases, and the list is much longer and there are some very inventive ways of using backup-restore in the wild.</P> <P>&nbsp;</P> <P>This article explains the challenges of cross-release restore to an older version of SQL engine and announces the private preview of a capability to restore a backup of a database taken from Azure SQL Managed Instance to instance of SQL Server 2022.&nbsp;</P> <P>&nbsp;</P> <H2>Why a backup from a newer release of SQL Server cannot be restored to an older release</H2> <P>The challenge with restoring backups is that earlier version of SQL engine cannot understand the internal format of backup file taken from the SQL Server instance with the newer version of SQL engine. There are new internal structures, new fields in the existing internal structures, or new values for the existing fields that older version of SQL engine simply doesn’t know how to deal with. For example, this is the error message you will get when you try to restore a backup file taken on SQL Server 2017 to an instance of SQL Server 2016:</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD width="100%">The database was backed up on a server running version 14.0.1000.169. That version is incompatible with this server, which is running version 13.00.1601.5</TD> </TR> </TBODY> </TABLE> <P>Minor version numbers in the error message may vary based on the cumulative update (CU) and/or Service Pack (SP) installed on the instance, but the outcome will be the same. The same will happen with any other two releases of SQL Server if source instance is on the higher release and hence major version number than the destination instance. Note though that having two servers with the <EM>same release</EM>, say SQL Server 2016 marked with major version number 13, and <EM>different CUs</EM> meaning <EM>different minor version numbers</EM>, will not result in the error message – you will be able to perform restore of backup file.</P> <P>&nbsp;</P> <H2>What about restoring backups from Azure SQL Managed Instance</H2> <P>The same happens with Azure SQL Managed Instance as a source and any RTM release of SQL Server as a destination. That’s because Managed Instance service is being upgraded almost continuously and <EM>most of the time</EM> it contains newly introduced SQL engine features and newer internal format compared to the latest available RTM release of SQL Server. The situation is slightly different with CTP releases of SQL Server vNext since they are published approximately every month and can have the same or newer version compared to Managed Instance. There are alternative mechanisms to copy or move a managed instance database described in the earlier <A href="https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/moving-databases-from-azure-sql-managed-instance-to-sql-server/ba-p/2335297" target="_blank" rel="noopener">blog post</A>, but backup-restore is still the most comfortable way and one of the top voted features for Azure SQL Managed Instance service on <A href="#" target="_blank" rel="noopener">Azure Feedback</A> at the time of writing this article.</P> <P>&nbsp;</P> <P>The introduction of a new major release of SQL Server happens once in few years and it is the time when the internal SQL engine versions of Managed Instance and SQL Server are closest or even identical. The latest such an event happened very recently with SQL Server 2022 public preview <A href="#" target="_blank" rel="noopener">announced</A> back in May. That opens an opportunity to align the SQL engine version of a managed instance with SQL Server 2022 engine version and keep them <EM>close enough</EM> as time goes by so that backup-restore can work in both directions. Keeping the versions harmonized requires some extra steps on the service side, which means that particular managed instance should be marked appropriately. Such an instance keeps receiving patches, fixes, and a subset of functional improvements, but its SQL engine version doesn’t diverge irrevocably through the service upgrades impacting internal engine structures.</P> <P>&nbsp;</P> <H2>Announcing private preview</H2> <P>We’re happy to announce that the option of restoring a full copy-only backup taken from Azure SQL managed instance to instance of SQL Server 2022 is now available for private preview. It currently requires a new test instance to be created by following specific instructions.</P> <P>The purpose of the private preview is to validate that the functionality meets your needs. Taking a copy-only backup and restoring it is a rather simple procedure, but we are interested in your feedback on the overall experience, handling of Transparent Data Encryption (TDE) data protection at rest, or any edge cases specific to your database and workload that you may come up with. To claim that database is successfully copied or moved, it’s not enough to restore the database backup without any error message. It’s crucial that your application/solution continues operating as expected once repointed to the restored database(s).</P> <P>&nbsp;</P> <P>If you are interested in trying out the functionality, please review the <A href="#" target="_blank" rel="noopener">private preview onboarding instructions</A> to learn more and sign up for the preview.</P> Tue, 05 Jul 2022 22:23:10 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/restoring-a-sql-managed-instance-database-backup-to-sql-server/ba-p/3556325 Mladen Andzic 2022-07-05T22:23:10Z Azure Arc-enabled data services Jumpstart scenarios updates | Data Exposed https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-arc-enabled-data-services-jumpstart-scenarios-updates-data/ba-p/3545677 <P><SPAN>In this episode of Data Exposed, Anna Hoffman and Lior Kamrat discuss the latest Azure Arc-enabled data services Jumpstart scenarios updates, covering new bootstrap and enterprise-ready Azure Arc-enabled SQL Managed Instance options.</SPAN></P> <P>&nbsp;</P> <P><FONT size="5"><A href="#" target="_blank" rel="nofollow noopener noreferrer">Watch on Data Exposed</A></FONT></P> <P>&nbsp;</P> <P><EM><SPAN class="style-scope yt-formatted-string">Resources:</SPAN></EM></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Azure Arc Jumpstart</SPAN></A><SPAN>&nbsp;</SPAN></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Azure Arc-enabled data services Jumpstart scenarios</SPAN></A></P> <P><A href="#" target="_blank" rel="noopener"><SPAN>Jumpstart ArcBox</SPAN></A></P> <P>&nbsp;</P> <P><SPAN>View/share our latest&nbsp;episodes on&nbsp;<A href="#" target="_blank" rel="noopener noreferrer">Microsoft Docs</A>&nbsp;and&nbsp;<A href="#" target="_blank" rel="noopener nofollow noreferrer">YouTube</A>!</SPAN></P> Thu, 23 Jun 2022 21:56:35 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-arc-enabled-data-services-jumpstart-scenarios-updates-data/ba-p/3545677 MarisaMathews 2022-06-23T21:56:35Z Azure SQL Database Hyperscale - Named Replicas feature is Generally Available (GA) https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-database-hyperscale-named-replicas-feature-is/ba-p/3455674 <P>We are happy to announce General Availability of Named replicas in the Hyperscale tier of Azure SQL Database. We released public preview of this feature in June 2021, since then this feature has been improved and adopted by many customers across industries.</P> <P>&nbsp;</P> <P>Named replicas is an addition to Azure SQL Database Hyperscale to scale-out a variety of read workloads, be it highly concurrent OLTP workloads or HTAP solutions for real-time data analytics.</P> <P>&nbsp;</P> <P><STRONG>Named Replicas uses cases:</STRONG></P> <UL> <LI>Flexibility: Scale-out read workloads to up to 30 read replicas. Each replica can be scaled to different compute size (Service Level Objectives) than primary compute, to cater to dynamic workloads. For example, new replicas can be added, or existing replicas can be scaled-up to cater peak times like end of month processing/sale period, etc and scale down during lean business times.</LI> <LI>Isolation: Multiple application users can work in isolation on their respective named replica as logins/AD group can be granted <A href="#" target="_self">isolated access</A> and dedicated connection endpoint to respective replica.</LI> <LI>Cost savings for read scale-out: Since named replicas share same storage as primary replica, storage cost is saved, and license charge does not apply to named replicas. There are additional cost savings opportunities when named replicas can be scaled down compared to the primary.</LI> <LI>Serve modern application architectures for Analytical workloads including Data Science and Reporting.</LI> </UL> <P>Reference architecture diagram shared below explains utilization of Azure SQL Database Hyperscale for a variety of workloads. Reporting <STRONG>Application 2</STRONG> connects to a named replica having smaller compute size than primary. Another two named replicas are utilized by <STRONG>Application 3</STRONG> for Analytical workloads both scaled to different compute sizes to cater to dynamic workloads.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Attinder_Pal_Singh_1-1654094689892.png" style="width: 700px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/376775i838A05B3E083A2C5/image-dimensions/700x636?v=v2" width="700" height="636" role="button" title="Attinder_Pal_Singh_1-1654094689892.png" alt="Attinder_Pal_Singh_1-1654094689892.png" /></span></P> <P class="lia-align-left lia-indent-padding-left-210px"><U>Hyperscale Reference Architecture</U></P> <P>&nbsp;</P> <P>Named Replicas documentation: <A href="#" target="_blank" rel="noopener">Hyperscale secondary replicas - Azure SQL Database | Microsoft Docs</A></P> <P>Named Replicas FAQs: <A href="#" target="_blank" rel="noopener">Azure SQL Database Hyperscale named replicas FAQ - Azure SQL | Microsoft Docs</A></P> <P>Sample to enable OLTP read scale-out using Named Replicas: <A href="#" target="_blank" rel="noopener">Azure-Samples (github.com)</A></P> <P>Customer Story: <A href="#" target="_blank" rel="noopener">Build fast, scalable data system on Azure SQL Database Hyperscale | Clearent</A></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Attinder_Pal_Singh_0-1654094689860.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/376774iD6FED98ED8BAD53B/image-size/medium?v=v2&amp;px=400" role="button" title="Attinder_Pal_Singh_0-1654094689860.png" alt="Attinder_Pal_Singh_0-1654094689860.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 22 Jun 2022 12:39:34 GMT https://gorovian.000webhostapp.com/?exam=t5/azure-sql-blog/azure-sql-database-hyperscale-named-replicas-feature-is/ba-p/3455674 Attinder_Pal_Singh 2022-06-22T12:39:34Z