• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

SQL Server Database Consulting

  • Services
    • SQL Server Health Check
    • Fractional DBA
  • Pocket DBA®
  • Blog
    • Speaking
  • Testimonials
  • Contact
  • About

Kevin3NF

Yes, please…ignore my advice….

October 26, 2015 by Kevin3NF 1 Comment

Short one today:

I tell the upper level manager that ALL of his data is at risk due to one root issue.   Got him good and scared…he totally believed me.  And did absolutely nothing to fix it, or even explore possible fixes, which would have been a good exercise.

Swept it under the rug.

Seriously…one disgruntled employee with minor hacking skills and this place goes away.

Oops.

No fries for you.

**  This was a long time ago, so no…you can’t guess who I’m talking about by reading my LinkedIN profile 😀

Filed Under: Uncategorized

Unsupportable…thats what you are….

February 11, 2015 by Kevin3NF Leave a Comment

With apologies to Nat King Cole 🙂

Database backup failing

Write on “D:backupMyDatabaseMyDatabase_20150208104103883_D.bak” failed: 665(The requested operation could not be completed due to a file system limitation) [SQLSTATE 42000] (Error 3202) 

Hey, customer…let not put backups on O/S compressed drives please.

Oh…and why do you have your MDF/LDFs on the same drive…also compressed?

Resolution – punt it back to them and tell them SQL Server on compressed drives is unsupported config by Microsoft and by me.   Uncompress and expand or add a drive and uncompress.

Sheesh.  How many worst practices can you get in one server?

Filed Under: Uncategorized

Monitor for blockings…

May 3, 2013 by Kevin3NF Leave a Comment

Short and sweet…

Ticket for error 1105.   Teammate response: No blockings on server, monitor 4 days.

Ticket for error 601.  Teammate response: No blockings on server, monitor 4 days.

Ticket for login failed.  Teammate response: No blockings on server, monitor 4 days.

I.  Kid.  You.  Not.

Someone needs to be fired.  Or congratulated for making me look like a SQL SERVER GENIUS!!!! by comparison.

That is all.

Kevin3NF

Filed Under: Uncategorized

When deployments go bad…

June 7, 2011 by Kevin3NF 2 Comments

Wow…its been a long time since something went so sideways I felt compelled to write about it….

But don’t mistake that for there not being any craziness!

ATTENTION ALL DEVELOPERS!!!!

If you are going to do a major upgrade to your very large database, please consider the following:

  • YOU are responsible for your rollback plan. Nobody else.
  • When you wake us up to rollback because your upgrade blew up, please give us a chance to get up to speed, before you start calling Directors and VPs.
  • TAKE A BACKUP IMMEDIATELY BEFORE THE UPGRADE!!!!!
  • Store that backup in a folder that does not have a cleanup/delete process attached to it
  • Test this upgrade in your test/dev environment first.
  • Don’t expect me to throw a teammate under the bus on a conference call.
  • Don’t expect me to be on a conf call every 30 minutes…I’m busy cleaning this up.

Not only do you not get fries, you now owe me some! (Waffle fries from Chick-Fil-A will be just fine, thanks.)

That is all.

Filed Under: Uncategorized

Cluster down….think before you blame

April 15, 2009 by Kevin3NF 1 Comment

OK…if all 3 instances on a 3-node cluster suddenly start “timing out”, yet you can log directly in and query the databases…don’t you think you should at least look at the network components first?

Especially when the errors are showing on the client and web boxen…

Grrrrr….

Filed Under: Uncategorized

When to Modify Somebody Else’s Code

March 11, 2009 by Kevin3NF Leave a Comment

When to Modify Somebody Else’s Code

I was tagged by Brent Ozar on this question that has been floating aroung the Tweeterverse and blogosphere the last few days…

In keeping with the short-but-useful-or-amusing style of this blog:

When you have an OK in writing from the vendor or internal group that wrote it AND from the supervisor you got the approval from on your side.

Yeah…make darn sure your suggestion actually works before you even ask, do backups, keep scripts, etc.

Else you get no fries. You get fried. 🙂

Kevin3NF

Tag: Lee Everest

Filed Under: vendor code modify

  • « Go to Previous Page
  • Go to page 1
  • Interim pages omitted …
  • Go to page 33
  • Go to page 34
  • Go to page 35
  • Go to page 36
  • Go to page 37
  • Interim pages omitted …
  • Go to page 39
  • Go to Next Page »

Primary Sidebar

Search

Sign up for blogs, DBA availability and more!

Home Blog About Privacy Policy
  • Home-draft
  • Blog
  • About Us

Copyright © 2025 · WordPress · Log in