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

Running the StreamInsightHost as a console app

I've been back at work on StreamInsight lately, and looking at using the Windows service-based host rather than run a self-contained .exe. Since I'd also been using the console for output, I was looking for a way to run the service as a console Read More...
Posted 25 august 2010 09:29 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

SQL Server 2005: Execution Context

This post is based on an old presentation I gave several years back. A video of the presentation used to be available here , but today I couldn't get it to work, so I am attempting to make available most of the information from the presentation within Read More...
Posted 25 august 2010 05:13 from Laurentiu Cristofor's blog @microsoft.com | (Comments Off)

Predilexion for Insight

The point: I am proud to invite you to enjoy our new product, Predixion Insight. It is a cloud-based predictive analytics service that can be accessed from Excel 2007 or 2010 (32 or 64 bit) and allows you to perform advanced analytics on your Excel or Read More...
Posted 18 august 2010 10:50 from DM(X) | (Comments Off)
Filed under:

SqlDependency based caching of LINQ Queries

Query Notifications is the SQL Server feature that allows a client to subscribe to notifications that are sent when data in the database changes irrelevant of how that change occurs. I have talked before about how Query Notifications works in the article Read More...
Posted 4 august 2010 23:23 from rusanu.com | (Comments Off)

Getting Ready For Showtime

Predixion is getting ready for show time. Today is the first day of the Predixion Insight invitational Beta, the first product from our company. This Beta will become public shortly (mid August) so if you are a Data Miner, a PowerPivot pro or  Excel Read More...
Posted 2 august 2010 11:52 from DM(X) | (Comments Off)
Filed under:

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:

Remote Desktop Manager now available

Microsoft internal folks have been used for years a little tool called the Remote Desktop Manager. This tool allows you to save connection settings for frequently used machines you remote into. You can group the servers, save the credentials used for Read More...
Posted 30 iunie 2010 08:21 from rusanu.com | (Comments Off)

A New Must Read Blog (if you are interested in Microsoft BI)

Cristian Petculescu is the Principal Architect of SQL Server Analysis Services. He is in part responsible for everything good that came out of SQL Server Analysis Services in the last 13 years or so. Also, responsible for part of PowerPivot. That really, Read More...
Posted 22 iunie 2010 09:48 from DM(X) | (Comments Off)
Filed under:

Updated serialization formats for SQL Server spatial types

Everyone's on the lookout for info about features of SQL Server VNext. The docs folks may have given us some insight in the publication of an update of the "Microsoft SQL Server CLR Types Serialization Formats [MS-SSCLRT]" spec. This includes Read More...
Posted 21 iunie 2010 19:23 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

SQLCLR debugging and VS 2010 revisited

In my blog entry from about a month and a half ago, I summarized my finding on using Visual Studio 2010 with SQLCLR, and the partial support of SQL Server 2008 new features. One feature (with the disclaimer that's it's not preferred/supported) Read More...
Posted 21 iunie 2010 12:21 from Bob Beauchemin's Blog | (Comments Off)
Filed under: ,

Thanks for a great TechEd!

Last week I was at TechEd in New Orleans , presenting, manning the SQL Server Security and Managability station, meeting with friends and business associates, and, of course, partying. The heat and humidity took a little getting used to, but otherwise Read More...
Posted 16 iunie 2010 09:14 from Bob Beauchemin's Blog | (Comments Off)

High Volume Contiguos Real Time Audit and ETL

Tomorrow at SQL Saturday #43 in Redmond I’ll be presenting a session documenting the real-time audit and ETL the Microsoft uses to manage the access policies on its network. This presentation goes over some of the challenges posed by a contiguos, Read More...
Posted 11 iunie 2010 21:31 from rusanu.com | (Comments Off)

The puzzle of U locks in deadlock graphs

In a stackoverflow.com question the user has asked how come a SELECT statement could own a U mode lock? The deadlock indeed suggests that the deadlock victim, a SELECT statement, is owning an U lock on the PK_B index. Why would a SELECT own an U lock? Read More...
Posted 13 mai 2010 00:15 from rusanu.com | (Comments Off)

Effective Speakers at Portland #devsat and #sqlsat27

Which is faster: ++i or i++? In 1998 I was looking to change jobs and I interviewed with a company for a C++ developer position. The interview went well and as we were approaching the end, one of the interviewers asked me this question: which is faster Read More...
Posted 12 mai 2010 08:52 from rusanu.com | (Comments Off)

Getting error 2337 installing SQL Server on a VPC?

I usually have a number of different versions of SQL Server around, installed on Virtual PCs. Usually works fine. So I was a bit surprised when installing the RTM version of SQL Server 2008 R2 from the downloaded .iso file to receive error message 2337 Read More...
Posted 9 mai 2010 06:50 from Bob Beauchemin's Blog | (Comments Off)
Filed under: