Welcome to Romanian SQL Server User Group Sign in | Join | Help
As of today I am working as a Principal Architect (tada!) for Predixion Software, a predictive analytics startup in Redmond, WA. So far, it’s pretty close to the Encarta definition of exhilarate!  The company aims to bring predictive analytics technology Read More...
Posted 16 martie 2010 09:24 from DM(X) | (Comments Off)
Filed under:
Today has been my last day at Microsoft. I spent more than 10 years with the company and loved every bit of these 10 years.  If not for a very promising startup, I would probably be looking forward to spending the next 10 years with Microsoft, in Read More...
Posted 13 martie 2010 10:39 from DM(X) | (Comments Off)
Filed under:
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...