Tuesday, November 23, 2010

Singapore SQLUG on 2nd Dec 2010:: Special guest from SQL Server Team


We have SQL Server User Group Meeting on 2nd December 2010 at Aventus Training (Tanjong Pagar)


The Future of SQL Server

I believe that there are many of you are busy migrating. Moving and upgrading from previous version to SQL Server 2008, and some of you already using SQL Server 2008 R2. There are tons of R2 features we can count on, especially on BI part. We already have countless meeting in the past talking about those BI enhancements, its benefit, and how does it improve and impact our development. Now it’s time for reflection. What we have done in the past. What we have achieved, and what are our expectation for the future. Are there any features you want to include in the next release? Do you have any idea on how to make this platform better in the future?

Come and join us with 2 executives from SQL Server product team in our next meeting. This is the right time to hear about strategic direction of SQL Server directly from people who made the product. You may have some concerns, wish list and feedback. Nobody knows better other than us on how SQL Server performs in daily production. Our feedback will be very valuable for the product team to make necessary improvements.

Bring your boss too; he/she may have strategic idea that will be valuable for our meeting.

We will discuss the following topics:

  • SQL Server achievements and its market position
  • Who and how “big” customer uses SQL Server
  • Latest benchmark on SQL Server, focus on high availability and performance
  • Long-term SQL direction
  • An overview of Denali, the future of SQL Server
  • Get feedback from users on SQL needs

Speakers profile:

Sameet Agarwal
General Manager
SQL Server RDBMS Development
Microsoft Corporation

Sameet Agarwal is the General Manager of the SQL Server RDBMS Team. His team is responsible for delivering all the core database technologies like T-SQL Language, Security, Query Processing and Data Warehousing, High Availability, Replication, Indexing, Transactions and Recovery, Storage management, Connectivity, etc. His team is also responsible for innovation in technologies to exploit commodity hardware for scale, large memory and multi-core, solid state drives, etc. Sameet has been associated with the SQL Server team in a variety of roles for the past 15 years with key contributions in the design of the logging and recovery subsystem, transactions, access methods, etc. In his most recent role, Sameet was Product Unit Manager of the Relational Engine for the SQL Server 2008 release with features for parallelism and optimization for large scale data warehousing, resource governor, spatial and fulltext support.

Amit Shukla
Principal Group Program Manager
SQL Server RDBMS Development
Microsoft Corporation

Amit Shukla has worked on database technologies for the past 15 years, the last 8 of them on SQL Server, and the last four of these years have been spent working on the core database product itself. He is currently a Group Program Manager in the SQL RDBMS team where he is working on a variety of features and technologies. Before Microsoft he worked at three startups one after the other, all of which have since gone under, though the experiences from the startups continues to endure.

Meeting details:

Date: December 2nd, 2010
Time: 7:00PM – 8:30 PM
Registration starts at 6:30 PM
Venue: Avantus Training
79 Robinson Road #15-04
Singapore 068897

Direction: take MRT and alight at Tanjong Pagar, CPF building is at the opposite of Tanjong Pagar MRT.

Please confirm your attendance by sending email to SGSQL@LIVE.COM

Get in touch with DENALI: the next version of SQL Server!

C u there on 2nd December at 6:30 PM. If there is any doubt, let me know.


Saturday, November 20, 2010

SQL Server Team based Development


Red-Gate has another excellent book on SQL Server Team based development by Phil Factor, Grant Fritchey, Alex Kuznetsov, and Mladen Prajdić

This book shows how to use of a mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as similar as possible to "normal" development.

Following are the topics covered in this book:
Chapter 1: Writing Readable SQL
Chapter 2: Documenting your Database
Chapter 3: Change Management and Source Control
Chapter 4: Managing Deployments
Chapter 5: Testing Databases
Chapter 6: Reusing T-SQL Code
Chapter 7: Maintaining a Code Library
Chapter 8: Exploring your Database Schema
Chapter 9: Searching DDL and Build Scripts
Chapter 10: Automating CRUD
Chapter 11: SQL Refactoring



