Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005   (RSS)

The Pond's Laws Home Page

This page will serve as a compendium of Pond’s Laws posts. The individual posts which promulgate the laws may be found as follows: Pond's First through Tenth Laws Pond's Eleventh Law Pond's Twelfth Law Pond's Thirteenth Law Pond's Laws of System Design

Pond’s Laws Home Page Now Live

Thanks to yet another kick-in-the-pants from Jimmy May (did he play soccer as a youth?) the Pond’s Laws Home Page is now live. Jimmy wanted to find all of Pond’s Laws in one place, and now he (and you) can. There’s also a link to the new page in the A

Windows 7 Now Available

You might have heard about this somewhere else.. but Windows 7 was launched today . I recently got an upgraded laptop from my employer, upon which I installed Windows 7. Both the machine and the software are quite remarkable. First, the machine, so you

Pond’s Thirteenth Law: Change Won’t Be Cheaper Tomorrow

Herewith, a discussion of the emergence of Pond’s Thirteenth Law (if you need to catch up, here are Laws One through Ten , Eleven , and Twelve , as well as three ruminations on the implications of Pond’s Seventh Law ).. One of the great things about my

A Gift From Jens and Jimmy

Two Microsoft folks frequently featured in this space, Microsoft Certified Masters Jimmy May and Jens Suessmeyer , have joined forces to bring to the world SQLIOSimParser, a tool to parse and interpret the XML output of the Bob Dorr’s SQLIOSim testing

Pond’s Twelfth Law: In Your Pursuit of Five Nines, Don’t Practice in Front of the CIO

After a long hiatus , Pond’s Laws of System Design (or, How to Be a Competent Professional in an Irrational World) returns. Thanks to Jimmy May for a kick-in-the-pants on this topic several months ago; I hope he’ll understand why I just had to wait until

Database Programming: Did You Know IN Can Do This?

Courtesy of Jens Suessmeyer comes this little gem purloined from an internal discussion; cut-and-paste this into SQL Server Management Studio and see if you can answer the questions in the comments before you execute the script: --   create and populate

Database Programming: What I’ve Learned About SQL Server 2008 (with a little on SQL Server 2005 thrown in)

With SQLRAP 2.5 out the door a couple of weeks ago, I’ve been free to turn to another project, SIPA, an internal effort to automate storage and retrieval of our group’s diverse intellectual property catalog. I’m acting as both the database architect and

Cumulative Upgrade 4 for SQL Server 2005 Service Pack 3 is Now Available

Actually, I’m about a month late to the party on this one..  but I’ve been busy.. Cumulative Upgrade 4 for SQL Server 2005 Service Pack 3 is available for download here . The SQL Server Release team discusses the SP3 release here and the SP2 release

Database Programming: The Time Zone Conversion Beast, Once Comatose, Returns to Taunt Us a Second Time (or, An Answer for Iain)

Now go away, or we shall taunt you a second time. - John Cleese as a French knight (picture at left); Monty Python and the Holy Grail One of the reasons I started blogging over four years ago was my conviction that the coding challenges with which my

Database Programming: Using the .modify() Method Against an XML Variable in SQL Server 2008

Make a note..  here’s my first useful programming tip for SQL Server 2008 (and yes, there will be more to come; I’m about a week and a half into my first SQL Server 2008 development project).. Way back in February of aught-seven, I shared Jerry’s

Thank You, Chris and Jorge: Follow-Up to Chris Shaw’s SQL Quiz 4

Last week I was tagged by Jorge Segarra (a/k/a @SQLChicken) in a meme started by Chris Shaw , who asked a great question about leaders in one’s career.  In reflecting on my response , it occurred to me that there was only one of the people I listed

Paul Randal Explains a Performance Bug

Paul Randal has another must-read post regarding a performance bug which surfaces in earlier versions of SQL Server 2005 and SQL Server 2008 when NOLOCK scans are executed against tables with off-row LOB data.  Both the causal scenario and the nature

So.. *This* Is How Twitter Gets People Into Trouble..

Consider this post a parable about what can happen if you let Twitter into your life.. I spent part of my day researching a particular capability of the TechSmith Camtasia Studio software my colleague Venkata Raj Pochiraju has been using to record readiness

Chris Shaw’s SQL Quiz 4

UPDATED 25 April 2009 to fix the link to Jimmy’s blog As a consequence of my recent ascension to Twitterato-hood (follow me @sqltwit), I’ve made several new SQL friends over the last couple of weeks.  One of those is Jorge Segarra (a/k/a @SQLChicken
More Posts Next page »
 
Page view tracker