Identify SQL Accounts Without Password Policy Enforced

jump for joy

When ‘Enforce Password Policy’ for SQL Server logins is turned off, you can make your password anything you want! Hooray! No picky criteria and trying to remember yet another convoluted password! Not the best idea, especially if you need to have a more secured server. Recently I was performing a security audit for a client. One of the many things …

Better SQL Agent Job Alerts

notifications

  They kinda suck. I mean it is nice that we have the option for the SQL Agent to tell us when a job fails or succeeds, but if you have ever looked at the message, there isn’t much detail in it. Take a look at this (slightly edited) email I used to get from our systems: Not very helpful. …

PowerShell -> Identify all SysAdmins in your SQL Server

bossman

No pressure. None whatsoever. There is just an Auditor standing behind you waiting for you to pull a list of all the accounts with sysadmin rights in your SQL Environment. You can’t BinGle; the Auditor is watching. You start to sweat. A lot. You excuse yourself to run to the restroom to hide the panic attack you are having. While …

Think Using .. In Code Is A Time Saver? Think Again!

doubledot

Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out there) identify the exact location of the objects in the environment. The 4 part name follows the convention of <server>.<database>.<schema>.<object>. In most cases, you are only going to use the schema and object names. If you need to grab something …

Organizing a SQL Saturday – Part 3 – The Venue

venue

You’ve got your team; now you need to find a somewhere to host your event. If you are lucky, you already had a place via your user group, or before you even started thinking about pulling an event together. Odds are, though, you have been inspired to put on an event, and you need to find somewhere. Keep in mind …

sp_WOxCompliant Update

sp_WOxCompliant Logo

I just released an update to the sp_WOxCompliant script to fix a couple of issues. You can download it here! What changed?