Schemas, Users, and Objects – I
UI can't stay away from the separation and users and schemas feature. I want to make sure I have it cold, and following up on
Menu
UI can't stay away from the separation and users and schemas feature. I want to make sure I have it cold, and following up on
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
I've known for a couple of weeks now that XQuery and the new XML-SQL client mapping have been dropped from System.Xml in .NET 2.0. The
Got back from Win-Dev last night…and immediately crashed. It was a great show, a little exhausting because some of the folks that I’d lined up
One more thing about getting an error 6522 wrapper from SQLCLR procedures. the workaround I spoke about last week (dummy catch block) works to propagate
Made it to this conference, came a day early just in case (see I’m at SQLPass…not). No hurricanes at this one, but fairly nasty cold
There's a new Community Technology Preview of SQL Server 2005 available on MSDN for universal subscribers. I'm sure you've all heard of it by now,
A few weeks ago, I was surprised by an error message when attempting to create an HTTP endpoint with CREATE ENDPOINT. The error was "You
About a month ago, I'd written about unhandled errors in .NET procedural code always causing error 6522 to be returned to the (T-SQL) caller (see
The new SNAC (SQL Native Client) OLE DB provider handles naming of parameters a tad differently than SQLOLEDB. Let's say that I have the parameterized query
After having been immersed in .NET since the alpha version, I'd lost touch with how many products use OLE DB and ODBC. After all, when
I heard that when SQL Server 2005 ships, SQLCLR (the ability to execute .NET code in SQL Server) will be disabled by default. This is
Just finished watching Ichiro break the single season hit record on TV. I’m a Seattle Mariner fan from way back when, and a big Ichiro
Last week I promised some of my students that I had an article in the works on the intricacies of SQL Server 2005/.NET 2.0 Query
It turns out that you can force SQL Server to use FX libraries that are not on the approved list. Deploying user code that uses
After reading Niels’ comment about the framework class library list, a quick check proved he was right, System.Runtime.Remoting.dll was not on the approved list. Adding
My apologies to anyone who showed up at SQLPass this morning for the pre-pre-conference talks, which was supposed to include a day of SQL Server
Back from vacation, drove from Ashland back to Portland Saturday, then Portland to Redmond Sunday. A lot of driving. The Michael Brundage XQuery book was even
After a summer of being a homebody, fall and winter will be *lots* of traveling. I’ll be doing the day of SQL Server 2005 for
Thinking ahead to the SQLPass conference and also back a few weeks to the Ascend Airlift. Almost forgot that at the airlift I met Angel
I just answered this question on the "public/private" sqlclr newsgroup, but now I'm wondering myself. What IS all that stuff doing in sys.assembly_files? If you've done autodeployment
After lots of interesting (but fruitful) experiences with the XQuery engine in SQL Server 2005, I decided that I'd rather have an XML schema collection
With the introduction of the XML data type (using an XML data model) comes there's a choice of pulling XML out of the database as
SQL Server 2005's HTTP endpoint functionality uses http.sys, the HTTP stack in the kernel, to do it's processing. Until lately Windows Server 2003 was the
Some folks have asked why I appear to use the XQuery data() function on occasion, but not always, when I'm doing demos. If you want
After getting a laptop with enough power this summer, I’d taken a week or so to familiarize myself with Virtual PC. Using it is a
There are a number of different ways that SQL Server 2005 checks to see whether on not you're trying to catalog or execute dangerous .NET code. This
Because of SQL Server 2005’s support of XQuery, a lot of folks have been asking about good XQuery-specific books. I’ve found two excellent books, each
I’m at the Ascend program launch this week; it’s being launched as part of a larger event. Yes, I finally got to meet Roger Doherty.
If you're developing procedural code, UDTs, or UDAggs in SQLCLR for SQL Server 2005, Visual Studio 2005 has these nice auto-deploy projects called SQL Server projects
To squeeze every ounce of performance out of the SqlServer data provider, the rule is to allocate the least number of ancillary object instances possible.
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.