Often times when working with a client, I’ll run into issues or get emails from a client with a message like the following: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 – The specified network name is no longer available.) (Microsoft […]
Category: Azure
Dynamic Data Masking – SQL Server
Use Dynamic Data Masking to protect your data
Common Issues with SQL Server Backups
I absolutely love talking about SQL Server backup and restores. It is one of my favorite sessions to give at user groups and conferences all over the world. I’ve also written a couple of books on the topic. Over the many years of working with Microsoft SQL Server, I tend to see the same mistakes […]
Online Training Courses
Today Paul sent out the quarterly numbers to the team letting us know the hours our courses have been viewed during March. Being a data guy, I decided that after nearly 5 years of having courses available, I should crunch some numbers. I currently have 4 courses available. SQL Server: Consolidation Tactics and Best Practices […]
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is always improving the environment by adding new features, tweaking interfaces, tweaking features, and much more. I’ve been working with Managed Instance since private preview and just […]
Query Store for Azure PostgreSQL
Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018 that Query Store was available in Public Preview for PostgreSQL. How cool is that! As Microsoft continues to expand the Azure Data Platform with including MySQL, PostgreSQL, and others, features that we know and love […]
New vCore Compute Levels for Azure SQL Database and Elastic Pools
Additional vCore-based elastic pools and single databases have been expanded for the general purpose, business critical, and hyperscale service tiers. This provides customers with more flexibility and options when migrating DTU-based deployments and right-sizing workloads for the cloud. Azure SQL Database, Elastic Pools, and Hyperscale have two processor types to select from. Gen 4 offers […]
Azure SQL Database Managed Instance Business Critical Tier Now Available
The business critical tier for Azure SQL Database Managed Instance is now available. Customers needing a higher level of high availability and disk performance now have the supported option of the business critical tier. The business critical tier provides customers with three secondary copies of their instance. Two are non-readable and the third provides a […]