SQL Server Events - Microsoft SQL Server Blog http://approjects.co.za/?big=en-us/sql-server/blog/content-type/events/ Official News from Microsoft’s Information Platform Thu, 19 Mar 2026 23:25:47 +0000 en-US hourly 1 http://approjects.co.za/?big=en-us/sql-server/blog/wp-content/uploads/2018/08/cropped-cropped-microsoft_logo_element-150x150.png SQL Server Events - Microsoft SQL Server Blog http://approjects.co.za/?big=en-us/sql-server/blog/content-type/events/ 32 32 FabCon and SQLCon 2026: Unifying databases and Fabric on a single data platform https://azure.microsoft.com/en-us/blog/fabcon-and-sqlcon-2026-unifying-databases-and-fabric-on-a-single-data-platform/ Wed, 18 Mar 2026 12:45:00 +0000 Welcome to the third annual FabCon and our first ever SQLCon here in Atlanta, Georgia. With nearly 300 workshops and sessions, this joint event will highlight how they are bringing the power of Microsoft SQL and Microsoft Fabric together to create a single, unified platform.

The post FabCon and SQLCon 2026: Unifying databases and Fabric on a single data platform appeared first on Microsoft SQL Server Blog.

]]>
Welcome to the third annual FabCon and our first ever SQLCon here in Atlanta, Georgia. With nearly 300 workshops and sessions, this joint event will highlight how they are bringing the power of Microsoft SQL and Microsoft Fabric together to create a single, unified platform. But FabCon 2026 and SQLCon 2026 are about more than product innovation. It’s about providing space for our 8,000 attendees to come together and share real experiences, learn from each other, and solve challenges side-by-side. Only together can we move beyond the hype and into meaningful results.

Learn more about FabCon and SQLCon 2026
The excitement surrounding this event reflects the same momentum we’re seeing across our data portfolio. Just two and a half years after Microsoft Fabric reached general availability, it’s already serving more than 31,000 customers and remains the fastest-growing data platform in Microsoft’s history. Fortune 500 companies like The Coca-Cola Company are already using Fabric at scale across their organizations.

Microsoft Fabric is helping us evolve our data foundation into a more unified, AI-ready platform. Combined with Power BI and capabilities like Fabric IQ, it enables the enterprise to turn data into intelligence and act on it faster.

Shekhar Gowda, Vice President of Global Marketing Technologies at The Coca-Cola Company
Our databases are accelerating just as quickly, with SQL Server 2025 growing more than twice as fast as the previous version.

Today, we’re thrilled to share how we are bringing the power of databases and Fabric together to form a truly converged data platform—one that unifies transactional, operational, and analytical data under a single, consistent architecture. I’ll also highlight how we’ve enhanced Fabric to help you transform data into the semantic knowledge AI needs to understand your business, powered by Fabric IQ and Power BI’s industry-leading semantic model technology.

Introducing the Database Hub in Microsoft Fabric
Databases sit at the heart of the enterprise data estate—a system of record powering applications, transactions, and mission‑critical insights. Yet as organizations scale across cloud, on‑premises, and edge environments, database estates have become increasingly fragmented and isolated. As AI places even greater demands on data estates, unifying databases under a single access point and control plane has become essential.

To address this challenge, Fabric is expanding its role as the central access point for enterprise data with the Database Hub in Fabric, now available in early access. Database Hub in Fabric provides a unified database management experience that brings together databases across edge, cloud, and Fabric into a single, coherent view. Teams now have one place to explore, observe, govern, and optimize their entire database estate—including Azure SQL, Azure Cosmos DB, Azure Database for PostgreSQL, SQL Server (enabled by Azure Arc), Azure Database for MySQL, and Fabric Databases—without changing how each service is deployed.

Built for scale, the Database Hub in Fabric introduces an agent‑assisted, human-in-the loop approach to database management. With built-in observability, delegated governance, and Microsoft Copilot-powered insights, teams can deploy intelligent agents to continuously reason over estate‑wide signals and surface what changed, explain why it matters, and guide teams toward what to do next. The result is a simpler, more confident way to manage databases at scale. Over time, this model enables database estates to become more proactive, resilient, and intelligent, laying the foundation for greater autonomy, while keeping humans firmly in control of goals, boundaries, and trust.

Learn more about Database Hub in Fabric and what’s new across Databases
Bringing databases together under a single management layer is a critical step as you prepare your estates for AI at scale. But it’s not the end of the journey. The challenge shifts from where data lives to how data is understood, connected, and activated across the enterprise.

Getting your data estate ready for AI with Fabric
As organizations move from traditional applications to AI‑powered, multi‑agent systems, the advantage is shifting away from the specific model you deploy. It now lies in the intelligence and context that allow agents to understand how your business is run, the state of your business, and your institutional knowledge to help take meaningful action.

This is the challenge Microsoft IQ is designed to address. Unlike point solutions on the market today, Microsoft IQ provides an intelligence layer that delivers shared, enterprise-grade business context to every agent. That context is built from three complementary sources: productivity signals from Work IQ, institutional knowledge from Foundry IQ, and live business data from Fabric IQ.

However, like the database layer, while the IQ context layer is a critical part of a successful, and healthy AI foundation, it is not the full story. Building a complete AI-ready data foundation requires investing in four core steps:

Unifying your data estate to eliminate silos and reduce architectural complexity.
Processing and harmonizing data so it becomes AI-ready, clean, connected, and structured for both operational and analytical use.
Curating semantic meaning to give agents contextual understanding, enabling them to interpret data the way your teams already do. This is where Microsoft IQ comes into play.
Empowering AI agents to act, applying that context to automate workflows, accelerate decisions, and transform operations end‑to‑end.
Unifying your data estate with Microsoft OneLake
Every AI initiative starts with the same fundamental challenge: understanding where your data lives and how to bring it together. Microsoft OneLake was built to solve that problem by unifying data across clouds, on-premises environments, and third-party platforms into a single logical data lake without unnecessary extracting, transforming, and loading (ETL), fragmentation, or duplicated copies.

Are my agents hunting for data?

Watch the podcast
Connecting to more sources than ever before
Today, we’re expanding Mirroring in Fabric to support even more systems our customers rely on. Mirroring for SharePoint lists and Dremio are now in preview with Azure Monitor coming soon, while mirroring for Oracle and SAP Datasphere are generally available—all of which are available as part of the core mirroring capabilities. We are also introducing extended capabilities in mirroring designed to help you operationalize mirrored sources at scale, including Change Data Feed (CDF) and the ability to create views on top of mirrored data, starting with Snowflake. Extended capabilities for mirroring will be offered as a paid option.

Shortcut transformations are also now generally available, allowing data to be shaped automatically as it connects to or moves within OneLake. You can convert formats such as Excel to Delta tables, now in preview, and apply AI-powered transformations.

Additionally, we are continuing to invest in open interoperability, ensuring OneLake works seamlessly with the platforms organizations already use. We are excited to announce the ability to natively read from OneLake through Azure Databricks Unity Catalog is now in public preview. We also recently announced the general availability of our interoperability with Snowflake.

