Archive for August, 2012

Page Restore Dialog in SQL Server 2012 August 30th, 2012

Vinod Kumar

If you are a SQL Server DBA then in the previous versions there were interesting scenario’s you never wanted to get into. A corrupt DB state is always a night mare and there weren’t well documented way of recovery from this state. One needs to understand some of the nuances of what has gone wrong and then based on this the recovery steps would vary. From metadata corruption, index corruption, page corruption etc the variations are many.

I am a big time supporter of enabling CHECKSUM on databases because these corruptions of 823, 824 can be easily caught at query time. And doing a page level restore was a delicate process yet there were points where mistakes can happen. Especially, if you forget to restore the tail :).

Setting up the environment

For the demo I have gone ahead and done the following. You are free to do the same.

  1. Create database (CorruptDB) and populate a table.
  2. Take Full Backup.
  3. Take it offline.
  4. Corrupt a Page
  5. Brought it online

Once this was done. We just access the table, an 824 error is got as below.

Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error:
incorrect checksum (expected: 0x7ddd3463; actual: 0x6dcd3473).
It occurred during a read of page (1:274) in database ID 7 at offset
0x00000000224000 in file ‘C:\Temp\CorruptDB.mdf’. 
Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately.
Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

Something’s that I like about the error message is – it surely guides you to the next steps. Perform a DBCC CHECKDB to see the level of damage. I prefer to use the following command as it suppresses informational messages.

image

From this we can see it is a single page (1:274) that has got damaged and the CHECKDB also suggests another option of repair_allow_data_loss. I highly caution you NOT to use this option as your first option but as a last resort. Understand using that option can make your database values in an inconsistent state. Please read the BOL for more details.

Page Restore – SQL 2012 way

In SQL Server Management Studio 2012, you will now have access to a Page Restore Dialog to allow easy database page restores through a simple user interface.

The goal of a page restore is to restore one or more damaged pages without restoring the whole database. Page restore is intended for repairing isolated damaged pages. Restoring and recovering a few individual pages might be faster than a file restore, reducing the amount of data that is offline during a restore operation.

Right click on the database in question, go to Tasks, then select Restore and you will see the Page… option.

image

Once the Restore Page dialog is open you can check for page corruption (click Check Databases Page button) and have dialog create the restore plan for you to be run later (script options) or run immediately.

image

Check Database Pages: This will execute DBCC CHECKDB … WITH PHYSICAL_ONLY on the selected database. This is a long running operation based on your DB size and its progress can be tracked and cancelled by the Progress Monitor on the dialog’s framework.

This grid of FileID and PageID is populated from the msdb.suspect_pages and the user can manually add and remove pages.

DONOT do this step now: If you click OK now, the page restore starts and you will see the following confirmation with 100% green on the status in the top left.

At this point, I highly recommend you to script using the Script dropdown from top to understand the exact steps. A typical steps will be:

  1. It restores the corrupt page. (WITH NORECOVERY MODE)
  2. It backs up the tail of the log.
  3. It restores all necessary log backups
  4. Finally, it restores the tail of the log.

Personally, if you don’t have SQL 2012 then these are the steps anyways. You can see in the UI the Tail-Log Restore mention. In the above UI, I don’t have any Log backup’s taken since the full backup. This UI in SQL Server 2012 really impresses me.

Final thoughts

There are surely restrictions and special cases for using Page level restore and we highly recommend taking some time reading it. One thing is sure, with SQL Server 2012 Management Studio the process for Page restore has surely been simplified and most importantly, the basics still remain the same.

If you don’t understand the nuances of Page restores, please don’t try to mess around with the DB’s or this dialog on production environments. The basis of Page restore is on the fact that there is a backup to start with. So please make sure your backup strategies are in place and you are on Full recovery model.

Credits: Thanks to Balmukund Lakhani (Technical Lead with Customer Support Team)  for helping me with Page Corruption. And he is also a blogger at: http://sqlserver-help.com/

Continue reading...


 

Picture Post: Your View Vs Management View August 28th, 2012

Vinod Kumar

Because a thing seems difficult for you, do not think it impossible for anyone to accomplish – Marcus Aurelius

There are a number of posts on this blog where I talk about leadership and Management behaviors. I wanted to take a easy shot at a simple concept in a funny way. Don’t take the analogy too harsh. Sometimes it is being cognizant of the fact and taking the corrective actions.

If you remember your performance review in the past year, maybe there is something you can correlate :).

