Detecting When a Login Has Implicit Access to a Database
Yesterday I blogged about how to figure out what database principals corresponded to what server principals. The key is to...
2009-02-23
1,874 reads
Yesterday I blogged about how to figure out what database principals corresponded to what server principals. The key is to...
2009-02-23
1,874 reads
All of the videos I've done are up under my profile. However, the video for The difference between GRANT, DENY...
2009-02-23
1,498 reads
It's been pretty busy since my last post. Just in one week I had at least 12 hours devoted to...
2009-02-23
713 reads
This past weekend was the Rocky Mountain Tech Trifecta, and I attended and presented as well. Actually I only attended...
2009-02-23
921 reads
It’s usually nice, sometimes challenging, always interesting.
The other day both Tia and I were working in the “spare” office when...
2009-02-23
753 reads
Question: Will the Mirror automatically fail back to the original Principal when it comes back online?
This question doesn't usually come...
2009-02-22
11,485 reads
A question on the forum asked how to find all the database mappings for a particular login. If you're on SQL...
2009-02-22
9,808 reads
Stuart says that as of Feb 20 registration is at 150 with a cap of 200, and plenty of speakers...
2009-02-22
672 reads
When the Kindle 2 was first announced, I debated about whether or not to get it. Then I realized I...
2009-02-21
1,369 reads
There is an active attack in the wild for the newly announced Adobe Acrobat and Adobe Reader vulnerability. While the...
2009-02-20
2,065 reads
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...
By Vinay Thakur
it has been a year since i have not written much on the blog...
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