Skip to content

Anna Hadnagy

  • About
05AugMarch 29, 2022

How to get back into a Postgres server after … yes. Locking out postgres user.

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

Continue Reading→
27JanMarch 29, 2022

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

Continue Reading→
04AprApril 5, 2020

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

Continue Reading→
04AprJune 26, 2020

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

Continue Reading→
02MayMay 2, 2017

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

Continue Reading→
29JulFebruary 13, 2023

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,' ',''),

Continue Reading→
28OctJune 26, 2020

When I get a request to build a 200-column report

Continue Reading→
19JunJune 26, 2020

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

Continue Reading→
29MayJune 26, 2020

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

Continue Reading→
28AprJune 26, 2020

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.

Continue Reading→

Posts navigation

1 2 … 4 Next

Categories

  • cybersecurity
  • Cybersecurity Path
  • Other
  • SQL server
© 2023 Anna Hadnagy
WordPress Theme: AccessPress Parallax