The picture surely can bring a laugh at the same time has enough food for thought too. Being self critical and doing the right assessment of your work from an organization point of view is important. Don’t just keep thinking from your point of view. And the vice-versa is also applicable – I don’t say the organization view is always right. As I sign off this picture post, was reminded of the following quote.

Management is efficiency in climbing the ladder of success; leadership determines whether the ladder is leaning against the right wall – Stephen R. Covey

Continue reading...


 

Microsoft Project 2010 Resources to bookmark August 27th, 2012

Vinod Kumar

The Office System product line up has tons of productivity tools that we use day-in-day-out. Some of the products like Word, Excel, PowerPoint and OneNote have become consumer products there are others that are used by the enterprises heavily. One such product that I talk with a lot of customers is the Project Server and MS Project. In this blog post let me give you a glimpse of resources that you can use to work with Microsoft Project 2010. If you want regular updates, feel free to add yourself to the subscription via email on latest blogs posts.

Videos and Webcasts

Project Server 2010 and SharePoint Server 2010: Focus on Collaboration

TechNet Simulcast

  1. Part 1: The Future of Productivity Today
  2. Part 2: A Day in the Life with Office 2010
  3. Part 3: Planning for Office 2010 and SharePoint Server 2010
  4. Part 4: Deploying Office 2010 and SharePoint Server 2010
  5. Part 5: Configuring and Managing Office 2010 and SharePoint Server 2010
  6. Part 6: Success Stories for the Next Wave of Productivity

Align IT: IT Manager Podcast #34 – The Importance of Project Management

MS Project 2010 "Ignite to Digital"

  1. Introduction
  2. Planning Design and Deployment
  3. Upgrade and Migration
  4. Demand Management
  5. Portfolio Strategy
  6. Timesheet and Statusing
  7. Reporting – Part 1
  8. Reporting – Part 2
  9. Administration
  10. Operations
  11. Extensibility
  12. Conclusion

Project 2010 Demos

  1. Simple and Intuitive
  2. Unified Project and Portfolio Management
  3. User Controlled Scheduling and Project Professional 2010
  4. Team Planner and Project Professional 2010
  5. SharePoint 2010 and Project Professional 2010
  6. Shifting from Excel to Project 2010

Project Server 2010 IT-Professional Webcasts

  1. TechNet Webcast: Project Server 2010 – Performance Part 1: Setup, Execution, and Results
  2. TechNet Webcast: Project Server 2010 – Performance Part 2: Architecture, Sizing, and Capacity
  3. TechNet Webcast: Project Server 2010 Upgrade and Migration
  4. TechNet Webcast: Project Server 2010 – Backwards Compatibility Mode
  5. TechNet Webcast: Project Server 2010 – Coexisting with SharePoint Server 2010
  6. TechNet Webcast: Project Server 2010 – Backup and Restore
  7. TechNet Webcast: Project Server 2010 – Operations

Project 2010 MVP Webcast Series

  1. TechNet Webcast: Microsoft Office Project 2010 Overview
  2. TechNet Webcast: Overview of Microsoft Project Server 2010 for IT Professionals
  3. TechNet Webcast: Managing the Project Life Cycle with Demand Management
  4. TechNet Webcast: Microsoft Project 2010 Portfolio Analysis
  5. TechNet Webcast: Resource Management in Microsoft Project 2010
  6. TechNet Webcast: Project Professional 2010 and SharePoint Server 2010 Better Together
  7. TechNet Webcast: Microsoft Project 2010 Enhanced Project Management
  8. TechNet Webcast: User-Controlled Scheduling in Microsoft Project 2010
  9. TechNet Webcast: Microsoft Project 2010 Desktop: Tips and Tricks
  10. TechNet Webcast: Project Server 2010 Project and Portfolio Management Reporting

Project Server Security

  1. Part 1 – Permissions
  2. Part 2 – Groups
  3. Part 3 – Categories
  4. Part 4 – RBS

What’s New in Microsoft Project 2010?

Overview of Project Portfolio Management Using Project Server 2010

Project Server and Team Foundation Server 2010 Integration Technical Preview

Project Financial Intelligence for Microsoft Project Server 2010

Microsoft Project 2010 – Tracking

Microsoft Project 2010 – Communicating

Project 2010 Software Development Kit (SDK) Drilldown

Information about Project 2010 and Project Server 2010 Service Pack 1

Project 2010 and Project Server 2010 Programmability

