cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Azure SQL

  • 409 Blog Articles
Options
537

Notebook Views in Azure Data Studio | Data Exposed

MarisaBrasile on Oct 15 2021 12:22 PM
Get a sneak peek at what's new in Azure Data Studio, including Notebook Views.
708

Migrating to SQL: Introduction to Database Schema Conversion Toolkit (DSCT) (Ep. 9) | Data Exposed

MarisaBrasile on Oct 07 2021 09:00 AM
Tune into episode 9 of the Migrating to SQL series to learn about DSCT.
1,449

Announcing Azure SQL MI Repository on GitHub

NikoNeugebauer on Oct 07 2021 07:13 AM
We are launching an official repository for the Azure SQL MI scripts, which will serve as a principal source location fo...
1,391

Azure SQL News Update: October 2021

Anna Hoffman on Oct 06 2021 07:42 AM
Read about the latest Azure SQL news or catch the live episode! We’ve included an iCal file, so you can add a reminder t...
1,526

Azure SQL and Azure Purview work better together

MarisaBrasile on Oct 05 2021 06:02 AM
Follow these easy steps to register and scan your Azure SQL database, extract lineage, and analyze data in Azure Purview...
1,289

How-to monitor SQL MI Failover Group & Replicas availability

NikoNeugebauer on Oct 01 2021 10:29 AM
Look inside the replication for High Availability and Failover Groups on SQL MI by monitoring the databases and replicas...
1,033

Migrating to SQL: How to find the right Azure SQL SKU for your SQL workloads (Ep. 8) | Data Exposed

MarisaBrasile on Sep 30 2021 09:20 AM
Dive into the migration series further with this new episode on tips to modernize your on-premises databases to Azure SQ...
1,080

SQL Server Failover Cluster Instances in Azure | Data Exposed: MVP Edition

MarisaBrasile on Sep 28 2021 09:00 AM
Learn how we use SQL Server Failover Cluster Instances in Azure VM and more!
1,944

Security concept: Audit Trail

AndreasWolter on Sep 24 2021 01:38 PM
The concept of an Audit Trail and its importance for any systems security state.
1,294

New Microsoft Learn Modules: Azure SQL IoT and Azure Arc-enabled data services | Data Exposed

MarisaBrasile on Sep 23 2021 09:00 AM
Check out our newly released Microsoft Learn content!
859

Change Tracking Cleanup–Part 3

MaraSteiu on Sep 22 2021 04:37 PM
Learn more about improvements made to the manual cleanup stored procedure in Change Tracking
565

How to Use Citus to Shard Postgres, for Performance and Scale | Data Exposed

MarisaBrasile on Sep 16 2021 09:00 AM
Learn how to scale out Posgres with Citus, this week on Data Exposed.
2,814

Azure SQL Managed Instance – Terraform command available

UrosMilanovic on Sep 14 2021 07:04 AM
Command for Azure SQL Managed Instance deployment is officially available in Terraform registry under Azure provider
1,534

How-to determine the SQL MI Failover Group & HA Replicas Details

NikoNeugebauer on Sep 14 2021 01:12 AM
Discover a way to determine the details for SQL MI Failover Groups and High Availability Replicas, such as the type of t...
3,356

How-to determine the SQL MI Failover Group configuration

NikoNeugebauer on Sep 12 2021 12:22 PM
Discover an easy way to determine with the help of T-SQL with the SQL MI if it is connected to the Failover Group and wh...
1,510

Data Platform Summit 2021 is a few days away!

MarisaBrasile on Sep 09 2021 12:52 PM
Plan which sessions you'll be attending at DPS with our quick reference guide.
1,030

Using Query Store Hints to Optimize Memory Grants Improving Performance | Data Exposed

MarisaBrasile on Sep 09 2021 10:42 AM
Learn how to improve the performance of bulk loading data using query store hints
2,482

Scalar UDF Inlining now available on Azure SQL

Pooja_Kamath on Sep 07 2021 07:29 AM
TSQL Scalar UDF Inlining is now available for Azure SQL Managed Instance and Azure SQL DatabaseThis feature is a part of...
4,552

Server roles for Azure SQL Database: Database Management without admin-access

AndreasWolter on Sep 02 2021 04:31 PM
Announcing Server roles for Azure SQL Database: Database Management without admin-access
1,025

