Thursday, April 22, 2010

SQL User Meeting on 29th April 2010

Singapore SQL Server User Group

April User Group Meeting

Topic: Analysis Services 2008: Real time cube and Proactive caching


SSAS is able to answer to real time BI scenario thanks to pro-active caching. During this presentation, we will see how ESSILOR uses this technology in order automate BI for plants, analysis and financial BI, keeping a detailed view and aggregated view at the same time (Asymmetric Pattern).

Speaker: Renaud Harduin
MVP – SQL Server

Renaud Harduin was Business Intelligence Domain Manager for ESSILOR ( where he is in charge of reporting projects for Finance, Distribution and Production. Today, he's working on new functional aspects as forecast and operational Scorecard. He is now Technical Manager of Order Management Information System for ESSILOR, and kept a BI expertise for European projects.

Blog :

Date: April 29th, 2010
Time: 7:00PM – 8:30 PM
Registration starts at 6:30 PM
Venue: Auditorium 21st Floor, Microsoft Office One Marina Boulevard

Please confirm your attendance by sending email to

Community Technology Update (CTU)

The first edition for CTU 2010 will be held on May 2010. Please mark your calendar and make a date with us! We will send you the detail soon. The theme of coming CTU is SQL Server 2008 R2 community launch. We will have special guest coming down to share the latest release of SQL Server.

Join for the Virtual Launch Event – May 12th

Office 2010 and SharePoint 2010 will be official launched to business customers on May 12 in New York City with a keynote from Stephen Elop, President of Microsoft’s Business Division. People around the globe can participate in a virtual launch by going to The virtual launch will include product demos, customer and partner testimonials, and interviews with product managers and executives.

Hope to see you all there.

Monday, April 19, 2010

SQL Server 2008 R2 ebook


As we all are aware that SQL Server 2008 R2 will be released in May. recently a book is released on SQL Server 2008 R2 Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner

The book is divided into 10 chapters and has total 216 pages:

PART I Database Administration

CHAPTER 1 SQL Server 2008 R2 Editions and Enhancements
CHAPTER 2 Multi-Server Administration
CHAPTER 3 Data-Tier Applications
CHAPTER 4 High Availability and Virtualization Enhancements
CHAPTER 5 Consolidation and Monitoring

PART II Business Intelligence Development

CHAPTER 6 Scalable Data Warehousing
CHAPTER 7 Master Data Services
CHAPTER 8 Complex Event Processing with StreamInsight
CHAPTER 9 Reporting Services Enhancements
CHAPTER 10 Self-Service Analysis with PowerPivot

How Is This Book Organized?

SQL Server 2008 R2 is a collection of components that can be implemented either separately or as a group to form a scalable data platform. This book is divided into two parts to focus on the new capabilities for each of these areas.

Part I, “Database Administration,” is for the DBA's and introduces numerous innovations in SQL Server 2008 R2.

Chapter 1, “SQL Server 2008 R2 Editions and Enhancements,” discusses the key enhancements, what’s new in the different editions of SQL Server 2008 R2, and the benefits of running SQL Server 2008 R2 on Windows Server 2008 R2.

Chapter 2, “Multi-Server Administration,” readers learn how centralized management capabilities are improved with the introduction of the SQL Server Utility Control Point. Step-by-step instructions show DBAs how to quickly designate a SQL Server instance as a Utility Control Point and enroll instances for centralized multi-server management.

Chapter 3, “Data-Tier Applications,” focuses on how to streamline deployment and manage and upgrade database applications with the new data-tier application feature.

Chapter 4, “High Availability and Virtualization Enhancements,” covers high availability enhancements and includes step-by-step implementations
for ensuring business continuity with SQL Server 2008 R2, Windows Server 2008 R2, and Hyper-V Live Migration.

Chapter 5, “Consolidation and Monitoring,” a discussion on consolidation strategies teaches readers how to improve resource optimization. This chapter also explains how to use the new dashboard and viewpoints to gain insight into application and database utilization, and it also covers how to use capacity policy violations to help identify consolidation opportunities, maximize investments, and ultimately maintain healthier systems.

PART II - “Business Intelligence Development,” readers discover components
new to the SQL Server data platform, as well as significant enhancements to the reporting component.

Chapter 6, “Scalable Data Warehousing,” introduces the data warehouse appliance known as SQL Server 2008 R2 Parallel Data Warehouse by explaining its architecture, reviewing data layout strategies for optimal query performance, and describing the integration points with SQL Server BI components.

Chapter 7, “Master Data Services,” readers learn about master data
management concepts and the new Master Data Services component.

Chapter 8, “Complex Event Processing with StreamInsight,” describes scenarios that benefit from complex event analysis, and it illustrates how to develop applications that use the SQL Server StreamInsight engine for complex event processing.

Chapter 9, “Reporting Services Enhancements,” reviews all the new features available in SQL Server 2008 R2 Reporting Services that support self-service reporting and address common report design problems.

Chapter 10, “Self-Service Analysis with PowerPivot,” continues the theme of self-service by explaining how users can integrate disparate data for analysis by using SQL Server PowerPivot for Excel, and how to centralize and share the results of this analysis by using SQL Server Power-Pivot for SharePoint.

Please download the book here:

XPS format

PDF format

Happy SQL Coding.....