Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008   (RSS)
Monday, October 26, 2009 8:45 PM

New Career Campaign From Microsoft Learning

UPDATED 27 October 2009 with the correct expiration date for the E-Learning Collections discount (thanks, Lain !). Whether you are currently unemployed, looking for a promotion, or trying to become indispensible in your existing role, Microsoft has launched
Posted by Ward Pond | 2 Comments
Monday, October 26, 2009 7:30 PM

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
Posted by Ward Pond | 0 Comments
Monday, October 26, 2009 7:30 PM

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
Posted by Ward Pond | 0 Comments
Thursday, October 22, 2009 8:45 PM

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
Posted by Ward Pond | 3 Comments
Tuesday, October 20, 2009 9:45 PM

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
Posted by Ward Pond | 0 Comments
Monday, September 28, 2009 9:15 PM

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
Posted by Ward Pond | 0 Comments
Monday, September 28, 2009 8:45 PM

SQL Server 2008 R2 August CTP Available for Download

If you’re interested in the next release of SQL Server, the BI-focused SQL Server 2008 R2, you’ll be pleased to know that the August CTP is available for download here for MSDN and TechNet members. Here’s the skinny from the download page: SQL Server
Posted by Ward Pond | 0 Comments
Wednesday, September 09, 2009 9:09 AM

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
Posted by Ward Pond | 1 Comments
Monday, September 07, 2009 6:15 PM

Database Programming: A New String Concatenation Contender for SQL Server 2008

UPDATED 11:11p 7 September 2009: Based on my latest exchange with Adam (see the comments for this post), compound operators should be avoided for string concatenation due to the ORDER BY bug discused in KB 287515 . The XML variant below is the preferred
Posted by Ward Pond | 7 Comments
Friday, September 04, 2009 5:30 PM

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
Posted by Ward Pond | 4 Comments
Tuesday, August 25, 2009 7:45 PM

Adam Machanic Likes MERGE, Too

Hot on the heels of yesterday’s MERGE discussion comes a complementary (and far more detailed) take from Adam Machanic .  It’s a nifty technical discussion, under the banner of an outstanding Dr. Strangelove pun. To see some of the true power of
Posted by Ward Pond | 0 Comments
Monday, August 24, 2009 9:30 AM

Database Programming: Why I Like MERGE

In the wake of last month’s post on my new development efforts in SQL Server 2008, several of you have asked me to go into further detail.  This post is my first effort to answer those questions; right now, we’ll focus on these two , which relate
Posted by Ward Pond | 2 Comments
Sunday, July 26, 2009 11:45 PM

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
Posted by Ward Pond | 6 Comments
Thursday, July 02, 2009 11:15 PM

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
Posted by Ward Pond | 0 Comments
Attachment(s): SLA Calculations.zip
Wednesday, June 17, 2009 11:45 PM

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
Posted by Ward Pond | 0 Comments
More Posts Next page »
 
Page view tracker