Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

WaterOx SQL

Chris Bell (MCITP) has been working with Microsoft technologies for over 20 years and using SQL Server for over 18 of those years. He is currently the Owner and Lead consultant for WaterOx Consulting, a Maryland based company focused on helping clients, that can’t afford or justify a full time data team, get the most from their SQL Server environments. For more information please visit WateroxConsulting.com.

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… Read more

0 comments, 1,380 reads

Posted in WaterOx SQL on 29 September 2016

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… Read more

0 comments, 231 reads

Posted in WaterOx SQL on 23 September 2016

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… Read more

0 comments, 185 reads

Posted in WaterOx SQL on 22 September 2016

sp_WOxCompliant Update

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

The post sp_WOxCompliant Update appeared first on WaterOx Consulting.

Read more

0 comments, 203 reads

Posted in WaterOx SQL on 22 September 2016

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… Read more

0 comments, 251 reads

Posted in WaterOx SQL on 31 August 2016

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

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… Read more

0 comments, 245 reads

Posted in WaterOx SQL on 26 August 2016

T-SQL Tuesday #080 – The Gift of the Basics

This month’s T-SQL Tuesday (#080) is being hosted by Chris Yates (B|T) (Happy B-day Chris!). He decided that this month’s theme was to be a gift to the community of something you had to offer that someone else may find as a gift. Or maybe it isn’t. That’s my interpretation.… Read more

0 comments, 276 reads

Posted in WaterOx SQL on 12 July 2016

Hearing Responsibility

A while ago I was watching Shark Tank on TV and at one point Robert Herjavich (T|B) made the great quote above. When I heard that statement I stopped the show immediately. I went back (Thank you whoever made rewindable TV possible!) and listened to it again to make sure… Read more

0 comments, 224 reads

Posted in WaterOx SQL on 29 June 2016

PASS Summit 2016 – My Session Evaluations

No Sessions For You! The announcements of the speakers and sessions selected for the PASS Summit 2016 were recently announced, and I was not picked for any sessions. I do not have any ill feelings to those that go through the herculean effort to create the reviews and the Summit… Read more

3 comments, 201 reads

Posted in WaterOx SQL on 24 June 2016

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

The post A New Look &… Read more

15 comments, 305 reads

Posted in WaterOx SQL on 28 April 2016

Quick PS script to get SQL Server Configuration Aliases - Syndication – WaterOx Consulting

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…

Read more

1 comments, 576 reads

Posted in WaterOx SQL on 9 March 2016

Documenting SQL Server Access – Who Can Do What? - Syndication – WaterOx Consulting

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…

Read more

5 comments, 1,456 reads

Posted in WaterOx SQL on 17 February 2016

What’s Going On? A review of 2015 and forecast for 2016 - Syndication – WaterOx Consulting

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,…

Read more

3 comments, 319 reads

Posted in WaterOx SQL on 6 January 2016

What Alerts Us About The SQL Agent? - Syndication – WaterOx Consulting

The SQL Agent is our friend! Setting up SQL Server Agent to automate jobs and alerts is a great idea. It is always better to learn about a failing job or system prior to end users so we, as DBAs, can try to deal with it. But what happens when…

Read more

1 comments, 414 reads

Posted in WaterOx SQL on 16 December 2015

SQL F.A.D. – Trace flag 834 and columnstore indexes - Syndication – WaterOx Consulting

Trace flags can be good Are special codes we, the DBA, can use to change the way the SQL Server engine works. Some perform simple changes, like turning off excessive backup success notices in the logs. Other can completely cripple your SQL Server if you don’t know what you are…

Read more

1 comments, 329 reads

Posted in WaterOx SQL on 10 December 2015

020 – A Foolish Decision - Syndication – WaterOx Consulting

Making Foolish Decisions In WOxPod!, episode # 020– “A Foolish Decision” I announce a foolish decision I recently made, and how it will impact the future of WaterOx Consulting. [divider] Show Links: The Motley Fool  

The post 020 – A Foolish Decision appeared first on WaterOx Consulting.

Read more

0 comments, 315 reads

Posted in WaterOx SQL on 16 October 2015

Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick - Syndication – WaterOx Consulting

The Assumption I assume you already have a Hyper-V basic configuration on your system, be it a laptop, server or “other” with at least 1 client/guest VM running. Whatever you have it running on, you are going to need to take a few additional, and very simple, steps to get…

Read more

3 comments, 1,046 reads

Posted in WaterOx SQL on 7 October 2015

019 – 24 HOP Questions Answered - Syndication – WaterOx Consulting

  24 HOP Questions Answered In WOxPod!, episode # 019 – “24 HOP Questions Answered” I answer those questions that I wasn’t able to get to during the webinar as well as a couple more items. [divider] Show Links: Watch the recording   Download the Slides & Scripts Townsend EKM for…

Read more

0 comments, 396 reads

Posted in WaterOx SQL on 2 October 2015

SQL Server’s TIMESTAMP Is Not What You May Think It Is. - Syndication – WaterOx Consulting

TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL Server is not what you may think it is. I know right? The general consensus seems to lean towards it just being a bad naming decision by someone at Microsoft. The TIMESTAMP in SQL Server is actually a…

Read more

1 comments, 856 reads

Posted in WaterOx SQL on 23 September 2015

The Poor Man’s SQL Backup Encryption - Syndication – WaterOx Consulting

Well, that was interesting While playing around with demos to use in my newer session, Hacking Exposé Too (See it at Summit 2015 or during the 24HOP Summit Preview next week!), I stumbled across a fun demo that one could call the poor man’s encryption for backups. It was quite…

Read more

2 comments, 350 reads

Posted in WaterOx SQL on 9 September 2015

Older posts