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

Browse by Tags

All Tags » Data Access   (RSS)

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)

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)

Adieu, OLE DB

The writing has been on the wall for some time, but a few days ago Microsoft made it official . OLE DB will no longer be supported with SQL Server after the Denali (SQL Server 11.0) release of SQL Server. Microsoft is "embracing" ODBC. "OLE Read More...
Posted 31 august 2011 14:19 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Correlating client and server-side trace in SQL Server Denali

I'm not usually one for repeating stuff you can find in BOL. Usually, a waste of your time and mine. But this feature, for SQL Server Denali, is pretty well buried; well at least from me, and I knew what I was looking for. I've always been interested Read More...
Posted 19 august 2011 08:28 from Bob Beauchemin's Blog | (Comments Off)

TVPs and plan compilation - the reprise

A few months ago, I published a blog entry entitled " The interesting case of TVPs and plan compilation " about the fact that a plan compile is reported (by perfmon) each time you correctly use a TVP from a program in RPC mode. After waiting Read More...
Posted 13 martie 2011 00:53 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

The interesting case of TVPs and plan compilation

A couple of people reported problems with SQL Server 2008's table-valued parameters and it eventually got back to me. Had to try it out. The reported problem is that there's a plan compile each time TVPs are used from ADO.NET. Interestingly, when Read More...
Posted 23 decembrie 2010 09:49 from Bob Beauchemin's Blog | (Comments Off)

LINQ to SQL and Entity Framework: Panacea or evil incarnate? Revisited.

I received an interesting question today that I started to answer in email, then realized it would make a good blog post. It went something like..."Do you know if EF4 addresses the Bob Beauchemin’s criticism in his “LINQ to SQL and Entity Read More...
Posted 1 iulie 2010 10:50 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Guide to the Data Development Platform for .NET Developers whitepaper available

I've been busy for the last few weeks putting together a "manifesto" whitepaper about the .NET-based data access stacks and also the possibilities for .NET programmers in the SQL Server product itself. The whitepaper's direct link is Read More...
Posted 18 noiembrie 2009 12:18 from Bob Beauchemin's Blog | (Comments Off)

Upcoming improvements in EDM T-SQL code generation

I'm always thought that what makes or breaks any ORM layer for use in any but the simplest of applications is the underlying SQL code that's generated. In fact, I'm a proponent of using stored procedures with any ORM for best performance. Read More...
Posted 7 august 2009 11:53 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

L2S and EF parameterization problem will be fixed in .NET 4.0 - completely

For those of you who's blog readers don't always get updated (rather than brand new) blog entries, there's a happy ending to my last "fixed-almost" blog entry on EDM 4.0 and parameterization. I've heard that this has been fixed Read More...
Posted 26 mai 2009 07:56 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

L2S and EF parameterization problem fixed in .NET 4.0 - almost

One of the first things that I did after installing VS2010 beta this week was to check on a parameterization problem with string parameters, and Linq To SQL/ADO.NET Entity Framework generated code. In the original version, this L2S query: var x = from Read More...
Posted 25 mai 2009 11:29 from Bob Beauchemin's Blog | (Comments Off)
Filed under: