Archive for the ‘SQL Server’ Category

Excel at 25 – What Are Your 25 Favourite Features? – BizIntelligence.TV – Site Home – MSDN Blogs

What Are Your 25 Favourite Features?

April 30, 2011 · Rahul Desai · No Comments
Tags: , , , , ,  Â· Posted in: General, SQL Server

PowerPivot

PowerPivot gives users the power to create compelling self-service BI solutions, facilitates sharing and collaboration on user-generated BI solutions in a Microsoft SharePoint Server 2010 environment, and enables IT organizations to increase operational efficiencies through Microsoft SQL Server 2008 R2-based management tools. More information at the following link: PowerPivot Technorati Tags: PowerPivot,Business Intelligence,Excel 2010,Microsoft,Rahul Desai

July 21, 2010 · Rahul Desai · No Comments
Posted in: SharePoint, SQL Server, Tools, Tips & Utilities

Download details: Microsoft SQL Server 2008 R2 Report Builder 3.0

Just for the information… Download details: Microsoft SQL Server 2008 R2 Report Builder 3.0 Technorati Tags: SQL Server,Report Builder,Rahul Desai

July 21, 2010 · Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities

Editorial: The SSRS 2008 Minefield

Editorial extract from the Simple-Talk Newsletter:   Editorial: The SSRS 2008 Minefield One of the big advances in Microsoft’s "2008 platform", with regard to Reporting Services, was that there would be a single, consistent Report Definition Language (RDL) across all the products. This means that reports developed in Report Builder can be shared with reports […]

October 20, 2009 · Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, Visual Studio

SQL Server 2008: Performance Data Collector

Brad McGehee mentioned the SQL Server 2008 – Performance Data Collector at the SQL Down Under Code Camp 2009 @ Wagga Wagga. Below is the link to one of his more detailed article. SQL Server 2008: Performance Data Collector Thanks Brad. Technorati Tags: SQL Down Under Code Camp,Brad McGehee,SQL Server 2008,Performance Data Collector,Wagga Wagga,Rahul Desai

October 11, 2009 · Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences

Reboot required check SQL Server 2008 and SP1 – "Restart Computer" – Failed

Technorati Tags: SQL Server 2008,Installation,Rahul Desai When installing SQL Server 2008 one can run into “‘Reboot required check’ failed” situation. After seeing it few times already, I think a solution is worth keeping in records. When you view the detailed report, it says: “Why don’t you just reboot?”, you say… Well, most likely it would […]

May 5, 2009 · Rahul Desai · No Comments
Posted in: Blogroll, Personal, SQL Server, Tools, Tips & Utilities

SQL DownUnder CodeCamp 2007 – Top ten DBA mistakes (18)

Session-18 Topic: Top ten DBA mistakes Kelvin Kline – SQL Server MVP Mentioned about the free seminar hosted by Quest software on SQL server in Melbourne on 16th October 2007: http://www.quest.com/events/listdetails.aspx?ContentID=6220&site=&prod=&technology=&prodfamily=&loc=   Some common mistakes: Unverified Backups, Insufficient error notification, Ignorance of internals, Unknown scalability requirements, No baselines or benchmarks, Query tuning ignorance.   Top 10 […]

October 16, 2007 · Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences

SQL DownUnder CodeCamp 2007 -Using SSCE from SQL management Studio (16)

Session-16 Topic: Using SSCE from SQL management Studio Marc Ridey – Consultant – Readify A quick session on installing and using SQL server compact edition from SQL server management studio. Blog: http://blog.mridey.com  Technorati Tags: Marc Ridey, Readify, SQL DownUnder, SQL Server, Code Camp, Rahul Desai

October 16, 2007 · Rahul Desai · No Comments
Posted in: SQL Server, UserGroups and conferences

SQL DownUnder CodeCamp 2007 – SSIS Best practices (15)

Session-15 Topic: SSIS: Best Practices – Patterns and Anti-Patterns Darren Gosbell – Senior consultant – James & Monroe – SQL server MVP 19% of Posts in MSDN SQL server forums are related to Integration services (as of 1st September 2007). Demonstrated the concept of FETCH  : Flexible, Efficient, Transient, Composable and Honest. (Detailed information available on […]

October 15, 2007 · Rahul Desai · 2 Comments
Posted in: SQL Server, UserGroups and conferences

SQL DownUnder CodeCamp 2007 – Analysis services

Session-13 Topic: Analysis Services Best Practices – Design, Storage, Queries and Calculations Grant Paisley – SQL MVP – Angry Koala Based on session DAT305 at TechEd 2007 (sessions by T K Anand and Christian Petculescu – Microsoft Corporation). Talked about Muvee and Armadillo Run…great tools. Started with importance of PERFORMANCE, how to get it: Focus on Cube […]

October 15, 2007 · Rahul Desai · No Comments
Posted in: SQL Server, Tools, Tips & Utilities, UserGroups and conferences