December 2008 - Posts

Happy New Year 2009

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.

Posted 12-31-2008 by vinodkumar | 1 comment(s)
Filed under: ,
I/O impact and Fragmentation - SAN and DAS

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

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.

Posted 12-26-2008 by vinodkumar | 1 comment(s)
Filed under: , ,
Innovation Days - Query Tuning Nov'08

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

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

The crisis around sorting and how Kaplan describes is always interesting. Read this post where he makes some interesting observations.

Posted 12-17-2008 by vinodkumar | 1 comment(s)
Filed under: ,
SSRS - Scalability Links

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

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

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

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.

Want a Tip a day from TechNet?

Yes, you heard it right - A tip a day on technology and one theme every month. This is really cool from the technet magazine. Check more about this news here on their blog.

ITPro Momentum Contest

 

Contest Goodies :) ...Have you worked on any technology integration involving Windows Server 2008, SQL Server 2008 or Microsoft’s Unified Communication Solutions? If so, submit a short video or a document showcasing your experience of working on Microsoft Technologies, and you could be among the lucky winners of a cool Windows Mobile Phone.

Read more about the contest and register here.

Search

Go

This Blog

Tags

Community

Archives

My Web Site

External Sites

Other Misc Blog Links

Newsletter

Syndication

News


  • Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

    Follow me on Twitter: vinodk_sql

    Site Counter: Free Hit Counter