SQL Clone
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.

Upcoming Content

This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts will be are notes, code snippets and processes I am using and coming up with to figure out how to move the entire SQL Server infrastructure from on-prem to an… Read more

0 comments, 220 reads

Posted in WaterOx SQL on 24 July 2017

Conditionally Retry a Failed Job

We have jobs that run in the early morning to load data to our data warehouses and other systems, and if they don’t complete correctly, we start to have issues that ripple through the day. In the past, we had a service provider that would monitor our jobs and rerun… Read more

0 comments, 1,256 reads

Posted in WaterOx SQL on 23 June 2017

SQL Security Email Course

Today I am very excited to announce that I have (finally!) launched my email course covering the basics of SQL Server Security. This has been a lot of work to get a new system in place to make the learning experience a little different. It is like a normal email… Read more

0 comments, 198 reads

Posted in WaterOx SQL on 19 April 2017

Identify SQL Accounts Without Password Policy Enforced

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

0 comments, 232 reads

Posted in WaterOx SQL on 2 March 2017

Better SQL Agent Job Alerts

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

9 comments, 3,063 reads

Posted in WaterOx SQL on 23 February 2017

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

2 comments, 1,601 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, 345 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, 280 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, 318 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, 419 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, 313 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, 367 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, 360 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, 291 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

10 comments, 490 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

3 comments, 643 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

7 comments, 1,541 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, 381 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

2 comments, 502 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, 432 reads

Posted in WaterOx SQL on 10 December 2015

Older posts