Archives: June 2012
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
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