I’m also excited to share that Auger, a rapidly growing supply chain platform designed to bring intelligence and automation to global operations, has built its platform on Fabric, with all data stored natively in OneLake. This architecture enables Auger customers to seamlessly access their operations data through OneLake shortcuts within their own Fabric environments and use the full power of the platform including Power BI, Fabric data agents, and more. Learn more in my blog, co-authored with Auger Chief Executive Officer Dave Clark.

Protect your data with OneLake security, now generally available
Security and governance remain foundational to OneLake. I’m thrilled to announce OneLake security will be generally available in the coming weeks, enabling data owners to define roles, enforce row- and column-level controls, and manage permissions through a single unified model that follows the data.

To learn more about these announcements, read the OneLake blog and the Fabric Data Factory blog.

Processing and harmonizing data with Fabric analytics
AI agents are only as reliable as the data you feed them. Before data can train or ground an agent, it must be integrated, cleaned, and structured, so the agent operates from consistent, trusted information. With industry-leading engines in Fabric like Spark, T-SQL, KQL, and Analysis Services, we can equip data teams to do exactly that.

Now, we are expanding these capabilities with the introduction of Runtime 2.0 in preview, purpose-built for large-scale data computation. It incorporates Apache Spark 4.x, Delta Lake 4.x, Scala 2.13, and Azure Linux Mariner 3.0 to power advanced enterprise workloads. Materialized lake views are also now generally available, simplifying medallion architecture implementation in Spark SQL and PySpark and enabling always up-to-date pipelines with no manual orchestration. In addition, a new agentic Copilot experience in notebooks delivers deeper context awareness, reasoning over your workspace, and generating code with greater speed and precision.

For real-time scenarios, we’re launching Microsoft Fabric Maps into general availability. Maps add geospatial context to your agents and operations by turning large volumes of location-based data into interactive, real-time visual insights.

For a comprehensive overview of these announcements and much more, read the Fabric Analytics announcement blog and the Fabric Real-Time Intelligence announcement blog.

Creating semantic meaning with Fabric IQ
Preparing raw data for AI is essential. The next step is transforming that data into meaningful, unified business context. That is where Fabric IQ comes in.

Fabric IQ unifies analytical data and operational data, including telemetry, time series, graph, and geospatial data, within a shared semantic framework of business entities, relationships, properties, rules, and actions. Instead of thinking in terms of tables and schemas, your teams and agents can operate on this framework, or ontology, aligned to how the business actually runs.

Fabric IQ ontologies will soon become accessible through an MCP server in preview, enabling agents to discover, understand, and act on this semantic layer. Ontologies can also serve as context sources for maps and soon in operations agents in Fabric, extending shared business context directly into operational decision-making and execution.

We are also excited to announce planning in Fabric IQ, a new enterprise planning capability that enables organizations to create plans, budgets, forecasts, and scenario models directly on top of Fabric’s semantic models. By complementing Fabric IQ’s ontologies with integrated planning, you get a complete, contextual view of your historical, real-time, and forward planning data. This allows users and agents to quickly answer what has happened, what is happening, and what should happen all from a single source. See this in action:

Finally, we recently announced a strategic partnership with NVIDIA to power the next generation of Physical AI by integrating Real-Time Intelligence and Fabric IQ with NVIDIA Omniverse libraries. The combined platform unifies real‑time operational data, business semantics, and physical simulation to enable organizations to optimize their physical operations in scenarios like intelligent digital twins, predictive maintenance, autonomous logistics, and energy optimization.

To learn more about all of our partner announcements, read the Fabric ISV announcement blog and the planning in Fabric IQ blog.

Enhancing the underlying Fabric IQ technology
Powering much of Fabric IQ’s rich experience is a combination of Power BI’s industry-leading, rich semantic model technology and graph in Fabric, our highly scalable graph database. Already delivering insights to more than 35 million active users, semantic models provide the ideal foundation for training agents through Fabric IQ. Now, with the general availability of Direct Lake on OneLake, your tables can be read directly from OneLake with native security enforcement, richer cross-item modeling, and import-class performance without data movement or refresh.

I’m also excited to share that graph in Fabric will be generally available in the coming weeks, enabling teams to visualize and query complex relationships across customers, partners, and supply chains.

To learn more, check out the Fabric IQ announcement blog and the Power BI announcement blog.

Empowering agents to act with Fabric data and operations agents
Frontier organizations are moving beyond general-purpose assistants and instead, adopting multi-agent systems composed of specialized agents. These agents are each grounded on specific data and reusable across different systems, allowing you to deliver more accurate, accelerated, and scalable outcomes.

To support your multi-agent systems, Fabric comes with built-in agent creation capabilities with Fabric data agents and operations agents. I’m excited to share that Fabric data agents are now generally available. Fabric data agents can be thought of as virtual analysts, aligned to specific domain data to support deeper analysis and deliver insights. Operations agents complement them by monitoring real-time data, detecting patterns, and taking proactive action.

Check out a quick demo of operations agents in Fabric:

These agents can be used across Fabric or as foundational knowledge sources in leading AI tools like Microsoft Foundry, Copilot Studio or even Microsoft 365 Copilot. To learn more about our AI announcements, check out the Fabric analytics blog covering data agents and the Fabric IQ blog covering operations agents.

Building mission-critical applications with developer experiences in Fabric
Developers building the next generation of AI applications need a comprehensive, cost-effective data platform that’s already integrated with your existing tools and workflows. Today, we are expanding Fabric’s developer tooling to meet that demand.

First, Fabric Model Context Protocol (MCP) is advancing with two major milestones. Fabric local MCP is now generally available, providing an open-source local server that connects AI coding assistants such as GitHub Copilot directly to Fabric. Alongside this, we’re introducing the public preview of Fabric remote MCP, a secure, cloud‑hosted execution engine that enables AI agents and automation tools to perform authenticated actions in Fabric.

We’re also enhancing our Git integration with selective branching, allowing developers to branch out for a specific feature and pull only the items they need. You also get improved change comparisons to more easily review recent updates, and new folder relationships which show how feature workspaces connect to source workspaces.

We’re also launching two open-source projects to help teams move faster with Fabric: Agent Skills for Fabric and Fabric Jumpstart. Agent Skills for Fabric is an open-source set of purpose-built plugins that let you use natural language in the GitHub Copilot terminal to harness the full power of Microsoft Fabric. Additionally, Fabric Jumpstart is designed to help you get off the ground with detailed guidance, reference architectures, and single‑click deployments for sample datasets, notebooks, pipelines, and reports.

Finally, we are announcing that the Fabric Extensibility Toolkit (FET), an evolution of the Workload Development Kit (WDK), is now generally available. Along with this release, we are enabling support for full CI/CD, variable library, and a new management experience in the Admin portal.

Read the Fabric Platform announcement blog
Migrating your existing Azure service to Fabric
As Fabric continues to grow in functionality, we are also simplifying the migration from other Azure services. In addition to our existing Synapse tooling, we are bringing new migration assistants for Azure Data Factory, Azure Synapse Analytics, and Azure SQL in public preview.

The new Fabric migration assistant for Azure Data Factory and Synapse Analytics helps move your existing pipelines and artifacts like Spark pools and notebooks into Fabric with minimal disruption. It’s designed to support incremental modernization, allowing teams to evaluate, convert, and optimize pipelines as they transition to Fabric. The migration assistant for SQL databases helps move SQL Server into Fabric by importing schemas through DACPACs, identifying and resolving compatibility issues with AI assistance, and guiding teams through assessment and data copy workflows for a smoother cutover.

