Free Datasets, Data Warehouse and OLAP Databases for your use

Wednesday, February 10, 2010

Whether you're doing demos, trying different aspects of applications or just looking for something new, you may want to have a broad and free selection of data to choose from. This post is here to help you out on that.I've collected a number of free data source for you to use: From the PowerPivot blog:Data on the District of Columbia http://ogdisdk.cloudapp.net/DataCatalog.aspx From Andrew Fryer's blog:Data from the UK Government: http://data.gov.uk/data/ Datasets for neighborhoods in the UK (with Geospatial data) http://www.data4nr.net/resources/all/ From Chris Webb's blog:The Guardian Data StoreData from the Greater London Authority http://data.london.gov.uk/ Also, following a post from Mr. Webb...

Adventure Works Samples

Monday, November 12, 2007

Just in case you were also looking for the SQL Server 2005 Sample Database, then you should know Microsoft has chosen to move it to the CodePlex site. SQL Server 2008 July 2007 CTP Samples are also available on the same site. I recommend downloading the versions which are marked in the end with CI as they enable a Case Insensitive search within them. The LT version is also CI. I really love the way Adventure Works gives you an entire look on the abilities of SQL Server.  

Recreating an Analysis Services Project

Saturday, August 25, 2007

Well, continuing our story about strange things that can happen, I thought I'd share with you this little tidbit. I was taking over a project from someone who had left the company a while back. In the cube that was on the old server, there was an MDX calculation. Only thing was that calculation was missing from the project on the new server (and I admit I couldn't guess what was behind it). So what can you do when you need something that in a project of an old cube? You import the project back to you! The way to do...

SQL 2008 July CTP!

Thursday, August 2, 2007

SQL 2008 July CTP is out! I started to get suspicious when my brother ( adlai ) called me and asked me "did you downloaded the SQL2008, because I can't download it now ! the link in MSDN doesn't function".With SQL Server 2008 July CTP release, customers can understand and get hands-on experience with the new capabilities that, with the release of SQL Server 2008, will help them support their mission-critical platform and enable pervasive insight across the enterprise. SQL Server 2008 lays the groundwork for innovative policy-based management that enables administrators to reduce their time spent on maintenance tasks. SQL Server 2008 provides enhancements in the...
no comments

Data Dude Service Release 1

Wednesday, August 1, 2007

I'll start by describing Data Dude (or DB Dude) first to all of us who don't use it, now shall I?   It's a tool for the management of databases, enabling you to keep track of version history of a database with a source control on the scripts that build the database. The tool was first introduced to the very talented DBA in my department – Boris Kogan – by Maor David from SRL. Boris was obviously very pleased to have a bit of work and headache saved with this new tool. Just a week ago, Microsoft released the SR1...