Azure SQL VM: Using PerfInsights to Evaluate Resource Health and Troubleshoot (Ep. 5) | Data Exposed

MarisaBrasile on Sep 02 2021 09:29 AM
Learn how to evaluate the health of your Azure SQL Virtual Machines with PerfInsights.
1,440

Azure SQL News Update: September 2021

Anna Hoffman on Sep 01 2021 09:00 AM
Read about the latest Azure SQL news or catch the live episode! We’ve included an iCal file, so you can add a reminder t...
5,140

Announcing Azure SQL Migration extension for Azure Data Studio - public preview

Mohamed Kabiruddin on Sep 01 2021 08:06 AM
Use the Azure SQL Migration extension for Azure Data Studio to migrate to either Azure SQL Managed Instance (Platform-as...
1,628

Azure SQL MI now removes virtual cluster as part of the delete flow

UrosMilanovic on Aug 31 2021 11:00 PM
Virtual cluster and other dependent components are removed with last instance deletion in the subnet.
1,793

Improved columnstore data loading using Query Store hints

Denzil Ribeiro on Aug 31 2021 01:44 PM
With query store hints, DBAs and engineers can use hints to affect performance without changing the source application o...
837

Managing SQL Server Agent Jobs with Notebook Jobs in Azure Data Studio | Data Exposed: MVP Edition

MarisaBrasile on Aug 31 2021 08:58 AM
Learn how to create, maintain, and manage SQL Server Agent jobs using Notebook Jobs.
1,816

Azure SQL Managed Instance – introduction to #SQLMIOPS

UrosMilanovic on Aug 26 2021 09:00 AM
A series of article dedicated to #sqlmiops – an area that will consolidate all aspects of instance management.
776

Migrating to SQL: New Conversion Reports in SSMA (Ep. 7) | Data Exposed

MarisaBrasile on Aug 26 2021 09:00 AM
Learn about all the new benefits of conversion reports in SQL Server Migration Assistant (SSMA).
1,831

How-to determine the timestamp of the last SQL MI failover

NikoNeugebauer on Aug 20 2021 11:33 AM
Discover when the last failover of the Azure SQL Managed Instance took place and you will be able to explain why the per...
1,229

Azure SQL VM: Get the best price-performance for your SQL Server workloads on Azure VM (Ep. 4)

MarisaBrasile on Aug 19 2021 08:53 AM
Learn what VM sizes to choose from when migrating SQL Server workloads to Azure VM.
1,484

Learn how Azure SQL works with Azure Purview on at the Azure Data Governance event on September 28

MarisaBrasile on Aug 17 2021 09:00 AM
Achieve unified data governance with Azure Purview

Latest Comments

alzdba
in Azure SQL News Update: October 2021 on Oct 11 2021 02:28 AM
I thought AzureRM was obsolete and AZ was the way to go !??Can you please explain when en why to use AzureRM vs AZ ?
0 Likes
sasapopo
in Cross-instance distributed transactions with Azure SQL Managed Instance on Oct 08 2021 07:42 AM
Hi @glin88 , if you are still experiencing the same error when trying to execute distributed transaction with your Azure SQL Managed Instance, please file a support ticket to engage with our support engineers.
0 Likes
Josh5
in Using Qlik Data Integration to Stream Data Changes from a CDC-Enabled Azure SQL Database on Oct 07 2021 06:35 AM
Is there any update or a link to keep up to date with exporting CDC changes to an Event Hub (or something similar)? It was mentioned in the previous CDC blog post as being on the roadmap. Using a third party is not the same as an Azure native solution.
0 Likes
AnshulDBA
in Managing SQL Server Agent Jobs with Notebook Jobs in Azure Data Studio | Data Exposed: MVP Edition on Oct 07 2021 02:33 AM
Using Azure Data Studio and SQL Server Agent extension, can we configure and schedule SQL agent jobs for Azure SQL Databases?Thanks,Anshul
0 Likes
glin88
in Cross-instance distributed transactions with Azure SQL Managed Instance on Oct 06 2021 08:17 AM
got this error:Msg 21, Level 20, State 1, Line 11Warning: Fatal error 8510 occurred at Oct 6 2021 3:08PM. Note the error and time, and contact your system administrator.when running:SET XACT_ABORT ONBEGIN DISTRIBUTED TRANSACTIONselect * from [sqlmi-linked-server].tpcc1000.dbo.new_order where no_o_id...
0 Likes