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,765 reads
Chris
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
179 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
454 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
370 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
154 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,488 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
337 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
439 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,484 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,998 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Grogol Permai Tlpn/wa:085373737551
Pert.Grogol Permai, Jl. Prof. Dr. Latumeten No.4 Blok F 3, Jelambar, Kec. Grogol petamburan,...
BCA KCU WISMA ASIA Tlpn/wa:085373737551
Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu Sel., Kec. Palmerah, Kota...
BCA KCU THAMRIN. Tlp :085373737845
BCA KCU THAMRIN. Tlp :085373737845.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers