Browse by Tags

• bi
• BULK EXPORT
• column store
• data compression
• DMVs
• express edition
• Filestream Storage
• Gemini
• keynote
• Madison
• Management Studio
• Management Studio Express
• mssqlsystemresource
• page compression
• pass
• resource database
• row compression
• service broker
• setup
• SQL 11
• SQL Server 2008
• SQL Server 2008 and beyond
• SQL11
• SSMS
• SSMSE
• TPC
• UCP
• Unicode compression
• Utility Control Point
• VMs
• Windowing functions
• Windows 7
• Windows Server 2008 R2

• 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 Saturday, February 06, 2010 3:43 PM from Bob Beauchemin's Blog | (Comments Off) Filed under: service broker, SQL Server 2008 R2

• 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 Friday, February 05, 2010 6:25 AM from Bob Beauchemin's Blog | (Comments Off) Filed under: Filestream Storage, SQL Server 2008 R2

• 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 Wednesday, January 13, 2010 10:40 AM from Bob Beauchemin's Blog | (Comments Off) Filed under: SQL Server 2008 R2

• 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 Wednesday, January 13, 2010 5:59 AM from Bob Beauchemin's Blog | (Comments Off) Filed under: SQL Server 2008 R2

• Connect Digest : 2009-11-20

  SSMS needs to support today's (and tomorrow's) number of cores Apparently when you try to get to the server properties page where CPUs are displayed, the UI is not equipped to handle 96 cores. Man, I wish I had a 96-core instance of SQL Server handy to...( Read More... Posted Saturday, November 21, 2009 6:43 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008 R2, BULK EXPORT, SQL11, Windowing functions

• Some tips on SSMS Express Edition setup

  I posted earlier that the Express Edition of Management Studio for SQL Server 2008 R2 (November CTP) is now available for download. During the first few pages in the setup wizard, I was certain that I had either downloaded the wrong version of the CTP,...( Read More... Posted Thursday, November 12, 2009 9:38 AM from Aaron Bertrand | (Comments Off) Filed under: setup, Management Studio Express, SQL Server 2008 R2, SSMSE

• November CTP of SQL Server 2008 R2 : Download now

  For those of you that have been wanting to try out SQL Server 2008 R2, you can download the November CTP of Express here (posted yesterday) and the full version of the November CTP here . This is version 10.50.1352.12. The full version is an evaluation...( Read More... Posted Thursday, November 12, 2009 8:44 AM from Aaron Bertrand | (Comments Off) Filed under: SSMS, Management Studio, express edition, SQL Server 2008 R2, SSMSE

• Blogging from the PASS Keynote : 2009-11-05

  Bill Graziano took the stage and promised us the shortest keynote yet. He started by giving thanks to outgoing board members Greg Low, Pat Wright and Kevin Kline. Wayne Snyder took over and gave an emotional homage to Kevin, who gave 10 solid years to...( Read More... Posted Friday, November 06, 2009 3:24 AM from Aaron Bertrand | (Comments Off) Filed under: pass, SQL Server 2008 R2, SQL Server 2008 and beyond, keynote, column store, SQL 11

• Blogging from the PASS Keynote : 2009-11-04

  Rushabh Mehta, PASS President of Finance What makes PASS run? He mentioned CA and Microsoft as founding members. But the overwhelming response from the crowd: we're more interested in free drinks. Stressed financial transparency ... members can log in...( Read More... Posted Thursday, November 05, 2009 2:31 AM from Aaron Bertrand | (Comments Off) Filed under: pass, bi, SQL Server 2008 R2, SQL Server 2008 and beyond

• Blogging from the PASS Keynote : 2009-11-03

  Highlights We were told that there is going to be a November CTP of SQL Server 2008 R2. There are two new editions planned for the RTM release: DataCenter Edition (256 logical processors, unlimited virtualization) and Parallel Data Warehouse Edition (formerly...( Read More... Posted Wednesday, November 04, 2009 1:53 AM from Aaron Bertrand | (Comments Off) Filed under: pass, SQL Server 2008 R2, Gemini, SQL Server 2008 and beyond, Madison, TPC

• More testing of Unicode Compression in SQL Server 2008 R2

  Background Several weeks ago, I ran some tests on the new implementation of Unicode Compression in SQL Server 2008 R2 - both space-related and performance-related . Of course it was pointed out that my performance tests were somewhat flawed, because I...( Read More... Posted Monday, October 05, 2009 8:24 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, data compression, SQL Server 2008 R2, Unicode compression

• SQL Server 2008 R2 : More peeking under the hood

  A little over a week ago, I performed some initial investigation into what has changed between SQL Server 2008 and 2008 R2 . Steve Cooney quickly asked, "Where is all the schema for UCP and DAC?" It was a great question, and my initial response was that,...( Read More... Posted Tuesday, September 01, 2009 3:00 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008 R2, UCP, Utility Control Point

• SQL Server 2008 R2 : Digging deeper into Unicode compression

  When SQL Server 2008 R2 was first released, I wrote a quick blog post discussing the additional space savings gained by Unicode compression . In one of the follow-up comments, Adam Machanic was quick to suggest that compression can bring significant CPU...( Read More... Posted Monday, August 24, 2009 6:50 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, data compression, SQL Server 2008 R2, Unicode compression

• Peeking under the hood : what bits have changed in SQL Server 2008 R2?

  We know what new features are available in SQL Server 2008 R2: data-tier applications (still with that unfortunate and poorly-chosen acronym, DAC), control point explorer, dashboard viewpoints, report builder 3.0, Unicode compression, StreamInsight, yada...( Read More... Posted Sunday, August 23, 2009 1:34 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, SQL Server 2008 R2, mssqlsystemresource, resource database

• Is SQL Server 2008 supported on Windows 7 / Windows Server 2008 R2?

  Yes it is! See this blog post from Peter Saddow: http://blogs.msdn.com/petersad/archive/2009/08/11/sql-server-on-windows-7.aspx First, if you have User Access Control in full swing, UAC will generate the following prompt to make sure you're okay with...( Read More... Posted Saturday, August 15, 2009 6:12 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, setup, Windows 7, SQL Server 2008 R2, Windows Server 2008 R2, VMs