Building Integrated Applications on the Project Server 2010 Platform

Understanding Project Server Interface (PSI) in Project Server 2010

Implementing Team Foundation Server 2010 and Project Server Integration Feature Pack

Successfully Deploy Project Server on VMWare with Shared Infrastructure

Deploy Project Server

Create a Project Web App Site

Add an Application Server to a Project Server Farm

Deploy Project Server 2010 to a Test Environment

  1. Hyper-V Quick Start
  2. Setting up a Domain Controller
  3. Adding a Virtual Machine to the Virtual Domain
  4. Setting Up a SQL Server
  5. Install SharePoint Server 2010
  6. Installing and Configuring Project Server
  7. Creating a PWA Site
  8. Configuring Reporting

How Reporting in Project Server 2010 Works

Project Server 2010 Reporting Tour

Configure Reporting

Up to Speed with Project Web App

  1. Part 1: The Basics
  2. Part 2: Proposing and creating a new project
  3. Part 3: Selecting projects for your portfolio
  4. Part 4: Plan your project
  5. Part 5: Manage your project

Create a Custom Enterprise Project Type

Create an Analysis

Prioritize a Project

Create the Approval Process for a Proposal

  1. Part 1
  2. Part 2
  3. Part 3

Define the Phases and Stages of a Project Life Cycle

Create or Edit a Project or Proposal

  1. Part 1
  2. Part 2

Articles and Documentation

