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,761 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
178 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
453 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
369 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
438 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,483 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
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers