Microsoft SQL Server 2025 is coming! SQL 2025 Features, and Azure Arc features

My shirt is from 2013, when I presented at SQL Saturday Rochester

Thanks to AMD and their EPYC processors for sponsoring and having great features that help you run SQL Server faster!

There is a SQL Server 2025 Blog Series for you to keep up.

Here are the big improvements, now in public preview. Most of this is from Microsoft.com learn documentation. At the end, see how Azure Arc can enhance capabilities for on-premises or other-cloud workloads.

AI & Vector Features

New feature or updateDetails
Copilot in SQL Server Management StudioAsk questions. Get answers from your data.
Vector data typeStore vector data optimized for operations such as similarity search and machine learning applications. Vectors are stored in an optimized binary format but are exposed as JSON arrays for convenience. Each element of the vector can be stored either using a single-precision (4-byte) or half-precision (2-byte) floating-point value.
Vector functionsNew scalar functions perform operations on vectors in binary format, allowing applications to store and manipulate vectors in the SQL Database Engine.
Vector indexCreate and manage approximate vector indexes to quickly and efficiently find similar vectors to a given reference vector.

Query vector indexes from sys.vector_indexes. Requires PREVIEW_FEATURES database scoped configuration.
Manage external AI modelsManage external AI model objects for embedding tasks (creating vector arrays) accessing REST AI inference endpoints.

Developer Enhancements

New feature or updateDetails
Change event streamingCapture and publish incremental DML changes of data (such as updates, inserts, and deletes) in near real-time. Change event streaming sends details of data changes such as the schema, previous values, and new values to Azure Event Hubs in a simple CloudEvent, serialized as either native JSON or Avro Binary. Requires PREVIEW_FEATURES database scoped configuration.
Fuzzy string matchingCheck if two strings are similar, and calculate the difference between two strings.
Regular expressionsDefine a search pattern for text with a sequence of characters. Query SQL Server with regex to find, replace, or validate text data.
Regular expressions functionsMatch complex patterns and manipulate data in SQL Server with regular expressions.
External REST endpoint invocationCall REST/GraphQL endpoints from other Azure services from the SQL Database. With a quick call to the system stored procedure sp_invoke_external_rest_endpoint, you can:

– Have data processed via an Azure Function
– Update a Power BI dashboard
– Call a local, in-house enterprise REST endpoint
– Talk to Azure OpenAI Services
JSON data in SQL ServerUse SQL Server built-in functions and operators to:

– Parse JSON text and read or modify values.
– Transform arrays of JSON objects into table format.
– Run any Transact-SQL query on the converted JSON objects.
– Format the results of Transact-SQL queries in JSON format.
– Review examples at: JSON data type: Store JSON in a native binary format.
Batch mode optimizations for built-in functionsPerformance improvements for the following built-in functions:

– Mathematical functions
– DATETRUNC
New Chinese collationsVersion 160 to support GB18030-2022 standard.

New SQL Developer Editions

SQL Server 2025 Standard Developer edition is a free edition licensed for development. It includes all features of SQL Server Standard edition.

  • Develop new applications for Standard edition.
  • Set up a staging environment to certify the upgrade of an existing application from the Standard edition to SQL Server 2025 Standard edition before deploying it in production.

SQL Server 2025 Enterprise Developer edition includes SQL Server Enterprise edition features.

  • Develop new applications for Enterprise edition.

Functionally equivalent to Developer edition in previous versions.

Analytics

New feature or updateDetails
Connect to ODBC data sources with PolyBase on SQL Server on LinuxSupports ODBC data sources for SQL Server on Linux.
Native support for specific source typesPolyBase services no longer required for parquet, Delta, or CSV.
TDS 8.0 support for PolyBaseWhen you use Features of the Microsoft ODBC Driver for SQL Server on Windows for PolyBase, TDS 8.0 is available for SQL Server as an external data source.
PolyBase support for managed identityUse managed identity to communicate to Microsoft Azure Blob Storage and Microsoft Azure Data Lake Storage.

Availability and Disaster Recovery

