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.

PASS Summit 2016 – My Session Evaluations - Syndication – WaterOx Consulting

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

1 comments, 134 reads

Posted in WaterOx SQL on 24 June 2016

A New Look & A New Direction - Syndication – WaterOx Consulting

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, 189 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, 493 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

2 comments, 1,345 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, 222 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, 297 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, 221 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, 241 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, 971 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, 290 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, 768 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, 302 reads

Posted in WaterOx SQL on 9 September 2015

018 – Learn Like A Pro! - Syndication – WaterOx Consulting

Learn Like A Pro In WOxPod!, episode # 018 – “Learn Like...

The post 018 – Learn Like A Pro! appeared first on WaterOx Consulting.

Read more

0 comments, 306 reads

Posted in WaterOx SQL on 4 September 2015

Checking for Excessive Permissions in SQL Server - Syndication – WaterOx Consulting

Who can do what? One of the key things that a DBA...

The post Checking for Excessive Permissions in SQL Server appeared first on WaterOx Consulting.

Read more

1 comments, 325 reads

Posted in WaterOx SQL on 2 September 2015

017 – Thinking Like A Manager - Syndication – WaterOx Consulting

Thinking Like A Manager In WOxPod!, episode # 017 – “Thinking Like...

The post 017 – Thinking Like A Manager appeared first on WaterOx Consulting.

Read more

0 comments, 405 reads

Posted in WaterOx SQL on 28 August 2015

The Problem With AshleyMadison - » Syndication

What is the real problem with the AshleyMadison data breach? Well, let...

The post The Problem With AshleyMadison appeared first on WaterOx Consulting.

Read more

3 comments, 378 reads

Posted in WaterOx SQL on 26 August 2015

016 – Me, Myself and I - WaterOx Consulting

Me, Myself and I In WOxPod!, episode # 016 – “Me, Myself...

The post 016 – Me, Myself and I appeared first on WaterOx Consulting.

Read more

0 comments, 492 reads

Posted in WaterOx SQL on 21 August 2015

015 – Brian Davis - WaterOx Consulting

Brian Davis In WOxPod!, episode # 015 – “Brian Davis” we have...

The post 015 – Brian Davis appeared first on WaterOx Consulting.

Read more

0 comments, 343 reads

Posted in WaterOx SQL on 14 August 2015

014 -Kon Melamud - WaterOx Consulting

Kon!!!!!! In WOxPod!, episode # 014 – “Kon Melamud” Today we have...

The post 014 -Kon Melamud appeared first on WaterOx Consulting.

Read more

0 comments, 490 reads

Posted in WaterOx SQL on 31 July 2015

Sneak Preview – Episode 014 - WaterOx Consulting

Let’s Play A Game! So, just to tickle your fancy, here is...

The post Sneak Preview – Episode 014 appeared first on WaterOx Consulting.

Read more

0 comments, 284 reads

Posted in WaterOx SQL on 27 July 2015

Older posts