Blog - Title

January, 2005

  • Your Data in the Cloud

    Ranking Functions, TOP and Aggregates

    • 4 Comments
    This is something I came across a few times within the last few weeks so thought I’d share the findings: You probably heard about ranking functions by now. However you may have a missed this great benefit ranking functions bring to easing a complex scenario...
  • Your Data in the Cloud

    TSQL Exception Handling and Deadlocks

    • 1 Comments
    You probably hear about exception handling in TSQL already but here is a neat use of the feature: TSQL exception handling is very close to the top when it comes to popularity of the new TSQL features. The ability to handle exceptions without having to...
  • Your Data in the Cloud

    Soundcheck...

    • 0 Comments
    Testing 1,2,3... Quick Intro: I am a program manager in the ISV team in SQL Server development. I try to ensure SQL Server is well crafted to solve the underlying issues in the financial vertical. I've recently left the field organization where I worked...
  • Your Data in the Cloud

    Block-Buster: SQL 2005 and Blocking/Deadlocking

    • 0 Comments
    If you'd like some help in going to sleep at night, try thinking about how concurrency is controlled behind the scenes in SQL Server. No guarantees however: you may wake up in the middle of the night having nightmares about blocking and deadlocking. Seriously...
Page 1 of 1 (4 items)