New feature or updateDetails
Always On availability groups
Availability group asynchronous page request dispatching improvementPerform asynchronous page requests and in batches during failover recovery. Enabled by default.
Allow database to switch to resolving stateAfter a failure to read the persisted configuration data due to network service interruption.
Configure AG group commit wait in millisecondsSet availability group commit time in milliseconds for an availability group replica so that transactions are sent to the secondary replica faster.
Control communication flow for availability groupsA new sp_configure option lets the primary replica determine if the secondary replica falls behind. With the new configuration option, you can optimize communication between HADR endpoints.
Distributed AG support for a contained AGConfigure a distributed availability group between two contained availability groups.
Distributed AG synchronization improvementsImproves synchronization performance by reducing network saturation when the global primary and forwarder replicas are in asynchronous commit mode.
Fast failover for persistent AG health issuesSet the RestartThreshold for an Always On availability group to 0, which tells the WSFC to fail over the availability group resource immediately when a persistent health issue is detected.
Improved health check timeout diagnosticsImproves synchronization performance by reducing network saturation when the global primary and forwarder replicas are in asynchronous commit mode. This change is enabled by default and doesn’t require any configuration.
REMOVE listener IP addressNew parameter in the ALTER AVAILABILITY GROUP Transact-SQL command lets you remove an IP address from a listener without deleting the listener.
Set NONE for read-only or read-write routingWhen configuring READ_WRITE_ROUTING_URL and READ_ONLY_ROUTING_URL, you can set to NONE to revert specified routing by using the ALTER AVAILABILITY GROUP Transact-SQL command to automatically route traffic back to the primary replica.
Configure TLS 1.3 encryption with TDS 8.0Configure TLS 1.3 encryption for communication between the Windows Server Failover Cluster and an Always On availability group replica with TDS 8.0 support.
Always On failover cluster instance
Configure TLS 1.3 encryption with TDS 8.0Configure TLS 1.3 encryption for communication between the Windows Server Failover Cluster and Always On failover cluster instance (FCI) with TDS 8.0 support.
Backups
Back up to immutable blob storageAvailable when backing up to URL.
Back up on secondary replicasIn addition to copy-only backups, you can now also perform full and differential backups on any secondary replica.
Log shipping
Configure TLS 1.3 encryption with TDS 8.0Configure TLS 1.3 encryption for communication between servers in a log shipping topology.

Intelligent Query Processing: Contains various improvements aimed at optimizing query execution and overall database performance.

Query Store Enhancements: Now includes the capability to block problematic queries using ABORT_QUERY_EXECUTION, helping maintain system stability and performance.

Security

New feature or updateDetails
Security cache improvementsInvalidates caches for only a specific login. When security cache entries are invalidated, only those entries belonging to the affected login are affected. This improvement minimizes the impact of non-cache permissions validation for unaffected login users.
OAEP padding mode support for RSA encryptionSupport for certificates and asymmetric keys, adding security layers to encryption and decryption processes.
PBKDF for password hashes on by defaultUses PBKDF2 for password hashes by default, enhancing password security and helping customers comply with NIST SP 800-63b.
Managed identity with Microsoft Entra authenticationCan use the Arc-enabled server managed identity in outbound connections to communicate with Azure resources, and inbound connections for external users to connect to SQL Server. Requires SQL Server enabled by Azure Arc.
Back up to/restore from URL with managed identityBack up to, or restore from, URL with a managed identity. Requires SQL Server enabled by Azure Arc.
Managed Identity support for Extensible Key Management with Azure Key VaultSupported for EKM with AKV and Managed Hardware Security Modules (HSM). Requires SQL Server enabled by Azure Arc.
Create Microsoft Entra logins and users with nonunique display namesSupport for the T-SQL syntax WITH OBJECT_ID when using the CREATE LOGIN or CREATE USER statement.
Support custom password policy on LinuxEnforce a custom password policy for SQL authentication logins on SQL Server on Linux.
Configure TLS 1.3 encryption with TDS 8.0 supportTLS 1.3 encryption added with TDS 8 for the following features:
– SQL Server Agent
– sqlcmd utility
– bcp utility
– SQL Writer service
– Configure usage and diagnostic data collection for SQL Server (CEIP)
– Data virtualization with PolyBase in SQL Server
– Always On availability groups
– Always On failover cluster instances (FCI)
– Linked servers
– Transactional replication
– Merge replication
– Peer-to-peer
– Snapshot replication
– Log shipping

Review Breaking changes.

Database Engine

New feature or updateDetails
Optimized lockingReduces blocking and lock memory consumption, and avoids lock escalation.
tempdb space resource governanceImproves reliability and avoids outages by preventing runaway workloads from consuming a large amount of space in tempdb. Supports percent-based limits.
Accelerated database recovery in tempdbProvides the benefits of accelerated database recovery for transactions in the tempdb database, such as transactions that use temporary tables.
Persisted statistics for readable secondariesCreates persisted statistics on readable secondaries so that workloads that run against secondary replicas are optimized.
Change tracking improvementsAdaptive shallow cleanup improves change tracking auto cleanup performance.
Columnstore improvementsMultiple improvements in columnstore indexes:
– Ordered nonclustered columnstore indexes
– Online index build and improved sort quality for ordered columnstore indexes
– Improved shrink operations when clustered columnstore indexes are present
Memory-optimized container and filegroup removalSupports removal of memory-optimized containers and filegroups when all In-Memory OLTP objects are deleted.
tmpfs support for tempdb on LinuxEnable and run tempdb on tmpfs for SQL Server on Linux.
ZSTD Backup compression algorithmSQL Server 2025 (17.x) Preview adds a faster and more effective backup compression algorithm – ZSTD.
Optimized sp_executesqlEffectively reduce the impact of compilation storms. A compilation storm is a situation where a large number of queries is being compiled simultaneously, leading to performance issues and resource contention. Enable this feature to allow invocations of sp_executesql to behave like objects such as stored procedures and triggers from a compilation perspective.

Allowing batches which use sp_executesql to serialize the compilation process reduces the impact of compilation storms.
Time-bound extended event sessionsAutomatically stops an extended events session after a time limit elapses. This helps avoid situations where sessions might be left running indefinitely by mistake, consuming resources and potentially generating a large amount of data.
PREVIEW_FEATURESDatabase scoped configuration allows you to enable features that are scheduled for general availability after this version of SQL Server releases for general availability. Review these features in release notes.

