Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Showing posts with label SQL Server 2022. Show all posts
Showing posts with label SQL Server 2022. Show all posts

Thursday, 16 November 2023

PASS Community Summit 2023 Keynote 1

The PASS Data Community Summit 2023 global data conference is happening in Seattle between 14-17 November 14-17 2023.  



The first keynote 'Limitless growth, limitless opportunities: Data and innovation in an AI world' was given by  Shireesh Thota. He started talking about new technologies and how they offer limitless potential with AI, Generative AI and Real-time capabilities.  The limitiless growth with Azure and those SQL databases: SQL Server, Azure SQL, Postgres, CosmosDB and MySQL. These offer limitless scale, flexible tools, Built-in AI, Performance and Guaranteed availability. 

There are celebrations a foot due to SQL Server on Windows reaching 30 years old this year. SQL Server 2022 is the fastest adopted version of SQL Server with growth on both Windows and Linux. He also mentioned SQL Server enabled by Azure Arc with that cloud manageability for managing your entire SQL Server estate. Announcements were made



Discussions moved to Azure SQL and the family of SQL cloud in edge databases. A further announcement was made about the Azure SQL Managed Instance feature wave , that is now generally available. Azure SQL Managed instance has a free offer in preview for 12 months of free managed instance, available soon.

 What's new in Azure SQL Managed Instance?

They talked about that Cloud Modernization Journey: Evaluate, Optimize, Migrate and Modernize with ease. 

Another announcement Azure SQL Database Hyperscale will be same price as commercial OSS databases – General Available mid December.

Some further to announcements were shared

  • Azure Cosmos DB for MongoDB vCore – Generally Available
  • Vector Search in Azure Cosmos DB for MongoDB vCore – Generally Available 
  • Natural language queries for Azure Cosmos DB – Public Preview
  • Azure Database for PostgreSQL Extension for Azure AI – Preview

Then concluding with the database of the future will be autonomous and intelligent, developer friendly, cost efficient, and mission critical by default.

Thursday, 17 November 2022

Day 1 Keynote PASS Data Community Summit

The day 1 keynote of the first in person PASS Data Community Summit was packed with exciting data platform innovations across SQL Server and the Microsoft Intelligent Data Platform.

The Keynote: Transform your Data Estate with Microsoft's Intelligent Data Platform.







There are many data challenges today within operational database, analytics and intelligence and data governance. 
 


Data officers are a critical role and it is a challenge to use the data right. A lot of governance tools are not fully integrated. 

Analytics is a core part and must be front and centre not a back end tool. Data Governance is more than creating a catalogue, it is hybrid and multi cloud and the volume of data is increasing. Data Governance needs to be deeply embedded.


The big announcement : SQL Server 2022 is generally available


SQL Server 2022 with embedded data governance. All the data management through Microsoft Purview, lineage tracking is very important. 

There is a new SQL Server pay-as-you-go licensing model 


The annoucements

SQL Server 2022 - GA (Generally Available)
New SQL Server pay-as-you-go licensing model
Link feature for Azure SQL Managed Instance
Backup portability with SQL Server 2022
SQL + Apps Migration Factory offer
Azure Cosmos DB for PostgreSQL - GA
Azure Data Factory SAP Change Data Capture Connector -GA
Azure Synapse Mapping Data Flow for M365 Graph -Public Preview
Azure Synapse Link for SQL











The keynote  then switched to data governance



Improved root cause analysis and traceability with SQL Dynamic lineage is GA

Tuesday, 2 November 2021

Ignite Innovate Anywhere From Multicloud to Edge

Innovate Anywhere From Multi-cloud to Edge with Scott Guthrie shares a raft of technical updates. The themes
  • Hybrid and multicloud
  • End-to-end data platform
  • Cloud native development
  • Developer velocity

Hybrid and multicloud updates announced
  • Deeper integration with VMware vSphere and Azure Stack HCI
  • Azure Virtual Desktop on Azure Stack HCI
  • Azure Arc enabled data services updates
  • Extension of Microsoft Defender to AWS
A data platform with end to end capability


SQL Server 2022 was announced




Azure Synapse Analytics announcements
  • Azure Data Explorer
  • Synapse Link SQL Server 2022
  • Synapse Link Dataverse (GA)





Great to see Azure Purview and data governance mentioned everywhere.