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

Contract position in Seattle

Do you know anybody that is interested in a 6mo-12mo contract position in Seattle (Redmond) area for a very interesting SQL Server project? Position requires good system architecture and development skills. Your main job will be writing T-SQL code for Read More...
Posted 9 martie 2010 20:02 from rusanu.com | (Comments Off)

Dealing with Large Queues

On a project I’m currently involved with we have to handle a constant influx of audit messages for processing. The messages come from about 50 SQL Express instances located in data centers around the globe, delivered via Service Broker into a processing Read More...
Posted 9 martie 2010 10:10 from rusanu.com | (Comments Off)

Trouble seeing "Birth of Venus" image in the SSMS spatial results tab?

Michael J Swart posted a SQL query on his blog that produced a rendition of Botticelli’s Birth of Venus, in the spatial results tab of SQL Server Management Studio when executed. But, when everyone rushed over in anxious anticipation, some folks Read More...
Posted 28 februarie 2010 16:28 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

DbccCommand Enumeration

The SMO libraries contain an enum for the DBCC commands: DbccCommand. But there is little explanation in the MSDN documentation what those commands are. I had a recent discussion with a developer who, understandably, expected a little cleaner explanation Read More...
Posted 23 februarie 2010 08:36 from rusanu.com | (Comments Off)
Filed under: , , ,

Transactions, isolation, and SQL Azure

I was trundling through my SQL Azure database today, looking for interesting behaviors. Found one. A "select * from sys.databases" reveals that both "snapshot_isolation_state" and "is_read_committed_snapshot_on" return 1 Read More...
Posted 11 februarie 2010 11:46 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

A SQL Server 2008 R2 change for Service Broker

There's another change to the SQL Server database engine in SQL Server 2008 R2. This concerns poison-message handling behavior in Service Broker applications. Service broker's messaging is always transactional. A RECEIVE SQL statement is transactional Read More...
Posted 5 februarie 2010 17:43 from Bob Beauchemin's Blog | (Comments Off)

Filestreams, Remote Blog Storage, and SQL Server 2008 R2

As long as I'm blogging about filestreams... Folks always want to know if the filestream information can be stored on a remote share. They look kind of disappointed when they hear that the filestream filegroup must exist on a local (to the SQL Server Read More...
Posted 4 februarie 2010 08:25 from Bob Beauchemin's Blog | (Comments Off)

Filestreams, transactions and SQL Server 2008 R2

I was under the impression that the database engine/programming model changes in SQL Server 2008 R2 were minimal and could be counted on one hand. Today I was running an old demo that I had, having to do with filestreams on the R2 Nov CTP. Usually I run Read More...
Posted 4 februarie 2010 07:47 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

The StreamInsight Object Model and Observables

In the last installment about the object model, let's the at the third development style, using .NET's IObservable/IObserver. IObservable/IObserver is a new interface in .NET 4.0, the "mirror image" (to use a less controversial term) Read More...
Posted 19 ianuarie 2010 07:28 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Populating the ObjectModel with ImplicitServer

Now that you know the StreamInsight metadata (see inside the metadata), its fairly easy to take apart the implicit model because you already know which objects are being created for you. In the implicit development model, you: 1. Create a CepStream for Read More...
Posted 19 ianuarie 2010 06:49 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Inside the StreamInsight Object Model - Metadata

The StreamInsight object model seems fairly complex at first. There's a series of choices as you progress down the development path which make things appear more complex than they are. One thing to keep in mind is, no matter how you populate it, there Read More...
Posted 19 ianuarie 2010 06:45 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

What deprecated features am I using?

Copyright Remus Rusanu 2010. Visit the original article at http://rusanu.com/2010/01/12/what-deprecated-features-am-i-using/   select instance_name as [Deprecated Feature] , cntr_value as [Frequency Used] from sys.dm_os_performance_counters Read More...
Posted 12 ianuarie 2010 21:37 from rusanu.com | (Comments Off)

DACPAC and pre-SQL Server 2008 R2 versions

I thought it was curious that in a DACPAC you can specify required version and edition of SQL Server as a deployment option. But DAC (Data-Tier Applications) is a new feature of SQL Server 2008 R2 and VS2010 data tools. So what versions and editions does Read More...
Posted 12 ianuarie 2010 12:40 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

Upgrading maps in BI Dev Studio projects

Folks that are on early betas of products (especially private betas) are not surprised when projects are not updatable between beta versions. These limits are usually listed in the release notes, sometimes you'll just stumble across them. I'm Read More...
Posted 12 ianuarie 2010 07:59 from Bob Beauchemin's Blog | (Comments Off)
Filed under:

SQL Azure: Adventures in connectivity

SQL Server Management Studio in 2008 R2 (and there's a standalone upgrade for SSMS) supports connecting to SQL Azure. And there were some tools on CodePlex that did too. And that's what I'd always used. But reading along in the latest docs Read More...
Posted 6 ianuarie 2010 18:04 from Bob Beauchemin's Blog | (Comments Off)
Filed under: