Skip to content

Anna Hadnagy

  • About
31MarMarch 31, 2015

sp_msforeachtable

I will make this short and sweet for you. If there is something you want to do to all tables in your database, there is a command for you. I wil

Continue Reading→
25FebFebruary 25, 2015

The thing with cursors

So our aggregated databases have experienced some loading errors lately, and until that gets fixed, I have to collect the data straight from the field

Continue Reading→
09FebFebruary 25, 2015

Cast datetime as varchar

I stumbled upon this great Q+A on Stack Overflow when I was looking for options to cast datetime for a report. (The customer didn't like our standard

Continue Reading→
09FebFebruary 9, 2015

When a blocked procedure alert comes in

And I realize I was the one who launched those procedures

Continue Reading→
02DecFebruary 9, 2015

When the Senior DBA sits by me

And I pretend I totally understand the whole query plan

Continue Reading→
08Sep

Fun fact – SQL server truncates

Tl;dr - SQL server 2008R2's results to grid output truncates string values above 43,680. Conclusion: if half of your script is missing, it might st

Continue Reading→
24JulFebruary 25, 2015

The morning after SQL server failed three times in one night

Continue Reading→
08Jul

Today was the day

When the server ran out of both memory and disk space. On both drives.

Continue Reading→
27JunJune 26, 2020

When I talk with my ex supervisor about my current supervisor

@annahadnagy It really is the only way to "supervise" you. Give you a hammer and some gaff tape and leave you alone for a few hours. — Jason Nobl

Continue Reading→
Linke
25JunJune 26, 2020

Linke

My brother asked me to come up with some pictures to show her girlfriend the many beautiful places of this world. Being the dedicated overachiever

Continue Reading→

Posts navigation

Previous 1 2 3 4 Next

Categories

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