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...
2019-02-08 (first published: 2019-01-23)
1,750 reads
WaterOx SQL
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...
2019-01-10
172 reads
Stretch Databases for the Budget Poor DBA
The post Stretch Databases for the Budget Poor DBA appeared first on WaterOx Consulting.
2018-03-28
446 reads
Upcoming Content
This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts...
2017-07-24
364 reads
Upcoming Content
This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts...
2017-07-24
147 reads
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...
2017-07-03 (first published: 2017-06-23)
1,480 reads
SQL Security Email Course
Today I am very excited to announce that I have (finally!) launched my email course covering the basics of SQL...
2017-04-19
331 reads
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!...
2017-03-02
433 reads
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...
2017-02-28 (first published: 2017-02-23)
3,474 reads
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...
2016-10-06 (first published: 2016-09-29)
1,993 reads
Blogs
T-SQL Tuesday #187–Solving Problems
By Steve Jones
This month we have a great invite from Joe Fleming, a first time host...
T-SQL Tuesday #187: It’s Extended Events. It’s Always Extended Events
Joe Fleming wants to know how I solve weird problems. I’m not sure I’m...
Starting Points for Quantum Computing Learning
By Brian Kelley
I didn't have these in my slides for the Techno Security & Digital Forensics...
Forums
The Trigger Updated Column(s)
Comments posted to this topic are about the item The Trigger Updated Column(s)
How to add metadata for every record in Azure postgres tables
Hi, I have a situation in one of the applications I am working on...
average duration increasing inline with exec counts
As the title says , I've got a handful of stored procs where the...
Question of the Day
The Trigger Updated Column(s)
In a trigger, I can use UPDATE() or UPDATED_COLUMNS() to determine which columns were changed. For these functions, which one accepts a column name as a parameter?
See possible answers