See more Fabric innovation
Explore the AI shift with The Shift podcast
In addition to the announcements above, we are also rolling out a broad set of Fabric innovations across the platform. For a deeper look at the updates and what’s new this month, visit the Fabric March 2026 Feature summary blog, the Power BI March 2026 feature summary blog, and the latest posts on the Fabric Updates channel.

Explore additional resources for Microsoft Fabric
Sign up for the Fabric free trial. View the updated Fabric Roadmap. Try the Microsoft Fabric SKU Estimator.
Visit the Fabric website. Join the Fabric community. Read other in-depth, technical blogs on the Microsoft Fabric Updates Blog.
Read additional blogs by industry-leading partners
Sonata Software: Building an AI-ready data platform with data agents, ontology, and governance in Microsoft Fabric
Quadrant Technologies LLC: Real-Time Operational Intelligence in Microsoft Fabric: Deep Dive into RTI Capabilities, Anomaly Detection and Activator Alerting
Inspark: Why switch from Azure Synapse to Microsoft Fabric?
Esri: Unlock the power of location intelligence with ArcGIS for Microsoft Fabric
Dream IT Consulting Services: 8 Real-World Use Cases of Data Agents in Microsoft Fabric
UB Technology Innovations Inc.: From Data Platform to Decision Platform: How Microsoft Fabric and Copilot are Redefining Enterprise Analytics
Simpson Associates: Fabric Data Warehouse: Bringing Structure to Modern Data Strategies
Synapx Ltd.: Migrating Power BI to Microsoft Fabric Lakehouse with Medallion Architecture: A Strategic Imperative for Modern Construction Enterprises
Cloud Services: Real-Time Intelligence in Action: How Microsoft Fabric Helped Delfi Transform Its Newsroom
Cloud Services: Microsoft Fabric Data Agents: A New Reality
iLink Digital: Detect to Act in Seconds: How Real-Time Intelligence Is Rewriting the Rules of Emissions Management
Valorem Reply: How Nonprofits Are Rethinking Data with Microsoft Fabric

The post FabCon and SQLCon 2026: Unifying databases and Fabric on a single data platform appeared first on Microsoft SQL Server Blog.

]]>
Advancing agentic AI with Microsoft databases across a unified data estate http://approjects.co.za/?big=en-us/sql-server/blog/2026/03/18/advancing-agentic-ai-with-microsoft-databases-across-a-unified-data-estate/ Wed, 18 Mar 2026 12:45:00 +0000 Built on a consistent Microsoft SQL foundation from on premises to the cloud, Azure SQL brings AI capabilities directly into your database experience.

The post Advancing agentic AI with Microsoft databases across a unified data estate appeared first on Microsoft SQL Server Blog.

]]>
This week, we are excited to kick off SQLCon 2026 alongside FabCon in Atlanta. Bringing these SQL and Fabric communities together creates a unique opportunity to learn, connect, and share what’s next across the Microsoft databases portfolio.

This year is especially meaningful, as it marks the return of a Microsoft‑led SQL community event, while also showcasing how SQL continues to evolve as a critical part of Fabric. It is not just about new technology, but about reconnecting with each other and building the future of SQL together.

It’s inspiring to see the Microsoft SQL community continue to grow and engage, with user groups worldwide keeping conversations active across the SQL portfolio and a lot of customers using Microsoft SQL to innovate every day. With a comprehensive portfolio built on strategic common foundations and available across edge, PaaS, and SaaS, Microsoft databases form a unified platform for modern enterprise needs, whether you are migrating and modernizing, building cloud-native AI applications, or unifying your data.

Migrate and modernize with Azure SQL

Many of our customers are not modernizing in one big leap. You are evolving from SQL Server to hybrid and then to cloud services, and you want that journey to feel familiar, predictable, and low risk. That is exactly what Azure SQL is designed to deliver. Built on a consistent Microsoft SQL foundation from on premises to the cloud, Azure SQL brings AI capabilities directly into your database experience, along with enterprise‑grade security, high availability, and the flexibility to scale as your needs grow. Azure SQL is fully SQL compatible, delivers strong performance and low latency, and supports hybrid scenarios through Azure Arc.

AI agents are becoming an important accelerator for database migration and modernization at Microsoft, helping our customers reduce manual effort and move faster with more guided experiences across the journey. The general availability of GitHub Copilot in SSMS 22 is a great example of that investment in action: you can use the same GitHub Copilot experience you already use in Visual Studio and VS Code, now inside SQL Server Management Studio (SSMS), with chat and code assistance that helps you write, edit, and refactor T‑SQL more quickly and confidently. Whether you are a developer or database administrator (DBA), new to SQL or highly experienced, GitHub Copilot can support common workflows like improving queries and assisting with troubleshooting and administration tasks right where you work, and we are continuing to expand what it can do.

Today we are announcing savings plan for databases, a flexible, spend-based pricing option that helps you save up to 35%1 vs. pay-as-you-go prices on a one-year commitment. Savings plan for databases is designed for modern, evolving database environments: Customers commit to a fixed hourly spend for one year and receive lower prices across eligible Azure database services. Savings are automatically applied to the highest-value usage each hour, helping reduce costs while supporting migration, modernization, and architectural change.

Build cloud-native AI apps at scale

Once you move to the cloud, the questions shift. How do you build faster, scale smarter, and unlock more value from your data without re‑architecting everything you have already built? That is where Azure SQL Database Hyperscale comes in.

With Azure SQL Database Hyperscale, customers gain better price-performance, elastic scale and resilience for any workload, without the cost or disruption of rewriting T‑SQL or reworking operational models. Its unique architecture, built on shared storage and multiple replicas, allows you to scale reads independently from writes. With built‑in HTAP isolation, applications can handle massive transactional and analytical workloads without complex redesign. New capabilities now in public preview extend that foundation even further, including the SQL MCP Server for securely connecting SQL data to AI agents and Copilots, as well as larger 160 and 192 vCore options for high‑throughput workloads.

We’re delivering faster, more capable vector indexes to power AI applications. Recent enhancements improve vector search performance and efficiency with no code changes required. With full insert, update, and delete support, vector indexes stay current in real time, enabling dynamic applications. Features like quantization, iterative filtering, and tighter query optimizer integration provide faster, more predictable results, helping teams build responsive AI experiences directly on their SQL data.

Temenos built its next‑generation banking platform, Temenos Core, on Azure using Azure SQL Database Hyperscale to achieve global scale, high availability, and resilient performance. The platform processes billions of transactions daily and more than 17,500 transactions per second at peak. By building on Hyperscale, Temenos reduced onboarding time, accelerated innovation, and shifted banks from worrying about downtime to competing on availability and digital innovation.

Unify your data estate with SQL database in Fabric

We continue to raise the bar on enterprise readiness for SQL database in Fabric by bringing enterprise-grade security and compliance capabilities directly into the platform. Today at SQLCon, we announced the general availability of features including SQL Auditing, Customer‑Managed Keys, and Dynamic Data Masking, and the preview of workspace‑level Private Link. We brought these enhancements to help customers meet strict governance and regulatory requirements without adding operational complexity. The result is confidence that your SQL workloads in Fabric are secure, compliant, and ready for production.

