So, since it has been some time since we looked at our Security Audit, let’s review what we’ve gone over so far: And We’re Back! Security Audit – Part 2 Security Audit On our next look at the Security Audit, let’s look at the server itself – SELECT COUNT(*) FROM sys.servers WHERE is_linked =’1′ This … More Security Audit – Part 4
So, as you can tell from the lack of posts over the past few months, I have been more than just busy. Between moving into a new house, moving my son into a college dorm, several SQL Saturdays, and just general work items, it has been extremely hectic. But, I am back now, and my … More And We’re Back!
Once again, we delve deep into what is part of a security audit and why each part is important. One part that I like to look at is the default directories where certain types of files are kept. To do this – on SQL Server 2012 and above – we simply run the following commands: … More Security Audit – Part 2
The words that many a person dreads hearing – Security Audit. Whether you’re the one having to perform the audit or just having to deal with the aftermath of one, it is never fun. Over the next few blog posts, we’re going to look at a few common points that are included in security audits, … More Security Audit