Kevin Remde's IT Pro Weblog

  • Microsoft Codename "Max"

    Create beautiful albums

    As a digital photography enthusiast, I’m really excited about this!

    Microsoft has a new product just for folks like me.  The current codename for the product is “Max”. 

    Did I say product?  Wrong.  It’s not a product;  It’s an “experience”.  (<sniff>.. I smell marketing.  Bleah…)

    Seriously though, it sounds a lot like FlickR or other online photo sharing… but it claims to have a new, cool interface built on WinFX

    Sounds to me like it’s worth a good long look!

    For more informaton, here is the Max site.

    Download Max here.


    Have you tried it?  What do you think?


    UPDATE: I'm playing with it now.   Here are a couple of notes..

    1.  It's not like Flickr at all.  I was way off.  You have to install it (and the installation requires and does the installation of WinFX Beta 2 as well), and then sign in using your Passport account.  What happens is, you create these cool "lists", which are your photo albums... and there are several (well, three) ways to display your pictures:

    • Thumbnail - just picture after picture one at a time in the viewing window
    • Album - It does some cool photo-album-esque arranging on the page.. like pages out of a scrapbook.  And the pages are interactive... you full-page a picture by clicking on it's little part of the photo album page
    • Mantle - Similar to Album, you have multiple pictures on a "page", but in this case, they're arranged tilted and ordered in 3-D... kinda like you would see framed pictures sitting on your fireplace mantle.  Again, you click on an image to bring it to full-page.  Clicking it again brings back the mantle look.

    2.  What about sharing?  Well.. that's something I haven't tried yet.  I need one of my family members (Dad?  PaulCarl?  Are you reading this?) I sent the installation link to to actually install it so I can share these lists with them.  Apparently once they have it installed, I can share my lists with them, and the photos will be sent to their computer for their own viewing.  Later they can delete them if they're taking up space.  (And according to the help (which is all coming off the Max team blog, by the way), space is something that Max needs a lot of.).

    3.  It looks and feels a lot like Windows Vista!  The graphics are smooth, glossy (at least on my computer), the buttons are animated, and the way it twists and bends the images is really amazing.  If you want a good idea of what Windows Vista looks and feels like, play around with Max.

    Give it a go!  If you want, share your list with me.  Contact me and let me know you're interested, and what your email address is, and I'll email you my Passport identity to use.

  • Microsoft Office 2003 Service Pack 2 is now available

    OfficeYes, Service Pack 2 for Microsoft Office is available today.

    Here are some notes from a memo I received about it…

    “Why should I upgrade?”

    SP2 is an update to Office programs and servers that addresses top customer experience issues. To optimize the customer experience with SP2, Microsoft recommends people update their Office applications and servers to take advantage of the improved stability of the Office system.

    Improved Security – SP2 includes an enhancement to Outlook to help prevent “Phishing.” Outlook has also improved the handling of “Junk” email. Junk messages are now rendered as plain text, preventing HTML information from being viewed inadvertently. Links are also now disabled in “Junk” email messages with SP2.

    Improved application stability – SP2 includes many fixes and enhancements for Office applications and servers based on customer and partner feedback as well as extensive internal testing.

    Support for Microsoft SQL Server 2005 and Microsoft Visual Studio 2005 – Microsoft Content Management Server, Microsoft Windows SharePoint Services and Microsoft InfoPath 2003 have been updated to include support for the upcoming releases of Microsoft SQL Server 2005 and Visual Studio 2005. Microsoft Office SharePoint Portal Server 2003 has been updated to include support for Microsoft SQL Server 2005.

    Go to for more details.

  • No really... What is it that, as you say, "sucks"?

    Beating-a-dead-horseOkay… I confess that I was “ego surfing” a few minutes ago.. after I read Steve Lamb’s post on the subject.. I used Technorati to see who was linking to my blog posts. 

    I found a nice reference back to my request for Windows Vista feedback from August 31st.. Vlad Mazek’s post (thanks Vlad!) pointed people there, and (rightly) suggested that if you want to influence how the product works, the time is NOW to help us with feedback.

    What I thought was especially interesting, though, was the one comment there from someone named “Anonymous”.  (Wow… That guy gets around!) 

    Mr. Anonymous writes, basically, that it all sucks.  It just plain sucks.  And there’s nothing I can say to make it suck any less.  It sucked in the beginning.  And it now and for-evermore shall suck.  Sucking forever and ever.  Sucks. Sucky sucky suck suckity-suck-suck-suck. 

    Did I say it sucks?

    Anyway… Mr. Anonymous (you know who you are); a simple question for you.  WHAT sucks?  What?  Specifically?

    My response comment asks him that also, and points out a couple of key ideas that Mr. Anonymous should have shoved up his.. er… crammed into his.. um…  brain. 

    • We can only change the things that we know about.  (Help us!)
    • We have many many people working hard to make it a GREAT PRODUCT… or to at least suck somewhat less than previous products.   (There’s a good tag line for any new product… “And when compared to our previous version, it SUCKS LESS!” )

    We have groups that blog internally about Windows Vista, and they have the eyes and ears of the product teams, if they’re not the product teams themselves.  Some of them even record feature demonstrations as videos, and then ask for and pass along feedback.  Do they want the product to suck less?  …perhaps even, dare I say, to “ROCK”?!  You bet!

    Mr. Anonymous.. their goal is to help you see a product that moves from the “sucks” category, to the “ROCKS” category.  And I and others like me will help you by passing along your feedback, and next year doing kick-ass demos to show you how good ROCKS can be. 

    Rock Rockity-rock-rock-rock.

  • Blonde Developers Have More Fun

    Marilyn at the PDCWell.. it’s been said that “Blondes have more fun”.  And we all know that Developers are having more fun than IT Pros this week, so it must follow that blonde developers are probably having more fun than anybody.

    Yes.. I must confess… this is NOT my natural hair color… AND I used to be a Software Engineer!  But then I started playing with TCP/IP, the Internet, NT Domains, and I was hooked. Group Policies were in my blood.  IT was in my future.  (And so was “Just for Men”)

    Here’s a discussion I had with a coworker back in 1989…

    Younger, less grey me: “Wow!  Come look at this!  I just made an FTP connection to a file server in f***ing Finland!”

    Him: “Huh?  FTP?”

    Me: “File Transfer Protocol.  It’s an Internet standard.”

    Him: “Huh?  Internet?”

    Me: “Yeah.. it’s this groovy** inter-connection of networks.”

    Him: “Oh.  That’ll never catch on.  So.. what’s so cool?”

    Me:  “I just told you!  I’m not just looking at some directory on the server downstairs.. I’m looking at a directory of files IN FINLAND!”

    Him:  (leaning over to look at the file listing.  Finally, a light-bulb goes on over his head)…”Wow!  …Porn!”

    Me: “No!  That’s not the point!  I’m connecting to a server that’s way over… Hey!  Where are you going?!”

    Him: “Porn!  FTP!  File Transfered Poooorn!…” [rushing off to his workstation to start his own FTP-enabled porn collection]

    ** Okay.. maybe “Groovy” was already out of style in ‘89.  But so was the tie I was wearing.

    And so the Internet flourished.  Because of porn.  But I digress…

    I spent several years as a developer even after those first FTP porn downloads.  And I loved it!  I went to a few cool conferences.. Borland’s, C|Net Web Builders, TechEds.. and it was at TechEd’s 94 and 95 that I saw more and more how Microsoft was making it easier to get to connect computers and manage directories of users.  And in the small company I was developing for, we needed someone to manage the network, email, set up Internet connectivity, file servers, etc. And I stepped into the role partly out of necessity, but mostly because I really thought this stuff was cool.  Eventually I gave up development for full-time IT work.

    Sound familiar?  I know many IT Pros who have similar stories.  Some not even involving porn.

    Now.. flash-forward to this week.  HUGE news coming out of the PDC.  Developers are going nuts with fun stuff.. Windows Vista demos.. Office 12 demos… Max, Sparkle, LINQ, WPF, WCF, WWF… whoo-hoo!  PDC is where it’s at!

    “But Kevin.. you went to TechEd, didn’t you?”

    <yawn>  Yeah… I did.  And it was fun.  But… that fun pales in comparison to the all-out geek-O-rama that is this year’s PDC.

    Granted – there are some really kick-butt products and technologies coming out yet this year and next year.  Things that make a young IT Pro’s heart jump for joy.  But when developers have so much fun… wow.  It makes me think maybe I should start working through the new Visual Studio demos, watch a few MSDN webcasts.. maybe attend a few MSDN Events

    Yep.  I think I’ll go back to being a developer.

    …And I’ll color my hair blonde.

  • A Technical Overview of Virtual Server 2005 WEBCAST - Additional Resources

    Virtual Server Webcast


    Here are the promised resources for the webcast I delivered today (September 7, 2005) on “A Technical Overview of Microsoft Virtual Server 2005”. 

    The content session number TNT1–154.

    Hope you find these links useful, either as you watch the webcast live or later when it’s available On-Demand.


    TNT1–154 Additional Resources


    Virtual Server 2005 Product Overview

    Virtual Server 2005 Frequently Asked Questions

    Virtual Server Technical Overview (Whitepaper)

    Virtual Server R2 (formerly SP1) Beta Program

    Virtual Server Migration Toolkit


    Virtual Server Migration Toolkit Frequently Asked Questions

    Server Consolidation with Virtual Server Migration Toolkit (whitepaper)

    Automated Deployment Services (ADS) 1.0

    Free Live TechNet Events


    TechNet Events Bloggers


    Microsoft TechNet

    Official Series Content Resource Page

    Free Windows Server 2003 Virtual Labs: 

    Windows Server 2003 Evaluation kit: 

    Windows Server 2003 Training and Events:

    Microsoft Events page:


  • Hurricane Relief Stories - Part 2 - Bill Steele

    Bill Steele

    Bill Steele is a developer and a skilled presenter on our MSDN team.  He is also a former military pilot and currently owns one or two small planes. 

    Recently he was given the okay to take some time off to help out in the hurricane Katrina relief efforts.  A couple days ago he sent this email update to the rest of us on the team:

    Well... Today is the first day of Internet access since I started this adventure.
    I'm flying out of Baton Rouge International... and have so far moved enough meals to feed about 6000 people.  When I say meal, I mean MRE... Meal, Ready to Eat.  I've been reacquainting myself to them as well... wow... I forgot how good some of them were.  I've also been delivering bottled water and some medical supplies.  My plane can handle about 700 meals with a bottle of water each and a couple boxes of medicines each trip.  (That puts me slightly over gross, but who's counting - we do remove the meals from the cardboard boxes to lighten the load a bit... and I only get about 50 gallons of fuel - since each trip is less then 1 hour.)
    Anyway, I've had to stop for a little while while some maintenance on my plane is done... I lost the left mag on the left engine on my last take off .  The maintenance staff over at "Million Aire" are fixing me up no charge... that's very cool.
    I have to tell you, most of my flights have been to the lower part of Mississippi which was just hammered.  I flew into one airport that was so badly damaged that I literally landed on an access road, because the runway didn't exist.  The control tower actually fell over from the wind.  It's a real mess in some places.  I did a small tour of the coast line for some damage assessment purposes (I've had relief coordinators with me on every flight) and it's just shocking to see the magnitude of the damage.  I've lived through some pretty bad tornados at home and the damage looks similar, but it's just so much more massive.  Tornados cut paths... there's no paths down here... just destruction everywhere.
    Anyway, the food deliveries are actually winding down because either the people are leaving or they now have "ground transportation of goods" which means that I'll move into a new type of role shuttling medical supplies and people.  (I removed the seats from my plane so we're going to have to reinstall them as well.)  There are about 50 planes doing this work... and we're all running about 6 or 7 trips a day.  We've got good sleeping quarters... a nearby Holiday Inn Select hotel and plenty of food... when I get hungry, I was just stealing an MRE.  The best so far is the Chili Mac... nice and spicy.  I'm getting ready to enjoy a Boneless Pork Chop dinner right now, however... you guessed it... it's an MRE as well.
    By the way... I see we're sending down the MSAM Buses... that's very cool!  The thing this is really lacking down here is communications... nothing works.  I'm currently using a US National Guard mobile communications van for this access - it's actually a Humvee with a bunch of antennas on it.  We get to use it for about 1 hour a day (when it's available.)
    Oh well... I'll let you know the progress the next time I can. 

    Bill also wanted me to mention that if you want to help him and other pilots like him who are volunteering so much of their time and resources there are ways to do that:

    One of the biggest questions is "How can I help?"  Well, it's simple... each flight costs roughly $200 just for the fuel alone.  I am flying for an organization called "Angel Flights" which normally shuttles sick kids to hospitals on available seats... however, during this we're also shipping food/supplies.  Angel Flights is part of a larger organization called the Air Care Alliance (ACA.)  ACA handles all the funding for all kinds of aircraft related relief efforts.  You can go to their site at and donate (I recommend that if [you're a Microsoft Employee, and] you donate to them, please do it via the Microsoft resources... that way we double the money going to them.)  You can also donate directly to Angel Flights at

    My hat’s off to you, Bill.  You make us all extremely proud.

  • Jose speculates on the Windows Vista-included games...

    Game on!

    A young man destined-to-be-an-MVP someday –  Jose Francisco blogs today about the games that potentially may be included in Windows Vista.

    Honestly, I haven’t looked at these yet.  I’ve had so much fun with the other features that I’ll have to re-look at the build I’m running and see what’s there… Fun stuff!


  • SQL Server 2005 Tidbit 025

    SQL Server 2005 Tidbit 025

    Happy SQL Express User

    This tidbit comes as an answer to a really good question asked at a recent TechNet Event:

    “What if a Maintenance Plan fails at some point?  Do I have the ability to restart the plan at a particular step?”

    The answer to this is similar to the answer to the one in tidbit 28 – You really should consider plans as full sets of work.  If the plan fails at some point, you would probably want to launch the task separately, or create a job just to tackle what wasn’t otherwise completed.

    Got an IT question?  Give me a comment, or contact me.


  • SQL Server 2005 Tidbit 026

    SQL Server 2005 Tidbit 026

    Happy SQL Express User

    This tidbit comes as an answer to a really good question asked at a recent TechNet Event:

    “If I’m running SQL Server 2005 Standard Edition, and I use the Database Engine Tuning Advisor, will I see Partition options available?”

    This quesiton came about mainly because partitioning is available SQL Server 2005 Enterprise Edition, but not Standard.  The answer is that the Tuning Advisor will simply not make partitioning suggestions on Standard Edition. 

    Got an IT question?  Give me a comment, or contact me.


  • SQL Server 2005 Tidbit 027

    SQL Server 2005 Tidbit 027

    Happy SQL Express User

    This tidbit comes as an answer to a really good question asked at a recent TechNet Event:

    “In your demo of integrated log viewers, you showed looking at the SQL and NT Event logs on the database server you were managing.  Can you integrate and view IIS Log information from a remote IIS Server?”

    This question is a good one.  I can see why you’d like to see what’s gone on on the SQL Server at the same time as on the IIS Server where the web application that is using it is running. 

    However, in the log viewer in SQL Server 2005, you’re only looking at the logs on the one server.  You can open up two log windows side-by-side (for other servers), but you won’t be able to see it on the same timeline.

    A solution is to EXPORT the log from one machine, and IMPORT them into the log viewer currently looking the other.  Or export from both and import into the same console.  This functionality IS supported on the Log File Viewer.

    Got an IT question?  Give me a comment, or contact me.


  • Happy Anniversary!

    Help me!Microsoft Word came out 22 years ago today.

    Microsoft Introduces Word
    9/29/83 Microsoft introduces its full-featured word processing program, Microsoft Word for MS-DOS 1.00. PC World subscribers receive a free demonstration floppy disk of Microsoft Word in the magazine's special Software Review. "This is the first time in the history of publishing that a magazine has featured a floppy-disk bind-in," said David Bunnell, Publisher of PC World.

    (And on a related note, today is the 21st anniversary of my marriage.  Wow.  Our marriage is of legal drinking age here.  …and it’s 5:00 somewhere…)


  • Scripting Guys Webcast Week #3 is coming! ...with prizes!

    Scripting Guys Webcasts Oh yes!  The Scripting Guys are at it again.  More fabulous, funny, and above all USEFUL content on how to use scripts to your I.T. management advantage.

    Mark your calendar: October 24 – 28, 2005.  Hurry up and register today. Space is limited!  Seriously! 

    See Dean Andrew’s TechNet Webcasts blog for more details, and more importantly for a list of all the prizes.  (Note: you must be present at all of the webcasts to be eligible for some of the prize drawings.)







  • It's Bill Gates! In his office! Talking to Scoble!

    BillG on Channel 9Robert Scoble, for Channel 9, finally got that dream interview… it’s on the Channel 9 site for all to see.

    Check it out!





    Poor Robert sounds sooo nervous.  And I don’t blame him one bit.  I probably wouldn’t be able to form sentences…

  • Hurricane Relief Stories - Part 3 - Microsoft Across America (Revisited)

    Microsoft Across America <— That’s Ed Faulkner, the program manager of our Microsoft Across America “Mobile Event Experience”. 

    Ed has a blog now, and he’s using it to put up stories (and pictures) about how several of these trucks are being used in the efforts to help hurricane Katrina victims in Louisianna and Mississippi.  (Here's my earlier blog entry about those trucks.)


  • Cool Rush Fan Tribute Video

    A friend passed this along to me.  I was never a huge Rush fan… but I sure like this song and especially what this Neil Peart fan did to animate this tribute. 

    "A Digital Man"

  • See you at the Launch!

    Chris Avis BEFORE

    Chris Avis here has challenged all of Southern California to come to the SQL Server 2005 / Visual Studio 2005 / Biztalk 2006 Launch event in Anaheim.  He promises on his blog that if that event draws the biggest attendance of all of the launch events, he will shave his head.

    Okay, Chris... once again you throw the gauntlet down.  Your challenge isn't just to your seven blog readers, it's to the rest of your coworkers and teammates as well.  You force us to offer similar challenges to our attendees, just because of how wonderfully competative we are!

    My own Karaoke Challenge was FORCED into play by yours... (of course, I sing way better than you, so I'm not afraid one bit. <mooohahaha>)

    Okay... so that's how it's going to be.  Here's my own attendance challenge for Minneapolis.  If Minneapolis gets the biggest attendance of any of the major SQL/VS/BizTalk Launch events…

    no… waitasec… I’ll sweeten this challenge up a bit…

    Chris Avis AFTERIf the Minneapolis SQL Server 2005 / Visual Studio 2005 / BizTalk 2006 Launch simply gets better attendance than the Anaheim event, I'm getting me a sharp trimmer, and SHAVING CHRIS AVIS's HEAD!  YEAH!

    Yep.. you heard me right.  I'm bad.  Don't you think I wouldn't do it, either. 



    Someone's getting shaved, and it's not going to be me.

  • SQL Server 2005 Tidbit 018

    SQL Server 2005 Tidbit 018


    Tidbit 18.

    A little birdie told me to expect a big announcement about SQL Server 2005 in the next day or two, originating from the floor of the PDC.

    Stay tuned…  As soon as it’s official, I’ll share it here. 

    UPDATE: It was announced today.  Here's my blog entry about it.

    Got an IT question?  Give me a comment, or contact me.


  • The new security bulletins are here! The new security bulletins are here!

    Jerk **

    …and there aren’t any! 

    That’s right.  Today is “Patch Tuesday”.  <sigh>  Just where did the month go?

    There are no Security Updates this month.  No new security bulletins.  None.  Zip.  Zilch. Nada.

    “Well… is there at least something?”

    Yes.  There’s a new version of the Malware Detection/Removal tool.  And there’s a “high priority, non-security related update” (KB891861) now being made available via Windows Update, Microsoft Update, Software Update Services, and Windows Server Update Services.

    Once again, that’s WU, MU, SUS, and WSUS.  PDQ.


    **Obscure Steve Martin movie reference.

  • SQL Server 2005 Tidbit 020

    SQL Server 2005 Tidbit 020

    Data Storage

    “Hey Kevin… Exchange 2003 sort of takes advantage of Volume Shadow Copy service (VSS).  Other things (like the file system) can use it to make quick snapshots of data.  Does SQL Server 2005 have any such capability?”

    There is indeed an interface definition for something called the SQL Writer.  This guide (for backup application vendors) describes how you can write to this SQL Writer in order to support using the VSS framework.  

    So… there is hope that soon after (or maybe even, dare I say, right away when) SQL Server 2005 ships, you should be able to purchase backup applications that take advantage of VSS.

    “What about good ol’ Windows Backup?”

    I really don’t know about that one.  Windows Backup can use VSS for the file system, and there were limitations on how it could (or couldn’t) be used for Exchange 2003.   

    That’s a really good question.  I’ll tackle that one in a later tidbit.

    Do you know the answer?  Share it here, or add a comment with a link to the solution in your own blog.

    Got an IT question?  Give me a comment, or contact me.


  • Start Something?

    Have you seen 

    Have you seen it lately?

    Eileen Brown reminded me of it this morning… Very cool. 

    Chris Avis also has a couple of posts on it as well.  (Post 1, and Post 2)



  • OSDL's Stuart Cohen - What are you afraid of?

    Is that Penguin carrying our flag?VERY interesting developments on the MS vs. Open Source battlegrounds…,1895,1854183,00.asp

    Yes, perhaps I’m a bit biased, considering who signs my paycheck.  But to me, Stuart Cohen sounds scared.  This eWeek article talks about him and OSDL turning down Microsoft’s offer of a joint, co-sponsored “independent” research study.  And what were they afraid of?  Well.. Cohen pretty much accuses Microsoft of taking parts of studies and only selling the news that is good for Microsoft in the midst of overwhelming bad news.  He accuses us of lieing. 

    “What do you think about that, Kevin?”

    Bullsh**.  Yep… I’m getting opinionated here… probably not something I should do on a Microsoft-owned blog. 

    Have you seen ?  Have you, Mr. Cohen?

    The site has a HUGE amount of information.. white-papers and research (yes, many sponsored by Microsoft, but some not) on

    • Total Cost of Ownership
    • Reliability
    • Security 
    • Intellectual Property Indemnification
    • Interoperability
    • Performance
    • Partner Success
    • Small Business

    These are not just snippets, either.  The complete studies are included when practical, and if not, they’re linked to and made available elsewhere.  Add to that the wealth of great case studies in categories of

    • Small Business
    • Medium Business
    • Large Business
    • .NET Success Stories

    Perhaps we highlight the good points in our marketing.  That’s granted.  That’s what MARKETING does, afterall.  But we do not hide any of the findings.  If we did so, you would have a valid concern.  But your accusation is weak, defensive, and without merit.  And frankly, sounds a bit whiney to me, too.  Get the facts, Mr. Cohen.

    What also infuriates me about the eWeek article is that it only gives Cohen’s side of the story.  I’d like to know more details about how Martin Taylor approached them, and what the specifics were.. but we’ll probably never know.  The original discussions were supposed to have been kept secret. 

    No doubt someone posted about it on their blog.  Stupid bloggers. 


  • Mirror, Mirror...

    Backup anyone?

    With all the focus on SQL Server 2005 our team has been doing lately, I was very glad to find this web site.  The team that builds the SQL Server engine has a blog of their own:
    SQL Server Engine Tips.

    One post in general got my attention – the team is requesting your feedback on Database Mirroring.  In fact, they’re even providing scripts you can use to play with Database Mirroring and familiarize yourself with it.

    Here is their “Feedback requested on database mirroring” post.  Help ‘em out!

  • SQL Server 2005 Tidbit 010

    SQL Server 2005 Tidbit 010

    Manly SQL DBA

    Number Ten! 

    Credit for this one goes to my friend and teammate Matt Hester...

    Q: How does SQL 2005 handle online databases during the upgrade, what about the applications that are in use?

    A: This questions was very interesting to me so I did some checking.  The best bet to see how this is going to work, is to use the Upgrade Advisor, this will give you great advice on any potential database or application issues.  However ultimately for any upgrade, some good ole’ fashion testing is in order.  For more information, and to down load the Upgrade Advisor look here: 

    Got an IT question?  Give me a comment, or contact me.


  • SQL Server 2005 Tidbit 011

    SQL Server 2005 Tidbit 011

    Manly SQL DBA

    SQL Tidbits Galore!

    Credit for this one goes to my friend and teammate Matt Hester...

    Q: Can I put Visual Source Safe components into SQL 2005?

    A: Yes.  If you have installed the Microsoft Visual SourceSafe 6.0 client components on your machine, SQL Server 2005 Management Studio will automatically detect that the VSS plug-in is available. As noted above, you can find the VSS plug-in listed in the Tools/Option dialog, by selecting the Source Control and then Plug-in Selection node. Also, the Source Control option in the File menu drop down becomes active, and from there you add an existing Management Studio solution to source control, or open a Management Studio directly from source control. You can enable multiple source control systems, and change from one to another. For more information on this check out this article:

    Got an IT question?  Give me a comment, or contact me.


  • SQL Server 2005 Tidbit 012

    SQL Server 2005 Tidbit 012

    Manly SQL DBA

    An even dozen Tidbits.

    Credit for this one goes to my friend and teammate Matt Hester...


    Q: In Mirroring with automatic failover, how do the SQL Client applications fail over when the mirror fails?

    A: It really depends on the client application and how it was written.  Client applications written using ADO.NET 2.0 will automatically fail over when the database fails over.  However other clients will have to manually fail over.  Basically the new SNAC (SQL Native Access Client) has information about the mirror, and about where to connect if the principle connection goes down.  If the principle drops, the application will try the mirror.  If a failover has occurred, then the mirror is able to respond and all is good.  If the mirror drops (or doesn’t answer at all), the app will then again try the original principle, and so on.

    Mirroring has always generated some great questions.  John Baker has a great post on mirroring.

    Got an IT question?  Give me a comment, or contact me.