Over the past few weeks, I’ve been contacted by multiple customers experiencing the same frustrating issue. Applications and SSMS sessions that had been rock-solid for years suddenly started throwing errors when connecting over VPN: Naturally, everyone assumed it was a SQL Server problem – which is why they called me. On the server side, though, […]
Category: SQLServerPedia Syndication
Can You Restore Multiple Differential Backup Files?
Can you restore multiple differential SQL Server backups
How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database
I have recently had the privilege of working with multiple clients who have been taking advantage of Change Data Capture “CDC”. Change Data Capture is a feature that utilizes SQL Server Agent to log inserts, updates, and deletes occurring in a table. It makes these data changes available to be consumed in a relational format. […]
There Is Insufficient Free Space on Disk Volume To Create the Database
I have been involved in countless database migrations. Most of the time I have access to the existing source servers and future destination servers. In cases where you have access to both environments, it is very easy to evaluate and clean up any issues with the source databases. In situations where you are only provided […]
Dynamic Data Masking – SQL Server
Use Dynamic Data Masking to protect your data
Children at Technical Conferences Part II
Nearly 10 years ago I wrote a blog post about having my son tag along at various conferences I was speaking at. So much has changed in the past ten years and thankfully I’ve been able to bring my entire family along on various other trips. I was reminded by a Facebook memory about a […]
Azure SQL Database Manage Instance
Azure SQL Database Managed Instance is bridging the gap between 0n-premises SQL Server and Azure SQL Database. Azure SQL Database Managed Instance gives you the benefits of Platform as a Service and the scoped configuration of a SQL Server instance. The overall goal of Azure SQL Database Managed Instance is to provide 100% surface configuration […]
New Course: Implementing a Hybrid Cloud Solution in Azure
My latest Pluralsight course – SQL Server: Implementing a Hybrid Cloud Solution in Azure – is well over two hours and long and is based on part of my popular workshop/precon that I have been presenting over the past 18 months. This was a fun and challenging course to develop and record. The modules are: Introduction Understanding Azure IaaS Understanding […]