Query Store and intelligent query processing

The intelligent query processing (IQP) feature family includes features that improve the performance of existing workloads with minimal implementation effort.

Screenshot of Chart representing the features in the intelligent query processing family.
New feature or updateDetails
Cardinality estimation feedback for expressionsLearns from previous executions of expressions across queries. Finds appropriate cardinality estimation (CE) model choices and applies to future executions of those expressions.
Optional parameter plan optimization (OPPO)Leverages the adaptive plan optimization (Multiplan) infrastructure that was introduced with the Parameter Sensitive Plan Optimization (PSPO) improvement, which generates multiple plans from a single statement. This allows the feature to make different assumptions depending on the parameter values used in the query.
Degree of parallelism (DOP) feedbackNow on by default.
Query Store for readable secondariesNow on by default.
ABORT_QUERY_EXECUTION query hintBlocks future execution of known problematic queries, for example nonessential queries affecting application workloads.

T-SQL Language

Lots of new language related to the AI features, JSON, etc.

Linux

Microsoft Fabric Integration: Offers a unified analytics platform that integrates various data and analytics services to streamline operations.

New feature or updateDetails
Mirroring in FabricContinuously replicate data to Microsoft Fabric from SQL Server 2025 on-premises. Microsoft Fabric already includes mirroring from a variety of sources, including Azure SQL Database and Azure SQL Managed Instance. For more information on SQL Server 2025 database mirroring to Fabric, see Mirrored SQL Server databases in Microsoft Fabric.

Starting in SQL Server 2025 (17.x) Preview, on-premises reporting services is consolidated under Power BI Report Server. For more information, see Reporting Services consolidation FAQ.

Discontinued Features

Data Quality Services (DQS) is discontinued in this version of SQL Server. We continue to support DQS in SQL Server 2022 (16.x) and earlier versions.

Master Data Services (MDS) is discontinued in this version of SQL Server. We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.

Synapse Link is discontinued in this version of SQL Server. Use Mirroring in Fabric instead. For more information, see Mirroring in Fabric – What’s new.

Breaking Changes

SQL Server 2025 (17.x) Preview introduces breaking changes to a few SQL Server Database Engine features, such as linked servers, replication, log shipping, and PolyBase.

For more information, see Breaking changes in SQL Server 2025 Preview.

Learn more

Microsoft has Azure Arc to enhance your on-prem or other-cloud capabilities with some Azure features:

Azure Arc for SQL Server 2025 – Key Benefits

FeatureDescription
Centralized ManagementManage all SQL instances (on-prem, edge, multi-cloud) from the Azure portal.
Inventory & InsightsUnified view of versions, editions, and compliance across environments.
Security & GovernanceEntra ID integration for MFA/SSO, apply Azure Policy for consistent security. Extended security updates delivery.
Operational EfficiencyAutomated backups, patching, and best-practice assessments.
Hybrid FlexibilityPay-as-you-go licensing for SQL components (DB Engine, SSAS, SSRS, PBIRS) and centralized view of Licenses
Migration AccelerationContinuous assessments, real-time replication, and Copilot-assisted provisioning.
Azure IntegrationUse Azure Monitor, Defender for Cloud, and other services without moving data.
Learn moreSQL Server enabled by Azure Arc
Azure Arc overview

As always, we have lots of learning resources available to help you!

Posted in AI, Azure, Licensing, Security, SQL Server | Tagged , , , , , , , , , , | Leave a comment

Agentic AI Report — Summer 2025 Update

I had the pleasure of speaking at the nference 2nd agentic AI summit. I am holding the mic 3rd from the left in the above photo. Thank you for that opportunity!

This got me thinking about how to share the way agentic AI leaps from theoretical constructs to enterprise-grade infrastructure. Microsoft has accelerated agent deployment across its ecosystem—building multi-agent systems, domain-specific Copilots (or assistants), and agentic web experiences. Agents are of course front and center across OpenAI, Google, and AWS as well.

In pharma, the strategic calculus involves dramatically faster research cycles. Operations become more efficient if governance, validation, and safety are baked in from the start.

1) Microsoft doubles down on agentic AI leadership

At Build 2025, Microsoft declared the dawn of the “agentic web.” They introduced over 50 new tools. These tools span GitHub, Windows, Azure, and Microsoft 365. They are primed for autonomous collaboration and persistent memory. This includes the GitHub Copilot coding agent and low‑code “Copilot Tuning” for domain‑specific workflows.
(The Official Microsoft Blog, VentureBeat)

2) Multi-agent orchestration gets real

Microsoft unveiled multi-agent orchestration via Copilot Studio, letting agents delegate, collaborate, and co-execute tasks. Complementing this is support for the open Agent2Agent (A2A) protocol—enabling seamless, secure agent communication across clouds and systems.
(Cloud Wars)

3) Platform infrastructure strengthens—MCP, Foundry, Dataverse, and identity

The Model Context Protocol (MCP) is now integral to Copilot Studio and Azure AI Foundry, enabling agents to access enterprise data and services. Microsoft also added Entra Agent ID for governance and traceability, while Dataverse becomes a deep agent data platform.
(Constellation Research Inc.)

