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
PowerBI - Gain Insights using familarity of Excel and power of the cloud with Office 365
Posted
2 months ago
by
Shashank Pawar
Our session on Power BI from Teched Melbourne & Sydney is now available on Channel 9 - below is the link http://channel9.msdn.com/Events/TechEd/Australia/2014/OSS206 Thank you for those that attended the last session on the Monday evening...
Now that SQL Server 2014 is out - wondering how you can leverage the power of In-Memory OLTP for your applications
Posted
9 months ago
by
Shashank Pawar
Take a look at this great whitepaper recently published that discusses common patterns for implementing and leveraging the new In-memory OLTP capabilities of SQL Server 2014. Download the whitepaper from: http://msdn.microsoft.com/en-us/library/dn673538...
PowerPivot SharePoint Integration Install Bug
Posted
over 4 years ago
by
Shashank Pawar
3
Comments
I have recently been doing a lot of work with PowerPivot, and installing it at customers site. I have on two occasions now come across the below error message: Error: Your SQL Server 2008 R2 installation completed with failures. ...
SQL Server 2014 RTM today - Available 1st April 2014 (USA date)
Posted
10 months ago
by
Shashank Pawar
SQL Server 2014, the foundation of Microsoft’s cloud-first data platform, is released to manufacturing and will be generally available on April 1st 2014 (US date). SQL Server 2014 provides organisations with a data platform: Delivering...
SQL Server 2008: Filestream Data & Delete Statement
Posted
over 5 years ago
by
Shashank Pawar
When using Filestream data in SQL Server 2008, you may come across what seems like strange behaviour. This is when you issue a DELETE statement to delete the filestream data, it doesnt actually disappear from the file system. You may ask…why is this?...
SQL Server Fast Track DW Seminar by HP
Posted
over 5 years ago
by
Shashank Pawar
1
Comment
.. SQL Server Webinar Microsoft SQL Server Fast Track Data Warehouse for Hewlett-Packard: Technical Overview and Reference Architecture This webinar is scheduled for Wednesday, January 13, 2010 11:00 AM Eastern/8:00 AM Pacific and...
Administering the Cloud database using your browser–Silverlight style :)
Posted
over 4 years ago
by
Shashank Pawar
1
Comment
The SQL Azure Labs site recently made available CTP1 of Project Houston. Through this Silverlight enabled site you can manage a SQL Azure database. You can create objects tables, stored procs, write TSQL queries and view results. So if you are looking...
Quickest way to deploy a Microsoft BI environment based on SharePoint - in the Windows Azure cloud
Posted
11 months ago
by
Shashank Pawar
I have recently been talking to a lot of customers and partners about what is the fastest way to deploy a Microsoft BI environment leveraging SharePoint and i usually point them to the following articles on msdn which have Power Shell scripts to deploy...
Whitepaper: SQL Server 2008 Management Data Warehouse
Posted
over 5 years ago
by
Shashank Pawar
A best practices whitepaper was recently released discussing the SQL Server 2008 Management Data Warehouse feature. It can be accessed at: http://msdn.microsoft.com/en-us/library/dd939169.aspx
Azure Machine Learning Overview at Big Data Meetup
Posted
2 months ago
by
Shashank Pawar
z
Master Data Services–Business Rule Activation error and its fix
Posted
over 4 years ago
by
Shashank Pawar
While preparing for a demonstration of SQL Server 2008 R2 Master Data Services – vanilla build – my colleague Lee Theofanis from Decision Resources came across an issue regarding business rule activation. The Issue After creating a business rule through...
Running SQL Server 2008 on Windows 7 and Windows 2008 Server R2
Posted
over 5 years ago
by
Shashank Pawar
The following knowledge base article describes the known issues when you install Microsoft SQL Server on a computer that is running Windows 7 or Windows Server 2008 R2 . List of known issues when you install SQL Server on Windows 7 or on Windows Server...
Partner Event: Dimension Data – See Microsoft Power BI in action
Posted
over 1 year ago
by
Shashank Pawar
30 August, 2013 Friday 8:00 AM - 9:30 AM Presenters Rolf Tesmer SQL Principal Consultant Dimension Data Venue Dimension Data Level 6 121-127 Harrington Street The Rocks, NSW 2000 Agenda 8:00AM Registration/Breakfast 8:30AM Presentation 9:30AM Finish...
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...
TSQL New Features in SQL Server 2008
Posted
over 6 years ago
by
Shashank Pawar
Briefly, here are the new T-SQL programmability enhancements in SQL Server 2008: 1. Data Types a. New Date/time types (date, time, datetime2, datetimeoffset) b. New table types (i.e. CREATE TYPE myT AS table (a int, b varchar(100)) ) 2. SQL...
Learn how Microsoft finance professionals use business intelligence
Posted
over 1 year ago
by
Shashank Pawar
1
Comment
You are invited. As a finance professional you are immersed in data. Odds are you spend a lot of your time using old tools and dreaming of a better way to do things. There is a better way with Microsoft's newly released business intelligence solutions...
SQL Server 2008 Desktop Background and Screen Saver
Posted
over 6 years ago
by
Shashank Pawar
5
Comments
Download the attached "SQL Server 2008 ScreenSaver Setup.zip", it is highly recommended for all SQL DBA's.
Start saving $$$ now, with the SQL Server Backup to Windows Azure Tool
Posted
over 1 year ago
by
Shashank Pawar
Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud. Download from: http://www.microsoft.com/en-us/download/details.aspx?id=40740...
Try out Power View in the comfort of your PC
Posted
over 3 years ago
by
Shashank Pawar
Just in case you missed it over the holiday period, Pej from the SQL Server product team made available Power View over the Internet so you are able to interact and create your very own reports without having to install anything. All you need is a browser...
SQL Server 2005 Performance Troubleshooting Resources
Posted
over 6 years ago
by
Shashank Pawar
1
Comment
Following are links to whitepapers on SQL Server 2005 Best Practices and performance troubleshooting you and your team can utilise to assist you in finding the root cause of the application performance issues. Whitepapers & Links · Troubleshooting...
Start planning your upgrade to SQL Server 2014 - SQL Server 2005 is approaching end of its support...
Posted
15 days ago
by
Shashank Pawar
1
Comment
SQL Server 2005 is approaching the end of its support on April 12, 2016 . With end of support, security updates and hotfixes are no longer available from Microsoft. So there’s never been a better time to upgrade and benefit from the dramatic performance...
Cloud OS…for databases
Posted
over 1 year ago
by
Shashank Pawar
Want to see how your organization can deploy databases, virtual machines with SQL Server instances in the same manner as the Windows Azure management portal. Below is a link to a session me and my colleague James Crawshaw presented at Teched Australia...
Big Data in Cloud with HDInsight Service Preview
Posted
over 1 year ago
by
Shashank Pawar
Preview of the Windows Azure HDInsight Service -- our cloud-based distribution of Hadoop – is broadly available through the Windows Azure Portal. The Windows Azure HDInsight Service is built on the Hortonworks Data Platform to ensure long term compatibility...
Windows Azure Cloud Platform Poster
Posted
over 2 years ago
by
Shashank Pawar
They say pictures tell you a 1000 words and helps you to understand things clearly. Well certainly then you will find this poster very useful in making it clearer and easier to understand what exactly is Windows Azure and all of the services offered....
SQL Server 2008 Compression feature and INSERTS
Posted
over 6 years ago
by
Shashank Pawar
1
Comment
If you a heap (table without indexes) configured for page-level compression, pages receive page-level compression only in the following ways: Data is inserted by using the BULK INSERT syntax Data is inserted using INSERT INTO... WITH (TABLOCK...
<
>