SQL database in Fabric is becoming even more powerful for AI‑driven applications. The same vector indexing enhancements available in Azure SQL Database Hyperscale are now built into SQL database in Fabric as well. Because both are powered by the same Microsoft SQL engine, customers benefit from consistent performance, capabilities, and innovation across the SQL portfolio—making it easier to build intelligent applications wherever their data lives.

Finally, moving to SQL database in Fabric is simpler than ever. The Migration Assistant now supports SQL database in Fabric as a target destination. It provides a Copilot-assisted experience that helps SQL developers assess readiness, migrate schema, identify compatibility issues, and copy data with less manual effort. By preserving familiar SQL skills and workflows, customers can modernize at their own pace while accelerating time to value on Fabric’s unified analytics and AI platform.

There is one more Fabric innovation that matters deeply for how we deliver Microsoft databases as a unified platform. As applications grow more sophisticated, most organizations now rely on a mix of SQL and NoSQL databases across cloud, on‑premises, and edge environments. Provisioning, monitoring, and maintaining health across a growing database fleet often requires multiple tools and portals, making it harder to see what’s happening and manage at scale.

To address this, we are introducing the Database Hub in Microsoft Fabric, now available in early access. The Database Hub provides a unified database management experience that brings together databases across edge, cloud, and Fabric into one coherent view. From a single place, database teams can explore, observe, govern, and optimize their entire estate, including Azure SQL, Azure Cosmos DB, Azure Database for PostgreSQL, SQL Server enabled by Azure Arc, and Azure Database for MySQL without changing how each service is deployed or operated.

Built for scale, the Database Hub introduces an agent-assisted, human-in-the-loop approach to database management. Intelligent agents continuously reason over estate-wide signals to surface what changed, explain why it matters, and guide teams toward what to do next, while built-in observability, delegated governance, and Copilot-powered insights help teams move from insight to action with greater confidence. With the Database Hub, teams spend less time navigating tools and more time enabling what comes next: unlocking deeper integration across applications, analytics, and AI from a single control plane for the Microsoft databases portfolio.

Database Hub is available today in early access. Sign up today and see how the Database Hub can bring clarity and control to your database estate.

Moving forward with the SQL community

SQLCon is about bringing the SQL community together. It is about rebuilding connections and shared learning. It also reflects our long-term commitment to SQL. With a comprehensive portfolio built on strategic common foundations and available across edge, PaaS, and SaaS, Microsoft databases provide a unified platform for modern enterprise needs, whether you are migrating and modernizing, building cloud-native AI applications, or unifying your data. We are investing in SQL for the future, alongside the community that continues to shape it.

Finally, SQLCon is coming to Europe! Join the global data and SQL community from 28 Sep – 01st October, 2026 in Barcelona, Spain for hands-on learning, expert insights, and real-world stories. Register to be a part of it. I can’t wait to see you there.

Additional SQL resources


1Customers may see savings estimated to be between 0% and 35%. The 35% savings estimate is based on one Azure SQL Database serverless running for 12 months at a pay-as-you-go rate vs. a reduced rate for a 1-year savings plan. Based on Azure pricing as of March 2026. Prices are subject to change. Actual savings may vary based on location, database service, and/or usage. 

The post Advancing agentic AI with Microsoft databases across a unified data estate appeared first on Microsoft SQL Server Blog.

]]>
One consistent SQL: The launchpad from legacy to innovation http://approjects.co.za/?big=en-us/sql-server/blog/2025/11/18/one-consistent-sql-the-launchpad-from-legacy-to-innovation/ Tue, 18 Nov 2025 16:00:00 +0000 One consistent SQL delivers the agility and consistency needed to modernize data systems and unlock new innovation opportunities.

The post One consistent SQL: The launchpad from legacy to innovation appeared first on Microsoft SQL Server Blog.

]]>
Millions of users work with SQL to keep the gears of their business turning. In an era marked by relentless digital transformation, the proliferation of AI workloads, and tightening regulatory demands, the journey of these organizations is uniquely their own. At Microsoft, we believe beneath this diversity lies a single, unified, and consistent backbone: one consistent SQL.

One consistent SQL is a promise of a unified experience that spans edge, cloud, and software as a service (SaaS), empowering developers to create intelligent applications with ease, while enabling data professionals to modernize on their terms. Write once, deploy anywhere because customers run diverse SQL estates, and we meet them wherever they are. Whether you’re running workloads with SQL Server, modernizing in Azure SQL, or activating real-time analytics in Microsoft Fabric, one consistent SQL unifies your data estate, bringing platform consistency, performance at scale, advanced security, and AI-ready tools together in one seamless experience and creates one home for your SQL workloads in the era of AI.

With a consistent platform, optimized performance, and multi-layered security, workloads scale dynamically while staying secure and highly available. And building intelligent, scalable applications is faster than ever with developer-first tools combined with AI capabilities. This is enterprise-grade performance for the era of AI, with one consistent SQL powering innovation across hybrid, multi-cloud, and AI-powered environments, all anchored by a unified data estate.

Delivering a consistent SQL platform across cloud and on-premises

From edge to cloud, one consistent SQL is Microsoft’s commitment to deliver a consistent experience—powering mission-critical workloads, next-generation apps, and data-driven intelligence. It provides unified management across infrastructure, platform, and software services for consistent operations in hybrid scenarios. Developers can use familiar SQL skills and tools to build and manage applications across environments, while sovereign cloud support addresses data residency and compliance requirements for regulated industries.

And now, the centerpiece of this vision takes the stage: SQL Server 2025 is now generally available. Built on SQL Server’s foundation of security, performance, and availability, this release introduces built-in AI capabilities and developer-focused enhancements. These features enable organizations to use existing data to support AI initiatives securely and at scale, all within SQL Server using the T SQL language.

Achieving optimized SQL performance and advanced security

In a world where trust is non-negotiable, organizations expect the same performance, availability, and security standards everywhere in their data lives. They adapt to the demands of your workload without compromise—delivering resilience and speed while keeping data secure and operations steady. These expectations are heightened for mission-critical workloads, where uptime and reliability directly impact return on investment. Businesses need a platform that not only meets these requirements but also evolves to handle growing complexity without adding operational burden.

The next generation of Azure SQL Managed Instance is now generally available to help organizations modernize with improved performance and simplified migration. The release offers expanded storage and database capacity, flexible compute and memory options, and features designed to support diverse workload requirements. These enhancements provide a foundation for scaling applications and managing data securely while maintaining compatibility with existing SQL investments. Customers are already benefiting from Azure SQL Managed Instance. Hexure, a life insurance software company, slashed processing time by 97.2%.

The path to Azure SQL Managed Instance also got easier. SQL Server migration in Azure Arc is now generally available. Copilot-assisted migration streamlines the entire process with real-time replication, confident cutover, and trusted failover—reducing months of work to days and lowering total cost of ownership.

Knowing that we have a reliable and highly secure database platform positions us to think about how we can use AI in ways that will benefit our customers and their customers most. With Azure SQL Managed Instance in place, we’re very well equipped to continue in our role as a leader in insurance tech

Warren Perlman, CTO, Hexure

Empowering developers with AI-ready SQL tools at scale

