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
consolidation
Cumulative Updates
data warehousing
denali
hadoop
high availability
Master Data Services
pdw
PowerPivot
Reporting Services
sharepoint 2010
SQL Azure
SQL Server
SQL Server 2008
sql Server 2008 R2
sql server 2012
Sydney
Training
whitepaper
whitepapers
Archive
Archives
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)
TechNet Blogs
>
All things Data Related....
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
All things Data Related....
Microsoft BI Video
Posted
over 3 years ago
by
Shashank Pawar
0
Comments
As part of the BIEB series, a short video of mine explaining Microsoft's BI capability has been published on The Australian newspaper website. Hope you find it informative and quickly summarises the concept of PowerPivot coming out shortly in SQL Server...
All things Data Related....
SQL Server Service Pack Roadmap
Posted
over 3 years ago
by
Shashank Pawar
0
Comments
SQL Server 2008 SP2 is scheduled for release in Q3/CY2010. SQL Server 2005 SP4. Yes there is going to be one. Expected release data is in Q4/CY2010. Based on current support volume as well as the fact that SQL Server 2005 will enter into extended support...
All things Data Related....
Think you are a Excel Guru? Why don’t you check for yourself
Posted
over 3 years ago
by
Shashank Pawar
0
Comments
We launched the Excelerators Quiz and the Alpha Geek Challenge. Go now to the sites below and take the quiz to see if you’re anywhere near as good as Donald Farmer! Remember to post your results on Facebook and Twitter or even challenge a friend...
All things Data Related....
Time really flies when you have fun
Posted
over 3 years ago
by
Shashank Pawar
0
Comments
Well with a great product release like SQL Server 2008 and many many features like Geospatial support, data visualisation with reporting services, DW optimisations and many other bells and whistles; one can be kept busy for a long long time. And it only...
All things Data Related....
SQL Server Fast Track DW Seminar by HP
Posted
over 3 years ago
by
Shashank Pawar
1
Comments
.. 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...
All things Data Related....
TSQL Tips – Modifying text in rows
Posted
over 3 years ago
by
Shashank Pawar
1
Comments
I have been doing some loading of random text in tables, but wanted to make changes to some of the text in rows, instead of running a full update operation, I discovered that you can also use TSQL functions REPLACE or STUFF to change text. Below are examples...
All things Data Related....
Off Topic – but useful none the less – Win 7 Trick
Posted
over 3 years ago
by
Shashank Pawar
0
Comments
Even though this is not related to SQL Server, I thought I would share it, as we know SQL Server runs on top of a OS – and it is always handy to know how we can configure the OS. PRODUCTIVITY TIP Do you spend precious time trying to find the right place...
All things Data Related....
SQL Server Integration Services (SSIS) Best Practices
Posted
over 3 years ago
by
Shashank Pawar
0
Comments
I was recently just asked for some best practices on SSIS, and put together a collection of the below whitepapers/articles that discuss good practices for SSIS package design/development. · Top 10 SQL Server Integration Services Best Practices - http...
All things Data Related....
SQL Server 2008 Enterprise and DW Optimisations
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
One of the key areas for the SQL Server 2008 release is to be a scalable Data Warehousing platform. Many organisations have deployed it – with DW ranging from 1TB well into the 60-80TB. So what makes SQL Server 2008 Enterprise a better choice than SQL...
All things Data Related....
Really Scale with SQL Server 2008 R2
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
You have no doubt heard that with SQL Server 2008 R2 and Windows Server 2008 R2 we can now address 256 processors. This is all good in theory – now see a video showing off some of the latest hardware from Unisys running pre-release versions of SQL Server...
All things Data Related....
SQL Server 2005 Users
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
SQL Server 2005 SP2 support will be retired on the 12th January 2010. Now is a good time to start planning upgrades of applications to SQL Server 2005 SP3 or SQL Server 2008 (were possible). Link: http://support.microsoft.com/lifecycle/search/default...
All things Data Related....
Want to try PowerPivot for Excel 2010, but don’t have access to Excel 2010
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
Well then follow the below link and you can launch an virtual lab that takes you through the PowerPivot add-in. The only thing you need to install is an ActiveX control to let you access the virtual lab environment. https://cmg.vlabcenter.com/default...
All things Data Related....
PowerPivot (NOV CTP) for Excel 2010 (Beta) Now Available
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
SQL Server PowerPivot is an innovative data analysis technology that redefines how organizations apply and succeed with BI. IT managers can deliver corporate BI solutions and also establish a managed BI collaboration environment that gives business users...
All things Data Related....
SQL Server 2008 R2 – November CTP now Available
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
The November CTP download is available for MSDN and TechNet subscribers. The public download is available here . The Data Platform Insider blog provides an overview of what's new in CTP release for SQL Server 2008 R2.
All things Data Related....
Top Tips for Effective Database Maintenance
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
Many of you new SQL Server DBAs may be wondering what are the things to lookout for to effectively maintain a production SQL Server database. Paul Randal has written an excellent article on this very topic, and it covers the following points: Managing...
All things Data Related....
SQL Pass Announcements - New SQL Server 2008 R2 Editions
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
Two new premium editions in SQL Server 2008 R2 SQL Server 2008 R2 Datacenter Built on SQL Server 2008 R2 Enterprise, SQL Server 2008 R2 Datacenter delivers a high-performing data platform that provides the highest levels of scalability for large application...
All things Data Related....
Whitepaper: High Availability with SQL Server 2008
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
This white paper describes the technologies available in SQL Server 2008 that can be used as part of a high-availability strategy to protect critical data. As well as describing the technologies in detail, the white paper also discusses the various causes...
All things Data Related....
Whitepaper: Consolidation Using SQL Server 2008
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
Many companies are considering or have already implemented consolidation of computing resources, including Microsoft SQL Server instances and databases, in their organization. A consolidation effort is a complex task that requires information, a detailed...
All things Data Related....
Project Gemini has got an official name – PowerPivot for Excel 2010
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. Leveraging familiar Excel features, users can transform enormous quantities of data from...
All things Data Related....
Want to take control of your SQL Server Environment?
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
Come and join me for a lunchtime session at tomorrows SQL Server user group meeting. Following are the details: Date: 7th October 2009 Time: 12:00pm Location: Westpac, 275 Kent St, Sydney NSW 2000 Session Details Learn how to leverage Policy Based...
All things Data Related....
Application and Multi-Server Management features in SQL Server 2008 R2
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and productivity. Investments in application and multi-server management will help organizations proactively manage database environments efficiently at scale through centralized...
All things Data Related....
Achieving High Availability with SQL Server 2008
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
I highly recommend that you read the following whitepaper on achieving high availability with SQL Server 2008 if you are planning or currently designing a high availability solution for your SQL Server environment. This whitepaper goes through the architecture...
All things Data Related....
Cumulative Update #7 for SQL Server 2008 RTM
Posted
over 4 years ago
by
TechNet Archive
0
Comments
Keep your system up to date with the most recent cumulative update package for SQL Server 2008 RTM. This package contains all of the SQL Server 2008 hotfixes that have been released since the initial release of SQL Server 2008 RTM. o Understanding...
All things Data Related....
Looking to save money $$$ Want to Consolidate your SQL Server environment?
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
If the answer to those questions is YES!! Then you don’t want to miss my talk about SQL Server consolidation/virtualisation. And the best part is you don’t even have to leave the comfort of your office. This is a virtual conference that can be accessed...
All things Data Related....
Teched Australia 2009
Posted
over 4 years ago
by
Shashank Pawar
0
Comments
Just got back from sunny Gold Coast, with what I can say was a very successful Teched, at least from my perspective and the many attendees I talked to. I think the biggest thing this year at Teched were the HP mini Netbooks. They were widely used by...
Page 6 of 10 (230 items)
«
4
5
6
7
8
»