It's 11 pm on a Sunday night. You sit down to your desk to do some routine maintenance on the Postgres server. Nothing major: 10 minutes to si
How to get back into a Postgres server after … yes. Locking out postgres user.
Continue Reading→
HackTheBox: Lame walkthrough
No, not "a lame walkthrough" but "the walkthrough of the box called Lame." That came off wrong. Anyhow .... Yes, hello. There are several H
Tanceuticals and Skin Drop
This is a brain-dump of what I believe is an online scam of three review sites. But maybe it's perfectly legal. I don't know, you tell me. I am just
Zero to OSCP Chapter 1 – CompTIA S+ and N+
Hi guys, One year ago I decided to switch careers and get into cybersecurity. Don't get me wrong, I love my DBA career. But maybe I would l
Use Query Store to help with SQL Server upgrades
The Query Store is a feature that helps you evaluating query performance. It captures execution information asl well as up to 200 plans for a single
When the client asks for a unique ID based on name and address but gives you dirty data
case when len( ROW_NUMBER() OVER( PARTITION BY left(replace(name,' ',''), 3) + left(replace(addrsscty,' ',''),3) ORDER BY left(replace(name,' ',''),
When I get a request to build a 200-column report
Setting database to trustworthy will let you deploy assemblies in unsafe mode
The title says it all, but let me expand on this a little bit. I have an assembly that I wanted to emulate in SQL server. The first, obvious choice
SSIS – SQL Server data type
This blog post here on BI Developer Network contains a nice list on data conversion between SSIS and SQL server, something that gets my blood pressure
DBCC DBReindex
I ran into some 'Message 823' issues on my development DB, and upon running DBCC CheckDB() I saw that my indexes were the ones throwing the errors.