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

Rotating Expired SQL Server TDE Certificates

In general, SQL Server TDE certificates will expire at some point. In SQL Server, if we have setup TDE using SQL certificates we may have reached a point in time when the cert has expired. Maybe we haven’t. Maybe we don’t even know. We can check quickly to see if… Read more

0 comments, 1,714 reads

Posted in WaterOx SQL on 23 January 2019

Big Changes for WaterOx Consulting

March of 2019 would have marked that start of the 8th year of WaterOx Consulting, Inc. running. That isn’t going to happen. I have been thinking hard for the last year about what to do when it comes to the consulting/incorporated side of my SQL life and have come to… Read more

1 comments, 160 reads

Posted in WaterOx SQL on 10 January 2019

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, 356 reads

Posted in WaterOx SQL on 24 July 2017

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, 136 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,446 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, 325 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, 401 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

15 comments, 3,436 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

4 comments, 1,975 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, 475 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, 400 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, 462 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, 720 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, 429 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, 513 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, 685 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, 413 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

12 comments, 794 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

7 comments, 788 reads

Posted in WaterOx SQL on 9 March 2016

Older posts