One consistent SQL means you can use your existing skills and familiar development tools together with AI-powered capabilities to simplify application creation. As organizations look to integrate generative AI into business processes, complexity and time to value remain major challenges. Analysts predict that most AI applications will be built on existing data platforms—reducing development effort and accelerating delivery. Customers want integration, not disruption, and they expect AI assistance embedded in the tools they already use.

This vision is supported by features that combine intelligence with security. GitHub Copilot integration enables developers to work with AI assistance directly in environments like Visual Studio Code and SQL Server Management Studio 22. Native support for retrieval of augmented generation scenarios includes vector search and semantic indexing within SQL Server and Azure SQL, while secure enclaves and Always Encrypted protect sensitive data during processing. Connections to Azure AI services and governance tools streamline data preparation and compliance, while elastic infrastructure supports training, inference, and deployment at scale. 

Creating a unified data estate for analytics and AI

Microsoft Fabric connects operations, analytics, and governance in one unified experience, unlocking the full potential of SQL data. As organizations prepare for real-time AI applications, the ability to bridge transactional and analytical workloads becomes essential. Analysts describe this capability as “translytical,” a foundation for responsive applications that combine speed with depth. A future-ready data strategy must integrate operational data with analytical insight, and Fabric delivers that integration without adding complexity.aka

Today at Microsoft Ignite 2025, we announced two key advancements: the general availability of Fabric databases and database Mirroring in Fabric. Fabric databases unify operational and analytical data within Fabric, backed by OneLake, the open data foundation for analytics and AI. SQL database in Fabric supports transactional processing, real-time analytics with zero Extract, Transform, and Load (ETL), and AI workloads side-by-side. In addition, database Mirroring enables replication of SQL Server and Azure SQL into Fabric for analytics and AI scenarios without migration or refactoring. Early adopters such as AP Pension have consolidated decades of fragmented data using Mirroring for SQL Server in Fabric and SQL database in Fabric, creating a centralized architecture with automated delivery and strong governance. These capabilities position Fabric as a cornerstone for organizations seeking to modernize data strategies and prepare for AI-powered applications.

Eastman built a new agentic sales copilot app, enabling their sellers to instantly query unified customer data using natural language. By integrating SQL querying with Fabric’s analytics and vector capabilities, the copilot retrieves hyper-precise answers directly from the database.

When it comes to SQL in Fabric, a huge advantage is you have the robustness of SQL Server, but already in the context of Fabric. The fact that it already has so many security features and integrations with the rest of the Fabric platform is a huge advantage.

—Logan Finke, Principal AI Data Architect at Eastman

Innovate with one consistent SQL

One SQL is a promise of consistency, security, and flexibility from edge to cloud, helping you innovate without disruption. Build intelligent apps powered by agentic AI, unlock real-time insights, and meet compliance demands, all with the tools and skills you already trust. Make your legacy databases your launchpad to innovation.

One engine. One experience. One SQL.

Take the next step today

The post One consistent SQL: The launchpad from legacy to innovation appeared first on Microsoft SQL Server Blog.

]]>
Announcing SQL Server 2025 (preview): The AI-ready enterprise database from ground to cloud http://approjects.co.za/?big=en-us/sql-server/blog/2025/05/19/announcing-sql-server-2025-preview-the-ai-ready-enterprise-database-from-ground-to-cloud/ Mon, 19 May 2025 16:00:00 +0000 Announcing SQL Server 2025—empowering customers to develop modern AI applications securely using their data, complete with best-in-class security, performance, and availability.

The post Announcing SQL Server 2025 (preview): The AI-ready enterprise database from ground to cloud appeared first on Microsoft SQL Server Blog.

]]>
Organizations are using generative AI to stay ahead of the competition, but the real advantage lies in harnessing the power of your own data securely and at scale.

SQL Server 2025, now in public preview, empowers customers to develop modern AI applications securely using their data, complete with best-in-class security, performance, and availability. It provides built-in, extensible AI capabilities, enhanced developer productivity, and seamless integration with Microsoft Azure and Microsoft Fabric—all within the SQL Server engine using familiar T-SQL language. 

Your data, any model, anywhere 

One of the most exciting new capabilities of SQL Server 2025 is the integration of AI directly into the database engine, enabling more intelligent search. With built-in vector search capabilities, you can perform semantic searches over your own data to find matches based on similarity, alongside full text search and filtering you are already using in SQL Server. This built-in capability opens up a host of exciting new use cases such as discovering deeper connections within large datasets, providing a natural conversational experience across various enterprise systems.  

SQL Server 2025 introduces enhanced model management by building model definitions directly into T-SQL, enabling seamless integration with popular AI services such as Azure AI Foundry, Azure OpenAI Service, OpenAI, Ollama, and others. Models are all accessed through REST APIs allowing you to deploy any model securely isolated from the SQL Server engine, anywhere from ground to cloud. As developers test embedding models to find the best fit for their use cases, whether running open-source models on laptops or hosting purpose-trained models, SQL Server 2025 makes it convenient to switch models without needing to change the code. 

This release also provides other essential building blocks for AI development and operational retrieval-augmented generation (RAG) patterns powered by AI agents. It includes vector embedding generation and text chunking built into T-SQL, using Disk Approximate Nearest Neighbor (DiskANN) as a vector index for faster, resource-efficient, and accurate results. Additionally, SQL Server 2025 offers seamless integration with popular AI frameworks like LangChain, Semantic Kernel, and Entity Framework Core. 

“With the new semantic search and RAG capabilities in SQL Server 2025, we can empower existing GenAI solutions with data embeddings to create next-generation, more intelligent AI applications. By connecting systems, we deliver a seamless, natural conversational experience across enterprise environments.”

—Markus Angenendt, Data Platform Infrastructure Lead, Kramer & Crew  

Microsoft’s most significant release for SQL developers in the last decade 

We understand that developers need the right tools and interfaces for modern, data-intensive applications. SQL Server 2025 delivers a rich set of feature enhancements that significantly streamline development process, reduce code complexity, and improve developer productivity. Along with built-in AI capabilities, this release makes SQL Server 2025 the most significant release for SQL developers since the introduction of SQL Server 2016 a decade ago.  

Enhancing data enrichment is our first area of focus in this release. SQL Server 2025 offers native JSON support, empowering developers to process JSON documents natively. Combined with REST APIs and Regular Expressions (RegEx) enablement, developers can now enrich, validate, and manipulate their datasets with external data sources. This allows for building more dynamic, enterprise-grade applications with richer functionality and enhanced performance. 

Empowering developers to build real-time, event-driven applications with SQL Server is another scenario that this release unlocks. Change Event Streaming allows users to consume transaction log changes as events directly from SQL Server to Microsoft Azure Event Hubs. This provides a new method to mitigate some of the issues developers have seen with the Input/Output (I/O) overhead of Change Data Capture (CDC). It also opens new possibilities such as developing real-time, event-driven applications powered by AI agents. 

There’s also excitement on the language and tooling front. We’re thrilled to announce the preview of our new open-source Python driver for SQL Server.1 Built from the ground up, this driver offers Python developers a robust, efficient, and fully open-source solution for connecting to SQL Server, as simple as pip install. In addition, we are bringing AI-powered assistance directly into your workflow with the integration of MSSQL Extension for Visual Studio Code with GitHub Copilot, now in preview. With GitHub Copilot aware of your SQL Server database connection, developers can generate SQL and object-relational mapping (ORM) migrations, explore schemas, optimize queries with intelligent suggestions, and streamline database interactions—all within in Visual Studio Code.  