4) Agent Factory & Agent Factory series

Microsoft appointed a “CoreAI” leadership team to transform Microsoft into an AI agent factory—a platform where businesses can build autonomous agents using GitHub, Copilot, and Azure. The “Agent Factory” blog series (part 2 published recently) offers design patterns and guidance for building production-grade agents.
(The Verge)

5) Agents in everyday productivity and on the Edge

Microsoft is embedding domain‑specific agents directly into the Microsoft 365 Copilot app. These include Researcher, Analyst, Facilitator, Interpreter, Project Manager, and Employee Self‑Service agents. They are live or in preview within Microsoft 365 Copilot.  I personally find immense value in Researcher (Think, a grad-level assistant), and Analyst (Someone really good at numbers)
(Microsoft Adoption)

Elsewhere, the Edge browser hosts an experimental Copilot Mode, enabling context‑aware browsing and task execution across tabs via natural language.
(Windows Central)

6) Vision of human agent-bosses & personal AI companions

Microsoft envisions a future where every worker becomes an “agent boss.” These workers will manage AI employees that automate tasks with human oversight. This approach facilitates increases in agility and productivity. Simultaneously, Microsoft’s AI head outlined a vision for personal AI companions—remembering interactions, offering visual memory, and driving user-level personalization.
(The Guardian)

7) Pharma adoption accelerates

Viz.ai — Agentic AI — Healthcare Isn’t Waiting. Pharma Can’t Either

This June 18, 2025 article discusses agentic AI systems. These intelligent, proactive assistants are already changing clinical care. Pharmaceutical companies should pay attention. A key quote from a Microsoft Life Sciences expert underscores the growing role of Microsoft in this space:

“HCPs need real-time access to therapeutic information, which is often lacking. AI can bridge this gap by ensuring the right treatment reaches the right patient at the right time.”
 Eunice Youhanna, AI Healthcare & Life Sciences Advisory, Microsoft (viz.ai)

The article frames emerging opportunities for pharma around three categories of AI agents:

  1. Clinical AI Agents — embedding therapies into the moment of care decisions.
  2. Analytics AI Agents — generating real‑time insights into clinical behaviors and patterns.
  3. Activation AI Agents — offering a new engagement pathway to support HCPs with timely education or messaging at the point of care. (viz.ai)

Genentech is using Bedrock AgentCore with Claude 3.5 to automate literature reviews. It is also used for internal data synthesis for biomarker/R&D workflows. This cuts weeks of work into minutes while keeping scientist oversight. IQVIA, in partnership with NVIDIA, is deploying agentic orchestration for clinical and commercialization systems. Regulatory bodies see AI as a “new normal” at meetings like DIA 2025. AstraZeneca is exploring AI‑powered clinical data querying via Bedrock.

Sources:

Posted in AI, Data, Healthcare | Tagged , , , , | Leave a comment

SQL Saturday NYC 2025 Conference, a Success!

Once again, the organizers and volunteers of SQL Saturday NYC created a wonderful experience at the Microsoft Times Square office!

I had the privilege and pleasure of delivering two sessions. One session was on the private preview of SQL Server 2025. My second session covered two areas: MySQL, PostgreSQL, Oracle, and other DBMS choices on Azure, as well as Microsoft Fabric.

The excellence of who organizes and volunteers to speak at SQL Saturdays shines in delivering excellence to the attendees. You can do this too! There is great help from various folks to build these community events.

This year was the first year for a student track! Newcomers welcomed this, and I saw them exclaim how great it was for them.

Later this fall in the northeast, the New England SQL User group will have SQL Saturday Boston in late September. Keep track here or on my Linkedin for announcements.

I love these events, and hope you join the community close to where you live! SQL Saturdays are worldwide!

Looking for demos or more information?

Microsoft Fabric’s YouTube channel is here: https://www.youtube.com/@MicrosoftFabric

For MySQL in Azure,https://www.youtube.com/@MicrosoftDeveloper/search?query=mysql

For PostgreSQL in Azure, https://www.youtube.com/@MicrosoftDeveloper/search?query=postgresql

For Oracle Database in Azure, https://www.youtube.com/watch?v=PnRwvZEPw7s

Posted in AI, Architecture, Azure, Business Intelligence, Conferences, Data, Fun, Open Source, SQL Server, Training, Uncategorized | Tagged , , , | Leave a comment

Key Highlights from Fabric Community Conference 2025

Fabric Community Conference 2025 just finished this past week. There have been a lot of updates since last year when I published this blog: https://george-walters.com/2024/05/10/microsoft-fabric-presentation-and-links-to-help-you/

Please review that blog for the basics around Microsoft Fabric, and how to migrate towards it from Power BI Premium.

This is the official Microsoft Fabric blog showcasing new features: https://www.microsoft.com/en-us/microsoft-fabric/blog/2025/03/31/fabcon-2025-fueling-tomorrows-ai-with-new-agentic-capabilities-and-security-innovations-in-fabric/

