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. […]
Category: SQLServerPedia Syndication
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 […]
New Course: Understanding and Using Azure SQL Database
At SQLskills, we just launched our new training class on Azure that I will be teaching in Chicago, and my course on Azure SQL Database was just published on Pluralsight too! While I am sharing awesome news, we also launched our new 3 day training class on upgrading SQL Server that Glenn and I will […]
SQL Saturdays and Why We Have Them
There has been some recent controversy over SQL Saturdays after PASS HQ announced some new changes. The changes introduced a new 600 mile radius for SQL Saturdays on the same day, an expansion from the previous 400 mile rule as well as reducing the PASS sponsorship from $500 per event to $250 per event and […]