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)

August 2009 - Posts - SQL Server Knowledge Sharing Network (@sqlmaster)

August 2009 - Posts

SQL Server 2008 -Discover how to securely manage your data in a scalable and high performance environment!

Do you have any data management strategies within your environment?

Would like to be part of a conference that can help build upon the knowledge you already have, as well as demonstrating how to get the best from Microsoft SQL Server for data management and business intelligence?

Listen to the Microsoft experts, MPVs and UK SQL Server experts at one place to accomplish the big task  on how effective information management can be delivered across an organisation.


Microsoft SQL Server Data Management Conference | Microsoft SQL Server 2008
Tuesday 29 September 2009, at Inmarsat, London
Discover how to securely manage your data in a scalable and high performance environment.
Learn from the experts, hear about future developments and network with peers.
Register now
As the amount of data created increases every year, a re-think about how it's stored and managed within an organisation is clearly needed.

That's why we're excited to invite you to the first Microsoft SQL Server Data Management Conference on 29 September 2009, at Inmarsat, London. You'll see first-hand how Microsoft SQL Server can help to increase business value and reduce costs through the delivery of more effective and efficient data management. Learn how to tackle the key data management challenges that face organisations like yours, including scalability, performance 'to the limits', data warehousing, virtualisation and business intelligence.

Whether you're a SQL Server, or alternative database platform specialist, we are confident that the conference will be an informative experience that will build upon the knowledge you already have, as well as demonstrating how to get the best from Microsoft SQL Server for data management and business intelligence.

The conference also gives you an opportunity to:

Meet Microsoft corporate and UK SQL Server experts and other SQL Server users to discuss how Microsoft SQL Server 2008 can offer you a solution for enterprise data management
Discover the latest developments in SQL Server 2008 performance, as well as scalability and high availability for data management and business intelligence
Obtain a strategic perspective on how effective information management can be delivered across an organisation
Experience a practical exploration of a wide range of SQL Server 2008 capabilities for data management, integration and business intelligence
The conference combines strategic perspectives on data management and two session tracks that cater for different data platform topics such as Data Management & Integration and Manageability, Security and Business Intelligence - you'll be able to choose the sessions most relevant to you and your data management needs.

Hear from technical experts including:
- Mark Whitehorn, Consultant and Academic - Databases, Data Management and Business Intelligence
- Donald Farmer, Principal Program Manager, Microsoft SQL Server Development Team

A more detailed agenda is available when you register.

Come and discover how other information managers, enterprise architects, database administrators and developers are re-thinking their strategies on data management, and learn more about Microsoft SQL Server solutions for data management and business intelligence.

Book your free place at the Microsoft SQL Server Data Management Conference.

Register now
You can also register by phone on: 0870 166 6670 (Event reference: 4125)


Free to Attend: UK Technical Launch at Wembley Stadium for Windows 7, Windows Server 2008 R2 and Microsoft Exchange Server 2010

Here is the chance for UK IT PRO crowd, Free to Attend: UK Technical Launch at Wembley Stadium for Windows 7, Windows Server 2008 R2 and Microsoft Exchange Server 2010

UK Technical Launch at Wembley Stadium and see how technical experts like you are using innovations in Windows 7, Windows Server 2008 R2 and Microsoft Exchange Server 2010 .... more_from_here ...


SQL Server 2008 R2 CTP - BOL : refer to documentation to know what's new!

In response to the SQL Server 2008 R2 CTP post I have had flurry of emails asking what more they can learn on 'What's New' compared to the existing SQL Server 2008 RTM which has celebrated its first birtday!

As a general recommendation I always recommend to download the latest update of SQL Server Books Online  (BOL) from MS Downloads site, you can follow the same to install BOL too if you have installed the CTP as a fresh install on to a seperate machine. Rather than disturbing existing 'working-order' server it is a best practice to run your Proof-Of-Concept (POC) based tasks by using a Virtual Server or VM based machine.

Let's say if you had a limited choice of having seperate machines (Virtual) in your environment then there is an obvious reason to have SQL Server 2008 R2 CTP to be installed as a seperate instance. But in the case of BOL I would recommend to refer to web based BOL within MSDN documentation site. The next set of questions I had is 'What's New', the reply is in the question!


SQL Server 2008 R2 CTP to download and test the new features

It is a public news on the availability of the first community technology preview (CTP) of SQL Server 2008 R2 for MSDN and TechNet subscribers, including the general availability.

So what's new with SQL Server 2008 R2?

To find out that you need to download the CTP which provides the first opportunity to explore the features of R2 release, also it is useful to what kind of enhancements made to performance and scalability of DB engine. Microsoft claims that R2 will enable BI related features such enable self-service BI and Reporting to improve IT and developer efficiency. To get more on Self Service BI SQL Server 2008, “R2” site refers:

Self-Service Business Intelligence

IT departments and users have traditionally been at odds with each other over self-service analytics. IT departments seek to maintain IT governance and control; end-users want to generate and manage their own content and reporting.  With managed self-service business intelligence in SQL Server 2008 R2, these two worlds meet, providing significant business advantage. SQL Server 2008 R2 provides both end-users and IT with cutting edge tools to create, analyze and model, share and manage business intelligence data in a secure and streamlined way.

Self-service analysis tools allow end-users to quickly create solutions from disparate data sources within a familiar Microsoft Office Excel user interface. By publishing these solutions in SharePoint Server, users can easily share them with others. IT gains management and oversight so they can help ensure the reliability, performance, and security of data-driven assets across the enterprise while also gaining better visibility into how people are using their data.

It is good innovation that SQL Server Business Intelligence has evolved in major enterprise application platform to improve the IT & data flow efficiency to reduce the time & cost in develooping such applications. Not only that it will help to scale with confidence by providing high levels of reliability, security and scalability for business critical applications.

On DBA & Developers perspective the SQL Server 2008 R2 brings Application and Multi-server Management: Improving DBA and developer efficiency. SQL Server News blog refers below that R2 brings a blend of features to combine the trends of DBA that are left with little time to effectively maintain and optimize their environment. To help defend against these costly trends, SQL Server 2008 R2 August CTP includes Application and Multi-Server Management capabilities which help DBAs proactively manage database environments at scale through centralized visibility into resource utilization and help streamline consolidation and upgrades across the application lifecycle.

Few new wizards are developed that will enable the DBAs to quickly setup multi-server management environment and dashboard viewpoints that will enable insights into instance and application utilization based on default Policy-Based Management capacity policies. 


There is much more to Developers for Reporting enhancements, Report Builder 3.0 supports for geospatial visualization (maps) to produce new insights and discoveries by combining geospatial data with business information. Additionally, end users will experience significant performance improvements, with enhanced ability to use Report Builder in server mode.  This allows for much faster report processing with caching of datasets on the report server when toggling between design and preview modes. 

The CTP also provides a stand-alone installer for Report Builder 3.0. 

So if you are geared up to develop the new application featuers taking help of these new features on reporting services and better DBA functionalities, you should download the CTP that is an opportunity to experience early, pre-release feature capabilities.

What's next?

Download the CTP

The Community Technology Preview allows you to experience SQL Server 2008 R2 before final release.

Feedback to SQL Server Development team via Connect

Collaborate and evaluate SQL Server 2008 R2 to ensure the product exceeds your expectations and needs.

Know more about this release on forums

Learn more about upcoming releases and other important product information.