DR drill - Part 2: Log Shipping
Welcome back to DR drill series!
In the last post (here), we have highlighted a number of ways to setup disaster...
2015-09-22
1,481 reads
Blog Posts
Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates
In this post we’re going to cover configuring a connection string in .NET applications...
2015-09-22
7,200 reads
Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates In this post we’re going to cover configuring a connection string in .NET applications for encrypting connections to SQL Server using certificates....
2015-09-22
5 reads
Finding Next Business Day in T-SQL
Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...
2015-09-22
5,165 reads
Finding the worst running query in a stored procedure
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...
2015-09-22 (first published: 2015-09-10)
4,661 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
539 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
329 reads
Improving Networking at PASS Events–Part 1
This week I’m spending some drive time thinking about how we might improve networking at SQLSaturday and that led to...
2015-09-22 (first published: 2015-09-10)
1,156 reads
Most Read: My Top 5 SQL Server Articles and Blogs
There has been some really useful blogs and articles posted over the last week or so, this is my top...
2015-09-22
519 reads
Populating My DBA Database for Power Bi with PowerShell – Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
855 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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