“I am genuinely enthusiastic about the AI advancements in SQL Server 2025. These features, along with the enhancements in RegEx and JSON data support, promise to make AI functionalities accessible to a broader range of software applications, and significantly enhance our database operations.” 

—Jacob Saugmann, SQL Specialist, J.H. Schultz Information A/S

Best-in-class security, performance, and availability 

This release builds on SQL Server’s history as an industry leader in database security, performance, and availability. For our enterprise customers, security is non-negotiable. SQL Server remains as the most secure database in the last decade.2 SQL Server 2025 continues the product’s legacy of top-notch security by incorporating modern identity and encryption practices. Support for Microsoft Entra managed identities improves credential management and reduces potential vulnerabilities.3

We’re bringing Optimized Locking to SQL Server, to reduce lock memory consumption and minimize blocking for concurrent transactions through Transaction ID (TID) Locking and Lock After Qualification (LAQ). This capability enables customers to increase uptime and enhance concurrency and scale for SQL Server applications. 

SQL Server 2025 has over 50 enhancements made to the database engine including key improvements for HADR all based on customer feedback. This new release will bring enhancements to performance for applications with no code changes required through Intelligent Query Processing (IQP) and columnstore improvements, enhancements for query processing, and enabling Query Store for readable secondaries.  

“Security Cache Improvement proved invaluable for high-demand environments like ours, reducing disruption when applying permissions on servers with 20,000–25,000 active connections. This enhancement ensures minimal performance impact, streamlining security management. The ordered non-clustered Columnstore index significantly improved query performance by over 63%, optimizing workloads reliant on analytical processing.”

—Madhab Paudel, Database Engineer, Entain

Cloud agility through Azure 

To build scalable analytics, data needs to be extracted, transformed, normalized, and made available in a central place. SQL Server 2025 will support database mirroring in Fabric, giving you near real-time analytics using a zero extract, transform, and load (ETL) experience and allowing you to offload your analytical workloads to Fabric.3  

Azure is a critical component of SQL Server. With Azure Arc, SQL Server 2025 will continue to offer cloud capabilities to enable customers to better manage, secure and govern your SQL estate at scale across on-premises and cloud. 

“Fabric mirroring for SQL Server 2025 helps MSC to build the bridge to bring our operational data into Microsoft Fabric.”

—Javier Villegas, IT Director of DBA and BI Services, Mediterranean Shipping Company

Get started with SQL Server 2025 today

With every AI-powered query for hybrid search, every millisecond saved in query execution, every change event streamed in real time, SQL Server 2025 is a critical building block for modern data-intensive applications in this AI era. Ready to try it out? Learn more about SQL Server 2025.

SQL Server Management Studio (SSMS) 21, now generally available, is based on Visual Studio 2022 and includes 64-bit support. This modernized version is available from the Visual Studio Installer, offers automatic updates, and introduces Git integration, query editor enhancements, and a new connection experience.

Microsoft Copilot in SSMS, now in preview, is available as an optional workload when installing SSMS 21, and assists customers in writing, editing, and fixing T-SQL queries using natural language. Leveraging database context, it also helps with database administration, maintenance, configuration and more.3

Explore solutions and capabilities

Person smiling while working on computer

SQL Server 2025

Explore new capabilities in AI development, enhanced model management, and more


1 Public preview of Python driver is June 1, 2025. The alpha version is available on GitHub today. 

2 According to the National Institute of Standards and Technology Comprehensive Vulnerability Database, as of December 2024.

3 Although SQL Server 2025 in public preview is free to try, using some features such as Microsoft Entra, Fabric and Copilot in SQL Server Management Studio 21 could incur costs based on usage. Try Azure for free and explore Fabric trial capacity.

The post Announcing SQL Server 2025 (preview): The AI-ready enterprise database from ground to cloud appeared first on Microsoft SQL Server Blog.

]]>
5 reasons to join us at Securely Migrate and Optimize with Azure https://azure.microsoft.com/blog/5-reasons-to-join-us-at-securely-migrate-and-optimize-with-azure Thu, 13 Apr 2023 15:00:00 +0000 Join us at Securely Migrate and Optimize with Azure digital event on Thursday, April 26, 2023, at 9:00 AM–11:00 AM Pacific Time.

The post 5 reasons to join us at Securely Migrate and Optimize with Azure appeared first on Microsoft SQL Server Blog.

]]>
The post 5 reasons to join us at Securely Migrate and Optimize with Azure appeared first on Microsoft SQL Server Blog.

]]>
PASS Data Community Summit 2022 keynote: Transform your data estate with Microsoft’s Intelligent Data Platform http://approjects.co.za/?big=en-us/sql-server/blog/2022/11/08/pass-data-community-summit-2022-keynote-transform-your-data-estate-with-microsofts-intelligent-data-platform/ Tue, 08 Nov 2022 16:00:00 +0000 I look forward to seeing you at PASS Data Community Summit, a conference curated for the Microsoft data platform professional.

The post PASS Data Community Summit 2022 keynote: Transform your data estate with Microsoft’s Intelligent Data Platform appeared first on Microsoft SQL Server Blog.

]]>
I look forward to seeing you at PASS Data Community Summit, a conference curated for the Microsoft data platform professional. Hosted by Redgate, this hybrid event will include the latest innovation across SQL Server and the entire Microsoft Intelligent Data Platform, as well as practical training and networking to empower you to transform your career and your organization.

Join us live in Seattle or virtually online, but don’t miss this unique opportunity to learn from the experts how to bring the full value of Microsoft Intelligent Data Platform to your organization.

This year, we continue the tradition of hosting a Microsoft day one keynote. We will also deliver a record-breaking 38 sessions, covering a wide array of themes and learning paths.  

We kick off the first official day of Summit on Wed., November 16. I invite you to join me and the Microsoft engineering team to learn how Microsoft’s Intelligent Data Platform—including data, analytics, and governance—can come together to help you get the full benefit of your data estate and do more with less. During the keynote, I will share new product announcements that you won’t want to miss, along with demos of some of the latest innovations from engineers like Anna Hoffman, Bob Ward, and Patrick Leblanc.

The keynote will be both live and in person at the Seattle Convention Center and live-streamed online and recorded, meaning registered attendees will have on-demand access. We highly encourage you to watch it live as we’ll discuss fresh topics and introduce some surprises along the way. Keep your eyes and ears open.

The event also connects you to peers and professionals while giving you the chance to talk with our engineers and advocates to learn about our latest solutions during our sessions and at our booth.

To register for Summit, visit the website and sign up today. Don’t forget to use the code AZURE175 at checkout to receive $175 off on the 3-Day, in-person conference pass.

Learn More

Learn more about our other sessions and Pre-cons in our post.

My team and I look forward to seeing you next week!   

