SQL Server – Script to generate Read-Only Routing URLs
If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should...
2015-10-01
509 reads
Blog Posts
The Extended Event GUI
In the previous article in this series I shared the basics around assembling an XEvent session. The method used in...
2015-10-01 (first published: 2015-09-25)
2,640 reads
What’s new for BI in SQL 2016 – Session materials
SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too...
2015-10-01
580 reads
Azure Virtual Machine Blog Series – Changing the size of a VM
I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on...
2015-09-30 (first published: 2015-09-24)
2,803 reads
Deployment Contributor Logger
Niche tool of the day
If you know what a deployment contributor is and have wanted to see what steps were...
2015-09-30
928 reads
Deployment Contributor Logger
Niche tool of the day If you know what a deployment contributor is and have wanted to see what steps were in a plan and have got bored setting...
2015-09-30
3 reads
Deployment Contributor Logger
Niche tool of the day If you know what a deployment contributor is and have wanted to see what steps...
2015-09-30
206 reads
Deployment Contributor Logger
Niche tool of the day If you know what a deployment contributor is and have wanted to see what steps...
2015-09-30
214 reads
How to convert to Base64 and backwards via T-SQL
I want to share my way to convert a string to Base64 and back. Let me note that presented method...
2015-09-30
1,927 reads
How to convert to Base64 and backwards via T-SQL
I want to share my way to convert a string to Base64 and back. Let me note that presented method is not the fastest, but it has one important...
2015-09-30
19 reads
Blogs
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
What is ALM in Fabric?
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
The Most Successful Startups in 2025 — And What They Have in Common
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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