Friday, November 19, 2010



SQL SERVER next version DENALI's CTP is out. Here are the details:

Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and management tools help deliver credible data reliably to the right users and new user experiences expand the reach of BI to enable meaningful insights. With SQL Server code-named “Denali” customers will benefit from the following added investments:

  • Enhanced Mission-Critical Platform: an enhanced highly available and scalable platform.
  • Developer and IT Productivity: new innovative productivity tools and features.
  • Pervasive Insight: expanding the reach of BI to business users and end-to-end data integration and management.

SQL Server code-named “Denali’ continues to magnify the each of  BI through highly interactive web-based visualization and storyboarding providing breakthrough performance, common models and IT manageability. With end-to-end data integration and management tools, IT can help deliver consistent, credible data to the right users at the right time. The following highlights a few key enhancements for pervasive insight.
Expand the use of BI to business users
  • Business users will gain greater agility and empowerment with a new highly interactive, web-based data exploration and visualization solution. Introducing new and engaging ways to discover insights through a drag-and-drop interface, smart and powerful data querying and interactive storyboarding to allow users to quickly create and share visual presentations of large datasets.
Experience breakthrough performance with in-memory analytics, and drive alignment across the organization
  • Provide breakthrough analytics performance from the desktop to data center through the Vertipaq in-memory column store technology. Also benefit from next-generation semantic model for both reporting and analytics that span your business from personal BI solutions to the most demanding organizational BI needs.
Enterprise data integration management
  • SQL Server code-named “Denali” will introduce a holistic data integration and management solution that will help organizations ensure the right data is delivered to the right users at the right time. New to “Denali” are two key components to data management, Data Quality Services for knowledge-driven data cleansing and Impact Analysis and Lineage.
    New tools and capabilities will help developers build innovative applications with reduced time-to-market while IT professionals benefit from greater operational control and ease of use. The following highlights a few key enhancements for increased IT and Developer productivity.
    IT administration enhancements
    • Security enhancements will help improve compliance by using auditing for all editions of SQL Server and more easily and effectively manage separation of duties using fine-grained server roles. Meanwhile supportability improvements will help simplify application testing and minimize errors with application changes and upgrades using Distributed Replay. In addition, Extended events dramatically streamline performance troubleshooting with new profiling information and a new user interface.
    Beyond relational enhancements
    • Build more flexible, innovative applications with rich capabilities and data patterns with faster performance for FileStream and Full-Text Search, 2D spatial support, and FileTable.
    Unified developer experience, SQL Server Tools code-named “Juneau”
    • Accelerate time-to-market for developers with a single environment for developing database, BI and web solutions. New capabilities include a unified environment for SQL Server development, Declarative Database Definition, Dynamically Edit Existing Databases, Round-Trip Code Refactoring, and Targeted Database Deployment.
      SQL Server code-named “Denali” provides a highly available and scalable platform with greater flexibility, ease of use, lower TCO, and the performance required by the most mission-critical applications. The following highlights a few key enhancements for a mission-critical platform.
      SQL Server AlwaysOn
      • The new SQL Server AlwaysOn will provide a set of capabilities to help businesses maximize uptime of their mission critical applications, simplify high availability deployments and provide better returns on hardware investments. AlwaysOn supports multi-site clustering and the new availability group option will help improve availability of databases by supporting multiple secondaries, increase utilization using active secondary and simplify HA management. In addition, Windows Server Core support will help reduce unplanned downtime related to OS patching with ~50-60% few OS reboots.
      Column-based query accelerator
      • Column-Based Query Accelerator will help dramatically increase query performance ~10x and reduce performance tuning through interactive experiences with data for near instant response times and streamlined setup which removes the need to build summary aggregates.

        Click here to Download the CTP.