The post PASS Data Community Summit 2022 keynote: Transform your data estate with Microsoft’s Intelligent Data Platform appeared first on Microsoft SQL Server Blog.

]]>
Register today—Free Azure Data training at Data Platform Summit 2022 http://approjects.co.za/?big=en-us/sql-server/blog/2022/08/23/register-today-free-azure-data-training-at-data-platform-summit-2022/ Tue, 23 Aug 2022 15:00:00 +0000 Data Platform Virtual Summit 2022 (DPS 2022), a free global learning event for data professionals, is just a few weeks away running from September 19–23.

The post Register today—Free Azure Data training at Data Platform Summit 2022 appeared first on Microsoft SQL Server Blog.

]]>
Data Platform Virtual Summit 2022 (DPS 2022) is just a few weeks away, running from September 19–23. A free global learning event for data professionals, DPS 2022 features a keynote from Bob Ward (Principal Architect, Microsoft) and Buck Woody (Applied Data Scientist, Microsoft), as well as more than 200 breakout sessions delivered by Azure Data engineering, partner organizations, and community leaders. With content delivered almost around the clock in five editions, DPS 2022 empowers Azure Data professionals worldwide with the deep technical skills they need to move ahead in their careers and digitally transform their organizations.

This year, DPS 2022 features eight tracks focusing on Azure Data: 

  • Architecture 
  • Azure Data Administration 
  • Azure Data Development 
  • Business Intelligence & Advanced Analytics 
  • Data Science (AI/ML)
  • Industry Solution 
  • SQL Server 2022 
  • Professional Development 
  • Student Track 

The virtual platform offers a live Q and A session, a networking lounge, and a community zone. Additionally, attendees will receive lifetime on-demand access to session recordings. 

DPS 2022 offers an incredible opportunity to learn directly from our engineering teams, who will share the latest advances and insights on the Azure Data platform. 

  • Bob Ward and Buck Woody from the Microsoft Data Platform team will deliver the keynote together. The keynote will highlight the latest innovations across the Microsoft Azure Data platform and share customer case studies. Bob and Buck will show you how to meet the needs of developers across the spectrum to leverage the new tools, processes, and platforms in the Intelligent Data Platform to create a data culture in your organization. Bob will go deep on the newest release in the Intelligent Data Platform—SQL Server 2022
  • Microsoft Azure Data engineering teams will deliver over 65 sessions at DPS 2022. Hear the latest from the people who develop the tools you use every day and engage in live discussions. 
  • Visit the virtual expo hall where you can connect with our team across SQL Server, Azure SQL, Microsoft Learn, Power BI, and more. 

Register now for a week of free training at the Data Platform Virtual Summit and receive all the session recordings also for free (streaming access). 

The post Register today—Free Azure Data training at Data Platform Summit 2022 appeared first on Microsoft SQL Server Blog.

]]>
Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation http://approjects.co.za/?big=en-us/sql-server/blog/2022/05/24/announcing-sql-server-2022-public-preview-azure-enabled-with-continued-performance-and-security-innovation/ Tue, 24 May 2022 15:00:00 +0000 Today, we are excited to announce the public preview of SQL Server 2022.

The post Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation appeared first on Microsoft SQL Server Blog.

]]>
Part of the SQL Server 2022 blog series.

Today, we are excited to announce the public preview of SQL Server 2022. Anyone can now download SQL Server 2022 preview to try the new features in this release.

Button to download SQL Server 2022, public preview.

SQL Server 2022 is the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability. It is part of the Microsoft Intelligent Data Platform, which unifies operational databases, analytics, and data governance.  

SQL Server 2022 integrates with Azure Synapse Link and Microsoft Purview to enable customers to drive deeper insights, predictions, and governance from their data at scale. Cloud integration is enhanced with managed disaster recovery (DR) to Azure SQL Managed Instance, along with near real-time analytics, allowing database administrators to manage their data estates with greater flexibility and minimal impact to the end-user. Performance and scalability are automatically enhanced via built-in query intelligence.

Over the past six months since our private preview announcement, we saw tremendous interest in our SQL Server 2022 Early Adoption Program (EAP). Thousands of companies applied for our early adoption program, representing strong momentum relative to prior releases.  

Top-requested features for SQL Server 2022 EAP applicants included:

  • Link feature for Azure SQL Managed Instance1: To ensure uptime, SQL Server 2022 is fully integrated with the new link feature in Azure SQL Managed Instance. With this capability, you now get all the benefits of running a platform as a service (PaaS) environment applied to DR—allowing you to spend less time on setup and management even when compared to an infrastructure as a service (IaaS) environment. The general availability of the bidirectional disaster recovery capability of the Link feature for Azure SQL Managed Instance will occur after the general availability of SQL Server 2022.
  • Azure Synapse Link for SQL: Azure Synapse Link for SQL Server 2022 provides near real-time analytics and hybrid transactional and analytical processing with minimal impact on operational systems.
  • Microsoft Purview integration: SQL Server 2022 is integrated with Microsoft Purview, a unified data governance and management service, for greater data discovery, allowing you to break down data silos, as well as policy management for access control.
  • Ledger: A new technology that brings the benefits of blockchains to relational databases, by cryptographically linking the data and their changes in a blockchain structure, to make the data tamper-evident and verifiable. By baking trust into the SQL Server Database Engine, Ledger makes it easy to implement multi-party business processes, such as supply chain systems, allowing participants to verify the integrity of the centrally housed data, without the complexity and performance overheads of a blockchain network. Ledger can also help customers streamline compliance audits, providing cryptographic proofs of data integrity to auditors and eliminating manual forensics.
  • Intelligent Query Processing enhancements: We are expanding more scenarios based on common customer problems. For example, the “parameter sensitive plan” problem refers to a scenario where a single cached plan for a parameterized query is not optimal for all possible incoming parameter values. With SQL Server 2022’s Parameter Sensitive Plan optimization feature, we automatically enable the generation of multiple active cached plans for a single parameterized statement. These cached execution plans will accommodate different data sizes based on the provided runtime parameter values.
  • Query Store: We are adding support for read replicas and enabling query hints to improve performance and quickly mitigate issues without having to change the source T-SQL. Also, Query Store hints arrive on SQL Server 2022. Query Store hints provide an easy-to-use method for shaping query plans without changing application code.
  • Security enhancements in SQL Server 2022 include Azure Active Directory authentication, support for richer queries in Always Encrypted with secure enclaves, backing up and restoring certificates using the PFX format, and multiple other improvements to enhance default cryptography in SQL Server to meet the evolving threat landscape.
  • Contained Availability Groups: Supports managing objects (users, logins, permissions, SQL Agent jobs, and more) at the availability group level using specialized contained system databases within the availability group.
  • Multi-write replication: We are automating the last-writer wins rule. Now, when a conflict is detected, the most recent modification time will be chosen to be persisted on all replicas. This helps keep your multi-write scenarios running smoothly.
  • Data lake virtualization and object storage: Query any data lake and backup/restore SQL to S3-compatible object storage.
  • JavaScript Object Notation (JSON) data: New JSON functions to increase the ability to query and manipulate JSON data.
  • Memory and concurrency: In-memory online transaction processing (OLTP) memory enhancements and system page latch concurrency enhancements.
SQL Server 2022: Azure-enabled with continued performance and security innovation from edge to cloud.

Collaboration with our customers and partners

We have collaborated closely with customers and partners over this past half year to test these new features. We have received positive feedback about how the innovation in SQL Server 2022 will empower users to do more.

