THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Rant   (RSS)
Showing page 2 of 3 (24 total posts)
  • What 5 things should SQL Server get rid of?

    I’ve been “tagged” by my friend Paul Randal. It’s a high-tech way of making someone else do what you want, but since it’s Paul, well, I guess I’m OK with that. He’s asked in his recent blog entry “What five things would you get rid of in SQL Server if you were in charge?” This is, of course, a delicate issue. After all, I work at Microsoft, so ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 12, 2010
  • Agile isn’t always Agile

    I want to make a disclaimer before I dive into this topic – At Microsoft we use all kinds of development methodologies, and I’ve worked in lots of other shops using lots of methodologies. This is one of those “religious” topics like which programming language or database is best, and is bound to generate some heat. But this isn’t pointed towards ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 12, 2010
  • Geek it Up

    I’ve run into a couple of kinds of folks in IT. Some really like technology a lot – a whole lot –and others treat it more as a job. For those of you in the second camp, you can go back to your drab, meaningless jobs – this post is for the first group. I’m a geek. Not a little bit of a geek, a really big one. I love technology, I get excited about ...
    Posted to Buck Woody (Weblog) by BuckWoody on April 1, 2010
  • Code that Writes Code - A Good Idea or Not?

    I’m a big fan of code that writes code – most of the time. For instance, whenever you use the “templates” feature in SQL Server Management Studio (SSMS) or the Maintenance Wizard, you’re using code that writes other code. There’s even a trick of writing Transact-SQL (T-SQL) code that in turn creates other code. But there is a class of code ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 16, 2010
  • Make it Easy for People to Help You

    OK, there are probably a dozen or more of these kinds of posts, but I’ll dive in anyway. From time to time, people send me e-mails or comments on this blog asking for help. Sometimes it’s on the topic at hand, and other times the topic just jogs their memory about something else. Often I’m happy to help. If I know the answer without doing any ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 8, 2010
  • Spit it out already!

    You’ve probably seen that commercial where the chewing-gum company van stalks the guy who has been chewing the same piece of gum too long, and they attack him and make him chew another piece. I feel like that with SQL Server 2000. Almost every shop I go into has at least one primary application running on SQL Server 2000. Now, don’t get me wrong ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 6, 2010
  • The Transact-SQL Prime Directive – a bad example

    A while back, I ranted that the design and implementation of Transact-SQL should be guided by a prime directive that guarantees no interference with the flow of set-based data in Transact-SQL.   That was primarily motivated by the fact that no such guarantee exists today in T-SQL. That is, when you move set-based data around in T-SQL, you ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 18, 2009
  • Aren’t DBA’s Just System Admins for Databases?

    Last week I ran into an argument I’ve had since I left the mainframe space decades ago. A developer told me “DBA’s don’t design databases.” The inference was that DBA’s (i.e., Database Administrators) only worry about hardware, security, OS, database backups, things like that. He seemed amazed that a DBA would ever do “data” work. It may be the ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 30, 2009
  • Please keep the system stored procedures updated

    One of the things I like about SQL Server (and Sybase for that matter) is that it comes with tons of system stored procedures. Who doesn't find procs like sp_who, sp_help, and and sp_helprotect indispenable? But unfortunately it seems to me that Microsoft is on the path to abandon these system stored procedures. Judging from the fact that many of ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on May 7, 2009
  • Document the locking behavior

    In a multi-process/multi-thread system, locking is central to maintain data consistency and keep things in order. It is inevitably at the root of almost all the concurrency and scalability problems. To understand the behavior of such a system and to troubleshoot its performance problems, you have no choice but to have a good grasp of its locking ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on April 2, 2009
Privacy Statement