Making a Change Log Easier With PowerShell
Having a Change Log is a good thing. A quick and simple place to find out what has changed on...
2014-12-16 (first published: 2014-12-08)
5,148 reads
Having a Change Log is a good thing. A quick and simple place to find out what has changed on...
2014-12-16 (first published: 2014-12-08)
5,148 reads
T-SQL Tuesday, which was started by Adam Machanic (blog|twitter) and is now starting its 6th year, is hosted by a...
2014-12-09
793 reads
Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate...
2014-11-28 (first published: 2014-11-24)
6,790 reads
So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on...
2014-11-28 (first published: 2014-11-18)
7,148 reads
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...
2014-11-11
2,411 reads
I have a lab on my laptop running various servers so that I can problem solve and learn and recently...
2014-11-05
548 reads
A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening...
2014-11-04
4,903 reads
So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...
2014-10-06
703 reads
When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good...
2014-09-09
731 reads
A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...
2014-09-07
525 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