Select Page

New Data Exposed episode: SQL Database Connectivity Explained

This session explains the basics of how connectivity works for SQL Database and how you can use network access controls to securely access SQL Database. Read more at the following links: Connectivity Architecture: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architecture Impact of removing Allow Access to ... continue reading
DP_Summit_LOGO-1.png

Meet the SQL Product Team at Data Platform Summit 2019

Several members of the SQL Team represented by Product Managers from Azure SQL Database (@azuresqldb) and SQL Server (@mssqltiger) Engineering will be speaking at Data Platform Summit 2019 (#DPS10), Asia’s Premier Data & Analytics Conference taking place on August 22-24 ... continue reading

New Data Exposed episode: A conversation about SLA for Azure SQL Database

When data is the lifeblood of your business, you want to ensure your databases are reliable, secure and available when called upon to perform. Service level agreements (SLA) set an expectation for uptime and performance and are a key input ... continue reading

New Data Exposed episode: Exploding Bill of Materials using Graph Shortest Path

In this demo, we will show how you can explode a Bill of Materials using Graph Shortest Path function, introduced with SQL Server 2019 CTP3.1, to find out which BOMs/assemblies a given product/part belongs to. This information can be useful ... continue reading

New Data Exposed episode: Exploding Bill of Materials using Graph Shortest Path

In this demo, we will show how you can explode a Bill of Materials using Graph Shortest Path function, introduced with SQL Server 2019 CTP3.1, to find out which BOMs/assemblies a given product/part belongs to. This information can be useful ... continue reading
QS_SSMS_Reports_m.jpg.png

Using Query Store with least privileges instead of db_owner to archive Separation of Duties

When using the Query Store in a production environment, sometimes customers need to delegate very specifically who can do what in terms of Performance Analysis and/or Tuning. The Query Store is a component that can be activated per database and ... continue reading

New Data Exposed episode: Data Migration Assistant

Learn how you can leverage our Data Migration Assistant tool to get the Azure SQL Database readiness at scale. More information: https://docs.microsoft.com/en-us/sql/dma/dma-assess-sql-data-estate-to-sqldb and https://docs.microsoft.com/en-us/sql/dma/dma-overview. Follow Colin Murphy and Venkata Raj Pochiraju on Twitter at https://twitter.com/colinatwork and https://twitter.com/rajpochiraju ... continue reading

Introducing SIOS high availability for SQL Server 2008/R2 in Azure

Support for SQL Server 2008 and 2008 R2 ended on July 9, 2019. That means the end of regular security updates. However, if you move those SQL Server instances to Azure or Azure Stack, Microsoft will give you three years ... continue reading

New Data Exposed episode: Data Migration life-cycle

Understand the cloud migration journey, strategy, Leverage Data migration tools and Azure Database Migration Service for successful database migrations to Azure Data. Follow Colin Murphy and Venkata Raj Pochiraju on Twitter at https://twitter.com/colinatwork and https://twitter.com/rajpochiraju ... continue reading
Data Exposed.PNG

Azure SQL joins forces with Data Exposed – the show that is all about data

Data Exposed is back! Data Exposed is all about data; relational and non-relational, on-premises and in the cloud, big and small. Join us as we demonstrate features, discuss the latest news, and share the love for data technology including SQL ... continue reading