How many times have you heard or uttered those words? You work hard and understand the business requirements, you try and get the logic to work to make the procedure return what was expected or update the data as expected. You do some unit tests in your environment, it may not scream but it comes [...]
Worked fine in development…
by Mike Walsh on 22. Jul, 2009 in Performance, Pet Peeve, SQL Server, Syndicate
Just add a join hint!
by Mike Walsh on 20. Feb, 2009 in Performance, Pet Peeve, Syndicate
When I posted about Empirical Evidence and finding a Troubleshooting Methodology, I talked about implementing a solution just because it seemed to work. This can manifest itself in different ways. Some are alright and harmless (what your shotgun hit happened to be the right fix) and some can be dangerous and hide the real problem.
One [...]
Empirical Evidence
by Mike Walsh on 18. Jan, 2009 in General, Pet Peeve, Syndicate
Or how I learned to stop asking so much and start trying…
Empirical, as defined by Webster: 1.) originating in or based on observation or experience 2.) relying on experience or observation alone often without due regard for system and theory 3.)capable of being verified or disproved by observation or experiment.
I think empirical thought and evidence [...]
Troubleshooting Methodology
by Mike Walsh on 31. Dec, 2008 in General, Syndicate, Troubleshooting
What is a troubleshooting methodology?
A lot of the technical problems I encounter with clients or in various roles are not really the fault of the technology at hand. They are either the result of rushed work, apathetic work or botched troubleshooting.
Before talking about what troubleshooting is, let’s talk about what it is not. It is [...]
- Invitation for T-SQL Tuesday #004: IO 01. Mar, 2010
-
Getting Organized – Goodbye Paper?
15. Jul, 2010
- Hey Software Vendors – Get a Clue! 02. Jul, 2010
- DBA Questions To Ask A Vendor 27. Jan, 2009
- Bill Clinton Wasn’t Impeached For… 29. Mar, 2010
-
Checklists, Recipes and Algorithms
16. Mar, 2009
-
SQL Server Licensing Myths
27. Jul, 2010
- Why Should I Blog? 14. Dec, 2009
- Don’t Touch that Shrink Button! 07. Jan, 2009
- Seacoast SQL Server Users? 09. Nov, 2009
-
Plan To Fail Or Don’t Expect To Succeed
18. May, 2010
-
Life Changes – 2 For The Price Of 1
08. Jun, 2010
- Tetelestai – It is Finished 11. Apr, 2009
-
Why Hire A DBA?
24. May, 2010
-
Getting Organized – A Task’s Life
19. Jul, 2010
-
Mike Walsh: On the Mac version at least it is incredibly easy....
-
NULLgarity: Trying Evernnote today... very first impression is...
-
Tom: Hi, just thought I'd add something.... the only re...
-
NULLgarity: Enjoyed reading your Evernote series. I'm a big O...
-
Mike Walsh: Hi Natasha - That is some error to make the DB gr...
-
Natasha: I would like your opinion please. My database w...
-
Mike Walsh: Stan - The rationale makes perfect sense and it is...
-
Stan Segers: Hi John, Mike, The development undertaken is Of...
-
Mike Walsh: John - If you re-read his note I believe we are in...
-
John Cogan: Pretty certain that Stan is not license compliant,...
-
John Cogan: @Stan, since none of those bundled admin/developer...
-
Mike Walsh: that is a great point. I hadn't thought of that ei...
-
Mike Walsh: Hi Stan - I have never checked with MS specifical...
-
Abhilash Melethil: Thanks for the Post Mike!...
-
Thomas Rushton: "The catch"? Unfortunately, v5.0 of the MAP requi...
