PowerShell -> Identify all SysAdmins in your SQL Server


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!


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


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?

Organizing a SQL Saturday – Part 2 – The Team


A lot of these types of events are pulled together by the local user group. If there is none, it is a great resource to spawn a group afterwards. Regardless, it helps to get a team together to get things underway. The trick is how you build the team and who is in it will have a tremendous impact on …

Organizing a SQL Saturday – Part 1 – Why Do It?

SQL Saturday Key Only

To kick off this series, I thought it would be worthwhile to discuss why it is I step up to help lead the effort to pull this event together. I know it did because it helped change mine. Without hesitation, which I now question sometimes, I stepped up and said I’d run the event. Information and contact info was relayed …