Update Wow, there was a lot more wrong with everything than I originally thought. (How many times have we said THAT in tech?) It wasn’t just 1 or 2 files that had malware…it was 155. And two websites. The solution (at least, I hope this has solved it): Install and use the WordFence plugin. The […]
Author: Jen McCown
Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)
Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves writing and teaching a lot. The plan for January 2022 is a focus on SQL Server security. We’ve already collaborated and published one blog over at MinionWare.net: UNDERSTANDING SQL SERVER SECURITY: Secure xp_cmdshell with the Microsoft Master’s guide (in 4 not-so-easy […]
NVARCHAR length shows up doubled
An experienced DBA I know didn’t realize this: if you look at sp_help or sys.columns for an NVARCHAR column, the max_length value will show up as double the allowable length. Let me explain. CHAR and VARCHAR length is normal Let’s say we have a “val” column in a table, and it’s of type VARCHAR(10). CREATE […]