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

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

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

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

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

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

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

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

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 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