TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Internet Explorer
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Lync
See all products »
Resources
Curah! curation service
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Microsoft Update
Trials
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Related Sites
Microsoft Download Center
TechNet Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certifications
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Other resources
TechNet Events
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support options
For small and midsize businesses
For enterprises
For developers
For IT professionals
From partners
For technical support
Support offerings
For home users
More support
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
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
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search Blogs
Tags
Azure
BI
Big Data
Business Intelligence
Cloud
Denali
eBook
Hadoop
In-Memory
Master Data Services
PowerPivot
Reporting Services
SharePoint 2010
SQL Azure
SQL Server
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Sydney
Training
virtualisation
Whitepaper
Whitepapers
Windows Azure
Archive
Archives
January 2015
(2)
December 2014
(3)
November 2014
(3)
October 2014
(3)
June 2014
(1)
May 2014
(1)
April 2014
(3)
March 2014
(3)
February 2014
(2)
December 2013
(3)
November 2013
(1)
October 2013
(2)
September 2013
(3)
August 2013
(1)
July 2013
(2)
June 2013
(2)
May 2013
(3)
April 2013
(2)
March 2013
(3)
February 2013
(1)
December 2012
(1)
November 2012
(3)
October 2012
(2)
September 2012
(3)
August 2012
(5)
July 2012
(1)
June 2012
(1)
May 2012
(3)
April 2012
(2)
March 2012
(2)
February 2012
(2)
January 2012
(3)
December 2011
(4)
November 2011
(2)
October 2011
(3)
September 2011
(1)
August 2011
(4)
July 2011
(4)
June 2011
(5)
May 2011
(5)
April 2011
(2)
March 2011
(2)
February 2011
(2)
January 2011
(4)
December 2010
(2)
November 2010
(6)
October 2010
(5)
September 2010
(5)
August 2010
(4)
July 2010
(1)
June 2010
(10)
May 2010
(1)
April 2010
(6)
March 2010
(7)
February 2010
(3)
January 2010
(6)
December 2009
(4)
November 2009
(4)
October 2009
(5)
September 2009
(5)
August 2009
(5)
July 2009
(2)
June 2009
(4)
May 2009
(4)
April 2009
(6)
March 2009
(3)
February 2009
(1)
January 2009
(8)
December 2008
(6)
November 2008
(4)
October 2008
(3)
September 2008
(2)
August 2008
(1)
July 2008
(3)
June 2008
(3)
April 2008
(4)
March 2008
(5)
February 2008
(1)
January 2008
(1)
December 2007
(1)
November 2007
(3)
October 2007
(4)
September 2007
(5)
All things Data Related....
TechNet Blogs
»
All things Data Related....
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Big Picture Review & some common questions about SQL Server 2012 Power View answered
Posted
over 3 years ago
by
Shashank Pawar
1
Comment
It has been a while since I have blogged and this has been due to my recent involvement with the Big Picture event that took place in Melbourne and Sydney. I was busy with the technical setup and developing a demo scenario for the Insights 24/7...
SQL Server 2012 RC0 Available Now
Posted
over 3 years ago
by
Shashank Pawar
1
Comment
The SQL Server 2012 Release Candidate (RC) is available now. It is the first release which is feature complete. The SQL Server 2012 Release Candidate delivers additional enhancements and capabilities built on the already robust CTP3: · Greater availability...
Have you registered for the Big Picture Event?
Posted
over 3 years ago
by
Shashank Pawar
Experience the future. NOW. Driven by the thought “Don’t tell me, SHOW ME!”, Microsoft brings you a complimentary annual event that allows you to explore first-hand cutting-edge and amazing Microsoft technology in action. Discover a theme park...
Want to know more of our cool SQL Appliances??
Posted
over 3 years ago
by
Shashank Pawar
The product team has just put together the following Linked In discussion groups, so be sure to join them to keep updated on Microsoft SQL Server appliances, and allows you to network with your peers about these appliances. Get your questions answered...
SQL PASS
Posted
over 3 years ago
by
Shashank Pawar
Heading over to the US for the largest SQL Server conference in the world!!! – the SQL PASS Summit - http://www.sqlpass.org/summit/2011/ . I will keep you updated about the announcements made at the event - there are some great ones so stay tuned. Hope...
BI: Excel Services Data Refresh Flowchart
Posted
over 3 years ago
by
Shashank Pawar
Use this flowchart to better understand how Excel Services in Microsoft SharePoint Server 2010 refreshes data or to troubleshoot data connection errors from Excel Services. The Excel Services Data Refresh Flowchart shows the sequence of actions performed...
Did someone say Pizza, Beer & some Denali Demos!!!
Posted
over 3 years ago
by
Shashank Pawar
2
Comments
I should have added one more thing and its FREE . If this is music to your ears then lock down the Tuesday, 27th September 2011 evening (5:30pm – 7:30pm) to come out to the recently re-furbished Microsoft Sydney offices – 1 Epping Rd, North Ryde. Details...
See you at Teched Australia 2011
Posted
over 3 years ago
by
Shashank Pawar
1
Comment
;
Tips & Tricks: SharePoint 2010 Performance Point Services–Reporting Services report settings
Posted
over 3 years ago
by
Shashank Pawar
3
Comments
I see this occur quite often and even I keep on repeating this mistake – when it comes to setting up the Report Server URL and Report URL properties for a Reporting Services based report (in SharePoint integrated mode) in Performance Point Services Dashboard...
SQL Server Denali AlwaysOn–Q&A
Posted
over 3 years ago
by
Shashank Pawar
3
Comments
Since the release of SQL Server Denali CTP3 I have been talking more and more to customers and partners about this release and one of its great new capability called AlwaysOn. The AlwaysOn feature basically provides an easy way for DBAs to enable High...
SQL Server “Denali” CTP3 Product Guide
Posted
over 3 years ago
by
Shashank Pawar
1
Comment
So you have downloaded Denali CTP3 from - https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/ and now want to know what are the new bits in it. To help answer this question we have released a product guide to help you through this process. This...
Book: MS SQL Server 2008 R2 Master Data Services
Posted
over 3 years ago
by
Shashank Pawar
The Master Data Services book I was technically reviewing has finally been published and is available for purchase, congratulations to the authors and publishers. Sample Chapter 1) Where to buy this book You can buy Microsoft...
SQL Server Code Name “Denali” CTP3 available
Posted
over 3 years ago
by
Shashank Pawar
1
Comment
Link for downloading CTP 3 of Denali: http://www.microsoft.com/denali The long awaited wait for CTP3 is over. You can now get access to the upcoming release of SQL Server code named Denali. CTP3 highlights: This preview is packed with additional functionality...
Whitepaper: Implementing SQL Server Parallel Data Warehouse using Kimball Approach
Posted
over 3 years ago
by
Shashank Pawar
Summary: This white paper explores how the Kimball approach to architecting and building a data warehouse/business intelligence (DW/BI) system works with Microsoft’s Parallel Data Warehouse, and how you would incorporate this new product as the cornerstone...
SharePoint 2010 Service Pack 1 Now Available
Posted
over 3 years ago
by
Shashank Pawar
You are reading right, sqlman is talking about SharePoint . The reason for this is that by applying SP1 to your SharePoint 2010 environment, you can improve the performance of PowerPivot based and Excel Services based BI solutions. You can download SharePoint...
Analysis Services Report actions and SharePoint Integrated Mode Reports
Posted
over 3 years ago
by
Shashank Pawar
2
Comments
This is one of those things that you can easily get wrong from time to time, (I have ), so thought I would share it on my blog and hopefully it will save some of you from facing the same issue. When you have Reporting Services running in SharePoint integrated...
Tips & Tricks: YOU HAVE LOST ACCESS TO SQL SERVER. NOW WHAT?
Posted
over 3 years ago
by
Shashank Pawar
12
Comments
A Principal Data Engineer at Microsoft (Saleem Hakani) had authored the below SQL Server Tips & Trick and I thought it would be one that would be found handy by many. Keep this one handy you never know when you may need it (Hopefully not too many...
Whitepaper: SQL Server 2008 R2 Analysis Services Operations Guide
Posted
over 3 years ago
by
Shashank Pawar
1
Comment
A comprehensive (108 pages) whitepaper has recently been released that describes describes how operations engineers can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, SQL Server...
PowerPivot in Action
Posted
over 3 years ago
by
Shashank Pawar
Microsoft partners Extended Results have done it again. They have released another great PowerPivot based Analytics tool – this time for analysing Twitter feeds. The first was a calendar based analytics tools which allowed you to analyse how you and/or...
DW infrastructure made easier
Posted
over 3 years ago
by
Shashank Pawar
Earlier this week we announced the availability of another DW appliance from HP called the HP Business Data Warehouse (BDW). Its the 3rd appliance we are making available from HP ( HP Enterprise Data Warehouse and the HP Business Decision Appliance )...
HPs Business Decision Appliance–Special Pricing for Australia
Posted
over 3 years ago
by
Shashank Pawar
5
Comments
HP Business Decision Appliance Quick Start Offer - Make better, faster, more relevant business decisions with the HP Business Decision Appliance The HP Business Decision Appliance, optimized for SQL Server 2008 R2 and SharePoint Server 2010, has...
Improve ETL performance in SSIS by introducing parallelism in the data flow of an SSIS package.
Posted
over 3 years ago
by
Shashank Pawar
2
Comments
There is a new transform component available for SQL Server Integration Services. It’s called the Balanced Data Distributor (BDD) and the download is available here . Note Downloading the BDD transform can be a bit tricky as when you go to the above site...
Trip down Memory Lane
Posted
over 3 years ago
by
Shashank Pawar
I had to share these photos, in my recent trip to customers in Brisbane, Australia, I saw the media for some old versions of SQL Server – 4.2 and 6.5. The only I was glad of was that none of these customers were actually running these versions...
SQL Server Private Cloud Simplified
Posted
over 3 years ago
by
Shashank Pawar
At Teched North America we just announced our official SQL Server Private Cloud story, and I really like how this encapsulated in the below poster (which by the way can be downloaded from the site). The SQL Server Private Cloud story is about consolidating...
SQL Server Migration Assistant (SSMA) v5.0 released!
Posted
over 3 years ago
by
Shashank Pawar
2
Comments
To even make it easier to migrate your databases from Oracle, Sybase, MySQL, Access to SQL Server or SQL Azure, we have released SSMA v5.0. In this release, SSMA family of products has been improved to further to reduce the cost and the risk of migration...
<
>