Feeds:
Posts
Comments

Archive for the ‘SQL White Papers’ Category

SQLAuthority News – Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments – Part 1

Posted in PostADay, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, T SQL, Technology on April 28, 2012 | 1 Comment »

Migration is always a challenge. How many times we have stayed away from migrating product to another server or next version because we are worried what will happen once we migrate. There are two main reasons we stay away from migration 1) Everything is working fine at this moment. 2) Fear of everything will not work fine after migration.

Let us address two of this fear in brief words.

1) Everything is working fine

Even though everything is working fine there are need to upgrade to next version because new version often brings improved features as well new enhancement which can help in many ways, i.e. scalability, manageability etc. There are often cases when something is often done very complex way in current version and in next version right away out of the box the same thing is supported. I am big fan of the going to next version when it is stable.

2) Fear of application not working on next version

This is very common and we all have faced it one time or another time. We always have fear of unknown. We often worry too much because we do not know things.

The best way to solve above two problem is – Knowledge. Here is the whitepaper which talks about migration from earlier solution of the Mirroring to SQL Server 2012 solutions. This is first part of the whitepaper and second part of the whitepaper release soon.

Following is the abstract of the whitepaper.

This paper provides guidance for customers who prior to SQL Server 2012 have deployed SQL Failover Clustering for local high availability and database mirroring for disaster recovery, and who want to migrate to SQL Server AlwaysOn. It describes the corresponding SQL Server AlwaysOn scenario and the migration paths to SQL Server AlwaysOn. It also contains the important knowledge and considerations that you must know in order to successfully migrate to a HADR solution based on SQL Server AlwaysOn technology, which implements AlwaysOn Failover Cluster Instances for high availability and AlwaysOn Availability Groups for disaster recovery.

Download Whitepaper.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

Read Full Post »

SQLAuthority News – Fast Track Data Warehouse Reference Guide for SQL Server 2012

Posted in PostADay, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, T SQL, Technology on April 22, 2012 | Leave a Comment »

I have always enjoyed learning about Fast Track Data Warehousing Technology. The goal of a Fast Track Data Warehouse reference architecture is to achieve an efficient resource balance between SQL Server data processing capability and realized component hardware throughput.

Recently Fast Track Data Warehouse Reference Architecture is updated for SQL Server 2012. Here are the changes in the FT 4.0.

Description Version Note
SQL Server 2012 4.0 Links to other SQL Server Best Practices documents
SQL Server 2012 4.0 Benchmarking and validation
SQL Server 2012 4.0 Memory requirements
SQL Server 2012 4.0 xVelocity memory-optimized columnstore indexes
SQL Server 2012 4.0 Solid state storage
SQL Server 2012 4.0 Validation and columnstore indexes
SQL Server 2012 4.0 Validation of baseline I/O

Fast Track database component architecture

following are key principles of the Fast Track program:

  • Workload-specific benchmarks. System design and configuration are based on real concurrent query workloads.
  • Detailed and validated hardware component specifications.
  • Component architecture balance between database capability and key hardware resources.

Please read the complete whitepaper over here.

Reference: Pinal Dave (http://blog.sqlauthority.com)

Read Full Post »

SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions – A Must Read

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, T SQL, Technology on March 4, 2012 | 1 Comment »

Yesterday I was reading architecture reference material helping my friend who was looking for material in this respect. While working together we were searching twitter, facebook and search engines to find relevant material.While searching online we end up on very interactive reference point. Once I send the same to him, he replied he may not need anything more after referencing this material.

The best part of this article was it gives access to various aspect of the technology of the image map.

Here is the abstract of the original article from the site:

The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and architecture guidance for various mission-critical workloads deployed by users. These guides reflect the knowledge gained by Microsoft while working with customers on mission-critical deployments. Each guide provides not only the key technical concepts and information helpful for design, but also “lessons learned,” best practices, and references to customer case studies.

Once you click on any of the desired topic, you will see further detailed image map of the selected topic.

Personally once I ended up on this site, I was there for more than 2 hours clicking through various links.

Click on image to see larger image

Read more here: Technical Reference Guides for Designing Mission-Critical Solutions

Reference: Pinal Dave (http://blog.sqlauthority.com)

Read Full Post »

SQLAuthority News – Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on February 5, 2012 | 1 Comment »

SQL Server 2012 is has very exciting new feature of SQL Server AlwaysOn. This new feature reduces planned and unplanned downtime and maximize application available. Additionally it provides data protection keeping database always available. Microsoft has released a whitepaper on this subject where it discusses common context business stakeholders, technical decision makers, system architects, infrastructure engineers, and database administrators.

This whitepaper discusses two major points. Following is the abstract from book online:

High Availability and Disaster Recovery Concepts. Provide a brief discussion of the drivers and challenges of planning, managing, and measuring the business objectives of a highly available database environment. This discussion is followed by a brief overview of the high availability and disaster recovery capabilities of SQL Server 2012 AlwaysOn and Windows Server solutions.

SQL Server AlwaysOn Layers of Protection. Provide a deeper discussion of the feature capabilities, rationale, and dependencies of the layers of protection offered by a SQL Server AlwaysOn solution. It will cover infrastructure availability, SQL Server instance-level protection, database-level protection, and data tier application capabilities.

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

Reference: Pinal Dave (http://blog.sqlauthority.com)

Read Full Post »

SQLAuthority News – Implementing a Microsoft SQL Server Parallel Data Warehouse Using the Kimball Approach

Posted in PostADay, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, T SQL, Technology on September 18, 2011 | Leave a Comment »

This white paper explores how the Kimball approach to architecting and building a data warehouse/business intelligence (DW/BI) system works with Microsoft’s Parallel Data Warehouse, and how you would incorporate this new product as the cornerstone of your DW/BI system. For readers who are not familiar with the Kimball approach, we begin with a brief overview of the approach and its key principles. We then explore the Parallel Data Warehouse (PDW) system architecture and discuss its alignment with the Kimball approach. In the last section, we identify key best practices and pitfalls to avoid when building or migrating a large data warehouse to a Microsoft SQL Server PDW system.

Download the Whitepaper from here.

Note: Abstract taken from whitepaper.

Reference:  Pinal Dave (http://blog.SQLAuthority.com)

Read Full Post »

« Newer Posts - Older Posts »