Browse by Tags

• Analysis Services
• ANSI
• auditing
• australia
• Backup
• backup compression
• backward compatibility
• bids
• BIDS Helper
• books online
• community
• compliance
• Conference Resources/Q&A
• connect
• conventions
• data compression
• debugger
• Design
• DMF
• DMVs
• DOS
• dynamic management views
• Events
• express edition
• indexes
• intellisense
• Katmai
• Licensing
• Management Studio
• MVP Summit
• MySQL
• next version
• numeric data types
• PBM
• Policy-Based Management
• powershell
• resources
• Screencast
• skus
• SP1
• spatial
• sql
• sql improvements
• SQL Server
• SQL Server 2005
• SQL Server 2011
• sql server express
• ssis
• SSMS
• standards
• Visual Studio 2008
• web edition

• My Management Studio wishlist for SQL Server 2011

  Inspired both directly and indirectly by fellow MVP Erland Sommarskog, whose programming wishlist I talked about the other day , I have decided to compile a list of my own wish list items, in the same spirit of, "it's never too early." This list is restricted Read More... Posted Wednesday, August 20, 2008 1:56 PM from Aaron Bertrand | (Comments Off) Filed under: SSMS, connect, SQL Server 2008, Management Studio, SQL Server 2011, next version

• Want to make a difference in the next version of SQL Server?

  SQL Server 2008 is out, and I'm sure you are either learning about or already enjoying some of the new features. And while the dev team probably doesn't wholeheartedly agree with me at this very moment, I think that it can never be too early to start Read More... Posted Sunday, August 17, 2008 1:31 PM from Aaron Bertrand | (Comments Off) Filed under: connect, SQL Server 2008, SQL Server 2011, next version

• BIDS Helper 1.3 Released (now with support for SQL 2008)

  I am pleased to announce that the BIDS Helper team have just released v1.3 which is our first release with support for SQL Server 2008. With these release we have also improved our international support. All of the features in BIDS Helper still only display Read More... Posted Saturday, August 16, 2008 9:51 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server, SQL Server 2008, SQL Server 2005, BIDS Helper

• SQL Server Express 2008 is now available

  Sorry I missed this yesterday with all the excitement over the Visual Studio SP1 release (which allowed some people to finally install the SQL Server 2008 release from last week). Yesterday also marked the release of SQL Server 2008 Express Edition, which Read More... Posted Tuesday, August 12, 2008 9:02 PM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, express edition, sql server express

• Visual Studio 2008 SP1 (RTM) is now available

  There is a forthcoming blog post which will explain how this release will interact with SQL Server 2008 installations. My recommendation is that if you haven't already installed SQL Server 2008, install Visual Studio 2008 SP1 first. If you have already Read More... Posted Tuesday, August 12, 2008 3:02 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008, Visual Studio 2008, SP1

• SQL Server 2008 has been released, but some BI developers will need to wait...

  For those of use with MSDN or Technet subscriptions, SQL Server 2008 is available for download now and you have probably heard this from multiple sources already. (is there an echo in here?) But for anyone that wants to work with the BI tools and who Read More... Posted Friday, August 08, 2008 7:08 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, SQL Server, SQL Server 2008, bids

• SQL Server 2008 has RTM'd

  According to a few sources (e.g. Gail Shaw and Brian Randell ), Microsoft announced today at TechEd South Africa that SQL Server 2008 has RTM'd. For those that aren't aware, this just means that the code has been signed off, not that it is being placed Read More... Posted Thursday, August 07, 2008 2:49 AM from Aaron Bertrand | (Comments Off) Filed under: SQL Server 2008

• New Kid on the Block : SQL Server 2008 Web Edition

  You may have heard rumblings at a conference or user group meeting about a new SKU of SQL Server that will be shipping soon: Web Edition. But what is it, exactly? Some information on this edition has recently been released by Ireland Licensing , and I Read More... Posted Monday, August 04, 2008 9:51 AM from Aaron Bertrand | (Comments Off) Filed under: Licensing, SQL Server 2008, web edition, skus

• Demos for Portland SQL Server user group talk on SQL Server spatial

  For attendees of last Thursday's talk on SQL Server Spatial for the masses, the demo code is located here . Thanks for coming and for your participation! This blog is sponsored by SQLSkills . Read More... Posted Tuesday, July 29, 2008 4:07 AM from Bob Beauchemin's Blog | (Comments Off) Filed under: SQL Server 2008

• SSMS T-SQL Debugger ScreenCast

  just posted - SSMS T-SQL Debugger ScreenCast 5:58 - focuses on the call stack. If you haven't played with the new Debugger, this is an easy way to get a look-see. Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Wednesday, July 23, 2008 4:22 PM from Paul Nielsen | (Comments Off) Filed under: SSMS, SQL Server 2008, Screencast, debugger

• How do the links in YOUR copy of SQL Server 2008 Books Online work?

  I am just taking a quick show of hands; and maybe some information, if you are willing. (And if this hasn't happened to you, I apologize for taking up your time.) I have had various problems on multiple installations of Books Online throughout the entire Read More... Posted Sunday, July 20, 2008 9:55 AM from Aaron Bertrand | (Comments Off) Filed under: Katmai, SQL Server 2008, books online

• DDL appdomains appear in SQL Server log in SQL Server 2008

  .NET (and therefore SQLCLR) divides up running its code (even within the same process like the sqlserver.exe process) into appdomains. The appdomain is like a lightweight process used to enforce isolation between running .NET code within the same Windows Read More... Posted Saturday, July 19, 2008 9:42 AM from Bob Beauchemin's Blog | (Comments Off) Filed under: SQL Server 2008

• I'm speaking at Portland SQL Server Users Group next Thursday

  I've been able to coordinate being home and the Portland (Oregon) SQL Server user group's meeting schedule, so next week I'll be speaking "at home" for a change. I'm giving a talk on one of my favorite features for developers in SQL Server 2008, Spatial Read More... Posted Friday, July 18, 2008 5:01 AM from Bob Beauchemin's Blog | (Comments Off) Filed under: SQL Server 2008

• Programming SQLRegistration in the SQL Server PowerShell Provider

  I've noticed that some folks have written PowerShell scripts that execute against a list of servers. In the scripts, they read the names of the servers from XML files. But the SQL Server PowerShell provider in RC0 has a useful "component" called SQLRegistration; Read More... Posted Tuesday, July 08, 2008 5:23 PM from Bob Beauchemin's Blog | (Comments Off) Filed under: SQL Server 2008

• Using PowerShell to program SQL Server's Policies and Data Collection

  I received a question today about whether I'd converted my Policy-Based Management examples using SMO (see the multi-part "Programming Policy-Based Management with SMO" series, starting here ) from C# to PowerShell yet. I did do this a while ago; they're Read More... Posted Tuesday, July 08, 2008 5:11 PM from Bob Beauchemin's Blog | (Comments Off) Filed under: SQL Server 2008