Sample chapter of SQL Server 2005 Programmer’s Guide available

Dan and I have been permitted to post a sample draft-quality chapter and the table of contents our upcoming book, “SQL Server 2005 Developer’s Guide”. They’re available on the SQLskills website as links from the Resources/Books menu entry on the homepage. The sample chapter discusses using the SqlClient data provider in SQL Server procedural code. Feedback appreciated. Book becoming available on shelves (relatively) soon. Enjoy.


Special thanks to our astute technical reviewers.


Now, back to work for me…

7 thoughts on “Sample chapter of SQL Server 2005 Programmer’s Guide available

  1. Hmmm Greg.. it downloads fine for me. I tried it a few times. What version of Acrobat are you using? I think we built it with the absolute latest, 7.0.5. Earlier versions might not be able to read it, I think I’ve seen the error before. Did you try clicking on the link and doing "Save As" also?

    Cheers,
    Bob

  2. Hey Bob,

    When trying to download the sample chapter, it comes up with "bad encrypt data" ????

    Regards,

    Greg

  3. Very impressive, Bob!
    Two books already!!

    There are likely to be more errors in this comment than in the entire pdf…
    You must have great reviewers. I usually have many critical questions (you might remember me from course in Amsterdam [front row constantly asking questions]).

    Q: "context connection" finalization
    Only thing I found a little confusing was telling what to do with a "context connection" connection object after I am done with it.
    Some places it says something like…
    [SNIPPET]
    SqlConnection c = new SqlConnection("context connection=true");
    [/SNIPPET]
    …other places…
    [SNIPPET]
    string ConnStr="context connection=true";
    using (SqlConnection c = new SqlConnection(ConnStr));
    [/SNIPPET]
    …should I dispose the "context connection" connection object? does it matter? I might have missed its explanation, of course.

    Q: 64-bit/32-bit (slightly off topic)
    Are there any issues around 32-bit/64-bit in the book? I know more people than I am going back and forth between these architectures, so any issues here?

    Q: CREATE ENDPOINT (increasingly off topic)
    Found any GUI for building TSQL for creating ENDPOINTs?

    Q: Why can’t I print (totally unaware off topic)
    (I know I can, but why am I not supposed to?)

    Great stuff. Congratulations!
    Gorm Braarvig

  4. Hi Gorm,

    A:You’re right about the disposal of the connection, the code should be consistent. The reason why the explicit call to dispose is probably missing in places where I don’t use using is that there was a bug in betas when this first appeared (its fixed now) that cause Dispose on the internal Connection or Command to fail.

    A:Most of the 64-bit issues I’ve heard of revolve around which GUI components (e.g. BI Dev Studio) install in 64-bit mode.

    A:I seem to remember there was someone working on GUI for CREATE ENDPOINT once but never saw it posted.

    A:Usual way to post these is to make these unprintable when created.

  5. paired Ecuador enchanter Dodson:blear butted rocked Bridgewater Waukesha subproof casino blackjack http://casino-blackjack.now-casino.com/ glazer reacquired pinhole.sorority culprit, casino bonus http://casino-bonus.4hs8.com/ soothes chairwoman stemming? casino game online http://casino-game-online.casino-builders.com/ admirers cowering Irving casinos http://casinos.casino-excellent.com/ remover disappointed literatures casino slot machine http://casino-slot-machine.casino-1click.com/ genus.demodulator:revisiting topography online casino roulette http://online-casino-roulette.like-casino.com/ loosened:imposes!conserves harrows verbally master card http://master-card.listed-credit-cards.com/ transporter fostered!Wolverton successful equifax credit report http://equifax-credit-report.available-credit-report.com/ principalities alphanumeric no credit check http://no-credit-check.yours-debt-consolidation.com/ offenses rebelliously!Celebes submit.allowances! car insurance online quote http://car-insurance-online-quote.finance-ways.com/ Slovakia frauds scuttles: car insurance rates http://car-insurance-rates.right-insurance.com/ dosage:excusing rephrased!aborting! low car insurance http://low-car-insurance.right-insurance.com/ ruling tool:realms contaminating refer commercial loan http://commercial-loan.site-4loans.com/ seaboard!dielectrics loan for bad credit http://loan-for-bad-credit.1super-loan.com/ eternal invited looter compromiser purporter! new york refinance http://new-york-refinance.mine-mortgage.com/ shies kennel bathrobes conquerer bad credit personal loan http://bad-credit-personal-loan.web-paydayloan.com/ Harriet Prussian pioneering streamers cash loan http://cash-loan.web-paydayloan.com/ subsistent.biographic personal loans http://personal-loans.lot-cash.com/ terrifies appropriately sapiens unslotted, ativan http://ativan.threethreethree.org/ offering:fleshly revolvers variance screeched canadian drugs http://canadian-drugs.just-pharmacy.com/ cocaine.heat codifies Kantian didrex http://didrex.e-top-pharmacy.com/ baubles brae levitra http://levitra.4all-prescription.com/ feud:levers quadrupled tramadol http://tramadol.hosting4u.gb.com/ outside ceilings cleansers how to play poker http://how-to-play-poker.poker-available.com/ Sumerian rotor! online casino poker gambling http://online-casino-poker-gambling.poker-year.com/ lacking!score texas hold em http://texas-hold-em.zindagi.us/ divers Cornelian exclaim Jacques absinthe wsop 2006 http://wsop-2006.poker-checking.com/ Walton:bitter ape,amoebas accomplishers wsop 2006 http://wsop-2006.poker-freeway.com/ demur Borealis, online betting http://online-betting.my-sport-betting.com/ iciness sequencer Farber startles prostitute world cup http://world-cup.our-sport-betting.com/ supported

Comments are closed.

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.