Opinion Poll: Creating Reports in SQL Express 2008

The Reporting Services team is developing a new report designer tool that we’re considering including in SQL Server Express 2008 with Advanced Services. This new report designer has a different user experience that is more geared toward information workers than developers. You can take a look at a preview of the new designer by downloading…

9

What’s New in SQL Express 2008 November CTP

SQL Server 2008 Express is now available as part of the November CTP – You can download it from the following link: http://www.microsoft.com/downloads/details.aspx?FamilyID=749bd760-f404-4d45-9ac0-d7f1b3ed1053&displaylang=en. There is already a bunch of information out there about the new functionality available in SQL Server 2008, so I won’t spend much time describing the features here. What I will do…

7

DIY SQL Express SP2 Bootstrapper

I’ve waited far too long to communicate this disappointing news to everyone, so here it is… I’m not going to be releasing the SQL Express SP2 Bootstrapper manifests that I had discussed in a long ago blog posting. I’ll spare you the sob story of my efforts to create this; suffice it to say that…

10

SQL Express 2005 SP2 VS Bootstrapper manifest – package.xml

<?xml version=”1.0″ encoding=”utf-8″ ?><Package  xmlns=”http://schemas.microsoft.com/developer/2004/01/bootstrapper“  Name=”DisplayName”  Culture=”Culture”  LicenseAgreement=”license.txt”>     <PackageFiles CopyAllPackageFiles=”false”>        <PackageFile Name=”sqlexpr32.exe” HomeSite=”SqlExprExe” PublicKey=”3082010A0282010100CD819638AE5CA2F2C1DFDED0AB958DD63C9D1F8BC35D862E5DF0B172F5ABAC886AB5DAB1227B0BC8C8A54B915E2213E9F9F5239DB5F46E76AEEFEEA43CC7C4C0595C3FABB3733326A662816179A162F46E8895D06EDDC79FD2A451117661BA708A65A1961689A75D81D04466E5DB569E40CAFCDC76242E443000E5D67D7B9511D5581DA3E84F0BC988DCA2D653996CCA63CA996A9A925E4C4D11E82FD35B5B5E5F52A3732DA5BB84450D8C191576CB08DA9AA67015E84DEC69FD5DB26B8FED295137388BC6464915945098B0F468A4D7DE097167749E778C1D856B97EAE75F45CCE0E6710DD16300937B31988E0BB413BDB3D0EEF1DF21EEA96061EE37433DC30203010001“/>        <PackageFile Name=”license.txt”/>    </PackageFiles>    <Commands Reboot=”Defer”>        <Command PackageFile=”sqlexpr32.exe”                  Arguments=’-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1′                 EstimatedInstalledBytes=”225000000″                  EstimatedTempBytes=”225000000″                 EstimatedInstallSeconds=”420″>            <InstallConditions>                <BypassIf Property=”SQLExpressInstalled” Compare=”ValueEqualTo” Value=”0″/>                <BypassIf Property=”VersionNT” Compare=”VersionGreaterThanOrEqualTo” Value=”5.1″/>                <FailIf Property=”AdminUser” Compare=”ValueEqualTo” Value=”false” String=”AdminRequired”/>                <FailIf Property=”Version9x” Compare=”ValueExists” String=”InvalidPlatform”/>                <FailIf Property=”VersionNT”…

2

SQL Express 2005 SP2 VS Bootstrapper manifest – product.xml

<?xml version=”1.0″ encoding=”utf-8″ ?> <Product xmlns=”http://schemas.microsoft.com/developer/2004/01/bootstrapper” ProductCode=”Microsoft.Sql.Server.Express.9.2″>   <RelatedProducts>      <DependsOnProduct Code=”Microsoft.Net.Framework.2.0″ />       <DependsOnProduct Code=”Microsoft.Windows.Installer.3.1″ />       <IncludesProduct Code=”Microsoft.Sql.Server.Express.1.0″ />    </RelatedProducts>   <PackageFiles>      <PackageFile Name=”SqlExpressChk.exe” />    </PackageFiles>   <InstallChecks>      <ExternalCheck Property=”SQLExpressInstalled” PackageFile=”SqlExpressChk.exe” />    </InstallChecks></Product>

2

Backup and Restore with User Instances

Backup and Restore is an important part of any application, but when you’re writing an application for an end-user, it becomes even more important that you do a good job of handling Backup and Restore in your code since you end-user will likely not know much about being a Database Administrator. Add to that the…

9

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. Notify, Download and Notify or…

3

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…

20

SQL Server 2005 Compact Edition – Final Release available!

If you’ve been reading this blog or the SQL Express Forum you’ve undoubtably seen me write about SQL Server 2005 Compact Edition (SQL CE) as an alternative database for use when writing client applications that require local data storage. SQL CE is the evolution of SQL Mobile, with support added for Windows desktop operating systems. The SQL…

1

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 many helpful new links and…

1