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
Whitepaper: PowerPivot Planning and Deployment
An comprehensive whitepaper regarding the installation and deployment of PowerPivot has been...
Author: Shashank Pawar Date: 04/19/2010
Master Data Services Training Videos
SQL Server 2008 R2 Master Data Services Training videos are available at -...
Author: Shashank Pawar Date: 04/18/2010
FREE Online SQL Server 2008 R2 Training
Three of the six RTM SQL Server 2008 R2 e-clinics are ready; the final three will arrive in...
Author: Shashank Pawar Date: 04/07/2010
Database Mirroring large number of databases
Just in case you have missed it. The SQL CAT team have written up a great article that answers the...
Author: Shashank Pawar Date: 04/06/2010
To BI or not to BI?
My blog post on the Australian IT news site has gone live, and can be found at -...
Author: Shashank Pawar Date: 04/06/2010
Update for SQL Server 2008 Developer Training Kit – Now includes SQL Server 2008 R2 material
Download it from -...
Author: Shashank Pawar Date: 03/29/2010
SQL Server 2008 R2 Tour Downunder
The official launch of SQL Server 2008 R2 is set for the 12th May, 2010. To celebrate the launch, we...
Author: Shashank Pawar Date: 03/29/2010
5W1H of Master Data Services
On the 26th of March 2010 evening I presented an overview of the Master Data Services at the...
Author: Shashank Pawar Date: 03/25/2010
SQL Server 2008 R2: Multi Server Management Feature Survey
As we are nearing to the release of SQL Server 2008 R2, I have been presenting about its new...
Author: Shashank Pawar Date: 03/16/2010
SQL Server 2008: Upgrading to Standard/Enterprise Edition from Evaluation Edition
I often get asked about upgrading SQL Server 2008 Evaluation Edition to a retail edition such as...
Author: Shashank Pawar Date: 03/15/2010
The premier BI event you can't miss.
We are excited to be hosting this year’s Microsoft Business Intelligence Conference 2010 in New...
Author: Shashank Pawar Date: 03/09/2010
Resource: Book on SAP integration with SQL Server
Do you run SAP as your ERP systems? Do you also have SQL Server or SharePoint in your environment?...
Author: Shashank Pawar Date: 03/07/2010
Looking for a new way to browse the Web instead of just links
…and if you love Pivot tables in Excel, then you are going to like this tool. Its called GetPivot,...
Author: Shashank Pawar Date: 02/21/2010
Microsoft BI Video
As part of the BIEB series, a short video of mine explaining Microsoft's BI capability has been...
Author: Shashank Pawar Date: 02/20/2010
SQL Server Service Pack Roadmap
SQL Server 2008 SP2 is scheduled for release in Q3/CY2010. SQL Server 2005 SP4. Yes there is going...
Author: Shashank Pawar Date: 02/17/2010
Think you are a Excel Guru? Why don’t you check for yourself
We launched the Excelerators Quiz and the Alpha Geek Challenge. Go now to the sites below and take...
Author: Shashank Pawar Date: 01/23/2010
Time really flies when you have fun
Well with a great product release like SQL Server 2008 and many many features like Geospatial...
Author: Shashank Pawar Date: 01/13/2010
SQL Server Fast Track DW Seminar by HP
..SQL Server Webinar Microsoft SQL Server Fast Track Data Warehouse for...
Author: Shashank Pawar Date: 01/10/2010
TSQL Tips – Modifying text in rows
I have been doing some loading of random text in tables, but wanted to make changes to some of the...
Author: Shashank Pawar Date: 01/05/2010
Off Topic – but useful none the less – Win 7 Trick
Even though this is not related to SQL Server, I thought I would share it, as we know SQL Server...
Author: Shashank Pawar Date: 01/04/2010
SQL Server Integration Services (SSIS) Best Practices
I was recently just asked for some best practices on SSIS, and put together a collection of the...
Author: Shashank Pawar Date: 01/01/2010
SQL Server 2008 Enterprise and DW Optimisations
One of the key areas for the SQL Server 2008 release is to be a scalable Data Warehousing platform....
Author: Shashank Pawar Date: 12/22/2009
Really Scale with SQL Server 2008 R2
You have no doubt heard that with SQL Server 2008 R2 and Windows Server 2008 R2 we can now address...
Author: Shashank Pawar Date: 12/22/2009
SQL Server 2005 Users
SQL Server 2005 SP2 support will be retired on the 12th January 2010. Now is a good time to start...
Author: Shashank Pawar Date: 12/15/2009
Want to try PowerPivot for Excel 2010, but don’t have access to Excel 2010
Well then follow the below link and you can launch an virtual lab that takes you through the...
Author: Shashank Pawar Date: 12/07/2009
PowerPivot (NOV CTP) for Excel 2010 (Beta) Now Available
SQL Server PowerPivot is an innovative data analysis technology that redefines how organizations...
Author: Shashank Pawar Date: 11/22/2009
SQL Server 2008 R2 – November CTP now Available
The November CTP download is available for MSDN and TechNet subscribers. The public download is...
Author: Shashank Pawar Date: 11/12/2009
Top Tips for Effective Database Maintenance
Many of you new SQL Server DBAs may be wondering what are the things to lookout for to effectively...
Author: Shashank Pawar Date: 11/07/2009
SQL Pass Announcements - New SQL Server 2008 R2 Editions
Two new premium editions in SQL Server 2008 R2 SQL Server 2008 R2 Datacenter Built on SQL Server...
Author: Shashank Pawar Date: 11/04/2009
Whitepaper: High Availability with SQL Server 2008
This white paper describes the technologies available in SQL Server 2008 that can be used as part of...
Author: Shashank Pawar Date: 10/28/2009
Whitepaper: Consolidation Using SQL Server 2008
Many companies are considering or have already implemented consolidation of computing resources,...
Author: Shashank Pawar Date: 10/28/2009
Project Gemini has got an official name – PowerPivot for Excel 2010
PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly...
Author: Shashank Pawar Date: 10/20/2009
Want to take control of your SQL Server Environment?
Come and join me for a lunchtime session at tomorrows SQL Server user group meeting. Following are...
Author: Shashank Pawar Date: 10/05/2009
Application and Multi-Server Management features in SQL Server 2008 R2
SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and productivity....
Author: Shashank Pawar Date: 10/05/2009
Achieving High Availability with SQL Server 2008
I highly recommend that you read the following whitepaper on achieving high availability with SQL...
Author: Shashank Pawar Date: 09/23/2009
Cumulative Update #7 for SQL Server 2008 RTM
Keep your system up to date with the most recent cumulative update package for SQL Server 2008 RTM....
Author: TechNet Archive Date: 09/21/2009
Looking to save money $$$ Want to Consolidate your SQL Server environment?
If the answer to those questions is YES!! Then you don’t want to miss my talk about SQL Server...
Author: Shashank Pawar Date: 09/15/2009
Teched Australia 2009
Just got back from sunny Gold Coast, with what I can say was a very successful Teched, at least from...
Author: Shashank Pawar Date: 09/12/2009
From the Ground to the Sky – SQL Azure Migration Wizard
Many of you maybe playing around with your CTP invitations for SQL Azure and wondering how to get...
Author: Shashank Pawar Date: 09/10/2009
Running SQL Server 2008 on Windows 7 and Windows 2008 Server R2
The following knowledge base article describes the known issues when you install Microsoft SQL...
Author: Shashank Pawar Date: 08/17/2009
Teched Australia 2009 – Less than a month away
Wow can’t believe it, Teched Australia 2009 is SOLD OUT!!! It must have something to do with those...
Author: Shashank Pawar Date: 08/09/2009
SQL Server 2008 Clustering White Paper
This white paper complements the existing documentation on planning, implementation, and...
Author: Shashank Pawar Date: 08/06/2009
SQL Server 2008 Developer Training Kit
Want some FREE training on the new developer features of SQL Server 2008? Download this developer...
Author: Shashank Pawar Date: 08/06/2009
Whitepaper: SQL Server 2008 Management Data Warehouse
A best practices whitepaper was recently released discussing the SQL Server 2008 Management Data...
Author: Shashank Pawar Date: 07/21/2009
TSQL Script – Determining Default Database File & Log Path
Below are two methods that can be used to determine the default location of data and transaction log...
Author: Shashank Pawar Date: 07/19/2009
SQL Server consolidation / virtualization Presentation
I am going to be presenting a session on SQL Server consolidation at the SQL Server User group on...
Author: Shashank Pawar Date: 06/30/2009
Happy EOFYS!!! Get Office 2007 for a Bargain Price!!!
I know!!! I know!!! What you might be thinking, what has office got to do with SQL Server. Well it...
Author: Shashank Pawar Date: 06/11/2009
Are you thinking of implementing Oracle RAC? You might want to think again….
Prior to making this decision I would strongly recommend that you read the following whitepaper -...
Author: Shashank Pawar Date: 06/01/2009
Lower Your Database Costs with SQL Server Database Consolidation
Discover how your organisation can do more with less at Dimension Data's SQL Server 2008...
Author: Shashank Pawar Date: 06/01/2009