All things Data Related....
On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data
HPs Business Decision Appliance–Special Pricing for Australia
HP Business Decision Appliance Quick Start Offer - Make better, faster, more relevant...
Author: Shashank Pawar Date: 05/27/2011
Improve ETL performance in SSIS by introducing parallelism in the data flow of an SSIS package.
There is a new transform component available for SQL Server Integration Services. It’s called the...
Author: Shashank Pawar Date: 05/27/2011
Trip down Memory Lane
I had to share these photos, in my recent trip to customers in Brisbane, Australia, I saw the...
Author: Shashank Pawar Date: 05/27/2011
SQL Server Private Cloud Simplified
At Teched North America we just announced our official SQL Server Private Cloud story, and I really...
Author: Shashank Pawar Date: 05/18/2011
SQL Server Migration Assistant (SSMA) v5.0 released!
To even make it easier to migrate your databases from Oracle, Sybase, MySQL, Access to SQL Server or...
Author: Shashank Pawar Date: 05/05/2011
New on Technet - BI Scenarios site
The Microsoft BI team have put together a great site on Technet, that has end-to-end guidance on how...
Author: Shashank Pawar Date: 04/13/2011
SQL Server as a Service/ SQL Server Private Cloud Offering
Recently I have been presenting around Australia about implementing SQL Server as a Service,...
Author: Shashank Pawar Date: 04/11/2011
SQL Server Standard vs. Enterprise Edition
A question I often get asked by customers is which edition of SQL Server do I use? I then based on...
Author: Shashank Pawar Date: 03/25/2011
Platform Power Briefings
Come and hear about the Microsoft Application platform at the upcoming briefing seminars in a city...
Author: Shashank Pawar Date: 03/17/2011
Kimball University Training in Sydney: Microsoft Data Warehouse in Depth
Anyone wanting to skill up in Microsoft Data Warehousing implementation methodology, then...
Author: Shashank Pawar Date: 02/22/2011
FREE Webinar: Master Data Services
As a leading authority on Master Data Management and the Australian distributor of Profisee's...
Author: Shashank Pawar Date: 02/05/2011
SQL Server 2008 R2 Update for Developers Training Kit–Jan 2011
The January 2011 update includes lots of great new content and several usability improvements. Below...
Author: Shashank Pawar Date: 01/29/2011
Microsoft was ranked as a Leader in the 2011 BI Platforms Magic Quadrant
Microsoft has move to no. 1 on Ability to Execute which is heavily influenced by customer...
Author: Shashank Pawar Date: 01/28/2011
Update: New SQL Server 2008 R2 Upgrade reference manual available
The almost 500 page Upgrade Technical Reference guide for SQL Server 2008 R2 is available at...
Author: Shashank Pawar Date: 01/22/2011
Fill out Cloud BI Survey and win XBOX 360 with Kinect
Here is your opportunity to help shape the future of Microsoft future of Cloud BI offering....
Author: Shashank Pawar Date: 01/04/2011
Ebook: Common SQL Server Myths by Paul Randal
I wanted to share an awesome SQL Ebook with everyone in the community. You can get it from...
Author: Shashank Pawar Date: 12/30/2010
Merry Christmas and Happy New Year Reporting Services Style :)
This year I thought I would do something different, since I had some time on my hand (rare) . I...
Author: Shashank Pawar Date: 12/23/2010
Database Development Guidance Paper published by the Application Lifecycle Management Rangers
Recently, on codeplex the Application Lifecycle Management Rangers from Microsoft have made...
Author: Shashank Pawar Date: 11/22/2010
Learn how Microsoft deployed SQL Server 2008 R2 Parallel Data Warehouse (PDW)
Microsoft IT Showcase is pleased to announce the publication of Deploying SQL Server 2008 R2...
Author: Shashank Pawar Date: 11/12/2010
Whitepaper: SQL Server High Availability Whitepaper by SQL CAT Team - Failure Is Not an Option: Zero Data Loss and High Availability
When it comes to financial transactions of customers and their money, it is absolutely...
Author: Shashank Pawar Date: 11/12/2010
Microsoft® SQL Server® code-named 'Denali' - Community Technology Preview 1 (CTP1)
The CTP 1 for SQL Server Denali is now available to download at the below link: Link to Download:...
Author: Shashank Pawar Date: 11/09/2010
Getting Trained by the Father of Data Warehouse–Mr Bill Inmon
The last two weeks have been absolutely great, working on Data Warehousing (DW) offerings based on...
Author: Shashank Pawar Date: 11/04/2010
Presenting at Sydney SQL Server User Group: Data Warehousing Trends, Microsoft's Data Warehouse Vision & New Solution Offerings
I am presenting on Microsoft’s SQL Server Data Warehousing offerings at the Sydney SQL Server...
Author: Shashank Pawar Date: 11/02/2010
When it rain it pours…well that saying definitely applies to the Windows/SQL Azure Cloud
As you no doubt are aware the Developer conference PDC is taking at Microsoft HQ Redmond Campus....
Author: Shashank Pawar Date: 10/28/2010
Busy with Data Warehousing
It has been a while since I updated my blog and this has been as a result of being busy with...
Author: Shashank Pawar Date: 10/23/2010
Non SQL Related Blog: Configuring a Hyper-V VHD to be a boot option on notebook with Windows 7
I have recently been asked by both my colleagues internally at MS and by customers and...
Author: Shashank Pawar Date: 10/15/2010
Whitepaper: SQL Server’s Price/Performance
Following whitepapers have been released/updated and discuss SQL Server’s great low TCO and...
Author: Shashank Pawar Date: 10/12/2010
End User Guidance for MS based BI solutions
As more and more customers implement Performance Point Services based BI solutions using SharePoint...
Author: Shashank Pawar Date: 10/12/2010
SQL Server 2008 SP2 Now Available
Microsoft is pleased to announce the availability of SQL Server 2008 Service Pack 2. Both the...
Author: Shashank Pawar Date: 09/29/2010
SQL Server High Availability: Technical Case Study
The SQL CAT Team have just released another SQL Server High Availability case study. This time it is...
Author: Shashank Pawar Date: 09/26/2010
PowerPivot SharePoint Integration Install Bug
I have recently been doing a lot of work with PowerPivot, and installing it at customers site. I...
Author: Shashank Pawar Date: 09/26/2010
SQL Server Most Secure Database
Let me say that again just in case you missed it, SQL Server is the most secure RDBMS. This is just...
Author: Shashank Pawar Date: 09/21/2010
Learning and getting trained to be a SQL Server DBA
Time to time I get questions asked about training and learning more about SQL Server management,...
Author: Shashank Pawar Date: 09/21/2010
Master Data Services Portal on MSDN
Master Data Services portal page is now live on MSDN! This portal presents information about...
Author: Shashank Pawar Date: 08/29/2010
SQL Azure Service Update 4
Service Update 4 is now live with database copy, improved help system, and deployment of Microsoft...
Author: Shashank Pawar Date: 08/28/2010
Making developer edition of SQL Server act/look like Standard Edition
Recently I assisted my colleague answer the question of making SQL Server Developer edition act/look...
Author: Shashank Pawar Date: 08/21/2010
Migrate from MySQL/Access to SQL Azure or SQL Server with ease!
Microsoft announced today the release of the first version of SQL Server Migration Assistant (SSMA)...
Author: Shashank Pawar Date: 08/16/2010
Administering the Cloud database using your browser–Silverlight style :)
The SQL Azure Labs site recently made available CTP1 of Project Houston. Through this Silverlight...
Author: Shashank Pawar Date: 07/24/2010
Master Data Services first cumulative update is now available!
A cumulative update for Master Data Services has been released. It addresses a number (30+) of...
Author: Shashank Pawar Date: 06/29/2010
Master Data Services–Business Rule Activation error and its fix
While preparing for a demonstration of SQL Server 2008 R2 Master Data Services – vanilla build – my...
Author: Shashank Pawar Date: 06/19/2010
SQL Server 2008 R2 Best Practices Analyser
Yes the SQL Server best practices analyser is back and it can be used to analyse your SQL Server...
Author: Shashank Pawar Date: 06/19/2010
SQL Server virtualisation improvements with SLAT in Intel and AMD
Recently I had query around documentation that discusses the benefits of running SQL Server in a...
Author: Shashank Pawar Date: 06/15/2010
Incorporating Reporting Services Reports in Word and PowerPoint
My colleague Alan Eldridge, BI Technology Specialist at Microsoft, put together a great post on...
Author: Shashank Pawar Date: 06/14/2010
Just like the fine Sydney weather today, some great announcements about our SQL Azure Cloud offering
SQL Azure Extends to 50 GB SQL Azure database is now extending from 10GB to 50GB size of database...
Author: Shashank Pawar Date: 06/07/2010
June 2010 Sydney SQL Server User Group: Come see my session on Master Data Services, details below
This month we have two sessions: Master you data with Master Data Services (Shashank Pawar) Why use...
Author: Shashank Pawar Date: 06/06/2010
Free Virtual - SQL Server 2008 Training for Oracle DBAs
Are you a Oracle DBA that has responsibility for SQL Server’s within your organisation, or even...
Author: Shashank Pawar Date: 06/05/2010
Its nearly that time of the year again–TECHED TECHED TECHED!!!
Be early to register for Teched this year as you all remember last year was a sell out. This year is...
Author: Shashank Pawar Date: 06/03/2010
SQL Server 2008 R2 and SQL Azure Whitepapers
Kerberos/Double hop with SSRS From a infrastructure implementation of Microsoft BI solutions, one of...
Author: Shashank Pawar Date: 06/01/2010
Video: What is Microsoft Business Intelligence?
See a video I did for the local news paper websites (SMH, Australian IT) explains how business...
Author: Shashank Pawar Date: 05/27/2010
SQL Server 2008 R2 has RTMed
We are very excited to share that today, Microsoft released SQL Server 2008 R2 to manufacturing!...
Author: Shashank Pawar Date: 04/22/2010