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: BIDS or Bust: Writing reports in SQL Express 2008

    I asked for your oppinions about a new Report Designer in one of my earlier posts in this blog. I wanted to thank everyone for taking the time to offer feedback and for those of you who even filed a bug or two. As you've probably already guessed from the title, our ultimate decision was to stick with...
  • 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: 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: Best Practice Analyzer for ASP.NET

    Joe Morel, from the Developer Solutions team just blogged about the Alpha release of the ASP.NET BPA , a tool that will help users properly configure their ASP.NET sites. Those of you that build data bound ASP.NET sites know that configuring the site for data access can be particularly challenging...
  • Blog Post: Answers to Embedded Database webcast

    Asked: Can you, i.e. is it legal, to sell a product that includes the free SQL Express dB??? Answered: Absolutely, SQL Express is free to download, free to use and free to deploy, you can even sell your application that includes SQL Express. We do ask that you register for redistribution at...
  • Blog Post: Questions from the Access to SQL Server migration webcast

    Asked: One of the most difficult tasks of the migrating process was the query upgratings. Most of them had to be all rewrited. PLease coment about queries and the sql of Access and sql of SQLServer. Answered: Access and SQL Server use different SQL dialects. When using the SQL Upsizing Wizard in Access...
  • Blog Post: Webcast on deploying embedded databases

    Update : Q & A from the webcast is available here . I'm still working on getting the source code posted. If you missed this webcast, you can view it on demand from this page . --------------------------------------------- I'll be giving a webcast that describes how to deploy an embedded database...
  • Blog Post: Demystifying the MSDE Workload Governor

    If you don't frequent Euan Garden's BLOG and you're interested in a history lesson on the Workload Governor in MSDE (and the fact that it doesn't existin in SQL Express), you should check out his recent post on the subject. http://blogs.msdn.com/euanga/archive/2006/03/09/545576.aspx Mike Wachal...
  • Blog Post: Various Downloads of Samples and Documentation for SQL Express

    MSDN has a downloads page specific to express: http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&displaylang=en -Euan Garden Product Unit Manager SQL Server Tools
  • Blog Post: SQL Express Beta 2 coming soon

    The full Beta 2 version of SQL Express is coming soon. While the Beta 2 release will not add any new features, it does contain many bug fixes that were not in the Tech Preview. We recommend upgrading to Beta 2 as soon as it is available. Unfortunately, the Beta 2 build requires a later build of the...
  • Blog Post: Networking is disabled by default

    After seeing a number of issues about this, I realized that we needed to comment on this. For SQL Express, all networking protocols except shared memory are disabled by default. There is a command line setup switch called DISABLENETWORKPROTOCOLS which is always set to 1 in SQL Express installations...
  • Blog Post: Welcome to the SQL Server Express Blog

    Welcome to our team blog for SQL Server Express. In this blog we post answers, to frequently asked questions from our newsgroup (see below) and try to address any general questions or issues from the community. Newsgroup: http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid...
Page 1 of 1 (15 items)