Welcome to Sign in | Join | Help

august 2008 - Posts

When SQL Server 2008 shipped, Visual Studio 2008 SP1 and .NET 3.5 SP1 shipped a few days later. Visual Studio SP1 contains some neat enhancements that allow you to use SQL Server 2008 databases in Server Explorer and the related designers. There's support Read More...
One of my favorite new features of SQL Server 2008 is extended events. I've written a bunch of blog entries on 'em (use the search, type in Extended Events). So a few days ago, I recieved an email from Jonathan Kehayias directing me to his new program Read More...
This week, at the KDD (Knowledge Discovery and Data Mining) conference, we (as in Microsoft SQL Server Data Mining team) presented the Table Analysis Tools for the Cloud, a preview for a technology that enables anybody to play with some of the Microsoft’s Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/08/25/certificate-not-yet-valid/  So you are running into a blocking issue, try to find a solution and you gets back a reply like ‘Sorry, I cannot repro Read More...
Exceptions are dangerous because people like to simplify their thinking process using rules, so exceptions always carry the risk of being overlooked. In security, exceptions are a bad thing because they make the model more complex and complex systems Read More...
Folks have always had trouble with the fact that ring orientation is required with spatial instances if you're using SQL Server 2008's geography data type, but not with the geometry data type. For an explanation of the need for this, reference Isaac Kunen's Read More...
I came across the following interesting behavior while testing a SQLCLR table-valued function that did work in SQL Server 2005 SP2 but doesn't work at all in SQL Server 2008. It appears to be by design, because the error message (in 2008) clearly indicates Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/08/13/error-handling-and-activation/   I have previously talked here about the queue monitors and the role they play in launching activated procedures. If you Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/08/08/service-broker-team-blog/  In case you miss it, the SQL Server Service Broker has recently started posting in an MSDN team blog: http://blogs.msdn.com/sql_service_broker. Read More...
A few weeks after my previous posting of a SQL Injection Advisory link, a new SQL Injection attack came up. Here's a post describing it; it also includes other useful links: http://www.rtraction.com/blog/devit/sql-injection-hack-using-cast.html A search Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/08/05/database-journal-articles-on-service-broker/  Marcin Policht has a series of articles on databasejournal.com covering Service Broker. So far the series has Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/08/03/understanding-queue-monitors/A major class of Service Broker applications have nothing to do with the distributed application capabilities SSB was designed for. Instead Read More...