Browse by Tags
All Tags »
DB (
RSS)
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...
Creating a Report Model based on an Analysis Cube – Pros and Cons If you follow my blog, you probably know by now that I developed a report model based on the Analysis Services cube I already had. I even got around to updating the report model . And then, my users started using it. And you know, whatever we do just seems so wonderful to us, until our users find all sorts of flaws with what we did… so yes, my users did open my eyes to quite a few problems that may occur when you build...
I have recently discovered a brand tool to help me better understand my work. It's a free tool from the Microsoft SDK . Specifically, I'm talking about the Rowset Viewer . The Rowset Viewer was intended for you to "view and manipulate OLE DB rowsets, with the added ability to call and manipulate other OLE DB methods from the data source, session, command, rowset, transaction, and notification objects supported by any OLE DB provider." I found myself using the tool so as to understand...
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...
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...