Power Pivot is the new name for Microsoft Gemini, a user-based cube building and data analysis add-in for Excel 2010.
Not to be confused with Pivot Power.
A few years ago, one of my clients determined that they should centralize their real estate and shift around workers to better optimize the facilities. Read – downsizing. I found this out from a student who was working on the project much later. All I knew was as contractors we had to be out of the building, and we might want to bring our computer equipment with us (and chairs, which I found out later).
So our development team was shuffled off from one of the nicest penthouse offices in the city, attached to a huge mall, next to the largest assortment of restaurants in the city, to a 1960s-design nuclear bunker disguised as an office.
We found out quickly that our small team of people had the run of the floor. Every chair was broken, and designed before Herman Miller got out of high school. There was a doomsday clock attached to the ceiling in the centre of the floor. It didn’t work either. The decor was styled with vintage warning signs. “Danger due to acid.” “Diesel generators – do not open this door!”.
It was a great work environment that motivated me to work from home (and other client locations) much more often.
Phil Factor reminded me about this, and has a funny story about how location is sometimes more important than appearance or prestige.
My friend, with some exaggeration, explained that the management had decided that it seemed wrong to give any offices of a major retail bank the appearance of a deserted building, so all contractors were given offices near the windows.
Simple Talk has a great article on the top 10 things you might have issues in dealing with SQL Reporting Services.
SSRS offers a range of different reporting techniques and technologies, to cater for the reporting needs of all levels of users, from the chief executives, to business analysts, to operational staff. Their reporting needs range from simple, tabular ad-hoc reports, to parameterized, linked or snapshot reports, to complex drill-down and drill-through multi-level reports.
Following is the list of some of the challenges I have encountered while developing such reports using Reporting Services 2000/2005. In the sections that follow, I will cover each challenge individually, providing insight into what may cause the difficulty, alongside a possible solution.
- Horizontal Tables: Calendar Reports
- Select "ALL" Query Parameter option
- Multiple Sheets in Excel
- Excel Merged Cell Issues
- Blank Pages
- Vertical Text
- Report Data in Header/Footer
- Are you missing XML/CSV data on your exports?
- Template Reports
- Using the Reporting Services database
A ZIP file containing samples of the reports detailed in this article is available to download, try out and amend to suit your own needs.
Microsoft has released a new version of the IIS Database Manager, providing the ability to manage SQL from a web page.
IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager. IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network. Once connected, IIS Database Manager provides a full array of management options including managing tables, views, stored procedures and data, as well as running ad hoc queries.
IIS Database Manager provides native support for SQL Server and is also fully extensible for developers to add support for other database systems. In addition, because IIS Database Manager is an extension of IIS Manager, administrators can securely delegate the management of databases to authorized local or remote users, without having to open additional management ports on the server.
Here are a few articles to get you started on using the IIS Database Manager:
Mar 18, 2009
Microsoft SQL Server is a very popular and widely deployed general purpose database server supported on Windows Sever operating systems. As customers embrace a “virtualize first” policy for all applications within their enterprises, they often need guidelines for deploying SQL Server in VMware Infrastructure. This paper should help you understand how to characterize your SQL Server databases for virtualization and the best practices for designing VMware Infrastructure to support SQL Server.
Sometimes when generating reports or text for web pages or form letters, it becomes handy to concatenate multiple column values from rows of data into a single value entirely within T-SQL. For reference, a problem I encountered recently involved selecting one or more department names and converting them to a comma-separated list to appear in a drop-down list.
The SQL language itself doesn't easily facilitate this but there are ways around this. Below I outline two alternate queries using SQL Server.
Open DBDiff for SQL Server 2008By Muthusamy Anantha Kumar aka The MAK
Open DBDiff 1.0 is the utility provided by Microsoft via CodePlex. You may have used the Open DBDiff utility for SQL Server 2005 before. DBDiff utility compares two databases and generates a script that could be used to synchronize two databases. The Open DBDiff utility is in beta version 8. This article is going to illustrate the various use of the Open Diff utility.
Features Supported by the Editions of SQL Server 2008
Use the following tables to determine which features are supported by the different editions of SQL Server 2008.
Winding down availability for add-ins in earlier versions brings this add-in’s lifespan to a close. It sounds like customers were using this instead of upgrading to Excel 2007… which is still missing some of the features of the add-in.
”The Excel Add-in for SQL Server Analysis Services has been removed to avoid customer confusion about support for this component. As noted in the details that accompanied the release of this product, Microsoft does not provide any support for this add-in and has no plans to release future versions. Newer versions of Excel include most of the functionality that is provided by this add-in; these newer versions are supported according to the Microsoft Product Lifecycle.”
What is the go-to path for Excel 2003 customers? Upgrade. It is unfortunate that they removed access to this tool rather than “open-sourcing” it or sending it off into MS Research land.
How about removal from MS downloads and addition into CodePlex?
Same goes for tools like Proclarity. Leaving customers in the dark is not necessarily the correct approach.
Excel 2003 has ended mainstream support as of April 14, 2009.
Extended support ends January 14, 2014.