Welcome to MSDN Blogs Sign in | Join | Help

June 2006 - Posts

Thursday, June 29, 2006 7:29 PM

Three significant Cursor changes in SQL Server 2005

Many ISV applications use ODBC API Server Cursors. One source of developer confusion when coding and debugging API Server Cursors against previous versions of SQL Server (6.5, 7.0, & 2000) was Implicit Cursor Conversions, also known as cursor degradation.
Posted by RaviR | 5 Comments
Friday, June 23, 2006 9:59 PM

Introducing Multiple Active Result Sets (MARS) (2)

MARS is a powerful tool, but you may shoot yourself by the foot if you don't use it correctly. In the following several talks, I will talk about how to use MARS safely. This talk will cover the session/request context management. In later talks, I will
Posted by pingwang | 2 Comments
Friday, June 16, 2006 10:21 PM

Impersonation in SQL CLR

When the user code will try to access a resource outside of the SQL server it will run in the security context under which SQL Server is running. But this is not the ideal situation since it could become a security issue when the logged user that calls
Posted by sqlclr | 1 Comments
Friday, June 16, 2006 10:03 PM

Assembly redirection and CLR Integration

Assembly redirection is not supported in SQL CLR. Assembly redirection can be done using publisher, application configuration and machine configuration files. SQL Server 2005 uses application configuration to redirect assembly call after Alter Assembly.
Posted by sqlclr | 1 Comments
Thursday, June 15, 2006 11:14 PM

T-SQL text hashing in SQL Servers 2000 and 2005

Recently several users of SQL Server ran into interesting issues related to hashing of T-SQL text by SQL Server for caching purposes. This blog post will describe how SQL Server performs this hashing, and the differences in behavior between 2000 and 2005
Posted by adbirka | 0 Comments
Tuesday, June 13, 2006 2:56 PM

Satellite assemblies in SQL Server 2005

This is a sample on how to register satellite assemblies in SQL Server 2005. Based on the CultureInfo on the executing thread, CLR will try to load the respective resource assembly. It should not be a difference between satellite assemblies inside and
Posted by sqlclr | 0 Comments
Friday, June 09, 2006 11:57 PM

TSQL Basics II - Parameter Passing Semantics

TSQL uses a copy-in/copy-out semantics to pass parameters to stored procedures and functions. This is a different semantics then the usual by-value or by-reference parameter passing semantics supported by most languages. What does this mean? When a parameter
Posted by adamp | 3 Comments
Tuesday, June 06, 2006 8:07 PM

Creating a CLR user define aggregate (part 2). Use multiple columns in the aggregation function

I part 1 we created a nice user defined aggregate. Now we are going to make it more sophisticated and let its value depend on two parameters ShipCountry and ShipShipCity. You might try having two parameters in Accumulate function of the aggregate but
Posted by nikitas | 1 Comments

Attachment(s): ClrAggregates.zip
Tuesday, June 06, 2006 8:05 PM

Creating a CLR user define aggregate (part 1). Simple CLR aggregate

SQL Server 2005 allows creating of User Defined Aggregate in any of the .NET languages such as C# or VB. For simple cases like SUM or MAX you probably want to use built-in aggregates, however there are cases where build-ins are insufficient. In such cases
Posted by nikitas | 0 Comments
Saturday, June 03, 2006 12:04 AM

Diagnosing CLR Execution in SQL Server

In this section, i am going to introduce some basic diagnostic tools. You may already be familiar with Dynamic Management Views. We modified a few existing DMVs and added a few new ones to help with some transparency to the execution of sqlclr code in
Posted by RaviR | 2 Comments
 
Page view tracker