One new overarching collection of blogs is by Worldwide Fabric lead Marc Reguera: https://www.linkedin.com/pulse/all-published-blogs-from-fabcon-marc-reguera-raxec/?trackingId=5x7sLKe5%2Bl5fr2JmbIv%2B6Q%3D%3D

Check the Fabric blog frequently for new updates!

Here are some features to notice:

Shortcuts for OneLake

Shortcuts are objects in OneLake that point to other storage locations. The location can be internal or external to OneLake. 

What is new in Shortcuts?

  • Microsoft Fabric shortcuts enable organizations to unify their data. These shortcuts provide integration across various domains and clouds. They achieve this by creating a single virtual data lake.
  • Integration with Azure Key Vault allows secure storage and management of secrets, keys, and certificates for connecting to data sources.
  • OneLake shortcuts support the discovery of Delta and Iceberg tables, simplifying table access and metadata recognition.
  • OneLake shortcuts now support connections to Fabric SQL databases, enhancing data integration.
  • OneLake shortcuts support batch creation through REST APIs, streamlining data connection setup.
  • OneLake shortcuts now support CI/CD workflows, enabling seamless management and deployment of shortcuts across different environments.

Database Mirroring into Onelake

Mirroring in Fabric is a form of CDC to copy data into OneLake tables.

What is new with Mirroring?

Here are the key points from the Microsoft Fabric Community Conference page:

  • Mirroring in Fabric: Enables seamless data replication from any database or data warehouse into OneLake, keeping data up to date in near real-time.
  • Firewall Support: Database Mirroring now supports sources behind a firewall, including Azure SQL Database and Snowflake.
  • PostgreSQL Flexible Server: Mirroring now supports Azure Database for PostgreSQL Flexible Server, allowing continuous replication to OneLake.
  • CI/CD Integration: Mirroring supports CI/CD workflows, enhancing development efficiency and reliability.
  • Workspace Monitoring: Mirroring supports detailed logs and performance metrics for comprehensive monitoring.
  • Schema Replication: Mirroring preserves source database schema hierarchy in the mirrored database.
  • Delta Column Mapping: Supports special characters in table column names for seamless replication.

SQL Database in Fabric

You can spin up a SQL Database inside Fabric!

SQL database in Microsoft Fabric is a developer-friendly transactional database. It is based on Azure SQL Database. A SQL database in Fabric uses the same SQL Database Engine as Azure SQL Database. It is a preview feature and currently has a 4TB size limit.

SQL Database in Fabric also gets a Copilot assistant!

What data store should I use?

Here is a decision guide for whether to store data in the Lakehouse, Warehouse, Eventhouse, SQL Database, or Power BI Data Mart.

Security

Microsoft Fabric is a SaaS platform, like many other Microsoft services such as Azure, Microsoft Office, OneDrive, and Dynamics. All these Microsoft SaaS services including Fabric, use Microsoft Entra ID as their cloud-based identity provider. Microsoft Entra ID helps users connect to these services quickly and easily from any device and any network.

Call to Action:

Enable a trial of Microsoft Fabric, or start by provisioning a F-sku in your Azure subscription.

Posted in AI, Architecture, Azure, Business Intelligence, Data, SQL Server | Tagged , , , , , , , , | Leave a comment

Streamline Compliance with Microsoft Purview Solutions

Microsoft Purview is a suite of solutions that can help your organization govern, protect, and manage data, wherever it lives.

Microsoft Purview provides an integrated solution. It helps tackle the fragmentation of data across organizations. Visibility improves with data protection and governance. It also addresses the blurring of traditional IT management roles.

The three main pillars for Microsoft Purview are Data Governance, Data Security, and Risk and Compliance.

Companies adopt Microsoft Purview for several key reasons:

  • Data Discovery & Classification – Identifies and labels sensitive data across various platforms.
  • Regulatory Compliance – Ensures adherence to regulations like GDPR and HIPAA.
  • Data Loss Prevention (DLP) – Provides alerts for potential data leaks.
  • Insider Risk Management – Detects suspicious employee activities.
  • Unified Data Governance – Centralizes data management across environments.
  • Access & Identity Controls – Limits access to authorized users only.
  • Automated Compliance Reporting – Simplifies report preparation for audits.
  • AI-Powered Insights – Enhances data security and risk management with AI.

Here is a nice video introducing Microsoft Purview.

Doesn’t M365 E5 give me security and governance?

Microsoft 365 E5 is the most advanced productivity & security suite, offering top-tier compliance, security, and analytics tools. Microsoft Purview enhances M365 E5. It provides robust data governance, compliance, and risk management across emails, SharePoint, and Teams. It also benefits other M365 services.

What about Governance with Databricks and Unity Catalog?

It’s important to note that Databricks Unity Catalog is superb at inside-of-databricks data governance and security.

Microsoft Purview integrates with Databricks Unity Catalog to provide centralized data governance, security, and compliance across cloud and data environments.

What about Governance with Microsoft Fabric?

By integrating Microsoft Purview with Microsoft Fabric, organizations can:

  • Ensure full visibility over data in OneLake, Power BI, and beyond.
  • Strengthen security & compliance with automated governance controls.
  • Enable trusted, high-quality data for AI and analytics workloads.

