See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Application Lifecycle Management
Azure Machine Learning
Data Protection Manager
Essential Business Server
Full Text Search
Microsoft Security Essentials
Performance Point Server
Read Only Domain Controller
Remote Desktop Services
Slowly Changing Dimensions
Software + Services
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL Server Express
TechNet Road Show
Windows Phone 7
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012R2
Browse by Tags
Insufficient data from Andrew Fryer
sql server express
Contain your Enthusiasm
You may be aware that I am still keen on SQL Server and despite the changing nature of my role at Microsoft I still try and keep my hand in with the latest version. One thing I overlooked until I did SQL Relay was contained database security which is easy to use and can make your life a lot easier...
29 May 2012
SQL Server 2008 RC0 Express on Vista
I wanted to get Express installed on my machine and so I downloaded the RC0 (of Express with Advanced Services) and ran it. BTW there is is this Akamai download manager behind all of the RC0 downloads which you have to allow to run to get the download to start. If all is well you should have this...
17 Jul 2008
Web Development & SQL Server Express part 3 - Development
In part 3 of my odyssey into the world of express development I’m ready to actually start development. I have a virtual machine (vm) with Microsoft’s free web development kit installed which comprises Visual Studio 2008 express for development and SQL Server 2008 express for my data repository...
19 Jun 2009
SQL Server Advent Calendar 22 – Spatial Data
Day 22 of my virtual advent calendar, about stuff I like in SQL Server 2008.. SQL Server 2008 now has data types to store points lines and polygons in 2 spatial data type, Geometry and Geography. I have already posted quite extensively on spatial data, but it is is one of my favourite new things in SQL...
22 Dec 2008
Project Atlanta part 2–Installation
Following on from last post I thought I had better fire up Atlanta to see what it cold find out about my demon environment. I made this screencast as I installed and configured it .. It only took a few minutes to get to the stage where I had two servers, one (Oxford-DC, a server with no SQL Server on...
19 Jan 2011
Install SQL Server 2008 Advanced Services
Having got past the pre-installation issues in my last post I am now ready to install SQL Server 2008 Express with Advanced Services.. I ran the System Configuration Checker and got a set of green lights, except for PowerShell... and the install won’t get past that so I am going to have to find that...
21 Jul 2008
Microsoft Free Software – a personal top ten
You might think this will would make for a really short article post but actually there’s a huge amount of free tools and resource out there and I have had to restrict myself to a top ten across the server and client, based on what Simon and I have used. So please feel free to...
22 May 2013
Web Development & SQL Server Express part 2 Install
My development skills are so old that the term 4GL and client server were the buzzwords of the day back then, so I thought it was about time I had look at what’s out there now. A quick search on Microsoft web development on Bing got me to the Microsoft Web Platform Installer site… This...
16 Jun 2009
Putting SQL Server on the MAP
Usually when I mention SQL Server and map in the same blog it’s a post on geospatial data but not today; today I want to talk about assessment and planning your SQL Server infrastructure. I know of several DBA’s who don’t know how many SQL Servers they have much less what stare they are in i.e...
5 Jun 2009
SQL Server Editions
I recently got a comment on my blog complaining about all of the editions of SQL Server, so why don’t Microsoft just stick to one? SQL Server gets everywhere, from a smart phone to a data centre and now the cloud (with SQL Sever data services). If you are using media player the metadata is in SQL Server...
12 Jan 2009
Beyond relational data in SQL Server 2008 Express
I was in a customer meeting today with David Portas of Conchango who is hard at work doing battle with the new FileStream data type in SQL Server 2008. He is developing a solution where large filestream objects are being pushed around a site from central servers to roving laptops. Curiously...
3 Jul 2008
Getting Started with SQL Server 2008 R2 Express
One of the criticism of SQL Server I hear on occasion is that it’s too big and therefore takes too to long to download and install. This is partly due to the inclusion of the client tools and other add-ons that are included, for example the BI development studio and SQL Server Management Studio...
26 May 2010
Web Development & SQL Server Express part 1 Virtual Machine
I see a lot of tweets, and questions on forums about SQL Server Express from developers, particularly around installing it on client versions of windows, so I though I’ll give it a go and see if there is nay truth to the rumours. Rather than try it on my physical desktop I decided to use a clean...
15 Jun 2009
© 2014 Microsoft Corporation.
Privacy & Cookies