Subscribe to our Newsletter!
If you like our blog posts make sure you subscribe to our newsletter . We will share all kinds of great stuff for FREE!Top Posts & Pages
Categories
Search Results for: azure sql database
Advanced Data Protection with Azure SQL Database and SQL Server
Here are the slides to my one hour session going over several advanced data protection security enhancements that are STILL not being used with SQL Server or Azure SQL Database.
Workload Replay for Azure SQL Database and Amazon RDS
Want to make sure you don’t have errors, validate performance, and save money while making changes with Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon AWS? In this video, you will learn how to use the Data … Continue reading
Posted in Azure, SQLServerPedia Syndication
Tagged aws, azure, Migration, performance tuning, replay
Import Databases to Azure SQL Database
I recently spoke at a conference and was asked what is the easiest way to import databases to Azure SQL Database. Therefore, I wanted to share how I do this with DBATools.io. You can use the same code to just … Continue reading
Posted in Azure, backup/restore, SQLServerPedia Syndication, syndication
Tagged Azure SQL Database, dbatools, migrate, powershell
Talking about Migrating to Azure SQL Database at #MSIgnite this week
This week I will have two talks on migrating existing database to Azure SQL Databases at Microsoft Ignite. If you are there and curious about migrating your existing databases we would love to talk with you. If you are attending … Continue reading
Benchmark Azure SQL Database Wait Stats
Today, I want to focus on how we can monitor wait statistics in an Azure SQL Database. In the past, I blogged about how you should benchmark wait stats with the box product. This process will give you misleading data in … Continue reading
Posted in Azure, SQLServerPedia Syndication
Tagged Azure SQL Database, DMV, performance tuning
Calculating DTU in Azure SQL Database
A few months ago, I posted a question over on ask.sqlservercentral.com. In a nutshell, it was how do you measure DTU? How could you pull the data shown in the Azure Portal graphs with T-SQL? No one answered, so this … Continue reading
Posted in Azure, SQLServerPedia Syndication
Tagged Azure SQL Database, DTU, performance tuning, Query Store
Azure SQL Database Live Migrations
Unfortunately, with Azure SQL Database you are not able to take an existing SQL Server Backup and restore it on an Azure SQL Database server. We are talking about Microsoft’s database as a service (DaaS) offering, not Azure VMs also … Continue reading
Posted in Azure, SQLServerPedia Syndication
Tagged amazon RDS, Azure SQL Database, Cloud, Migration, Transactional Replication
Replication for Azure Databases – #TSQL2SDAY #77
If you’re not familiar, T-SQL Tuesday is a blogging party hosted by a different person each month. It’s a creation of Adam Machanic (b|l|t), and it’s been going on for a long time (77 months to be exact). The host … Continue reading
SQL Server 2025: Is the Upgrade Worth the Money?
SQL Server 2025 was released in November of 2025. The issue I’ve found is that reviews of SQL Server 2025 that showcase the business impact of the upgrade are hard to find and don’t focus solely on its technical aspects. … Continue reading
Posted in C-Level, Data Architecture, SQLServerPedia Syndication
Tagged ROI, SQL Server 2025
Azure Managed Instance Changing DNS prefix
Azure Managed Instances are provisioned by default with a yourname.uniqueid.databases.windows.net DNS fully qualified domain name (FQDN). Even on your private virtual network you will still have to use this FQDN. If you want your Azure Managed Instance to connect with … Continue reading
Posted in Azure, SQLServerPedia Syndication