What is the difference between Azure Purview and Microsoft Purview?

Azure Purview and Microsoft Purview are related but distinct in their scope and branding:

Microsoft Purview – In 2022, Azure Purview was rebranded as Microsoft Purview. This change reflects its expanded capabilities beyond just Azure. It also highlights its integration with broader Microsoft security and compliance tools.

Microsoft Purview now combines Azure Purview’s data governance with Microsoft’s compliance solutions. It also integrates risk management tools such as Information Protection, Insider Risk Management, and Data Loss Prevention.

How do I get started?

Azure Purview – This was the original name of Microsoft’s cloud-based data governance solution. It focused on data discovery, classification, lineage tracking, and compliance. These features spanned on-premises, multi-cloud, and SaaS environments.

If you’re not an M365 E5 customer, use the 90-day Microsoft Purview solutions trial. This trial allows you to explore additional Purview capabilities. It can help your organization manage data security and compliance needs. Start now at the Microsoft Purview trials hub. Learn details about signing up and trial terms.

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

SQL Saturdays, and Future Data Driven Summit: Networking and Learning for Data Professionals

For over ten years, I have been volunteering and speaking at SQL Saturdays, which are free, one-day training events for professionals who use the Microsoft data platform.

These events are organized by local communities and Microsoft MVPs around the world and offer a variety of technical sessions on topics such as SQL Server, Azure SQL Database (including postgreSQL, MySQL, Etc), Business intelligence with Power BI, Analytics with Azure Databricks and Fabric, and more.

Most also have a Women in Technology presentation, as well as other career-oriented topics. The value is in networking with other data professionals, who have a helping mindset.

SQL Saturdays are a great way to stay up-to-date with the latest trends and technologies in the data platform world, and they cater to all levels of expertise, from beginners to advanced users.

Where did I present?

Albany, NY!

I had the great opportunity to return to SQL Saturday Albany in August, and to present. The organizers as always are terrific, and the event took place on the UAlbany campus.

Syracuse, NY!

I had the great pleasure of presenting at the first ever SQL Saturday Syracuse in September, at the beautiful Onondega Country Central Library! Analyse Adams was our host and organizer, and the event was well-run and well-received in the central-western NY region!

Boston, MA! or Burlington, MA!

In October, the SQL Saturday Boston event was the most attended as percentage of registrants in history! The Cloud Workshop for the SQL Professional by Bob Ward was well-received on Friday before the main event.

As always, this was well run by the organizers and volunteers!

Virtual Events

I had the pleasure of speaking at the Future Data Driven virtual summit in September, which connected hundreds of people around the world in a multi-track conference! This is a great option for people to connect and learn without needing to travel.

I recommend folks check in on meetup, or on eventbrite, or even facebook for what local events are happening, and how you can get involved, or at least get connected for learning!



Posted in AI, Architecture, Azure, Conferences, Data, SQL Server, Training | Tagged , , , , , , , , | Leave a comment

Microsoft Fabric! Presentation and links to help you!

I presented Microsoft Fabric to the New England SQL User group on May 8th 2024! What a great crowd! If your are local to eastern mass, and do data work with Microsoft products, consider joining!

This content provides a detailed overview of Microsoft Fabric and related terminologies, tutorials, and SKUs.

Here are some of the highlights of the content, and some links to help you dive deeper:

  • Microsoft Fabric: Microsoft Fabric is the data platform for the era of AI, with everything unified, SaaS-ified, secured and governed
  • You can follow a guided tour of Microsoft Fabric — there are many experiences, from data science, to data warehousing, data observability, pipelines, real time analytics, and the well-known Power BI reporting.
  • OneLake is a single SaaS lake for the whole organization, with all data organized in an intuitive hierarchical namespace. The underlying format is Delta on top of Parquet, on Azure storage.
  • There is a Decision Guide to help you formulate when to you which data store, based on use case.
  • Metadata to connect you to other storage, without copying data to Onelake, known as shortcuts, connect you to other cloud storage like S3, Google storage, and Databricks delta lake, and letting you query that data remotely.
  • Copilot in Microsoft Fabric is generative AI for every step of your data journey, unlocking data, enhancing productivity, and accelerating insight discovery. Three experiences exist currently:
  • Partner Ecosystem: Microsoft Fabric has a strong partner ecosystem, with hundreds of partners to help with add on capabilities, or extensions, or system integrators to help you deploy.
  • Microsoft credentials: Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric, DP-600 https://learn.microsoft.com/en-us/credentials/certifications/exams/dp-600/

Fabric Terminology:

  • Capacity: Capacity is a dedicated set of resources that is available at a given time to be used. Capacity defines the ability of a resource to perform an activity or to produce output. Different items consume different capacity at a certain time. Fabric offers capacity through the Fabric SKU and Trials. For more information, see What is capacity?
  • Experience: A collection of capabilities targeted to a specific functionality. The Fabric experiences include Synapse Data Warehouse, Synapse Data Engineering, Synapse Data Science, Synapse Real-Time Analytics, Data Factory, and Power BI.
  • Item: An item a set of capabilities within an experience. Users can create, edit, and delete them. Each item type provides different capabilities. For example, the Data Engineering experience includes the lakehouse, notebook, and Spark job definition items.
  • Tenant: A tenant is a single instance of Fabric for an organization and is aligned with a Microsoft Entra ID (formerly Azure Active Directory ID)
  • Workspace: A workspace is a collection of items that brings together different functionality in a single environment designed for collaboration. It acts as a container that uses capacity for the work that is executed, and provides controls for who can access the items in it. For example, in a workspace, users create reports, notebooks, semantic models, etc. For more information, see Workspaces article.

