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,751 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,481 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
Teaching at the SC Statewide Audit Conference
By Brian Kelley
Instead of teaching the CISA exam prep course, I'm teaching in the IT track....
Upgrading SQL Server in a Container
By Steve Jones
I decided to update software on my laptop recently during a trip. I’m loathe...
SQL Server Editions: What’s the Difference and Why It Matters
By Kevin3NF
Understanding the Limits Before You Hit Them If you’re responsible for a SQL Server...
Forums
is there a reorg available in sql server?
hi i have a 67 million row fact table that needs about 30 million...
The Technical Debt Anchor
Comments posted to this topic are about the item The Technical Debt Anchor
Question of the Day
Getting the Updated Column List
What happens when I run this code in SQL Server 2022?
UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED()See possible answers