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
SQL Server 2008 Security Related Whitepapers
I was just conducting research for improvements in security in SQL Server 2008 and came across the...
Author: Shashank Pawar Date: 05/23/2009
Guest Failover Clustering now supported for virtualised SQL Server
Just in case you missed it!!! Microsoft Support announced an update to the SQL Server virtualisation...
Author: Shashank Pawar Date: 05/19/2009
Converting Existing table from BLOB to Filestream
- Create FILESTREAM filegroup. 2. Add FILESTREAM column to table 3. Choose one of: a....
Author: Shashank Pawar Date: 05/17/2009
Lots of SQL Server related announcements at Teched 2009 (USA)
Summary of the SQL Server Announcements: Official name for the next release of SQL Server: SQL...
Author: Shashank Pawar Date: 05/13/2009
Little Off Topic - Augmented Reality & SQL Server
Finally I found a cool demo of Augmented Reality that is near and dear to me – as it promotes...
Author: Shashank Pawar Date: 04/29/2009
Say good bye to performance issues in SQL Server 2008 with the aid of this whitepaper…
A new white paper on SQL Server 2008 performance troubleshooting is now available and linked from...
Author: Shashank Pawar Date: 04/20/2009
SQL Server I/O for Thought
Following are the links specifically relating to best practices for setting up disk I/O for SQL...
Author: Shashank Pawar Date: 04/14/2009
SQL Server 2008 SP1 Released
Service Pack 1 for SQL Server 2008 will be available today for customers. The Service pack is...
Author: Shashank Pawar Date: 04/08/2009
SQL Server Consolidation Resources
In the current economic climate, it is important for IT to be agile and respond to business needs of...
Author: Shashank Pawar Date: 04/05/2009
Get Ready for Teched 2009
Pre-registrations for Teched 2009 have begun, so don’t miss out – go to:...
Author: Shashank Pawar Date: 04/03/2009
Cumulative Update #4 for SQL Server 2008 RTM
Keep your system up to date with the most recent cumulative update package for SQL Server 2008 RTM....
Author: Shashank Pawar Date: 03/17/2009
SQL Server 2008: Filestream Data & Delete Statement
When using Filestream data in SQL Server 2008, you may come across what seems like strange...
Author: Shashank Pawar Date: 03/11/2009
Reporting Services – Combining different datasets to be displayed in a single table in SSRS
Regardless of version of SSRS (2005 or 2008), it is not possible to combine different datasets e.g....
Author: Shashank Pawar Date: 02/28/2009
SQL Server 2005 Cumulative updates
Cumulative Update #2 for SQL Server 2005 Service Pack 3 Keep your system up to date with the most...
Author: Shashank Pawar Date: 02/17/2009
Download - SQL Server 2008 System View Poster!!!
SQL Server 2008 System Views - Map just went live and is available for download at...
Author: Shashank Pawar Date: 01/29/2009
NEW!!! Sydney SQL Server User Group !!!
My mate, Victor Isakov (MCT, MCITP, MCM, SQL Ranger) is starting a new SQL Server User Group Meeting...
Author: Shashank Pawar Date: 01/27/2009
Verifying if a connection to SQL Server is Encrypted
If you do not have a network parser such as netmon and want to verify if the connection from the...
Author: Shashank Pawar Date: 01/26/2009
How to measure SSIS component/transformation performance
To assist in improving performance of your SSIS packages, you are essentially looking at performing...
Author: Shashank Pawar Date: 01/09/2009
SQL Server CACHING & Performance Testing
As you know SQL Server uses caches to speed up access to data and also query plans. There are...
Author: Shashank Pawar Date: 01/09/2009
Microsoft is Positioned in the Leaders Quadrant by Leading Independent Research Firm
In keeping you informed of third-party evaluations of our products and technologies, I wanted to...
Author: Shashank Pawar Date: 01/07/2009
Reporting Services Tip – Automating the creation of multiple charts
I had a question regarding automating the creation of multiple charts from one dataset, instead of...
Author: Shashank Pawar Date: 01/07/2009
Merry Christmas and a Happy New Year
Thank you for making SQL Server a success in 2008. I look forward to sharing many more SQL Server...
Author: Shashank Pawar Date: 12/23/2008
SQL Server 2005 SP3 has been Released
Microsoft SQL Server 2005 Service Pack 3 (SP3) contains hotfixes that were included in cumulative...
Author: Shashank Pawar Date: 12/17/2008
Upgrading to SQL Server 2008 – Technical Reference Guide
Technorati Tags: SQL Server 2008,Upgrade,Technical Reference Guide A common request from customers...
Author: Shashank Pawar Date: 12/16/2008
SQL Server 2005 Performance Troubleshooting Resources
Following are links to whitepapers on SQL Server 2005 Best Practices and performance troubleshooting...
Author: Shashank Pawar Date: 12/12/2008
SQL Server Application and Multi-server Private CTP - Registration
As part of SQL Server “Kilimanjaro”, we have announced baseline investments for application and...
Author: Shashank Pawar Date: 12/09/2008
Driving Insight into your data stored on Oracle
Oh no...did I just say the O word, oh well I have to live in real world and accept that there are...
Author: Shashank Pawar Date: 12/01/2008
Scale Up Up and Away :)
Just in case you have not heard the great news about SQL Server's scale up capability that was...
Author: Shashank Pawar Date: 11/20/2008
FREE: SQL Server 2008 Consolidation Seminar in Sydney and Brisbane next week
Following are details for a free SQL Server 2008 Consolidation Seminar Microsoft and Dimension Data...
Author: Shashank Pawar Date: 11/20/2008
SQL Server 2008 Video
Author: Shashank Pawar Date: 11/17/2008
Microsoft SQL Server Virtualisation Support Policy Updated
Microsoft provides technical support for SQL Server 2005 and for SQL Server 2008 that are running in...
Author: Shashank Pawar Date: 10/28/2008
Report Builder 2.0 for Reporting Services 2008 has released
Microsoft SQL Server 2008 Report Builder 2.0 RTM (build 10.00.1600.60) on Microsoft Report Builder...
Author: Shashank Pawar Date: 10/20/2008
Whitepaper: Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations - Released
Finally a whitepaper released regarding virtualising SQL Server. This white paper describes a series...
Author: Shashank Pawar Date: 10/05/2008
SQL Server 2008 Cumulative Update 1 is release
Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed...
Author: Shashank Pawar Date: 09/23/2008
I will be Presenting at Teched 2008 - Sydney, Australia
Please do come by and say HI!! I will be presenting a session on PowerShell integration with SQL...
Author: Shashank Pawar Date: 09/04/2008
Cumulative update package 9 for SQL Server 2005 Service Pack 2 Released
The ninth Cumulative Update for SQL Server 2005 SP2 is available and it contains 40 fixes. For...
Author: Shashank Pawar Date: 08/20/2008
SQL Server 2008 Transparent Database Encryption (TDE) Tip
After enabling TDE take a backup of the transaction log, as the current transactions in the...
Author: Shashank Pawar Date: 07/26/2008
Version 4 of SQL Server Migration Assistant Tools have been released
If you are looking at conducting a migration to SQL Server from some other platforms (as you should...
Author: Shashank Pawar Date: 07/25/2008
SQL Server 2008 Desktop Background and Screen Saver
Download the attached "SQL Server 2008 ScreenSaver Setup.zip", it is highly recommended for all SQL...
Author: Shashank Pawar Date: 07/25/2008
Tools to help write best practice code to protect against SQL Injection attack
The three tools that can help to detect and minimise the threat from SQL Injection attacks are: HP...
Author: Shashank Pawar Date: 06/26/2008
SQL Server 2008 Release Candidate 0 Releases on June 10
SQL Server 2008 Release Candidate 0 becomes available for customers starting June 10th. Although no...
Author: Shashank Pawar Date: 06/10/2008
SQL Server 2008 and Hyper-V Support
As much as possible, I do not recommend virtualisation of SQL Server or any other RDBMS system, due...
Author: Shashank Pawar Date: 06/03/2008
In case you were wondering.....SQL Server 2008 Change Data Capture
Today I just had a question from someone with regards to SQL Server Change Data Capture and database...
Author: Shashank Pawar Date: 04/23/2008
Remix 08
REMIX08 registrations are now open for Sydney, 20 May and Melbourne, 22 May. REMIX08 will be packed...
Author: Shashank Pawar Date: 04/22/2008
SQL Server 2008 Compression feature and INSERTS
If you a heap (table without indexes) configured for page-level compression, pages receive...
Author: Shashank Pawar Date: 04/02/2008
SQL Server 2008 Replication & Filestream
Ever wondered whether filestream will be supported with replication? Well before I give the answer...
Author: Shashank Pawar Date: 04/02/2008
New Releases by the SQL Server CAT Team
The SQL Server Customer Advisory Team, Best Practices group just released four projects to CodePlex...
Author: Shashank Pawar Date: 03/25/2008
How to find Analysis Services Server Version
The below was put together by a colleague at Microsoft - Olga Liakhovich, and this information can...
Author: Shashank Pawar Date: 03/25/2008