I was going about my own business today when I got an e-mail from Brent Ozar (twitter, blog) who is the editor-in-chief of SQLServerPedia. Apparently a wiki article that was made from my blog posts on shrinking has received the honor of being the first to receive the “Wiki of the month” recognition.
Great honor as [...]
Tag Archives: SQL Server
SQLServerPedia –> Do you use it?
Manage Your Transactions (So they don’t manage you – Part 1)
This is part 3 in a series on shrinking and transaction management. Click here for part 4. You can see them all in the Shrinking & Transactions category.
If you are one of the people who have been reading this blog, you know where I stand on shrinking databases/log files. I don’t like the practice (Post 1, Post [...]
What SQL instances are installed on my network?
Find All SQL Server Instances On Your Network!
It’s been awhile since a tool has given me that giddy, starstruck feeling but it’s happened this week… If you ever struggle with instance discovery and management, I hope you get excited and try this tool out as well. Bear with me as I walk through it.
If you [...]
Just add a join hint!
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 [...]
Shrinking is a popular topic…
When I started blogging, my first posts were on shrinking. That’s still a popular search. Why?
Don’t Touch that Shrink Button!
This post is part 1 in a series on shrinking and transaction management. Part 2 is linked at the bottom or here. You can see them all in the Shrinking & Transactions category.
This topic has indeed been done to death. Yet I still often encounter unnecessary database autoshrinks, scheduled shrink jobs and at times a seeming [...]
Good information on upgrade to 2008
The SQL Server Customer Advisory Team has a great blog and they have a good article here about upgrading to 2008. Lot of reasons to upgrade to 2008 (especially if you are on SQL Server 2000 or earlier). Check it out; http://blogs.msdn.com/sqlcat/archive/2008/12/08/ultimate-guide-to-upgrading-to-sql-server-2008.aspx
Follow Straight Path
Recent Comments