“Features like Query Store hints and the next generation of Intelligent Query Processing are awesome. The possibility of improving and maintaining great performance over time without code changes is getting better on every new SQL Server version.”—Javier Villegas, IT Director for DBA and BI Services, Mediterranean Shipping Company

“With the arrival of Synapse Link for SQL Server 2022, we can finally achieve near real-time analytics over our most important operational data, all without the need to build and manage complex packages and pipelines.”—Nic Hopper, Data Architect, Atrium Underwriters   

icon

Learn more


1Public preview for the bidirectional disaster recovery capability of the Link feature for Azure SQL Managed Instance will occur at a future date. Sign up to apply for early access to the capability.

The post Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation appeared first on Microsoft SQL Server Blog.

]]>
Meet us at SQLBits 2022 and level up as a data professional http://approjects.co.za/?big=en-us/sql-server/blog/2022/02/10/meet-us-at-sqlbits-2022-and-level-up-as-a-data-professional/ Thu, 10 Feb 2022 16:00:00 +0000 We are excited to be the premium sponsor at this year’s SQLBits 2022, March 8 – 12, in-person in London and virtually.

The post Meet us at SQLBits 2022 and level up as a data professional appeared first on Microsoft SQL Server Blog.

]]>
It has been over two years since we have had the opportunity to meet face-to-face with our data community at a large event and we miss it. From hallway conversations to the energy that comes from solving problems and helping people understand complex concepts, we cannot wait to teach, meet and greet everyone. This is why we are excited to be the premium sponsor at this year’s SQLBits 2022, March 8 – 12, in-person in London and virtually.

As the lead sponsor, we will deliver content including the keynote, five full-day training days, and over fifty general sessions. With so many opportunities to educate, we are bringing the full Azure data team including folks from across the data platform, such as SQL Server, Azure SQL, Cosmos DB, Azure Purview, Azure Synapse Analytics, and Power BI.

Start the week with my team for two day-long training sessions where you will have a unique chance to work directly with Microsoft engineering:

The Hands-on Azure SQL Workshop on March 8 will help you translate your existing SQL Server skills to Azure SQL. Bring your laptop and get ready to learn hands-on. You will gain a foundational knowledge of what to use when, as well as how to configure, monitor, and troubleshoot the “meat and potatoes” of SQL Server in Azure: security, performance, and availability.

Migrate SQL Server to Azure on Wednesday, March 9 will help you migrate your SQL Server environments to Azure. In this session, the Microsoft engineering team will show you everything you need to know, including the tools and knowledge you need to make your migrations seamless, cost-efficient, and optimized for speed.

Other training sessions cover topics such as Azure SQL Database, Synapse Analytics, and Power BI.

All speaker proceeds from these sessions will be given back to a local charity.

The SQLBits event theme this year is Video Games—and in the “Level Up With Azure Data” keynote, Buck Woody has asked me to come talk about SQL Server 2022 and Azure Data. He assures me I will have help with some surprise guests so it should be interesting. It is always a fun keynote when Buck and I are on stage, and this year you really do not want to miss it!

You also have the opportunity to attend the Microsoft general sessions to learn about the entire Azure data platform.

Take a look at some of the learning available SQLBits 2022

Unified Data Governance with Azure PurviewGaurav Malhotra, Evangeline White
What’s New in Azure SQL MINiko Neugebauer
The fundamentals of building a lakehouse with SynapseLuke Moloney
SQL Server in Azure Virtual Machine ReimaginedPam Lahoud
Microsoft Database InnovationsAnna Hoffman
Azure Arc-Enabled Data ServicesJes Schultz, Buck Woody
Azure SQL Database customer success stories for IoT workloadsSilvano Coriani
Azure SQL availability and resiliencyEmily Lisa
Microsoft SQL Server 2022 Deep Dive (two parts)Pedro Lopes
Modernize your Oracle workloads to Azure DataAlexandra Ciortea
Empowering every individual with Power BIMohammad Ali, Patrick LeBlanc
AMA with the Microsoft Engineering team hosted by
Bob Ward
“Rockstars” of the engineering team

See all the opportunities to engage with Microsoft engineering by heading over to our blog on Microsoft Tech Community, Ready for SQLBits 2022. And don’t forget to stop by our booth, where you can get your questions answered by members of the Microsoft team.

SQLBits is a marathon of top-quality training from global specialists, with two days of full-day training sessions and three days of general sessions. As always with SQLBits, Saturday, March 12 is free to attend. Meet with community leaders sharing their real-world experience and Microsoft product teams providing deep insights into innovations that meet your needs.

Register today for SQLBits 2022

Join Microsoft at this hybrid event for the latest on the data platform and a chance to see whether Buck Woody or I have the best arcade game skills!

Register to attend, and we’ll see you there, in-person, or virtually!

The post Meet us at SQLBits 2022 and level up as a data professional appeared first on Microsoft SQL Server Blog.

]]>
PASS Data Community Summit keynote: a bridge to a new universe http://approjects.co.za/?big=en-us/sql-server/blog/2021/11/08/pass-data-community-summit-keynote-a-bridge-to-a-new-universe/ Mon, 08 Nov 2021 18:00:40 +0000 It is almost time for PASS Data Community Summit 2021, a free online conference for the Microsoft data platform professional.

The post PASS Data Community Summit keynote: a bridge to a new universe appeared first on Microsoft SQL Server Blog.

]]>
It is almost time for PASS Data Community Summit 2021, a free online conference for the Microsoft data platform professional. The conference, hosted by Redgate, will include the latest SQL Server and Azure data innovations, practical training, and networking to empower you to transform your career and your organization. This year’s event is coming to you online for free from November 8 – 12, 2021, and we will continue the tradition of a Microsoft day one keynote.

Deliver faster performance than ever before with SQL Server and Azure

Hear directly from Microsoft’s Rohan Kumar and senior Microsoft engineering leaders during the day one kick-off keynote as they take you on a journey to a new universe shaped by our past—and built to take us into a limitless future. The cloud has created a whole new universe and advancements in Microsoft data products and services are your bridge.

You’ll see how you can use your existing SQL Server and Azure skills, and learn about new tools and platforms available from Microsoft to deliver faster performance than ever before. You’ll see how to shape your data so you can harness its power to find a new galaxy of insights, answers, and predictions. And you will hear about new innovations that continue Microsoft’s rich heritage of data integrity and governance.

Additionally, in the special on-demand keynote, Microsoft Azure Data CTO Raghu Ramakrishnan and team will share a technical keynote and demos showing Azure Purview and SQL.

Register for the PASS Data Community Summit

Don’t miss this opportunity to see how Microsoft is uniquely positioned to provide you with an end-to-end data platform seamlessly integrating limitless database scale and performance, unmatched analytics and intelligence, and unified data governance.

After the keynotes, ground your learning with in-depth training in one of more than two dozen sessions Microsoft will be delivering. Hear the latest from the Engineering teams who develop the tools you use every day. After your sessions, don’t forget to visit the virtual exhibit hall where you can connect with our team across SQL Server 2022, Azure SQL, Azure Synapse Analytics, Microsoft Power BI, Azure Arc, and more.

Register for PASS Data Community Summit today.

The post PASS Data Community Summit keynote: a bridge to a new universe appeared first on Microsoft SQL Server Blog.

]]>