Microsoft Fabric operates on two types of SKUs:

  • Azure – Billed per second with no commitment.
  • Microsoft 365 – Billed monthly or yearly, with a monthly commitment

Azure SKUs, also known as F SKUs, are the recommended capacities for Microsoft Fabric. You can use your Azure capacity for as long as you want without any commitment. Pricing is regional and billing is made on a per second basis with a minimum of one minute.

Azure capacities offer the following improvements over the Microsoft 365 SKUs.

  • Pay-as-you-go with no time commitment.
  • capacity reservation. This feature allows you to reserve a capacity for a specific period of time, and save money on your Azure bill. A reserved capacity is no longer charged at the pay-as-you-go rates.
  • You can scale your capacity up or down using the Azure portal.
  • You can pause and resume your capacity as needed. This feature is designed to save money when the capacity isn’t in use.
  • Microsoft Cost Management.
  • Azure Monitor Metrics.

The following tutorials walk you through scenarios within specific Fabric experiences.

Tutorial nameScenario
Power BIIn this tutorial, you build a dataflow and pipeline to bring data into a lakehouse, create a dimensional model, and generate a compelling report.
Data FactoryIn this tutorial, you ingest data with data pipelines and transform data with dataflows, then use the automation and notification to create a complete data integration scenario.
Data Science end-to-end AI samplesIn this set of tutorials, learn about the different Data Science experience capabilities and examples of how ML models can address your common business problems.
Data Science – Price prediction with RIn this tutorial, you build a machine learning model to analyze and visualize the avocado prices in the US and predict future prices.
Application lifecycle managementIn this tutorial, you learn how to use deployment pipelines together with git integration to collaborate with others in the development, testing and publication of your data and reports.

Please check the Fabric Blog for more updates!

I hope this material helps you get started! Feel free to reach out to me on LinkedIn if you need help!

Posted in AI, Azure, Data | Tagged , , , , | Leave a comment

The World of AI! GPT! Copilot! Microsoft has it!

A LOT of information has been swirling ever since ChatGPT hit the news!

ChatGPT! Everyone uses it, right? Fastest growing application of all time! ChatGPT is an AI model that uses deep learning to generate human-like text based on prompts from users like you. It works by predicting the next word in a given text, based on the patterns it has learned from a massive amount of data during its training process. Here’s an example:

A prompt to chatGTP asking "Tell me about OpenAI' and a response around the origins of the company OpenAI

Well, what happened since then? In the past 6 months, Microsoft Ignite showcased work on Microsoft products integrating some of these Large Learning Models into Microsoft products.

GPT means Generative Pre-Trained in terms of the AI model. These are Large Learning Models of significant size, generally trained on “much of the internet” for their information contained within.

OpenAI has the mindshare in recent history on these GPT models. There are others, like Amazon’s Bedrock, and Google’s Bard and Salesforce’s Einstein, and Meta’s Llama

Transparency note: I work for Microsoft at the time of this writing.

Microsoft is a 49% investor in OpenAI, and besides investing in OpenAI, also hosts these (and other) models. The Microsoft version of OpenAI are called Azure OpenAI on the Azure cloud. These models on the Azure cloud are bound by the Responsible AI principles. That topic is huge, and in general covers using AI for good, and making sure your data is yours, and your deployment of your model in your Azure tenant is not trained on your data.

These OpenAI Models are being leveraged inside of Microsoft’s product suites to build per-product “Copilots” relevant to those use cases. Why “copilot”? Because you, the human, are still the pilot.

Work Productivity has been shown to increase when leveraging some of these tools within the Microsoft 365 suite of products as well as other Microsoft products. “CoPilot for Microsoft 365” is a set of copilots built for different use cases inside the broad Microsoft 365 experience. Here is a quick video on M365 Copilot. Here is a 56 minute video on a variety of copilot experiences, from office, to sales, to custom copilots.

Think of it this way: Copilots are a way to offload the long tedious work, say to a smart, but inexperienced, human assistant.

“Go build me a powerpoint on Gross Domestic Product for the last 20 years” is an example of a human command. Give that to your new hire or intern, and in a day they come back with something. I used the above prompt in PowerPoint copilot to have it generate a draft, including data, of the request. It took about 30 seconds max. I re-did the prompt, and it actually presented a different view of that information into a different set of slides. Here is an example:

Image of Powerpoint, and Copilot helping build the report. The prompt is "Create a presentation on Generative AI, and focus on Microsoft. Make it Brief.

Inside of Teams, for example, I installed the M365 Chat app. Here is what it says about itself:

M365 Chat

