Browse by Tags

Tagged Content List
  • Blog Post: SQL Server 2008 Upgrade Whitepaper

    The SQL Server Engineering team has released a masive white paper that details upgrading to SQL Server 2008. It's all good information, but if you're reading this blog you're probably interested in chapter 10, which specifically covers SQL Server 2008 Express. You can find more information here . ...
  • Blog Post: Getting SQL Server 2008 Express on a DVD

    A small but persistent group of developers has been asking for SQL Server Express to be released on media, most commonly from those folks who live in areas without broadband Internet (yes, there are still such areas) for whom downloading an 80 MB package can be an endurance challenge. One of the benefits...
  • Blog Post: Announcing the SQL Express 2008 Installation Package

    Update: The SQL Express 2008 Installation Package (Express Wrapper) is no longer available. Currently the best way to install SQL Server Express is to use Web Platform Installer . FYI: SQL Server MVP Andrea Montanari has posted his own summary of the experience of using this tool including screen...
  • Blog Post: FAQ: Switching between SQL Server 2008 edtions

    There is an extra step that you need to take when upgrading from one edition of SQL Server 2008 to another, for example when upgrading from Express to Express with Tools. This extra step is called Edition Upgrade (sometimes SKU Upgrade) and the net result is that you have to run the install wizard twice...
  • Blog Post: SQL Server 2008 Express is now live!

    I promised an update on SQL Express availability in my last post about the release of SQL Server 2008 so here it is. SQL Server 2008 Express is now available along with the release of the .NET Framework 3.5 SP1, which is a prerequisite and Visual Studio Express SP1 . As I mentioned, there are two more...
  • Blog Post: What's up with SQL Server 2008 Express editions

    Microsoft has announced the release of SQL Server 2008 and that means it time for another post about SQL Server Express. The press release indicated that SQL Express is already available, but those of you who have followed the link have found that it is not actually there. Nothing to worry about,...
  • Blog Post: SQL Server 2008 Express RC0

    It's time for another release post, this time for RC0 of SQL Server 2008 Express and SQL Server 2008 Express with Advanced Services. Here is the information that everyone is waiting to hear about the SQL Express product line. (Note: If you're the impatient type you can skip to the end of this post to...
  • Blog Post: SQL Server Express and Hosting

    Several questions have come up lately regarding whether SQL Server Express is an appropriate product to be used in a hosting environment. Here are the answers: · User Instances (also known as RANU) available with SQL Server Express Edition, are NOT RECOMMENDED for hosting environments. ·...
  • Blog Post: Understanding SQL Express behavior: Idle time resource usage, AUTO_CLOSE and User Instances

    I've gotten a number of questions recently asking how SQL Express uses resources during idle time, and how that behavior impacts the way SQL Express behaves "on first connection" after being idle for a period of time. While many of these questions have been related to web hosting, the behavior is a general...
  • Blog Post: SQL Express SP2 available on Microsoft Update

    Just a quick not to let you know that the SP2 update for SQL Express, SQL Express with Advanced Services and SQL Express Toolkit are being published to Microsoft Update today. These are automatic updates and will apply to computers based on your Microsoft Update settings for automatic updates. (i.e....
  • Blog Post: SQL Server 2005 SP2 has been released

    It's been a long road filled with many shouts of "Are we there yet?", so I'm happy to say that yes, we're there now. SP2 has finally be released. You can find the SQL Express SP2 bits on the SQL Express download page along with several other related downloads. As of this writing, we were having some...
  • Blog Post: New benefits for Registration and new Absolute Beginners Videos

    The SQL Express team has been working hard to increase the offerings the help you learn and use SQL Express. Be sure to check out these new offerings. Mike SQL Server Express Registration Benefits Update We recently update the 'Welcome' e-mail sent to SQL Server Express registered users to include...
  • Blog Post: Inaccuracies in recent CNNMoney.com article about SQL Express and Windows Vista

    Owen Thomas wrote an article for the Business 2.0 secton of CNNMoney.com on December 15,2006 that made some inaccurate claims about SQL Express compatibility with the upcomming Windows Vista operating system. Mr. Thomas wrote that you "can't run the current version of SQL Server" on Windows Vista. This...
  • Blog Post: SQL Express SP2 and Windows Vista UAC

    Now that SQL Server 2005 SP2 has been released I thought I should make good on my promise to explain more about how we handle Windows Vista User Access Control in SQL Express SP2. I explained earlier that UAC works by removing the administrator ACEs from your User Token when you are a member of the Builtin...
  • Blog Post: Yes it's true: MSDE will not be supported on Windows Vista

    There have been a few blog postings (most notably Eric Nelson's post on July 12) about the fact that MSDE 1.0 and 2000 will not be supported on Windows Vista and Longhorn. It's high time I made it official: MSDE 1.0 and 2000 will not be supported on Windows Vista If Windows Vista compatibility...
  • Blog Post: Keeping Express up to Date

    Two of the tenets that were important to us as we designed SQL Server 2005 were called "Secure by Default" and "Secure by Design." These tenets are manifest in a number of ways throughout the product. Examples in SQL Express include the fact that we install the minimum components required to get a functioning...
  • Blog Post: Exciting New Features in SQL Server Express with Advanced Services

    As a part of the release of SQL Server 2005 Service Pack 1 , we’re happy to announce the availability of a new package of SQL Server Express called Advanced Services. Advanced Services includes SQL Server Reporting Services and Full Text Search, along with SQL Server Management Studio Express and SQL...
  • Blog Post: Report Packs and SQL Server Express

    The SQL Server team recently released eight new SQL Server 2005 Report Packs for download . Use the Report Packs as way to get up and running on Reporting Services in SQL Server 2005 Express. The Report Packs include sample reports and databases for views into commonly used application data such as IIS...
  • Blog Post: Management Studio Express white paper

    We've just released a new white paper that discribes Management Studio Express and gives some of the basics of database administration. You can download the paper from http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/MgSQLExpwSSMSE.doc . This paper will be available on...
  • Blog Post: SQL Express Family CTP now available

    I’m happy to announce the release to public CTP of the following SQL Express Family products: SQL Server 2005 Express Editions SP1 SQL Server 2005 Express Edition with Advanced Services SQL Server 2005 Express Edition Toolkit SQL Server 2005 Management Studio Express (included as part of Express Advanced...
  • Blog Post: Announcing: SQL Express with Advanced Services Beta

    Are you using SQL Server 2005 Express Edition and want to contribute to helping us continue to improve it? Now is your chance. We are about to start a beta program for the next update to SQL Express and are looking for beta testers who have experience working with MSDE or SQL Express and who are...
  • Blog Post: Using SMO with SQL Express

    SMO is the new management model for SQL Server 2005, its included for use with SQL Express. Because SMO is put into the GAC adding a reference to it requires some extra work. As with all of the new Managed APIs provided for use with SQL Server 2005 that are GAC'd, we also put a copy of the assemblies...
  • Blog Post: Licensing and Pricing for SQL Server Express

    We just received a great question requesting information on the pricing and licensing for SQL Server Express when it RTMs. SQL Server Express will be free to use and redistribute. The only requirement that we have is that you register to redistribute the product. The reason we require registration...
  • Blog Post: Difference between SQL Server Express and MSDE

    Hi, I'm attending Teched Europe where we announced the Express Products earlier this week. Several people here have asked me the difference between MSDE and SQL Server Express. I thought that that I'd include a quick high level summary here: SQL Server Express 2005 MSDE...
Page 1 of 1 (24 items)