SQL Server Analysis Services (SSAS) is becoming increasingly popular as an OLAP platform for business analysts. There are many tools available for enhancing the analysts’ ability to process data and get meaningful insights. These vary from direct queries in Excel to custom applications. For example, using PowerPivot to extend Microsoft Analysis Services directly into an Excel Workbook, you can then use Excel to build and explore an OLAP model using pivot tables and other techniques. One thing you can generally be sure of is that this will result in processing very large sets across the network.
Along with freelancing, consulting, I also spend time in replying to my blog comments to learn something new. Few such conversations end up in business deals, few in emails and few in the blog. This blog originates from one of such conversation regarding incorrect syntax.
Question: How to Find Size of All the Indexes on the Database?
There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it.
When I wrote the blog around Understanding Database Scalability – Vertical and Horizontal, I saw few have conversations with me on if it is this or that. And these discussions could take a course all by itself. There is no one size fits all when it comes to scalability. We need to understand the fine prints and details of how the application needs are, what are the restrictions, user requirements and much more.
The cloud phenomenon is no more a dream for many, but a reality for several customers I have been working with. Many of my customers are looking for guidance and from time to time I get an opportunity to have some deep constructive discussions. These discussions can range from should I be going to cloud or not, is this app cloud ready, can we do a lift-shift of this application directly to some cloud player etc. Though each of these discussions lead from one point to another, there is a lot of profiling I do with customers. In this blog, I want to talk about a conversation I had with one of my customers who was evaluating cloud for one of his applications. Let us see a Cloud Consulting Pre-Engagement Questionnaire.