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,735 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
170 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
437 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
360 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
141 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,473 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
328 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
419 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,471 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,983 reads
Blogs
The Redgate Seminar – Brisbane
By Steve Jones
On Thursday, May 2, we have the Redgate Seminar in Brisbane. I’ll be at...
Microsoft Fabric Training and Tutorials
By Brian Kelley
Microsoft Fabric is the new data offering in Microsoft Azure and there is a...
DBA and Developer: Allies or Adversaries?
By Rohit Garg
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and...
Forums
Report definition has an invalid target namespace
I'm hoping someone here has encountered this before and was able to fix it....
Query about GAC (Global Assembly Cache)
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
How to check for data loss after rollback
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
Question of the Day
Reporting Services Editions
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers