WaterOx SQL

Rotating Expired SQL Server TDE Certificates

• by WaterOx

• WaterOx SQL

In general, SQL Server TDE certificates will expire at some point. In SQL Server, if we have setup TDE using...

2019-02-08 (first published: 2019-01-23)

1,724 reads

Big Changes for WaterOx Consulting

• by WaterOx

• WaterOx SQL

March of 2019 would have marked that start of the 8th year of WaterOx Consulting, Inc. running. That isn’t going...

2019-01-10

164 reads

Stretch Databases for the Budget Poor DBA

• by WaterOx

• WaterOx SQL

The post Stretch Databases for the Budget Poor DBA appeared first on WaterOx Consulting.

2018-03-28

435 reads

Upcoming Content

• by WaterOx

• WaterOx SQL

This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts...

2017-07-24

358 reads

Upcoming Content

• by WaterOx

• WaterOx SQL

This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts...

2017-07-24

138 reads

Conditionally Retry a Failed Job

• by WaterOx

• WaterOx SQL

We have jobs that run in the early morning to load data to our data warehouses and other systems, and...

2017-07-03 (first published: 2017-06-23)

1,462 reads

SQL Security Email Course

• by WaterOx

• WaterOx SQL

Today I am very excited to announce that I have (finally!) launched my email course covering the basics of SQL...

2017-04-19

326 reads

Identify SQL Accounts Without Password Policy Enforced

• by WaterOx

• WaterOx SQL

When ‘Enforce Password Policy’ for SQL Server logins is turned off, you can make your password anything you want! Hooray!...

2017-03-02

413 reads

Better SQL Agent Job Alerts

• by WaterOx

• WaterOx SQL

  They kinda suck. I mean it is nice that we have the option for the SQL Agent to tell us...

2017-02-28 (first published: 2017-02-23)

3,467 reads

PowerShell -> Identify all SysAdmins in your SQL Server

• by WaterOx

• WaterOx SQL

No pressure. None whatsoever. There is just an Auditor standing behind you waiting for you to pull a list of...

2016-10-06 (first published: 2016-09-29)

1,977 reads