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!
I know most of you turned in today for the next post in my series on Security Audits. Well, I felt that I had to talk about something much more important. A friend of mine died on Monday (April 2nd, 2018). Not just any friend though. This was Robert Davis, also known as SQLSoldier on … More SQLSoldier
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