THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Development   (RSS)
Showing page 2 of 2 (20 total posts)
  • We don't always need mobile or web equivalents of our Windows applications

    At SQLRally, we brought along an iPad to demonstrate that monitoring doesn't have to be web-based to be mobile. We fielded a lot of questions about this, the most common one being, ''Whoa, is that native?'' No, it was not native... we were using remote desktop (RDP). While yes, it can be an extra step (or two, if you need to VPN) to go ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 19, 2011
  • Big League Technical Staff

    So I was blissfully reading the twitter feed when @Tim_Mitchell tweeting the following article Consultants are pros, while corporate IT staff are minor leaguers by Erik Eckel, that for some reason seems to exist to feed the need that IT staffers have to despise consultants who come in and are listened to, often when there are hyper qualified IT ...
    Posted to Louis Davidson (Weblog) by drsql on April 12, 2011
  • T-SQL Tuesday : Are hotshot DBA skills necessary?

    Let's face it, there is a wide variety of skill out there. If you spend any time monitoring StackOverflow, MSDN forums, Ask SQL Server Central or twitter's #sqlhelp hash tag, you'll be very well aware that there are people out there barely managing their database environments - people that some of us wouldn't let within a mile of our own data ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 2, 2010
  • Sometimes it's the small things : match column names in subqueries

    The behavior of column matching in subqueries is a little peculiar, to say the least.  If you've been bitten by this behavior once, you're unlikely to have been bitten a second time, but for some of us it just takes a while to sink in. This morning I wasted a good five minutes ''troubleshooting'' a query that wasn't working out the way I ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 27, 2010
  • "What three events brought you here?"

    I was tagged by Tim Mitchell (twitter) in a recent meme launched by Paul Randal (twitter), entitled, ''What three events brought you here?'' Well, I've lied told stories about this in the past.  If you've read my previous posts about my career (in particular, this one), you'll know that I'm Canadian, gave up NHL dreams early, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on January 19, 2010
  • Connect digest : 2009-10-17

    I've been fairly distracted this past week with my ''Bad habits to kick'' series, so apologies for being so late with the Connect digest.  I stumbled upon a few pretty interesting items from the past two weeks; I hope you find them interesting as well. #498082 : Allow direct usage of scalar functions in RAISERROR() It has bugged me that in ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 17, 2009
  • What is a physical database?

    A bit of terminology that gets beaten to death is that of the “physical” database.  I would think most every DBA uses this term (I do), but…to mean what?  I think there are two common utilizations: The layer of tables, constraints, indexes, etc used to store data The actual on-disk structures. Frankly, until 3 years ago, I ...
    Posted to Louis Davidson (Weblog) by drsql on June 11, 2009
  • disallow results from triggers

    A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers.  Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor usage of them will allow you to shoot your foot off in a heartbeat as I discussed in my earlier ...
    Posted to Louis Davidson (Weblog) by drsql on June 6, 2009
  • Using a Mac in a Windows world

    As a ''SQL Server guy'' first and foremost, I often have to defend my use of a Mac both as a travel and presentation laptop, and as my primary development workstation.  Today over on my work-related blog, I penned a story explaining my experiences, why I chose to switch platforms for much of my work, and what kind of problems this has caused ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 30, 2009
  • Data correctness during the development process

    During all phases of development, particularly when building a completely new system, it is very common to have a need for data to test with.  As important as this is for a UI system, the need is doubled is when you are working on a reporting system.  While Everyone knows that the process of getting test data can be a fickle ...
    Posted to Louis Davidson (Weblog) by drsql on October 9, 2006
Privacy Statement