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

Browse by Tags

All Tags » SQL Server 2008 R2   (RSS)

Looking at Data-Tier Applications (DAC)? Look at version 1.1

About a week or so ago, I read a request for information about a SQL Server database management feature known as Data-Tier Applications, abbreviated as DAC (apparently someone realized that the DTA abbreviation was already "taken" in SQL Server Read More...
Posted 5 iulie 2011 12:37 from Bob Beauchemin's Blog | (Comments Off)

SQL Server Security Best Practices whitepaper update is live

I've recently completed an update to the SQL Server 2005 Security Best Practices whitepaper. It's available on the security and compliance website under whitepapers or the direct link is here . Unsurprisingly, its called "SQL Server 2008 Read More...
Posted 7 ianuarie 2011 11:16 from Bob Beauchemin's Blog | (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:

Recompiling the StreamInsight CTP3 samples for 1.0 - Part 3

This posting is a journey through StreamInsight 1.0 APIs, undertaking by porting the CTP3 samples. Part 3. In the StreamInsight CTPs, there existed three methods to code applications. My original post describes the current state of Observable. That leaves Read More...
Posted 4 mai 2010 09:33 from Bob Beauchemin's Blog | (Comments Off)

Recompiling the StreamInsight CTP3 samples for 1.0 - Part 2

This posting is a journey through StreamInsight 1.0 APIs, undertaking by porting the CTP3 samples. Part 2. So let's update the SimulatedDataInputFactory provider, now. The problem seems to be the replacement of the interface that allows you to configure Read More...
Posted 4 mai 2010 09:32 from Bob Beauchemin's Blog | (Comments Off)

Recompiling the StreamInsight CTP3 samples for 1.0 - Part 1

This posting is a journey through StreamInsight 1.0 APIs, undertaking by porting the CTP3 samples. The first look at the errors produced by recompiling the CTP3 examples is the realization that the IObservable model for coding adapters doesn't exist Read More...
Posted 4 mai 2010 09:29 from Bob Beauchemin's Blog | (Comments Off)

StreamInsight 1.0 RTM: Installation and Samples

StreamInsight V1.0 RTM'd a few weeks ago. Although I worked with it, looking especially at the infrastructure and programming models, I just installed the RTM version a few days ago. One thing I noticed immediately upon install is that it requires Read More...
Posted 4 mai 2010 09:25 from Bob Beauchemin's Blog | (Comments Off)

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)

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: