Opinions, tips, and news orbiting Microsoft
First published on MSDN on Oct 19, 2017 Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but that’s not for lack of usefulness. RAM is far faster than SSD and certainly arm based disks, … Continue reading Implementing Buffer Pool Extension
First published on MSDN on Aug 21, 2017 In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option in a video. If you are using Availability Groups or Mirroring you know you need to sync SQL logins and … Continue reading Sync SQL Logins and Jobs
First published on MSDN on Jul 18, 2017 In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth with multiple data files in TempDB consistent. You’ll see how growth occurs if the files are disproportiona… Continue reading Trace Flag 1117 Growth and Contention
First published on MSDN on Jul 17, 2017 I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read on the internet so this video is aimed at both answering the questions and debunking … Continue reading Query Store Questions From The Field
Today we have @neenakamath telling us about the great new @Azure Mixed Reality Services we announced at #MWC19. More information at https://aka.ms/MR. Continue reading What is Azure Mixed Reality Services? | One Dev Question
I’ve moved my blog to https://devkeydet.blog. Links to individual posts on this blog should start redirecting shortly. Please update your RSS readers.
@devkeydet
First published on MSDN on Jan 23, 2019
Azure SQL Managed Instance is fully managed PaaS version of SQL Server hosted in Azure cloud and placed in you own VNet with private IP address. In this post, I will shortly explain how to c… Continue reading Getting started with Azure SQL Managed Instance
First published on MSDN on Jan 21, 2019
Azure SQL Database – Managed Instance is fully-managed PaaS service that provides advanced disaster-recovery capabilities. Even if you accidentally drop the database or someone drops your databas… Continue reading Recreate dropped database on Azure SQL Managed Instance