How to shrink an Excel when connecting to a DB

Tuesday, November 12, 2013

A colleague in the IT department wanted to send his clients a report in Excel which was actually a pivot table on data from their DWH. He created the file easily enough. He defined on the Data tab in Excel a connection from SQL Server. He chose to connect to a specific table in the relevant DB. He could then edit the connection he created through the Data tab > connections > choosing the relevant connection and then properties and then edit the query on the Definition tab, through the Command Text box.   ...
no comments

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...

Creating a Report Model based on an Analysis Cube – Pros and Cons

Thursday, May 15, 2008

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...

Discovering your MetaData

Saturday, December 29, 2007

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 what was problematic in my cube. Basically,...

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...