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

noiembrie 2011 - Posts

SQLCLR .NET 4-based behavior differences in SQL Server 2012

As I mentioned in a few previous blog entries, SQL Server 2012 runs the .NET 4 version inside of SQL Server. Your SQLCLR code may be affected by some behavior differences between .NET versions 2.0/3.5/3.5 SP1 and .NET 4.0. I like the way SQL Server chose Read More...
Posted 27 noiembrie 2011 14:52 from Bob Beauchemin's Blog | (Comments Off)
Filed under: ,

Per-appdomain diagnostic info in SQL Server 2012 SQLCLR

In SQL Server 2012, SQLCLR now loads .NET 4.0 code rather than .NET 2.0 as in previous versions of SQL Server. Note that the "main system" assemblies (e.g. mscorlib.dll, System.Data.dll) in .NET did not appear as a separate directory, between Read More...
Posted 27 noiembrie 2011 14:45 from Bob Beauchemin's Blog | (Comments Off)
Filed under: ,

Native ODBC components in SQL Server 2012 SSIS

Just had the occasion to look at SSIS Sources and Destinations in SQL Server 2012 RC0. After reading about the stated direction to use ODBC for SQL Server/relational data access over OLE DB and writing up my own blog post about it , I wondered how long Read More...
Posted 26 noiembrie 2011 12:58 from Bob Beauchemin's Blog | (Comments Off)

Using SQL Server 2012 tools with older database versions

Last week, while teaching a class based around SQL Server 2008 R2, I happened to "brag up" the new tools in SQL Server 2012, mainly the Extended Event graphic user interface in SSMS and the ability of Database Tuning Advisor to tune from the Read More...
Posted 21 noiembrie 2011 10:44 from Bob Beauchemin's Blog | (Comments Off)

Speaking at Portland, OR, User Group in December

Speaking at a user group is a bit different from speaking at a conference or other event. Because you know the folks there personally (hi Ken, Chris, and all ;-), you can ask around and "do requests", rather than just do what's interesting Read More...
Posted 4 noiembrie 2011 09:54 from Bob Beauchemin's Blog | (Comments Off)
Filed under: ,

SQL Server 2012 client features - ADO.NET 4.02 released

This post is about the changes in the client stack for SQL Server 2012. It's a very short post. The last two major releases of SQL Server (2005 and 2008) corresponded to .NET 2.0 and .NET 3.5 SP1 respectively. In addition, each one corresponded to Read More...
Posted 3 noiembrie 2011 10:09 from Bob Beauchemin's Blog | (Comments Off)