Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

May 2010 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

May 2010 - Posts

SQL Server Setup Portal - a preview and planning of what you are about to setup?

There is a myth (rather a wrong impression) in database world that SQL Server setup is pretty easy, what you do is insert setup-media into drive and click next....next.....next, well it is not!!!  ....read here...


SQL Server 2008 R2 PowerPivot for Excel and SharePoint is here; volume licensing downloads available

 Self-Service Business Intelligence is the new solution from SQL Server 2008 R2 that enables the end users to access, analyze and share data across the ...read_more.... 

The SQL Server 2005 evaluation software is no longer available. Learn more about the enhancements and new features in SQL Server 2008

Well it is a surprise (rather a bad news) for the SQL Server users, especially those who wanted to evaluate the SQL Server 2005 edition.

From SQL Server 2005 downloads resources  ...read more... 


SQL Server 2008 R2 Feature Pack, get yours now

 In continuation to the SQL Server 2008 R2 RTM release here is the another download the Feature Pack which consist the a collection of stand-alone packages which provide additional value to your R2 environment....more here....


SQL Server Certification - a database platform primer for your career path

When you need to upgrade your knowledge then training is required, at the same time certifications will help you to keep up on what you have learned!

There is a big debate on the web about whether certifications are important in your career or not, the bottomline is if you do not know the stuff or unable to answer few basic technical questions, it does'nt matter how many certifications you have then you will not get the job, well I'm not starting the same discussion here.  But in the recent times I was presented with the question about SQL Server certification path, as there has been changes to versions & releases of SQL Server during last 3 to 5 years. 

As the current version of SQL Server is 2008 & R2, it is better to highlight on those aspects, to find 2008 path see this Microsoft SQL Server 2008 Certification Paths document and 

Microsoft Learning: Microsoft SQL Server Certification pages.

For the R2 here is the interesting blog post on  Why the SQL Server 2008 Certifications Don’t Cover R2  is a must read, finally

Certification path for SQL Server 2008, whats your choice? - SQL ...

 for your information.

SQL Server 2008 Best Practices Analyzer - keep an eye for the release

What practice do you classify as a best practice?

The answer is its not a rocket science, you don't need any specific formula to satisfy the need!

Ok what if a tool can follow those common best practices & perform ...read from here.


SQL Server 2008 R2 Express Edition - a treat for small scale businesses

SQL Server Express edition is a light-weight software within SQL Server arena, it is classed as database platform that makes it easy to develop data-driven applications that are rich in capability, offer enhanced storage security, and are fast to deploy.

Also the SQL Server 2008 Express with Advanced Services is an edition of same flock that includes a new graphical management tool, features for reporting, and advanced text-based search capabilities. You can add the GUI capabilities for management tools for your SQL Express edition. As referred this light weight tool can be downloaded freely which can be redistributed subject to agreement. As per the BOL Each edition can function both as the client database and as a basic server database. Any edition of SQL Server Express is an ideal choice for independent software vendors (ISVs), server users, non-professional developers, Web developers, Web site hosts, and hobbyists who are building client applications. If you need more advanced database features, you can upgrade SQL Server Express to more sophisticated versions of SQL Server.

Ok all of this information is known to the world, what's new now in terms of SQL Server 2008 R2 release is the database size limit has been increased  to 10Gb from the previous limit of 4Gb. This is great news for many developers, as the 4Gb limitation was by far the most difficult barrier preventing Express adoption. So this is a real benefit of the small scale organisations that are looking to integrate their Microsoft applications applications with a robust backend technology.

Also it is worth to mention about SQL Server Features Not Supported in SQL Server Express

As per the BOL the following table lists the additional SQL Server database features that are not supported in this version of SQL Server Express. It also lists database features from previous versions of SQL Server that are not supported.

SQL Server features not supported in SQL Server Express SQL Server features from previous versions not supported in SQL Server Express

Database mirroring

SQL Mail

Online restore

Fail-over clustering

Database snapshot

Distributed partitioned views

Parallel index operations

VIA protocol support

Mirrored media sets

Log shipping


Parallel DBCC

Address Windowing Extensions (AWE)

Parallel Create Index

Hot-add memory

Enhanced Read Ahead and Scan

Native HTTP SOAP access

Indexed views (materialized views)

SQL Mail and Database Mail

Partitioned views

Online Index Operations


SQL Server Agent and SQL Server Agent Service


Next time I will go through on how to manage the REPORTING Services platform using SQL Express with Advanced Services edition.

Further resources of Home Page for Microsoft® SQL Server 2008® R2 & Embedding, Upgrading, and Custom Installations are helpful and finally you can download SQL Server 2008 R2 edition for your own testing & joy!


SQL Server 2008 R2 is here now, MSDN and Technet subscribers get ready to download

IN contintuation to SQL Server 2008 R2 announcement here is the good news for MSDN & Technet subscribers, see here_for_more,


R2 Banner


Don't forget to uninstall the previous & current SQL Server 2008 R2 CTP releases (by taking database backups) and install afresh for further testing.

Good luck.... more to come on R2 here!