.NET-based library for Service Broker
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
Menu
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'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
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
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
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
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
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
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
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
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.
What's error 6522? It's the error that you always get from an unhandled exception in a SQLCLR stored procedure. If I write a SQLCLR error that
Good T-SQL programmers are always looking to optimize their procedural code. Little optimizations can end up as big savings if the code will be executed
I've been trying out the new session support in HTTP endpoints. You manipulate this through SOAP headers, and looking through the list of SOAP headers
I was talking with Dan Sullivan this week about UDTs in SQL Server 2005 and he's made an interesting discovery. About a week ago, I'd
As Mark Fussell will tell you, one of the coolest things in System.Xml 2.0 is the static creator methods on XmlReader and XmlWriter. It made
Came across something recently that I thought was odd (or a bug) when dealing with UDTs in SQL Server Management Studio. If I have a
I’m a person who always likes to know where things live in the OS, database, or whatever product I’m dealing with. Being able to point
I've been looking at the SMO (SQL Server Management Objects) model recently. Because the amount of data they retrieve is potentially large and potentially expensive
There have been a number of questions recently (well OK, three) on the beta newsgroups about SqlDependency problems. It's been suggested that SqlDependency doesn't work
Just when I thought I'd found all the new cool features. An Ascend Phase 1 participant once asked me “can the DBA get rid of
Sometimes you have to hit me over the head to make me aware that something's changed. I've been working with Visual Studio 2005 beta 1 for about
When you get a brand new tool, programming language, or API, the first thing most programmers use it for is to write their favorite "rite
About a month ago, there was another chapter in the long discussion about DataSets and web services. An old cohort Scott Hanselman fired off the
If you've recently installed the SQL Express version of SQL Server 2005, you may or may not have noticed SQL Native Client (SNAC). If you
I was checking some of the SQL Server 2005 features on the way over on the plane. The latest build that I have is 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.