IMG_1059 (2)

A New Look & A New Direction

You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you choose. You’re on your own, and you know what you know. And you are the guy who’ll decide where to go. – Dr. Seuss

ALIASES

Quick PS script to get SQL Server Configuration Aliases

Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or migrating to a new server. Trust me, we just got burned by this recently. A missed alias resulted in a critical app being down for a while until we figured it out. If you use aliases and don’t have them …

Digby! says what?

Documenting SQL Server Access – Who Can Do What?

When is the last time you audited who has SQL Server access? No really? When did you last do this? Have you ever done it? If you have, great! If not, well, let’s fix that. Below I have a PowerShell script that can help enlighten you to your SQL Server security situation a little more. Before we get to that, …

STIGs Image

DoD STIGs – V-32368

Overview: Title: The DBMS must produce audit records containing sufficient information to establish what type of events occurred. Vulnerability ID: V-32368 STIG ID: IA Controls: None Severity: medium Description: Information system auditing capability is critical for accurate forensic analysis. Audit record content that may be necessary to satisfy the requirement of this control includes: time stamps, source and destination addresses, …

STIGs Image

DoD STIGs – V-32413

Overview: Title: Database software directories, including DBMS configuration files, must be stored in dedicated directories, or DASD pools, separate from the host OS and other applications. Vulnerability ID: V-32413 STIG ID: IA Controls: None Severity: medium Description: When dealing with change control issues, it should be noted any changes to the hardware, software, and/or firmware components of the information system …

Rack'em

What’s Going On? A review of 2015 and forecast for 2016

It’s been quiet… Too quiet Yes, yes it has. Things have been quiet here as of late. Posts and podcasts both have been lacking. I felt it important to share will all of you what has been happening, and what is going to happen in the future with this site, my company WaterOx Consulting, and me.   What Happened? 2015 …