Project Server 2010

  • Project 2010 Ignite Training Slide Presentation
  • Time and Task Progress Workflow Diagrams (Project Server 2010)
  • Product Evaluation
    • What new for IT Pros in Project Server 2010
    • Project Server 2010 with SharePoint Server 2010 architecture (overview)
    • Project 2010 Ignite on-demand training videos
    • Project Server 2010 IT-Professional TechNet Webcasts
    • Project 2010 MVP Webcast Series
    • Project Server 2010 Demand Management Webcast Series
    • Project Management Comparison: Project Professional 2010 and Project Web App
    • "From the Trenches" white papers (Project Server 2010)
  • Planning and Architecture
    • Plan hardware architecture in Project Server 2010
    • Plan for Deployment
    • Plan for authentication
    • Project Server and SharePoint Server security
    • Plan for performance and capacity
    • Plan groups, categories, and RBS
    • Project Server 2010 upgrade overview
    • Plan for upgrade
    • Hardware and software requirements
    • Project Server 2010 architecture
    • Plan browser support
    • Plan for Project Server 2010 Web Parts
    • Plan for disaster recovery in Project Server 2010
    • TechNet Webcast: Project Server 2010: Performance, part 1: setup, test, execution, and results
    • TechNet Webcast: Project Server 2010: Performance, part 2: architecture, sizing, and capacity
    • Project Server 2010: A financial management solution for projects, programs and portfolios (white paper)
    • Technical diagrams (Project Server 2010)
  • Development
    • Visual Studio Team Foundation Server 2010 and Project Server Integration Feature Pack
  • Deployment
    • Deploy Project Server 2010 to a server farm environment
    • Testing Project Server 2010 deployments
    • Deploy Project Server 2010 to a test environment
    • Install Project Server 2010 to a stand-alone computer
    • Deploy language packs
    • Deploy Project Server 2010 with Exchange Server
    • Upgrade to Project Server 2010
    • Deploy Project Server 2010 updates
    • Book excerpt: Post-installation configuration (Project Server 2010)
  • Operations
    • Project Server 2010 Administrator’s Guide
    • Microsoft Project Server 2010 Project Manager’s Guide for Project Web App
    • Server Settings
    • Back up and restore databases
    • Project backup and recovery
    • Database maintenance plans for Project Server 2010
    • Database management
    • Use Project Web Apps
    • Add or remove Project Web App Web Parts for a site in the Project Web App site collection
    • Add Project Web App Web Parts to a site not within the Project Web App site collection
    • Best practices for managing a large number of resources in Project Server 2010
  • Security and Protection
  • Technical Reference
    • Windows PowerShell for Project Server 2010
    • Project Server 2010 global permissions
    • Project Server 2010 category permissions
    • Microsoft Project Server 2010 default categories
    • Project Server 2010 default group permissions
    • General reference
    • System Center Operations Manager knowledge articles (Project Server 2010)
    • Accessing Project Web App and Project Professional from a Macintosh-based computer
    • Microsoft Project Server 2010 integration with SAP (white paper)
    • Conformance statement A-level
    • Conformance statement AA-level
  • Video demos and training
  • More links and Resources

    Microsoft Project Server 2010 – Resources

    Project 2010 – Tips and Tricks

    1. Easier Planning with User-Controlled Scheduling
    2. Enhanced Copy & Paste
    3. Intuitive Access with the Ribbon
    4. Add Key Milestones to the Timeline View
    5. Add a New Column & Save As a Custom Table
    6. Effectively Manage Resources with Team Planner View
    7. Add Project Summary Tasks & Outline Numbers
    8. Make Smart Scheduling Decisions with Task Inspector
    9. Sync with SharePoint
    10. Focus on Data with AutoFilter

    Customer Success

    1. What Project Managers Need to Know About Strategic Planning
    2. Lean Agile PM: Applying Agile and Lean Practices to Managing Projects
    3. Negotiating Realistic Estimates and Schedules: Maximizing Your Power to Reach Win-Win Results
    4. Critical Chain Project Management—Estimating and Scheduling
    5. Six Sigma Can Help Project Managers Improve Results
    6. Boxed In
    7. Seven Fallacies That Delay Project Management Maturity
    8. Risk-Tolerance Based Schedule and Cost Estimates
    9. Kicking It Off

    Project Management Resources

    • Using Project 2010 as an Effective Project Management Tool for Public Sector
    • Effective Project Management in Biotechnology and Pharmaceutical Sectors: Using Microsoft Project 2010
    • Project Management in Manufacturing Environments: Using Microsoft Project 2010

    White Papers

    1. Microsoft Project for the masses
    2. SharePoint 2010 Lifecycle Management with Project Server 2010
    3. Microsoft Project Server 2010: Get the Most for Your Organization, Now and for the Future
    4. Project Portfolio Management: Doing the Right Things Right
    5. Microsoft Project and SharePoint Server 2010 — Better Together
    6. Microsoft Project Server 2010, A look at Portfolio Strategy
    7. Portfolio Analysis with Microsoft Project Server 2010, A Guide for the Business User
    8. Microsoft Project Server 2010, A look at Demand Management
    9. Reporting with Microsoft Project Server 2010
    10. Reconciling the Agile Team with Enterprise Project Management
    11. Project and Work Management with Project Server 2010 and Team Foundation Server 2010

    Developer Resources

    Project 2010

      1. Welcome to the Project 2010 Developer Reference
      2. Getting Started
      3. What’s New
      4. Object Model Maps
      5. Reference
  • SDK Documentation
      1. General Reference
      2. Class Library and Web Service Reference
  • Technical Articles
      1. Getting Started with Development for Project 2010

    Project 2010 for Developers – TOC

    • Essentials

      • View the Project 2020 SDK Online
      • Download the Project 2010 SDK
      • Solution Starters for Project 2010
    • Working with Project 2010
      • When to Wait, and When Not to Wait for the Queue
      • Create a Project Server Event Handler
      • Use the Updated ProjTool Test Application
      • Develop a Project Server Web Part
      • Use Managed Code to Modify the Ribbon in Project 2010
      • Modify the Project Web App Ribbon
      • Develop a Project Server Workflow
    • Learn about Project 2010
      • Get Started with Project 2010 Development
      • Project 2010 Product Site
      • Project 2010 "Ignite"
    • Community downloads
      • Code gallery
      • CodePlex
    • Forums
      • Project Professional 2010 General Questions
      • Project Server 2010 General Questions
      • Project Server 2010 Setup, Upgrade, Administration and Operation
      • Project 2010 Customization and Programming
    • Support
      • Help for Project 2010, 2007, and 2003
      • Project Solution Center

    Virtual Labs

    Microsoft Project 2010 and Microsoft Project Server 2010 Overview

    Microsoft Enterprise Project Management – Project and Portfolio Management with Project 2010

    Links, Samples and Resources

    Developer Code Samples

    Script Center

    Script Resources for IT Professionals

    Microsoft Project 2010 Homepage

    Project for Developers

    Support for Microsoft Project and Microsoft Project Server

    Microsoft Project 2010 – The Official Blog of the Microsoft Office Product Development Group

    Microsoft Office Project Support Weblog

    Project Programmability

    Christophe Fiessinger’s Blog

    Downloads

    Getting Started with Microsoft Project 2010

    Microsoft Project 2010 "Ignite" (a.k.a. "Quick Start 2010 Training")

    1. Introduction
    2. Operations
    3. Extensibility
    4. Conclusion
    5. Planning, Design and Deployment
    6. Upgrade and Maintenance
    7. Demand Management
    8. Portfolio Strategy
    9. Timesheet and Statusing
    10. Reporting – Part 1
    11. Reporting – Part 2
    12. Administration

    Microsoft Project for the Masses

    SharePoint Lifecycle Management Solution with Project Server 2010

    Microsoft Project 2010: Interactive menu to ribbon guide

    Microsoft Enterprise Project Management 2010 Licensing Guide

    Microsoft Project 2010 – Enterprise Project Management Solution Demo

    Download Project Software

    Project 2010 Software Development Kit

    Project 2010 MVP Webcast Series slide presentations

    Microsoft Project 2010 Demonstration and Evaluation Installation Pack

    Ribbon Customization for Project 2010 – Favorites Tab

    Microsoft Project Server 2010: Get the Most for Your Organization, Now and for the Future

    Web-Based Schedule Management Comparison‎

    Setting up the Host Machine for the SharePoint, Office and Project 2010 Virtual Machines

    Virtual Migration Environment (VME) for Microsoft Project 2010 and Microsoft SharePoint 2010

    Microsoft Project Server 2010 Technical Library in Compiled Help format

    Microsoft Project Server 2010 Resource Kit

    Project Server 2013 (Preview)

    Recently Published Content

    Downloadable Content

    Video Demos and Training

    Explore

    • What’s new for IT Pros in Project Server 2013 Preview

    Plan

    • Hardware and software requirements
    • Plan for performance and capacity
    • Plan user access
    • Plan for deployment

    Develop

    Install and Configure

    • Deploy Project Server 2013 Preview to a server farm environment
    • Upgrade to Project Server 2013 Preview
    • Install Project Server 2013 Preview to a stand-alone computer
    • Configure site mailboxes in SharePoint Server 2013 Preview

    Operate and Maintain

    • Server Settings (SharePoint Central Administration)

    Use

    • Security
    • Enterprise Data
    • Database Administration
    • Operational Policies
    • Add SharePoint task list data to Project Server 2013 Preview

    Security and Protection

    Technical Reference

    • Windows PowerShell for Project Server 2013 reference
    • Global permissions in Project Server 2013 Preview
    • Category permissions in Project Server 2013 Preview
    • Default categories in Project Server 2013 Preview
    • Default group permissions in Project Server 2013 Preview
    • SharePoint Permissions Mode default permissions for Project Server 2013 SharePoint groups

    This I think completes a long list of resources for Microsoft Project. Please feel free to add your comments and pass this via your social networks. I surely welcome comments.

    Continue reading...


     

    Picture Post: Doing Vs Saying August 25th, 2012

    Vinod Kumar

    A life spent making mistakes is not only more honorable, but more useful than a life spent doing nothing – GB Shaw

    In continuation to the picture blog series, thought of moving to a different chart type (Pie) this time :). There are so many visualizations and let us try to see how we can bring content in these different formats. This blog post was inspired by a simple concept.

    I get to see two types of people:

    Type 1: Who talks more (broadcasts), and do less.

    Type 2: Who does more (caring), and talks less.

    These categorization makes interesting stereotyping of people. A typical way to look at the above diagram is Manager (Type 1) Vs Leader (Type 2) analogy. It can also be seen as Doing Vs Delegating. Another way to look at it is, doing charity Vs talking about charity. The list can keep going on and on.

    The fun thing about this is, the 80-20 rules are everywhere. I want to know your views on this and the 80-20 rules !!!

    Do the best you can, where you are, with what you have, now.

    Continue reading...


     

    Picture Post: Decision Making August 20th, 2012

    Vinod Kumar

    Each indecision brings its own delays and days are lost lamenting over lost days… What you can do or think you can do, begin it. For boldness has magic, power and genius in it. – Johann Wolfgang von Goethe

    The above lines pretty much sums up what I had in mind. If you are thinking of a context, well just assume the situation when you had to buy a new gadget (say Mobile, TV, Stereo System etc). More the choices, more the trouble to get into a decision. In the same way in professional life, you need to take strong decisions on where you want to be based on where you are. Don’t get distracted by what others are doing !!!

    Some people are very decisive when it comes to avoiding decisions. I would say, take the bold step and keep moving. Life is an experience of the choices you have made so why wait and procrastinate.

    Are you a symptom of this? Would love to hear from you.

    Continue reading...