Wishing all my blog readers a Happy and successful new year 2009. There are exciting times ahead and loads to blog … Keep reading, keep commenting and have fun.
Archive for December, 2008
I/O impact and Fragmentation – SAN and DAS December 29th, 2008
Vinod Kumar
Saw this 4 part series from Linchi Shea (MVP – SQL Server) up on their blogs. Some raw statitistics to backup some of the theories are very refreshing. Check the posts – Part 1, Part 2, Part 3 and Part 4.
Features Comparison between SQL 2005 and SQL 2008 December 26th, 2008
Vinod Kumar
Just thought to outline few of the features that we introduced with SQL Server 2005 and SQL 2008 side-by-side for your reference. Please do send us your comments.
Innovation Days – Query Tuning Nov’08 December 25th, 2008
Vinod Kumar
After the recently concluded Innovation Days Roadshow a lot of them have pinged me asking me of the presentation etc. For the folks who attended and want to grab what I presented can pick it up from here.
Updated: On popular demand I am attaching the demo script that I used during the presentation.
Transfer Schema’s and removing them December 18th, 2008
Vinod Kumar
This post from Kyle is simple to understand from schema usage and how one can remove, use and transfer objects between schema’s. It is crip and to the point. Read the same here.
Incomplete Scenarios: They don’t know everything that’s up with number sorting December 17th, 2008
Vinod Kumar
The crisis around sorting and how Kaplan describes is always interesting. Read this post where he makes some interesting observations.
SSRS – Scalability Links December 16th, 2008
Vinod Kumar
At the recently concluded GISV Days in Pune one of the gentleman had asked questions around how to scale SSRS and I had promised to drop the set of links here over my blog. So here are those links.
Reporting Services Scale-Out Deployment Best Practices
Reporting Services Scale-Out Architecture
Scaling Up Reporting Services 2008 vs. Reporting Services 2005: Lessons Learned
BOL: Monitoring Report Execution Performance with Execution Logs
BOL: Reporting Services Programming
Report Design: Best Practices and Guidelines
Planning for Scalability and Performance with Reporting Services
Hope you find these links useful.
WSRP Toolkit for SharePoint December 15th, 2008
Vinod Kumar
Microsoft is announcing the Web Services for Remote Portlets (WSRP) Toolkit for Microsoft Office SharePoint Server 2007. The Toolkit provides customizable source code to help customers build ways to reuse content that resides on other portals. More about this at the Sharepoint Team’s Blogs.
SQL Server 2008 Upgrade Technical Reference Guide December 12th, 2008
Vinod Kumar
I think I missed writing about this, my friend and cose buddy Arvind was involved in this and he had passed me the link. Today I just took a tour of the same and was amazed by the detailing this close to 500 pg document outlines from Relational to AS to IS to RS and a whole bunch of checklists to use. This is like a bible guide I would want to recommend to everyone involved in migrating from SQL Server 200/2005 to SQL Server 2008.
SQL Server 2008 White Paper: Analysis Services Performance Guide December 8th, 2008
Vinod Kumar
Here is a cool witepaper for OLAP users from a query performance, processing performance tuning and general OLAP Server tuning perspective. Bookmark and if possible read the same when time permits, really worth.
