I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?
2010-08-25
3,618 reads
In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...
2010-07-23
5,025 reads
When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....
2010-01-08
2,756 reads
Midlands PASS is a small user group. We average about 15 people coming to meetings, which is good for Columbia,...
2009-12-30
1,349 reads
The conversation on local administrators having rights in SQL Server has proven to be interesting and at times entertaining. My...
2009-12-10
2,810 reads
This was actually spurred by a post from Ted Krueger (@onpnt), which led to a short, but hearty, discussion on...
2009-11-25
8,179 reads
SQL Server Express has the same code base as the rest of the versions of SQL Server, but there are some differences in how to set it up and configure various tasks. MVP Brian Kelley shows us how to enable the Dedicated Administrator Connection.
2009-10-21
5,952 reads
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns
2009-10-13
3,534 reads
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-10-01
7,587 reads
I've started a blog to write down and track my personal goals:
The Goal Keeping DBA
Since Active August is part of reaching my goal...
2009-08-04
1,098 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers