Saturday, November 20, 2010

SQL Server Team based Development

Guys,

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


Enjoy

Sudhir

Friday, November 19, 2010

SQL SERVER - DENALI

GUYS,


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.

        Enjoy



Friday, October 29, 2010

Monitoring and Tuning Parallel Query Execution + Performance Monitoring and Tuning from www.SQLWorkShops.Com

Guys,

I am sure we all are aware of www.SQLWORKSHOPS.com and Mr. R Meyyappan.

SQL Bits VI recorded sessions are available at: http://www.sqlbits.com/information/event6/PublicSessions.aspx and we especially recommend you to watch 'Performance Monitoring & Tuning - Documented Tips & Tricks', the content is not part of our previous webcasts.

Monitoring and Tuning Parallel Query Execution: http://videos.sqlbits.com/event6/Monitoring%20and%20Tuning%20Parallel%20Query%20Execution_w.wmv

Performance Monitoring and Tuning - Documented Tips and Tricks: http://videos.sqlbits.com/event6/Performance%20Monitoring%20and%20Tuning_w.wmv

All my past SQL Bits sessions are available at: http://www.sqlbits.com/Speakers/R_Meyyappan/Default.aspx

These are very helpful sessions, please spare some time and watch the same.

Happy SQL Coding.

Sudhir

Friday, October 22, 2010

Southeast Asia SharePoint Conference 2010

Event Name: Southeast Asia SharePoint Conference 2010

Location: Waterfront Conference Centre at Grand Copthorne 

392 Havelock Road, Singapore - 169663
+65 6733 0880

Event Date: 26th & 27th Oct 2010

Keynote Announced! - Join Mike Fitzmaurice to hear about "The Evolution of SharePoint from Two Pet Projects to a Multi-Company Ecosystem"

Organiser: The Southeast Asia SharePoint Conference is organised by a group of dedicated SharePoint MVPs and Community Leaders from the Asia Pacific Region who participate and support the community through organising and sharing their knowledge at user group events.

How did SharePoint start and how did it become the centre of the universe in under a decade? Mike Fitzmaurice was there at the beginning, has worked on every product with the word “SharePoint” in it, and continues to work on SharePoint technology today, in a former position for Microsoft and now for a SharePoint partner ISV. He will share with you the motivations behind SharePoint’s creation and evolution, the realities behind how the products ship, why SharePoint caught on so completely, and how SharePoint has grown into something far beyond a single product from a single company.

Fees: Regular Registration fee is $SGD400.00.

This is is the conference to learn about SharePoint 2010 with expert local and international speakers presenting on topics that will help you understand and succeed with your SharePoint implementations and add real value to your organisation and businesses.

In addition to the session content you'll have ample opportunities to network with your peers in the community and technical and industry experts including local and international Microsoft Most Valued Professionals and Southeast Asia's top Certified Partners.

The wider Southeast Asian SharePoint Community (MVPs, User Group Leaders, Partners and Customers) are also valued contributors to the event.

The SharePoint Conference is intended for a wide audience and has content to cover roles such as:


  • Business Roles like End Users, Business Champions, Power Users and Business Managers


  • Information Architects, Record and Information Managers IT Managers, CIO and Decision Makers


  • Technical Roles including Developers, IT Pro, Systems Administration and DBA's Microsoft



  • Technologies covered during the conference include:


  • SharePoint Foundation 2010 SharePoint Server 2010


  • SharePoint Designer 2010


  • Integration with Microsoft Office, InfoPath, Excel, Access and Visio


  • Integration with 3rd Party products enhancing SharePoint functionality



  • Hope you can attend this.

    Enjoy

    Sudhir

    7 Free .NET Development and Architecture E-books »

    Guys,

    Here are some links to download Free .Net Development and Architecure E-books.

    Foundations Of Programming: The Foundation Of Programming Series Free e-book By Karl Seguin is one of the best book. It is simple, short and sweet. It gives a better thought process – that’ll definitely enable to code better and think better. This book covers the ALT.NET Philosophy, Domain Driven Development concepts, DI, TDD etc in a nice way. Download it

    Microsoft Application Architecture Guide, 2nd Edition: An essential read for any Microsoft.NET developer or Architect to understand the underlying architecture and design principles and patterns for developing successful solutions on the Microsoft platform and the .NET Framework. This guide neatly covers popular architecture patterns, best practices and common challenges you need to understand for developing .NET applications. Get a good grip on developing enterprise applications in .NET. Download it

    Rob Miles C# Yellow Book 2010: A nice action packed book that takes you through C# and .NET concepts. This book explains C# language and .NET library in general – with a clear focus on implementation thought process and best practices.
    Rob Miles CSharp Yellow Book 2008.pdf
    Rob Miles CSharp Yellow Book 2009.pdf
    Rob Miles CSharp Yellow Book 2010.pdf

    Threading in C#: A short, neatly written book from Joe Albahari about Threading in C#. This is a must read for any .NET programmer to understand more about threading in general, thread pooling, synchronization, Non blocking synchronization, etc. In this book, Joe even covers the Parallel Framework Extensions and Parallel programming in .NET.
    http://www.albahari.com/threading/threading.pdf

    Improving .NET Application Performance and Scalability: Microsoft guide, which focuses on designing your applications with Performance and scalability in mind. It has sections relevant to architects, developers, testers, and administrators. Following the checklists and guidance in this book will ensure that there won’t be any unpleasant surprises in the end. Read this guide if you develop Enterprise applications in .NET.
    Download it

    Applying Design Patterns: A quick introduction towards the thought process of applying design patterns. The objective of the book is to introduce design patterns in a simple way, so that developers can understand some common patterns and how to apply them.
    http://amazedsaint.net/patterns.pdf
     
    RefCardz from DZone: DZone has a number of awesome Quick reference sheets on various technologies. Registration is required to get these reference sheets.
    Getting started with WCF 4.0
    Getting Started With Silverlight + Expression Blend
    Essential F#
     

    Enjoy & Happy Coding

    Sudhir