Pre-provisioning and SqlDependency

In helping out with a project involving ASP.NET 2.0's cache sync feature, which has best performance when built on SQL Server 2005's Query Notifications, I was asked if there was a way to "pre-provision" the queue, service, and stored procedure that cache sync needs. The concern was that the connection string to start up the […]

Federation Enhancements/Changes in SQL Server 2005

SQL Server 2005 implements quite a few technology pieces to help database developers and administrators acheive scale-out while acheiving the appearance of (or actually accomplishing) application or server federation. The information is scattered throughout the books online, but you can read a nice whitepaper by Roger Wolter on how to choose among the features here. I'll be […]

TechEd2006 Wrapup

It was a fine time at TechEd. I enjoyed catching up with a lot of old friends and making some new friends. Thanks to all of you who dropped by my chalktalks or attended my error handling breakout session. It was fun hanging around the Data/SQL Server area and talking with all the folks who came by. Thanks […]

TechEd2006 – Content links and plan guide presentation

It’s raining here today, starting to feel like home. Many thanks to the folks that told me they had an excellent time delving into error handling in SQL Server 2005 server and clients during yesterday’s talk. The demos are already posted on the SQLskills website; look under “Current Events” for the link. Today’s talk (to a […]

At TechEd: Errors and Handling Errors; DLINQ interest

My talk on error handling in SQL Server and clients starts in another hour. Error handling in SQL has been more of an art than a science in previous versions, and some folks just pass every error back to the client directly. With TRY-CATCH in Transact-SQL you don’t have to do “passthrough” error handling now, […]

At TechEd: Event Notifications and scope creep

Started my part of the festivities today with a chalktalk mentioning SQL Server DDL triggers and Event Notifications. But explaining Event Notifications meant explaining Service Broker services, queues, and contracts. And the fact that both Event Notifications and DDL Triggers use a XML format. That you can change to a rowset format using the XML.nodes […]

SQLskills welcomes Elizabeth Vitt

If you haven’t already seen the good news on our website, SQLskills welcomes Elizebeth Vitt. Elizebeth is well-known in the business intelligence community and will be our Director of Business Intelligence Skills. We’re looking forward to even more synergy among members of the organization; Business Intelligence may be the most earthshattering part of SQL Server […]

About my TechEd activities

The week before TechEd, everyone’s reminded to blog about what they’ll be up to, to draw folks to sessions. The sheer number of presentations and topics this year, including breakouts, chalktalks, BOFs is overwhelming. The show is sold out, but some of the talks are being “simulcast” as well. So I’ll be there talking about […]

DLINQ and FLWOR

I've been looking at the DLINQ syntax a bit more (I'm participating in a BOF at TechEd next week), and its always struck me how, at its most basic, its reminiscent of XQuery FWOR. Yes I did leave out the L (Let) on purpose. I guess its the relative placement of the SELECT part of […]