The Microsoft 365 Chat feature in Copilot combines the power of large language models (LLMs) with the intelligence of the Microsoft Graph to help you get things done. If authorized by your organization, you have the option to add plugins for more data sources (like apps and web content) that Copilot will interact with on your behalf. Copilot can synthesize data from multiple sources to give you a summary of things you need to catch up on, including your files, messages, meetings, emails, and people. It can also help you find and use info that’s buried in documents or lost in conversations. And with Copilot by your side, you can create content with it all. Ask a work-related question, or try one of these: – Draft a message with action items from my last meeting – Catch up on my unread email – How do I write a request for proposal? AI-generated content may be incorrect, so sources are provided for your review when possible. Discover more with these helpful links: – [Explore what’s possible with Copilot](https://go.microsoft.com/fwlink/?linkid=2240275) – [See what’s new with Copilot](https://go.microsoft.com/fwlink/?linkid=2239566) – Check out our [FAQ](https://go.microsoft.com/fwlink/?linkid=2238505)Created by Microsoft Corporation

M365 Chat Logo

Here’s what this app can do:

Receive messages and data that I provide to it.

Send me messages and notifications.

Access my profile information such as my name, email address, company name, and preferred language.

Receive messages and data that team members provide to it in a channel.

Send messages and notifications in a channel.

Access this team’s information such as team name, channel list and roster (including team member’s names and email addresses) – and use this to contact them​.

In M365 chat, I can say “Summarize recent emails from coworker” and it will show many in summary form. What a time saver! Here is an example prompt and result. Note: It always gives you links to the source, so you can validate the accuracy. This also works in the mobile version of teams with the M365 chat app installed.

Prompt to M365 Chat: Summarize recent emails from Snowflake.  The chat responded with a list of recent emails in summary form.

That’s pretty good. But have you ever wondered where the approved customer-ready powerpoints are? This is where M365, data labelling, and other features shine, with security. In the following case, I will not show the results because they are Microsoft internal. It did return 5 examples.

M365 Chat prompt: Find powerpoints that are customer-ready on Microsoft fabric and the response on it combing through documents it finds that may be relevant

There are licensing and other requirements for Microsoft 365 Copilot.

Copilots are not just in Microsoft 365. Copilots for Power BI, the new Microsoft Fabric data and ai platform, and more will have prebuilt copilot experiences.

Using the AI-infused Copilot in Dynamics 365 Sales, Avanade reduces workload for sellers with a range of time-saving features.

Keep in mind: These Large Language Models have limitations on accuracy. They are “Creative” and there are settings on “how creative” they should be. You are in charge. You cannot just “copilot and send”. The above m365 chat example which is new, may not always do things in the right order or precision by default. Additional prompt engineering can help with accuracy of results.

For developers who wish to build “Copilots” into their own products, or ISVs who wish to improve their applications similarly can use Azure OpenAI and other Large Language Model-as-a-Service (announced at Microsoft Build in May 2023). You can integrate the latest AI models, such as Llama 2 from Meta and upcoming premium models from Mistral, and Jais from G42, as API endpoints to your applications.

As with other AI platform infrastructure on Azure, you do not need to manage the GPU setup, hardware, patching, or other processes.

To help you train or use or implement the variety of AI, including the above mentioned models, there is Microsoft AI Studio. To Quote: “Your platform for developing generative AI solutions and custom copilots”

Finally for a low code alternative, there is Microsoft Copilot Studio. “Copilot Studio offers graphical development environment to build copilots using generative AI, sophisticated dialog creation, plugin capabilities, process automation, and built-in analytics that work with Microsoft conversational AI tools.”

I encourage you to “Try a demo” in the above website, enter your favorite website with information on it, and ask questions of that. My example would be: http://www.microsoft.com and ask who is the ceo, or president of the board for example. Check this out: My question is on the right.

Image of "Try a demo" in Microsoft Copilot studio. It became the virtual assistant for www.microsoft.com. The prompt is "who is the head of HR" and the response listed shows Kathleen Hogan, Chief People Officer

I hope this information helps, and you can find value in a new way to accelerate your work.

Here is the link to the Ignite Book of news.

After writing most of this blog, I found the “AI Assistant” in WordPress. It gave me tips to improve the content before publishing! I want your input however.

Please let me know if you have any questions, and I encourage feedback!

Posted in AI, Azure, Licensing, Office | Tagged , , , , , | Leave a comment

CDOIQ Symposium at MIT

I have the pleasure of being chosen to staff the Microsoft booth at the CDOIQ Symposium in Cambridge, MA, from July 18-20th! It will take place at the Hyatt Cambridge/Boston Hotel.

I posted on LinkedIn below, and there you can find how to contact me, as well as how to register for this event!

If you are a Chief Data Officer, or aspire to be one, this is a great event for you!

Posted in Architecture, Azure, Conferences, Data | Tagged , , , | Leave a comment

Microsoft Fabric was announced at Build 2023! This is excellent stuff. I recommend you read Matt Roche’s blog below.

With an introduction like that, I should probably remind everyone that this is my personal blog, my personal perspective, and my personal opinions. Although I am a Microsoft employee, I am not speaking for or otherwise representing my employer with this post or anything else on this blog.

Introducing Microsoft Fabric
Posted in Uncategorized | Tagged , | Leave a comment