What’s the SqlDependency doing now?
I'm headed out on the road. For quite a while. Wanted to settle this before I went. Looks like the implementation details of SqlDependency have
Menu
I'm headed out on the road. For quite a while. Wanted to settle this before I went. Looks like the implementation details of SqlDependency have
I like to read the readme files. There's often juicy little tidbits of info in there that won't show up by searching the BOL (that's
Now that SQL Server 2005 has been released, I'm becoming more "at one" with the tools. I've commented on a couple of cool features as
After reading my last blog entry, Wally McClure points out that I did indeed meet him once. In July 2001, on Redmond campus. Amazing. And of course,
The podcast I did with Wally McClure is up on his website. Here’s the link to it. I did this podcast about a month ago,
The last five blog entries were a lot of “off-the-top-of-my-head” list writing. Mostly remembering what people had said or the “I wish there were” comments. Just
OK, SQLCLR wish list comes last. Mostly because I'm tired of being accused of being a SQLCLR bigot; I think it was because our book
Transact-SQL has been around for a lot longer, the list will be a bit smaller. But the T-SQL enhancements in 2005 were numerous but, of
This one is about SQL Server Service Broker. It's not necessarily a cool or sexy feature, but may be the most revolutionary feature in there.
OK, because it was Michael that asked originally, XML/XQuery wishes for SQL Server 200x. In no particular order. Full compliance with "standard" W3C XQuery. If
It's just a few weeks until the launch of SQL Server 2005. I'm been hiding under a rock since returning from Hong Kong. TechEd there
A couple of hours after checking into my hotel on the Hong Kong waterfront, fireworks started going off outside…the real kind. Turns out I’d arrived
Made a quick exit from SQLPass in Dallas, hopped on a plane, and 4 planes later (plus a stop at home to get things together)
I’m here at SQLPass conference in Texas, the preconference doesn’t look like it will be “rained out” as my was last year. I came in yesterday in the
When I'd talk at Ascend about how Visual Studio auto-deploy of SQLCLR assemblies not only catalogs the assemblies and the PDB files to SQL Server 2005 but
After writing about a lot of new security features that were added since we published our "First Look at SQL Server 2005 book" its nice
This one's been around for a while, but don't think we'd mentioned it in the book. In addition to Windows logins and SQL logins, you
You’ve probably heard by now of the usage of the EXECUTE AS clause with procedural code. As in “CREATE PROCEDURE foo WITH EXECUTE AS OWNER”.
As a blog reader as well as blog writer, I’m disturbed by a trend that seems to be more commonplace lately, the “continued here” trend.
One of the things folks would always ask during the Ascend program was "anything new for application roles? do they support connection pooling yet?". Well,
In July 2004, encryption built-ins and key management had just been introduced in SQL Server 2005. Now its old news. They'll be a good-sized section
While working on the new edition of our book for after RTM, I've been looking around for security features that I missed or that didn't exist
That’s the question that folks ask a lot lately. See you at PDC? It’s not that I wouldn’t *like* to go. It’s that there’s another 3-letter
I’ve heard this around quite a bit lately, but I attend some conferences and follow a lot of newsgroups. If you haven’t heard: Database Mail
Ahh…enough shameless self-promotion (for a while), let's talk transactions. I worked in the past with folks who like to compose transactions. SQL Server supports nesting
About how they work together. The panel is being held as a webcast, and they’ll be some slides too. This is all taking place on September
I received email today that it was OK to talk about this. Our book “A First Look At SQL Server 2005 For Developers” was selected
About a week or two ago, there was a LONG discussion on the SQLCLR beta newsgroup about the fact that the IsNull property that you
I've been working on a student question about using Impersonation inside of a stored procedure. This one's worth sharing. You can do impersonation using the
In answering a question about schemas, users, and objects (search on "schemas" to see the blog series I, II, III), I realized I never posted
I’ve spent the last few days talking with the data access folks at Microsoft. They’re working on the next set of features and I’ve given
I answered a question on the beta newsgroups last week about OSD and RSD (remember them?) by saying that those features had been pushed out into the future. The
I'm known for my vivid imagination when making up test/exposition examples. I have a cat named Sam. So, once upon a time, I wrote: CREATE
I've been wondering what happened to the QueryNotification dispatcher proc that's used by SqlDependency in ADO.NET (and in ASP.NET with SQL Server 2005). The one
Another fantastic book for your reading pleasure this month. “Customizing The Microsoft .NET Framework Common Language Runtime” by Steven Pratschner. In-depth coverage of .NET 2.0 hosting API.
They always get a bit of a jump on us WRT “current events” because of the timezone difference, especially if you live in the land
I really like the feature known as “All Permissions Grantable” in which any permission can be managed using the GRANT verb, because there are no
Just was looking through my reported problems last night to see what the resolutions might be. Looks like the two having to do with managed
Today I embark on a new venture, a new part of my career. I’m joining SQLskills as Director of Developer Skills. I’ve worked with SQL
After writing a blog entry on "How DO you change your SQL Login Password" and complaining that "neither" SSMS nor SQLCMD allows you to change
Sometime between when I left for Europe and when I started reading email that wasn’t addressed “question from student” (yes, I do answer all those), my
Wow. I was going through old blog entries looking for some unique insight (TM) I had, once upon a time, about SQL Server 2005 error
I just finished up our last gig for SQL Server 2005 Ascend last week in Paris (OK… in Les Ulis). It was my first class on
In the April CTP of .NET 2.0, I chanced upon some changes to SqlNotificationRequest, using my favorite tool, .NET Reflector and my one my favorite
While at TechEd, I purchased the first computer book I’ve actually had to shell out hard cash for in quite a while, The Rational Guide
I meant to blog from TechEd but with all the activity, I never got the time. The talk on when to use T-SQL and when to
I commonly do a demo when teaching SQL Server 2005 where I write a SQLCLR UDF that's returns the string "Hello World". The define it,
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.