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

mai 2008 - Posts

What's the DataSet doing in a trace of an Entity Framework program?

In a blog posting about a few weeks ago , I'd written about noticing a DataSet being created in an Entity Framework program by using the ADO.NET client trace facility. Entity Framework programs do (indirectly) cause a DataSet to be created, but its only Read More...
Posted 31 mai 2008 01:48 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Heading Out To TechEd

I'm getting ready to head out to TechEd in Orlando. I'll be doing a full day of SQL Server 2008 for Developers on Monday, a talk on SQL Server client and server-side tracing (including SQL Server 2008 Extended Events), one on PowerShell and SQL Server, Read More...
Posted 31 mai 2008 00:38 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Saving a roundtrip when inserting rows with filstream columns

It's a good idea when talking to a database to save on network roundtrips. The table-valued parameter in SQL Server 2008 is an example of a feature that can reduce them in the "1 order, 1-n detail items" use case. So its always been mildly irritating Read More...
Posted 30 mai 2008 20:29 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Dialog Security Configuration Wizard in Toad

On my last post I’ve said that the Toad tools from Quest lack the option to configure Dialog Security for Service Broker. I stand corrected, as they actualy do. Not only that, but they support both full security and anonymous security, and the configuration Read More...
Posted 23 mai 2008 00:22 from rusanu.com | (Comments Off)
Filed under:

SQL Server 2008 Change Tracking and Sync Services ARE made for each other... in VS2008 SP1

This item was mentioned in other blogs too, but just to mention it again (so my SQLCE and Sync Services friends won't think I overlooked it)... Visual Studio 2008 SP1 Beta contains direct support for using SQL Server 2008 Change Tracking. When you use Read More...
Posted 17 mai 2008 01:12 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

SQL Server 2008 data types in LINQ to SQL and EF, they (mostly) did it

Last fall I'd asked the folks on the data access team about the possibility of including the new SQL Server 2008 data types in the new data access object mapping layers. At that time they said "no" but they also asked "why do you want it?" and "are people Read More...
Posted 17 mai 2008 00:43 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

First blog entry in a month...what's up

After posting the last blog entry, I realized that I hadn't blogged in about a month. Hmmmm... Well, since last month I posted the demos for my SQLConnections talks on the SQLskills website (under PastConferences). I really had a good time at SQLConnections, Read More...
Posted 17 mai 2008 00:20 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Trace Events in ADO.NET Entity Framework

Every once in a while I'll get inquires on a paper I wrote in 2004 about the ETW trace providers for ADO.NET (named "Tracing Data Access"). I got an inquiry today, and since I'd recently installed Visual Studio 2008 SP1 Beta, I thought I'd try it out Read More...
Posted 16 mai 2008 23:37 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Viable tools for Service Broker

Technically Service Broker can offer a huge value over any other comparable technology, but every project faces in the early stages the same barrier: the extremely steep learning curve faced by developers and dba in order deploy a Service Broker solution. Read More...
Posted 16 mai 2008 12:05 from rusanu.com | (Comments Off)
Filed under:

A discussion of password authentication schemes

I have talked in the past about how passwords for SQL logins are protected in SQL Server (see this post ). I would like to describe this scheme in a more generic way and compare it with the alternative of encrypting the passwords, because I have seen Read More...
Posted 9 mai 2008 22:45 from Laurentiu Cristofor's blog | (Comments Off)