Let’s take a look at how to display Always Encrypted Data in SSRS with a gMSA (Group Managed Service Account). We are mixing some technologies […]
The post Always Encrypted...
2020-11-26 (first published: 2020-11-17)
280 reads
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-18 (first published: 2019-11-11)
569 reads
You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will only...
2019-11-18
15 reads
You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. The FCI will only...
2019-11-18
11 reads
You are going to create a SQL Server Failover Cluster Instance in Part 4 of our series on how to build a SQL Cluster Lab. […]
The post Build a...
2019-11-18
12 reads
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you give the Cluster Name...
2019-11-11
21 reads
You are going to create a multi-subnet Availability Group in Part 3 of our series on how to build a SQL Cluster Lab. First you […]
The post Build a...
2019-11-11
15 reads
This article is Part 1 in a series of articles showing how to build a SQL Cluster Lab. It covers building a Windows Cluster in Hyper-V that supports both...
2019-11-06 (first published: 2019-10-28)
676 reads
You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run cluster validation followed by...
2019-11-04
19 reads
You are going to create a Windows Cluster in Part 2 of our series on how to build a SQL Cluster Lab. You will run cluster validation followed by...
2019-11-04
29 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers