ExpressProfiler: The New Kid on the Block
I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools...
2014-05-15
613 reads
I'm pleased to inform you that yet another of my pet-projects, ExpressProfiler, joined the rapidly growing family of Ecosystem-based tools...
2014-05-15
613 reads
Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During...
2014-05-15 (first published: 2014-05-07)
8,542 reads
As is the case for many DB professionals, I am always tweaking (not twerking) and refining the missing indexes script to try and make it more robust and a...
2014-05-15
7 reads
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-05-15
684 reads
I’ve run into the not uncommon situation where there is a SQL login and no one seems to have the...
2014-05-15
1,014 reads
Today is Peace Officers Memorial Day and that’s why the flag is at half staff (Had to search, I didn’t...
2014-05-15
312 reads
I got this from watching a session from Jeffrey Snover at TechEd. It was a neat trick, and it’s worked...
2014-05-15
1,432 reads
I’m back from my
on the
with a big on
my face.
Like a good
I took lots (over 1400) pictures of
and
and
I also swam with...
2014-05-15
791 reads
2014-05-14
765 reads
Just spent some time re-reading my notes far and my ideas from before – glad I wrote them down, lots and...
2014-05-14
533 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