SQLCLR, transaction nesting, and TransactionScope
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
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
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.