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,724 reads
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
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
The post Stretch Databases for the Budget Poor DBA appeared first on WaterOx Consulting.
2018-03-28
435 reads
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
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
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
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
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
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
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
By Rayis Imayev
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
By Ed Elliott
The next example is how to do a CTE (Common Table Expression). When creating...
I have 2 tables, df1, and df2. I would like to join the two...
Hi , Has anyone tried to do this...I'm trying to select only "new customers"...
Hello, I'm trying to get the server name programmatically. Even after I do this:...