Welcome to Romanian SQL Server User Group Sign in | Join | Help

august 2008 - Posts

Visual Studio 2008 SP1 and SQL Server 2008 SQLCLR features

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...
Posted 31 august 2008 12:57 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

A GUI visualizer/editor for SQL Server 2008 Extended Events

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...
Posted 31 august 2008 11:29 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Data Mining for the Cloud (or how I spent my summer)

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...
Posted 29 august 2008 10:19 from DM(X) | (Comments Off)
Filed under: , ,

Certificate Not Yet Valid

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...
Posted 25 august 2008 10:28 from rusanu.com | (Comments Off)
Filed under:

SQL Server: Windows Groups, default schemas, and other properties

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...
Posted 23 august 2008 01:15 from Laurentiu Cristofor's blog @microsoft.com | (Comments Off)

A helper function for ring-orientation in the SQL Server 2008 geography data type

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...
Posted 21 august 2008 07:25 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Semantic (possibly breaking) change in SQLCLR TVFs

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...
Posted 21 august 2008 06:54 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Error Handling and Activation

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...
Posted 13 august 2008 20:44 from rusanu.com | (Comments Off)

Service Broker Team Blog

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...
Posted 8 august 2008 20:50 from rusanu.com | (Comments Off)
Filed under:

A SQL Injection attack and search engines

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...
Posted 5 august 2008 21:07 from Laurentiu Cristofor's blog @microsoft.com | (Comments Off)

Database Journal articles on Service Broker

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...
Posted 5 august 2008 15:31 from rusanu.com | (Comments Off)
Filed under:

Understanding Queue Monitors

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...
Posted 3 august 2008 19:58 from rusanu.com | (Comments Off)