Determining Active Directory Group Membership
As discussed in my previous post I prefer to use Windows authentication over SQL authentication on my SQL Servers. There...
2012-01-24
1,722 reads
As discussed in my previous post I prefer to use Windows authentication over SQL authentication on my SQL Servers. There...
2012-01-24
1,722 reads
Security is a very important part of every DBA’s role. If you are not clued up on security best practices...
2012-01-23
940 reads
Today's post is a follow on from one earlier this month Database uplevel Restores. I got round to testing restoring...
2012-01-20
1,144 reads
I had a problem just before the festive period where one of our production SQL Servers was randomly grinding to...
2012-01-18
1,718 reads
Today’s post is a quick one as I am a bit under the cosh.
There are many ways to move database...
2012-01-13
686 reads
I've been using 4 alerts for corruption now for about 2 years for Errors 823, 824, 825 and 9100. Basically...
2012-01-11
1,048 reads
I have, in the past had the need to rename a server, either because the server has been named incorrectly...
2012-01-10
777 reads
Today I've been reading Paul Randal's collection of Blogs from a series called A SQL Server DBA myth a day....
2012-01-06
687 reads
I read a blog post this morning on SQLServerCentral by Tim Radney about SQL Server Error Logs. Tim talks about...
2012-01-04
1,080 reads
I came across an issue on a server this morning where a drive had run out of free space. Now given...
2012-01-03
617 reads
Next Monday, Marchg 9, 2026, my one-day live online training SQL Server 2025 Unleashed:...
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
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