Welcome to Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008 R2   (RSS)
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...
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...
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...
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...
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...
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...
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...
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 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...
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...