I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat. Maybe I should be jaded. But I’m just a 12 year old (it’s been argued 10) in reality so I get really, really jumping up & down excited when I… Read more

First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand printing.

Here’s the story.

Book. Nine months of writing. Excellent technical editing. Great copy editing. Book complete about six weeks ago. Yay!

Now things get fun…

Here’s how it works.… Read more

Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:

CREATE PROCEDURE DL2e
    WITH ENCRYPTION
AS 
    BEGIN TRANSACTION
    UPDATE  Purchasing.PurchaseOrderDetail
    SET     OrderQty = 2
    WHERE   ProductID = 448
            AND PurchaseOrderID = 1255;

Then I’ll execute things in the following order. From one… Read more

I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider. They’ve just released the list of sessions. You should click this link and check them out. There’s going to be some magnificent instruction available in all aspects of SQL Server.… Read more

For some reason, which isn’t completely clear to me, we’re voting for part of the members of the Nomination Committee who will work their buns off (make no mistake, this is not a glamor posting) to pick and choose from the people applying to be possible candidates for the PASS… Read more

I was given the opportunity to put together a guest blog post for the MVP blog. I did a little something on determining whether or not you have high memory use through the use of a DMO. Check it out.

Read more

While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it), I had what I thought was a little piece of throw-away code, but several people from the audience asked about it. Here it is:

DBCC FREEPROCCACHE(0x05000700618F532C40E190CE000000000000000000000000) ;

Not much to… Read more