Checking for dangerous attributes at catalog time
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
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.
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
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.