More ADO.NET 2.0 and XML data type
When you retreive a rowset that contains an XML data type column or use an XML data type column as parameter input, you have two
When you retreive a rowset that contains an XML data type column or use an XML data type column as parameter input, you have two
I returned home from Europe late Saturday night. With catching up on my sleep, email, questions, Thanksgiving (which Mary and I celebrated on Sunday this
A few weeks ago, I'd posted links to ADO.NET 2.0 articles I'd written for MSDN online. At that time, I mentioned there would be one
I was demonstrating SQLCLR appdomain usage (see previous post) to a class last week.Later on, I mentioned a different concept, that of dependent assemblies. This
A little-known behavior of SQLCLR (although we did mention it in our book) is that SQLCLR creates one appdomain per assembly owner, not one appdomain
This is actually posted a few days after I wrote it. I haven’t done the “internet on the plane” service although I think it exists.
SQLNS is an acronym for SQL Server Notification Services. Originally introduced as a “free addition” to SQL Server 2000, it is an integrated part of
Every time I demonstrate using XQuery against a table that contains an SQL Server XML data type to a new class, a get about one
Looking for some cool SQLCLR and/or security-related features to show off. Before I hit the road again Friday, for a long stint in “airplane-land“ on
[Comment heard from an XML afficianado] A: Uh…Yes, lots of them… User-schema separation always leads to the recollection that “user-schema separation is the way things
More on user-schema separation. In SQL 2000 and previous versions, granting someone CREATE TABLE privilege meant that they could create tables (no surprise there). The
People always ask…if ownership chains work the way they do, why do they not work with dynamic SQL? And how about .NET procedures and ownership
Separation of users and schemas is another cool SQL Server 2005 feature, but it has some interesting behaviors that folks may have to get used
I was browsing through some of the SQL Server 2005 code samples today (the ones that come with the product) and came across one that
And now, for something a little technically lighter… I've taken to using a convention when writing statements that involve XML/XQuery and SQL together. I put
Rereading the post about this from last night, it appears that I may have used an ambiguous analogy when attempting to figure why this feature works
Dan Sullivan pointed this out to me a couple of weeks ago. I'd forgotten about it, but it came back to bite me in a
I seem to have lost the gift, if I ever had it, for what some of my old collegues would call (with a smile on
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.