Error 6522 and You
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
Menu
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
When you load XML into an ADO.NET DataSet using it's ReadXml() method, ADO.NET uses a fixed set of rules to determine how to infer a
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 was writing slides and labs last week. I read Dare’s discussion of “The Sex and Cash theory“ about doing what you think is cool
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
I started my career as a maintanance programmer, and spent a lot of time searching out and fixing bugs, in existing code and also introduced by
sqlaccess.dll is the in-database .NET data provider, System.Data.SqlServer. If you do any data access in .NET stored procedures, UDFs, triggers, UDTs, and UDAggregates, you are
SQL Server 2005 beta 2 is now available for MSDN subscribers on the MSDN website. Although it’s not yet listed in the “what’s hot” section,
In recent posts I'd mentioned mapping a few times, it's time to get back and explore it in earnest. There appears to be three major
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
Since you’ve probably seen this on every other blog in the world already, I’m not going to post that the language that was known as
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
I collegue of mine is studying SQL Server Analysis Services and asks about APIs for it. I have the unique (wierd?) perspective of having come
After writing DevelopMentor's Essential OLE DB class and teaching it to provider writers (and detail-oriented consumer writers) for a few years, I always thought that a
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
The first blog entry got me thinking. For someone supposedly cloistered writing a book, I have been doing some heavy traveling. For the last year,
I’ve finally decided to take the plunge and start this up. I’ve been in hiding for the last year and three quarters or so, working
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.