bet.ucoz.co.uk

Posts Tagged ‘InterOp’

Work Smart Guides: Getting Started Series December 24th, 2012

Vinod Kumar

As part of my twitter stream (@vinodk_sql), I post a lot of links and resources that I come across. These are mostly from MSDN or from other sources that I find as interesting content. Having said that, there is no one place we can go and find all the information over the internet for getting started series. I found the Work Smart series has a number of interesting documents that are worth a look if you are a beginner or want to start learning a technology. Whenever there is a new release, I look forward for these papers because they are quick to read and give me a great idea to start learning the concepts in detail later. In my experience of more than a decade of IT, I have come to a conclusion that there is no substitute for self learning and exploration. Sky is your limit and your imagination is your limitation to how far you can learn.

Desktop

Exploring Windows 8: This guide provides a high-level overview of the exciting new features in the Windows 8 user interface.

Windows 8 Shortcut Keys : This guide provides a quick reference to the shortcut keys in the Windows 8 Start screen.

Windows 7 New Features :This guide describes some of the new feature available now in Windows 7.

Windows 7 on a Slate Device : Learn how to use Windows 7 features on a slate device, using touch-friendly features in IE9, the tablet input panel, speech inputs and more.

Everyday Work with Windows Vista Get Started : Windows Vista offers improved search capabilities, easier ways to sort and organize files, and interface enhancements that help manage applications and information.

Windows Vista and Microsoft Office Work Smarter Checklist : Streamline your work with powerful new features in Windows Vista, the 2007 Microsoft Office system, and Exchange Server 2007.

Using Windows Internet Explorer 10 : Internet Explorer 10, included in Windows 8, offers two browser experiences, a touch-optimized, modern-style experience and a classic desktop, web-browsing experience. This guide provides detailed instructions for using the Internet Explorer 10 modern experience, provides useful tips for working across both experiences, and discusses security and privacy.

Office

Microsoft Office 2010 User Interface Get Started : Use this guide to learn more about Office 2010 user interface new features.

Groove 2007 Get Started : Groove enables teams of people to work together securely over the Internet or a corporate network as if they were in the same physical location. Groove is good for teams that don’t work in the same location, time zone, or company. Groove manages changes to shared files even when you are offline.

Groove 2007 Learn More : With Groove 2007, small teams can work together securely over the Internet or corporate network without sharing the same location, time zone, or company.

Microsoft Excel 2010 Get Started : Use this guide to learn about some of the new and improved features which are available in Microsoft Excel 2010.

Microsoft PowerPoint 2010 Get Started : Use this guide to learn about the new features of Microsoft PowerPoint 2010.

Microsoft Word 2010 Get Started : Use this guide to learn about some of the new and improved features which are available in Microsoft Word 2010.

OneNote Overview : You can use this guide to learn about the features in Microsoft OneNote 2010, and how to use them.

Outlook 2010 Calendar Scenarios Get Started : Microsoft Outlook 2010 makes setting appointments, sharing your calendar availability, and managing your schedule even easier.

Outlook 2010 Get Started : Use Microsoft Outlook 2010 to manage your e-mail messages. You can use this guide to learn about some of the new features in Outlook 2010.

Outlook and SharePoint Integration Get Started : Understand how you can use Outlook to work directly on SharePoint resources.

Outlook and SharePoint Integration Overview : Understand how you can use Outlook to work directly on SharePoint resources.

Outlook E-Mail Signatures Get Started : Office Outlook 2007 e-mail signatures enable you to create a brief description of yourself for the benefit of those you correspond with.

Outlook Web App Get Started : Microsoft Outlook Web App (OWA) provides secure access to your Outlook email, calendar, contacts, tasks, and Global Address List – via the Internet. This guide explains how to log on to OWA and use OWA features.

Microsoft Office Tasks Get Started : Use Outlook Tasks to organize your time and your work. Work across applications with Tasks integrated across Outlook, SharePoint, and OneNote.

Sharepoint

Collaborating with SharePoint Overview : Collaborate effectively with SharePoint sites and features.

Collaborating with SharePoint Server 2010 Get Started : Get started on collaborating effectively with SharePoint sites and features.

Customizing SharePoint Sites Get Started : Customize SharePoint sites with Web parts. Display libraries, documents, RSS feeds, and customize the left navigation menu (Quick Launch).

Office SharePoint Workspace Get Started : Microsoft® SharePoint® Workspace 2010 is a client application that offers a seamless experience when you work online and offline with document libraries and lists on Microsoft SharePoint Server 2010 and Microsoft SharePoint Foundation 2010. Additionally, it conducts real-time, automatic, transparent synchronization of that content when you connect to the SharePoint server.

Messaging / Communication

E-Mail Basics: Managing E-Mail Get Started : This guide describes several tips and tools that will help you take charge of your email.

Successful Meetings with Lync Get Started : Traditional meetings, large and small, can be a challenge when people are spread out over long distances and include internal and external attendees. Communication technology can overcome the physical boundaries by allowing people to attend from any location with Internet or phone access. But that alone is not enough to make a meeting successful. By understanding the best practices for conducting meetings and using the right communication technology from Microsoft Lync 2010, you are on your way to conducting successful meetings.

Security

Protect Data with BitLocker Get Started : Microsoft BitLocker Drive Encryption technology uses the strongest publicly available encryption to protect your computer’s data, and prevents others from accessing your disk drives without authorization. Additionally, the BitLocker To Go feature prevents unauthorized data access on your portable storage devices, including Universal Serial Bus (USB) flash drives, also known as “thumb drives.”

Protecting Data with Windows 8 BitLocker : This guide discusses how to use Microsoft BitLocker Drive Encryption technology to protect your computer’s data, and prevents others from accessing your disk drives without authorization.

Securing Business Information : At work, all forms of information, including ideas and concepts, have potential business value. It is everyone’s responsibility to protect this information from unauthorized disclosure. The Securing Business Information Work Smart Guide details how to classify business information and how to choose the correct technology to protect this information before you transmit, share, store, or destroy it.

Securing Your Computer
Every computer at Microsoft is a gateway to the corporate network. Employees need to guard these gateways against intruders who might try to gain access to corporate resources. By adhering to Information Security Standards and following the best practices in this guide, you can help protect Microsoft against potential threats.

Securing Your Windows Phone Get Started : Windows Phones are powerful tools that enable you to work remotely by synchronizing to your corporate email and the corporate network. More and more employees work remotely and use Windows Phones and other mobile devices. However, protecting them is a challenge, because they are small and easily lost or stolen. This guide provides information on securing your Windows Phone.

Others

DirectAccess is Key to Microsoft IT Remote Access Strategy : Microsoft IT has leveraged DirectAccess as its future in preferred remote access technology. DirectAccess is a new feature in Windows 7 and Window Server 2008 R2. With DirectAccess, users are always connected to the corporate network whenever they are connected to the Internet, and without having to use a VPN. This seamless and ubiquitous access method has resulted both significant end user and business benefits for Microsoft.

Environmental Sustainability Get Started : Environmentally responsible IT business strategies continue to gain momentum across the industry. Microsoft IT has been addressing Environmental Sustainability issues for years but now has a single point of collaboration around these efforts in order to increase awareness and reduce the company’s overall carbon footprint.

System Center 2012 Configuration Manager Get Started : System Center 2012 Configuration Manager puts the management of your computer in your hands. You can use Configuration Manager to quickly and easily identify and install applications that are relevant to you based on your role, language, and location. You can also use Configuration Manager to manage the timing of installations and upgrades to avoid disruptions to your work.

Transfer Files and Settings Get Started : Use this guide for instructions on how you can transfer your files and settings from your old computer that is running Windows XP or Windows Vista using the Windows Easy Transfer tool. Topics include: Install Windows Easy Transfer for Windows XP, Transfer Files and Settings Between Computers Over a Network, Transfer Files and Settings Using a Location on a Network, Transfer Files and Settings Using Removable Media, and Recycle Your Old Computer.

Using Microsoft Forefront Identity Manager Get Started : Microsoft Forefront Identity Manager (FIM) 2010 provides an integrated and comprehensive self-service group management and password reset solution. FIM 2010 simplifies the identity management landscape and enables group management through a Microsoft Office SharePoint Server 2007 portal and a Microsoft Office Outlook 2007 add-in.

Using Windows Phone 7.5 Get Started : Microsoft IT deployed Windows Phone 7 companywide to over 50,000 employees. Cross-company, Cross-team collaboration, planning, and focused marketing was the key to deploying and supporting Windows Phones successfully to employees around the world.

Backing Up Your Data and Settings : This guide provides information on how to set up and use the new File History feature in Windows 8 or the IntelliMirror Redirection Service to back up your data.

Connect a Microsoft Account (Windows Live ID) to Your Domain Account : This guide discusses how, with Windows 8, you can connect your Microsoft account to your corporate domain account. By connecting the accounts you can continue to sign in to your office PC with your domain (network) credentials, sync your Windows personalization settings across multiple PCs, and use a single sign-on for Windows Live services.

Connecting Remotely Using Windows 8 DirectAccess : This guide discusses how to connect remotely using Windows 8 DirectAccess, which enables you to seamlessly connect to the corporate network from any Internet-equipped remote location without having to establish a Virtual Private Network (VPN) connection.

Hope you found the links and resources useful. I am sure I might have missed couple of links for sure but keep an eye for these series on the Microsoft site.

Continue reading...


 

SQL Server: Database Recovery Advisor December 19th, 2012

Vinod Kumar

We have talked about two concepts earlier in this blog when it comes to backup in the recent past. First is around Page Restore Dialog and other is around how to find the Sequence of backup taken. Both these are very interesting and very important concept in my opinion and a frequently asked question. In this blog post, we will discuss the concept of Database Recovery Advisor (DRA) of SQL Server 2012. DRA is a new SQL Server 2012 feature to make it easier for SQL Server Management Studio (SSMS) users to do point-in-time database restore and Database Page restores. Although this feature is called Database Recovery Advisor, the end-user will only see these improvements via the Restore Database dialog and new Page Restore dialog. In DRA the users will be able to figure out which data pages are corrupt directly from the dialog and will be able to do Page Restores from the backups and this has been explained in our Page Restore Dialog post mentioned earlier.

What has DRA given us in the long term with SQL Server 2012.

  1. Redesigned the Database Restore Dialog in SSMS to support consistent restore plan creation and verification.
  2. Backup History Time-line dialog, this visually shows the backups on a time-line and lets user select a possible point-in-time to restore.
  3. Page Restore dialog in SSMS.
  4. Have support for these restore plan creation and verification even in SMO.
  5. Enabling the SSMS restore dialog to generate automated restore plan for all the scenarios.
  6. Show the Database backup history when exists in the msdb in the restore.
  7. When the msdb does not have the backup history of the Database, it needs to be constructed from the backup header info when pointed.
  8. Feature allows users to check the integrity of the backup files before restoring directly from the Restore Dialog.
  9. Allowing the user to restore to the point-in-time, even if it in the tail of the log, by automatically taking a Tail-Log backup.
  10. Page Restore Dialog allows the user to find out the corrupt pages in the Database.
  11. Page Restore Dialog automatically generate Restore Plan for Page-Restore from the backup history of the database.

Restore Correctness

Correctness of the Restore Plan is checked every time it is modified. If the sequence of the backups is not correct. Error message will be shown in the top message bar. For example:

The page header will give some interesting warnings making the dialog really complete and makes sure the DBA doesn’t miss a step.

  1. No Full backup Selected.
  2. Differential backup not compatible with the full backup.
  3. Some of the T-Log is not compatible with the Full or Diff backup set selected.
  4. The T-Log backup sequence is broken.

These some of the most common warnings that come up !!!

The checkboxes in the grid lets users exclude some backup sets from the Restore Plan as required. The Dialog handles various scenarios intelligently: for example, if a backup set is excluded from the plan, all the backup sets that are dependent on it will be unselected. The selection of the backup sets in the grid is always consistent to be restored.

Verify Backup Media: Checks the integrity of the selected backup sets. This will call RESTORE VERIFYONLY on the selected backup sets. This can be a long running operation, and its progress can be tracked and cancelled by the Progress Monitor on the Dialog Framework. The top information bar also shows the progress of the operation. We can Stop it too from the top bar.

image

RESTORE VERIFYONLY performs the following checks:

  1. Makes sure we are able to read all the backup set and all volumes.
  2. Some header fields of database pages, such as the page ID are accessible.
  3. Checks for Checksum correctness (if present on the media).
  4. Checks for sufficient space on destination devices.

Recovery time Range – Timeline Dialog

In the above figure we can see the timeline button and that opens up a nice dialog like below. This is really a powerful dialog that cannot be missed. This backup/restore functionality provides us the ability to restore back the state of the database to a previous point-in-time.

image

Last Backup taken: This selects the time of the last backup taken for that database that can be restored. (Selecting this disables the slider in the timeline.) This is the default setting.

Specific date and time: Allows the user to select a point-in-time in the timeline to restore the database to. (Selecting this enables the slider in the timeline.)

Interval: This combo box lets you select the span of the view in the timeline.
  1. Hour
  2. 6 Hour
  3. Day (Default)
  4. Week
Graphical Timeline: This timeline visually represents the backups of the database.
  1. The red line represents the selected point-in-time, this red-line will not go outside the feasible time span in which the database can be restored. Default location is the end of the last feasible restore point.
  2. The slider lets the user select a point-in-time restore location by moving the red line.
  3. The left-right button lets the user navigate on the timeline.
  4. Markers:
  1. The Markers represent the Full (bigger) and the Diff (smaller) backups.
  2. The green bar represents the T-Log backup coverage, while the light green bar represents the tail of the log, which has not been backed up.

Scripting Options

The best strategy to learn is always using the “Script to” option. There are four scripting options:

  1. Send RESTORE DATABASE script to a "New Query Editor Windows".
  2. Send to a T-SQL File.
  3. Copy text to Clipboard
  4. Create an Agent Job that can be run later.

We will highly recommend to get it to a T-SQL file because this can we can learn from what script SQL spits out and we can use the same script for later use if needbe.

Limitation of DRA

  1. Support for File and FileGroup Restore is not supported and there is a separate dialog to do that, but that will not have Recovery Advisor features.
  2. DRA will not support the recovery of system databases.
  3. DRA will not support DBCC Repairs.
  4. DRA does not support piecemeal restores: Files and Filegroups Restore dialog should be used for that.
  5. DRA will not support Page restores of Database Boot pages, PSF, GAM, SGAM etc.

As we described in the previous post, the Page Restore Dialog can be read from that post. I highly recommend you to read that post too.

Continue reading...


 

SQL Server 2012: Finding Sequence of backup taken October 22nd, 2012

Vinod Kumar

Recently I had a customer come over for a session on designing their HA/DR strategy and one of the steps for that was to understand the backup strategy too. I took sometime to talk at length what FULL Backup, Differential Backup and Transaction Log Backups. After understanding the core concepts one of the developer asked me, “Is there a way I can know in what sequence the current backups are taken? This will help me re-visit the current process done by my networking team”. Interestingly, a lot of people fail to understand how Page level restore needs to be done.

This was an interesting question and needed a little digging into the MSDB database which has most of the information. The below query will give you a list of backups and feel free to check the same in your environments. This also works in any of the SQL Server versions.

SELECT s.database_name,
       m.physical_device_name,
       s.backup_start_date,
       CASE s.[type]
         WHEN ‘D’ THEN ‘Full’
         WHEN ‘I’ THEN ‘Differential’
         WHEN ‘L’ THEN ‘Transaction Log’
       END AS BackupType,
       s.recovery_model
FROM   msdb.dbo.backupset s
INNER JOIN msdb.dbo.backupmediafamily m
ON s.media_set_id = m.media_set_id
ORDER  BY database_name,
          backup_start_date,
          backup_finish_date 

A typical output looks like below:

image

All these information are great stuff and the best part starts when we use the same for RESTORE. The UI for example will show interesting information which I was pleasantly surprised.

image

There are two things that stand out in the above dialog -

  1. The header shows we need to take the tail of the log backup for the restore. This is an awesome step which a lot of DBA forget in their restore process.
  2. The Backup Step shows what you will be restoring and in what sequence. This is also a pre-requisite for any restore stage.

On initializing the Filegroup restore dialog I can see ALL the Backups taken for the restore step and this is also handy if you are planning to restore any corrupt files.

image

Hope you find these improvements useful and the scripts handy. In future posts, let me take a shot in showing what all can be done with these backups.

Continue reading...


 

SQL Server 2012: THROW your errors October 11th, 2012

Vinod Kumar

In this post let me take a shot at showing some of the nice features SQL Server THROW command. When I planned to write this post, was tempted to write about Error handling, TRY-CATCH, Raiserror commands etc. But I have had the unique privilege of reading the Joes2pros Series and the basics are explained well there. Interestingly, Pinal Dave did run few contests around Joes2Pro’s series sometime back and I thought it will be better to just link the concepts rather than rehashing the efforts already done. Read about Error Messages and RAISERROR, Structured Error Handling with TRY-CATCH explained. They are a great start to learn those basics.

From SQL Server 2012, it is recommended to use the THROW syntax instead of the conventional RAISERROR syntaxes. The MSDN documentation for THROW syntax can be got here.

Simple usage

Let me take a moment to start the simplest form of throw. Assume we get an error inside a nested procedure and we want to bubble it up. the previous avatar was to use the RAISERROR and it was quite an task sometimes. In the THROW construct it can be simply done with a single THROW command. like below.

BEGIN TRY
    THROW 51051, ‘I come from the THROW construct :)’, 1
END TRY
BEGIN CATCH
    PRINT ERROR_NUMBER();
    THROW;
END CATCH

The output for the above batch will be:

image

There is a small thing to take care, the previous statement before the THROW construct needs to have a semicolon – else an error is raised. This is one of the requirement for THROW. A typical error would be like below:

Msg 102, Level 15, State 1, Line 7
Incorrect syntax near ‘THROW’.

This is one of the common mistakes all of us make and hence thought will be worth sharing here.

With Custom Message

The second common mechanism to use RAISERROR with applications is to add an custom message and then invoke the same parameterized via the RAISERROR. Let me show a fundamental functionality of creating a custom error message and then raising the same.

EXECUTE sp_addmessage @msgnum=55055, @severity=16,
@msgtext=N’This error was raised for %s user’,
@replace=’replace’
GO
RAISERROR (55055, 16,1, ‘vinod’)

The output for the above batch would be as below. You can see the username has been properly replaced in the final message as it got rendered.

image

To get the same effect with the THROW statement we need to manually format the message before using the same. A typical construct would be:

DECLARE @message NVARCHAR(2048) = FORMATMESSAGE(55055, ‘vinod’);
THROW 55055, @message, 1;

This gives the same output as above and behaves the same way as before as we used with RAISERROR.

As you can see, we have used the FORMATMESSAGE function to make the replacement with RAISERROR as it allows the error message to be formatted to be used later with the THROW statement.

Final words

Hope this new construct of THROW will be useful and I highly recommend we use this new feature of SQL Server 2012 for our future coding practices. Do tell me if you have used this in your environments already. Will be interested in listening to your usecases.

Continue reading...


 

Windows Server 2012–Virtual Academy Training October 5th, 2012

Vinod Kumar

Yesterday I wrote a blog post around what is new in Windows Server 2012 and I had couple of my friends ask how to learn it more efficiently. Thought I will write about the same in this post with links to the Virtual Academy Courses that are awesome and available online as TechNet resources. So here is a dump of links to various Microsoft Virtual Academy (MVA) around Windows Server 2012. This can easily take away your couple of weekends if you want to learn it properly :) – Trust me it is worth it !!!

These videos are part of the Microsoft Virtual Academy (MVA). The MVA is a free program delivering structured learning paths for IT Professionals on various Microsoft products and solutions.

Microsoft Virtual Academy: Hyper-V Network Virtualization | TechNet VideoThe module introduces the new Hyper-V Network Virtualization feature and this video rounds off the module with a how-to look at the Hyper-V Network Virtualization.

Microsoft Virtual Academy: IP Address Management in Windows Server 2012 | TechNet VideoThis module introduces the IP address management (IPAM) feature in Windows Server 2012. You will see why IP address management is important for network infrastructures in modern organizations, followed by the installation process and requirements for the new IPAM feature. You will also see some of the IPAM server options, and how to delegate access to IPAM and related tasks. This Video shows how to configure IP Address Management.

Microsoft Virtual Academy: Managing Data Deduplication | TechNet Video - This module is part of the Windows Server 2012: Storage course. This video shows how to manage Data Deduplication by excluding file types, scheduling out of hours and using the DDPEVAL tool.

Microsoft Virtual Academy: Windows Server 2012 Server Virtualization Part 2 | TechNet VideoThis video explains how you can achieve increased flexibility with virtual machine mobility. The video includes a demo of Shared Nothing Live Migration.

Microsoft Virtual Academy: Windows Server 2012 Server Virtualization Part 4 | TechNet Video – This video looks at the things Microsoft has done to work with Partners to increase the capabilities of Hyper-V. The video includes a demo of Managing Windows Server 2012 with System Center 2012 SP1.

Microsoft Virtual Academy: Windows Server 2012 Server Virtualization Part 5 | TechNet Video – This video explains how you can manage Isolation and Multitenancy in your organization with Windows Server 2012. The video includes a demo of Resource Metering of a Virtual Machine.

Microsoft Virtual Academy: Windows Server 2012 Storage Part 1 | Technet Video  – This video looks at the improvements that have been made in Storage within Windows Server 2012. The video includes a demo of Data Deduplication.

Microsoft Virtual Academy: Windows Server 2012 Storage Part 2 | Technet Video -This video covers Windows Server 2012 storage solutions that deliver continuous application availability. The video includes a demo of Cluster-Aware Updating.

Microsoft Virtual Academy: Windows Server 2012 Storage Part 3 | TechNet Video -This video explains how Microsoft have innovated with partners to maximize performance, scalability and choice. The video includes a demo of ODX.

Microsoft Virtual Academy: Windows Server 2012 Storage Part 4 | TechNet VideoThis video explains how Windows Server 2012 helps improve operational efficiency through simplified manageability.

Microsoft Virtual Academy: Windows Server 2012 Identity and Access Part 1 | TechNet VideoThis video explains how Windows Server 2012 helps IT Professionals manage their Identity and Access. The video includes a demo of Dynamic Access Control.

Microsoft Virtual Academy: Windows Server 2012 Identity and Access Part 2 | TechNet Video – This video covers Active Directory for the Cloud and the enhancements made in Active Directory in Windows Server 2012.

Microsoft Virtual Academy: Node Drain | TechNet VideoThis video shows how to use node drain to pause a Windows Server 2012 cluster node, ready for maintenance, and then to resume that node with all roles automatically failing back.

Microsoft Virtual Academy: Add Storage Space to Cluster Share Volumes | TechNet Video  – This video shows how to add a mirrored Storage Space to a Cluster Shared Volume in Windows Server 2012.

Microsoft Virtual Academy: BitLocker on Cluster Share Volumes | TechNet VideoThis video shows how to use BitLocker to encrypt a Cluster Shared Volume in Windows Server 2012.

Microsoft Virtual Academy: Add disk to CSV in Windows Server 2012 | TechNet VideoThis video shows how to add available disk storage to a Cluster Shared Volume in Windows Server 2012.

Microsoft Virtual Academy: Setting up Clustered Shared Volumes | TechNet VideoThis video shows how to configure Cluster Shared Volumes in Windows Server 2012.

Microsoft Virtual Academy: End to End Management | TechNet Video – This video shows how Windows Server 2012 gives a consistent management experience across all standard compliance storage arrays and has simplified the management of storage end-to-end.

Microsoft Virtual Academy: SMB 3. 0 High Performance Storage with Transparent Failover | TechNet Video  – This video shows SMB transparent failover in action using SQL Server running with 200,000 IOPs.

Microsoft Virtual Academy: Local Server Experience and Deployment Options | TechNet VideoThis module is part of the Windows Server 2012: Manageability & Automation course and covers the Standards-based management that is the foundation of the management experience in Window Server 2012, robust automation through PowerShell 3.0 and Multi-machine experience thought the new Server Management. This video focuses on Server Manager running on Minimal Server Interface.

Microsoft Virtual Academy: Live Migration of Virtual Machines with Nothing Shared | TechNet VideoThis video shows the new option in Windows Server 2012 to live migrate virtual machines between Hyper-V servers that do not share an infrastructure.

Microsoft Virtual Academy: Windows Server 2012 Web Application and Platform Part 1 | TechNet VideoThis video explains how Windows Server 2012 delivers an application platform that offers high performance and high density applications. The video includes a demo of Centralized Certificate Store.

Microsoft Virtual Academy: Windows Server 2012 Web Application and Platform Part 2 | Technet Video – This video looks at Non-Uniform Memory Architecture (NUMA) Scalability. The video includes a demo of CPU throttling and dynamic restrictions.

Microsoft Virtual Academy: Personalizing Your Experience with Server Manager | Technet Video  – This module is part of the Windows Server 2012: Manageability & Automation course and covers the new Server Manager in Window Server 2012. This video shows you how to customise the Server Manager Tools menu to suit your personal preferences.

Microsoft Virtual Academy: Deep Dive into Core Functionalities | Technet VideoThis module is part of the Windows Server 2012: Manageability & Automation course and covers the new Server Manager in Window Server 2012. This video shows the key features of the new Server Manager.

Microsoft Virtual Academy: Multi-Machine Server Management | TechNet VideoThis module is part of the Windows Server 2012: Manageability & Automation course and covers the Standards-based management that is the foundation of the management experience in Window Server 2012, robust automation through PowerShell 3.0 and Multi-machine experience thought the new Server Management. This videos shows how Server Manager in Windows Server 2012 improves the multi-machine server management experience for administrators.

Microsoft Virtual Academy: Live Migration between Clusters | TechNet VideoThis module is part of the Windows Server 2012: Server Virtualization and covers the new features in Windows Server 2012 Hyper-V related to virtual machine mobility and scale up technologies. This video shows the new option in Windows Server 2012 to live migrate virtual machines between two Windows Server 2012 clusters.

Microsoft Virtual Academy: Windows Server 2012 Networking Part 1 | TechNet Video - This video covers some of the networking features of Windows Server 2012 and how those features help customers to overcome networking challenges in their organizations.

Microsoft Virtual Academy: Windows Server 2012 Networking Part 2 | TechNet VideoThis video explains how Windows Server 2012 provides a simplified multitenant network infrastructure. The video includes a demo of Network Virtualization.

Microsoft Virtual Academy: Windows Server 2012 Networking Part 3 | TechNet VideoThis video looks at how Windows Server 2012 enables high-performance networking with current and next-generation hardware. The video includes a demo of Receive Segment Coalescing.

Microsoft Virtual Academy: Windows Server 2012 Networking Part 4 | TechNet VideoThis video covers operational efficiency through simplified manageability with Windows Server 2012. The video includes a demo of IP Address Management (IPAM).

Microsoft Virtual Academy: Windows Server 2012 Networking Part 5 | TechNet VideoThis video explains how to build a rich and diverse ecosystem with Windows Server 2012. The video includes a demo of Extensible Shift.

Microsoft Virtual Academy: Windows Server 2012 Networking Part 6 | TechNet VideoThis video summarizes how Windows Server 2012 can help overcome networking challenges in your organization.

Microsoft Virtual Academy: NIC Teaming in Windows Server 2012 | TechNet VideoThe module examine the new DHCP high availability solution, options for providing fault tolerance and higher bandwidth for network adapters, and how you can apply QoS within a Hyper-V environment in order to ensure predictability of network performance for virtual machine workloads. This Video show how to team NICs and change their properties.

Microsoft Virtual Academy: Windows Server 2012 Virtual Desktop Infrastructure Part 1 | TechNet VideoThis video explains the enhancements that have been made in Windows Server 2012 to Virtual Desktop Infrastructure. The video includes a demo of VDI deployment, administration and management.

Microsoft Virtual Academy: Windows Server 2012 Virtual Desktop Infrastructure Part 2 | TechNet VideoThis video covers the best value for VDI with key platform capabilities. The video includes a demo of User experience improvements in VDI.

Microsoft Virtual Academy: Windows Server 2012 Virtual Desktop Infrastructure Part 3 | TechNet VideoThis video summarizes how Windows Server 2012 enhancements have improved Virtual Desktop Infrastructure.

Microsoft Virtual Academy: Windows Server 2012 Web Application and Platform Part 3 | TechNet VideoThis video covers consistent and repeatable configurations and Ecosystem and Extensibility.

Exchange Storage Discussion | TechNet VideoThe UK Exchange team discuss storage in Exchange 2010.

UK Exchange Team Top Tips | TechNet VideoThe UK Exchange team discuss their top tips for Exchange 2010

Bytes by TechNet Sean Deuby and Harold Wong | TechNet VideoJoin Harold Wong, Senior IT Pro Evangelist for Microsoft, and Sean Deuby, Technical Director for Windows IT Pro and SQL Server Pro discuss Active Directory. Sean talks about what he feels will be the most impactful in Windows Server 8 like using Dynamic Access Control to set central access policy, claims based authorization and what the big deal is about VM Gen ID that is built into Hyper-V. Another amazing Bytes interview!

PS Session Reconnect via PowerShell Web Access | TechNet VideoWindows PowerShell supports disconnecting and reconnecting to Windows PowerShell sessions. You can start a session through Windows PowerShell Web Access on one device and then reconnect to that session later on the same or different device either through Windows PowerShell Web Access, PowerShell.exe, Windows PowerShell ISE, or another PowerShell host.

Customizing the Wizard Pages in MDT UDI | TechNet VideoSystem Center 2012 Configuration Manager OSD and MDT User-Driven Installation (UDI) work together to deploy Windows. This video shows from a developer perspective how to customize the wizard pages in MDT UDI. Watch this if you would like to code your own customizations into the pages.

Building Extensions for the MDT UDI Designer | TechNet VideoSystem Center 2012 Configuration Manager OSD and MDT User-Driven Installation (UDI) work together to deploy Windows. In this video, see how to build extensions for your deployment to further customize MDT UDI for your environment.

Configuring MDT UDI for Hardware Refresh Deployments | TechNet VideoSystem Center 2012 Configuration Manager OSD and MDT User-Driven Installation (UDI) work together to deploy Windows. In this video, see additional information on the MDT UDI Refresh Deployment Scenario, including language pack installations.

Microsoft Virtual Academy: (Part 1) Competitive Advantages of the Microsoft Private Cloud over the VMware Private Cloud | TechNet Video

Microsoft Virtual Academy: (Part 2) Competitive Advantages of the Microsoft Private Cloud over the VMware Private Cloud | TechNet Video

Microsoft Virtual Academy: (Part 3) Competitive Advantages of the Microsoft Private Cloud over the VMware Private Cloud | TechNet Video

Microsoft Virtual Academy: (Part 4) Competitive Advantages of the Microsoft Private Cloud over the VMware Private Cloud | TechNet Video

Microsoft Virtual Academy: (Part 5) Competitive Advantages of the Microsoft Private Cloud over the VMware Private Cloud | TechNet Video

Microsoft Virtual Academy: (Part 6) Competitive Advantages of the Microsoft Private Cloud over the VMware Private Cloud | TechNet Video

We will analyze how the cloud is traditionally built in a VMware environment using vSphere, and the vCenter server. Then taking this analysis further, we will show how Microsoft provides comparable solutions to these products, and to additional products such as vFabric Application Director and vCenter Operations Manager. You will learn how Microsoft can manage virtual machines in a more granular way, and monitor the performance of applications running in virtualized and in physical environments.

Microsoft Virtual Academy: (Part 1) Competitive Advantages of Hyper-V Server 2012 over VMware ESXi 5.0 | TechNet Video

Microsoft Virtual Academy: (Part 2) Competitive Advantages of Hyper-V Server 2012 over VMware ESXi 5.0 | TechNet Video

Microsoft Virtual Academy: (Part 3) Competitive Advantages of Hyper-V Server 2012 over VMware ESXi 5.0 | TechNet Video

Microsoft Virtual Academy: (Part 4) Competitive Advantages of Hyper-V Server 2012 over VMware ESXi 5.0 | TechNet Video

We will focus the demonstrations and presentation on Microsoft Hyper-V Server, the free product from Microsoft that contains the core hypervisor components.

We will detail how the core driver model works to enable interoperability with different hardware and software. We will discuss concepts such as Live Migration, and how IT administrators can move running virtual machines around between physical nodes within a cluster. Following this, we will demonstrate exactly how a cluster can be built within Hyper-V Server to provide high availability. Then we will cover how to run virtual machines on the clusters.

Microsoft Virtual Academy: (Part1) Competitive Advantages of Windows Server 2012 Hyper-V over VMware vSphere 5.0 | TechNet Video

Microsoft Virtual Academy: (Part 2) Competitive Advantages of Windows Server 2012 Hyper-V over VMware vSphere 5.0 | TechNet Video

Microsoft Virtual Academy: (Part 3) Competitive Advantages of Windows Server 2012 Hyper-V over VMware vSphere 5.0 | TechNet Video

Microsoft Virtual Academy: (Part 4) Competitive Advantages of Windows Server 2012 Hyper-V over VMware vSphere 5.0 | TechNet Video

We will look specifically at Hyper-V and how it competes effectively against VMware vSphere 5 when building virtualized infrastructures.

This session will focus first on scalability, performance and density. Then we will look at multi-tenancy and the improvements we have made around security and networking. We will look at how Hyper-V can power an agile infrastructure, giving you flexibility to move workloads around better than before. Finally, we will look at the different levels of availability and resiliency built-in to Hyper-V, and how they can provide the best platform for your mission critical applications and workloads.

Microsoft Virtual Academy: (Part 1) Competitive Advantages of System Center 2012 over VMware’s Management Technologies | TechNet Video

Microsoft Virtual Academy: (Part 2) Competitive Advantages of System Center 2012 over VMware’s Management Technologies | TechNet Video

Microsoft Virtual Academy: (Part 3) Competitive Advantages of System Center 2012 over VMware’s Management Technologies | TechNet Video

Microsoft Virtual Academy: (Part 4) Competitive Advantages of System Center 2012 over VMware’s Management Technologies | TechNet Video

We will take an in-depth look at the technologies and how they map to a private cloud strategy, comparing the VMware vCloud and System Center 2012.

We will cover several key areas of management including VM management, monitoring, service management, self-service automation, and configuration management. The presentation and demonstrations will evaluate the competing products component-by-component, and how each brings their own benefits. In addition, we will address the concept of protection, and how it is a central part of the private cloud infrastructure protecting virtualized and non-virtualized environments.

Hope you have a great learning time with these links and resources. Feel free to drop a comment anytime.

Continue reading...


 

What is new in Windows Server 2012 October 4th, 2012

Vinod Kumar

With the release of Windows Server 2012, there is so much to learn from each version and this release is no excuse. In this post, let us look at some of the enhancements done with Windows Server 2012 for reference. There are some interesting features introduced for SQL Server 2012 too and we will look at it in future posts.

What’s New in Active Directory Domain Services (AD DS)
Active Directory Domain Services (AD DS) in Windows Server 2012 includes new features that make it simpler and faster to deploy domain controllers (both on-premises and in the cloud), more flexible and easier to both audit and authorize access to files, and easier to perform administrative tasks at scale, either locally or remotely, through consistent graphical and scripted management experiences.

  1. Dynamic Access Control (DAC), permissions based on AD attribute eg. Location, Department

What’s New in BitLocker
BitLocker encrypts the hard drives on your computer to provide enhanced protection against data theft or exposure on computers and removable drives that are lost or stolen.

  1. Used Disk Space Only encryption allows for a much quicker encryption experience
  2. Support for Encrypted Hard Drives for Windows

What’s New in BranchCache
BranchCache in Windows Server 2012 and Windows 8 provides substantial performance, manageability, scalability, and availability improvements.

  1. Data De-duplication, duplicate content is stored once and downloaded once

What’s New in Failover Clustering
Failover clusters provide high availability and scalability to many server workloads. These include file share storage for server applications such as Hyper-V and Microsoft SQL Server, and server applications that run on physical servers or virtual machines.

  1. Scalability, Scales to 64 nodes and 4,000 virtual machines per cluster
  2. Cluster-Aware Updating, applies software updates across the cluster nodes while maintaining availability
  3. Scale-Out File Servers, provides CSV storage and integrates with File Services features to support scalable, continuously available application storage
  4. Dynamic Quorum, simplifies quorum setup and increases the availability

What’s New in File Server Resource Manager
File Server Resource Manager provides a set of features that allow you to manage and classify data that is stored on file servers.

  1. File Classification, automatic classification processes

What’s New in Hyper-V
The Hyper-V role enables you to create and manage a virtualized computing environment by using virtualization technology that is built in to Windows Server 2012. Hyper-V virtualizes hardware to provide an environment in which you can run multiple operating systems at the same time on one physical computer, by running each operating system in its own virtual machine.

  1. Client Hyper-V, now available in a desktop operating system
  2. Hyper-V Replica, replicate virtual machines between storage systems
  3. Live migration, perform a live migration in a non-clustered environment
  4. Scale and resiliency, significantly larger compute and storage resources
  5. SMB 3.0 file shares, SMB 3.0 file shares to provide storage for virtual machines
  6. Virtual switch, open framework that allows third parties to add new functionality, extensible capabilities to connect virtual machines to the physical network

What’s New in Networking
Discover new networking technologies and new features for existing technologies in Windows Server 2012. Technologies covered include BranchCache, Data Center Bridging, NIC Teaming, and more.

  1. SMB 3.0 and RDMA, very fast inter-process communication (IPC) and inter-computer communications
  2. Network (IP) virtualization and Virtual switch, decouples virtual networks for customer virtual machines from the physical network infrastructure
  3. NIC teaming, bandwidth aggregation and traffic failover
  4. Quality of Service, deliver predictable network performance to virtual machines
  5. DirectAccess and RRAS, new Remote Access server role allows for centralized administration, configuration, and monitoring

What’s New in Remote Desktop Services
The Remote Desktop Services server role in Windows Server 2012 provides technologies that enable users to connect to virtual desktops, RemoteApp programs, and session-based desktops. With Remote Desktop Services, users can access remote connections from within a corporate network or from the Internet.

  1. Fairshare experience (Network, Disk, and CPU), one user does not negatively impact the performance of another user’s session
  2. Multi-Touch RDP

What’s New in Smart Cards
Smart cards and their associated personal identification numbers (PINs) are an increasingly popular, reliable, and cost-effective form of two-factor authentication. With the right controls in place, a user must have the smart card and know the PIN to gain access to network resources.

  1. Virtual smart cards, emulate the functionality of traditional smart cards

PowerShell 3.0 and ISE, improved IDE eg. Intellisense

Storage Spaces, virtualize storage by grouping industry-standard disks into storage pools (thin provisioning)

SQL on SMB, store clustered user database files on SMB file shares

Hope these will make a good weekend reads. If you feel we missed something significant from Windows Server 2012 in this post, feel free to write it over the comments.

UPDATE: Links and resources to Microsoft Virtual Academy Courses on Windows Server 2012.

Continue reading...


 

Contained Databases inside SQL Server 2012 October 3rd, 2012

Vinod Kumar

Recently I was reading one of the blog post from Pinal around “Importance of users without Logins” and this triggered this post. The concept of contained databases are lesser known inside SQL Server 2012 release and hardly mentioned. In this post let me introduce what Contained Databases are and explain some of the benefits.

Before we hit the basics, it is important to understand what are the different things applications require from the database? Apart from the database, data and some logics (SP’s, functions, triggers etc) there are also components that live outside the scope of the application database. Some of them include:

  1. Logins: Maintained in the master DB.
  2. Temp tables: T-SQL code use them and are manipulated in the tempDB Database.
  3. Jobs: These can be agent jobs for specific automation or day end jobs for cleansing.
  4. Error Messages: Custom error messages are stored inside the master DB.
  5. Linked Servers: These are stored in the master database.

There can be other things that get missed from the above list. But the problem starts when this application needs to be moved around between environments for system upgrades, high availability, consolidation or load balancing etc reasons. Before SQL Server 2012 there was no systematic process to take these items along in this situation. The biggest downfall today is to have significant familiarity with all these moving components and to manually set them on each of the environments. I am not trying to make this sound really bad, but these are things to keep in mind even today.

Partial Containment in SQL Server 2012

Now that we know the basics of why and need for some changes, let me introduce the containment concept. SQL Server 2012 introduces partial containment concept which introduces an application boundary around the database yet allowing features that cross the application boundary to be accessible. As the name suggests, in this release we have the contained authentication and some subtle collation dependencies added. This means:

  1. We can have a new SQL User with a password part of the contained authentication.
  2. Now tempDb objects don’t use the default collation of tempDB but uses that defined with the contained database.

I feel this is a great start atleast. In the future, we can see enhancements going into this feature to make it more complete by adding all the application objects into the containment boundary. Only the future releases will define these, let us see what we have in hand.

Enable Contained Databases at Instance level

Using SQL Server Management Studio, the steps are simple.

  1. In Object Explorer, right-click the server name, and then click Properties.
  2. On the Advanced page, in the Containment section, set the Enable Contained Databases option to True.
  3. Click OK.

image

If you would like to script this step and use it part of your application deployment strategy.

EXEC sp_configure ‘show advanced options’, 1 ;
GO
RECONFIGURE ;
GO
EXEC sp_configure ‘contained database authentication’, 1;
GO
RECONFIGURE ;
GO
EXEC sp_configure ‘show advanced options’, 0 ;
GO
RECONFIGURE ;
GO

The above option enables both contained databases and contained authentication.

Creating a Partially Contained Database

Just like the option with the Server node, there is a containment type option that has been added to the existing database options. The same can be set in the database properties –> Options page like the image below:

image

From a T-SQL perspective, you can use the option extended part of the CREATE Database command to enable the same.

CREATE DATABASE database_name
[ CONTAINMENT = { OFF | PARTIAL } ]
[ ON
[ PRIMARY ] <filespec> [ ,...n ] ….

Now coming for existing databases to be converted to contained databases, there are few steps to be taken. I would highly recommend to check if there are any containment errors that might come before this step. The first and simplest way would be to use the DMV (sys.dm_db_uncontained_entities). Just run:

select * from sys.dm_db_uncontained_entities

Some of the Dynamic SQL cannot be determined till the run time and can be ignored or needs further attention. To pick these errors at runtime use the database_uncontained_usage Xevent if needbe. Since this XEvent will fire for actual uncontained entities at run time, it will not identify any uncontained user entities that you have not run.

Once the errors have been eliminated and we are sure the database is safe to be turned into contained database, use the SQL Server Management Studio to do the same or use the below T-SQL.

USE [master]
GO
ALTER DATABASE [AdventureWorks2012] SET CONTAINMENT = PARTIAL
GO

Once this step has been performed, check if the same has taken effect. The two columns namely containment and containment_desc can be used to determine the containment state of the databases.

SELECT containment, containment_desc FROM sys.databases
WHERE name like ‘AdventureWorks2012′

Next step would be to Migrate your existing logins to be converted to SQL users for contained databases. This can be done using the SP sp_migrate_user_to_contained. A typical login called “AppUser” can be converted like below:

EXECUTE sp_migrate_user_to_contained
        @username = ‘AppUser’,
        @rename = N’keep_name’,
        @disablelogin = N’disable_login’;

If you would like to find out specific Logins associated with users inside a given database, feel free to use the below query:

SELECT dp.name
       FROM sys.database_principals AS dp
       JOIN sys.server_principals AS sp
       ON dp.sid = sp.sid
       WHERE dp.authentication_type = 1 AND sp.is_disabled = 0;

Creating Contained Users

We started this blog post talking about users without logins. Contained users are new and authenticated inside SQL Server 2012 and can be of 3 types.

  1. User based on a Windows user who has no login.
  2. User based on a Windows group that has no login.
  3. Contained database user with password.

To create a new contained user, under the Security node inside the Database node you have the New –> User option.

image

Once inside the dialog, Select either SQL user with password or Windows user. On the General page, enter a name for the new user in the User name box and click OK.

image

To do the same operation inside T-SQL, feel free to use the below syntax. You can see we have not referenced the Login here for the user. For a contained DB this will be an contained user.

CREATE USER MyDBUser
WITH PASSWORD = ‘my$tr0ngPwd’;
GO

How are Users Authenticated?

For SQL Server authentication in a contained database, the connection must specify an initial catalog and the authentication in this scenario is first attempted against the contained user. In event of no such user exists, SQL Server will fall back to check the authentication at the server level. If the user or password donot match then the authentication will fail.

The concept is similar incase of Windows authentication too but the order is reversed as the first check is done at the server level and then at the DB level.

Final thoughts

I think this is a great start to understand contained databases to start with. Do try to play around with this feature and drop a line if they are making interesting scenario’s for you. We have refrained from talking about other fine prints and scenarios of duplicate names (Login ID), tempDB objects, Collation etc in this post. We will reserve the same for a later post.

Hope this post makes it easy to understand what contained databases are, how to create contained users and what are some of the fine prints to understand. Your comments are most welcome.

Continue reading...


 

Microsoft Lync 2010 Resources to bookmark September 7th, 2012

Vinod Kumar

In continuation to the resources and links on other technologies, here is yet another set of links for Microsoft Lync. Lync is an enterprise-ready unified communications platform. With Lync, users can keep track of their contacts availability; send an IM; start or join an audio, video, or web conference; or make a phone call—all through a consistent, familiar interface. Lync is built to fully integrate with Microsoft Office. More and more I work with this technology it just increases the productivity at work. Feel free to subscribe to the blog feed via email to get the latest updates.

Videos and Webcasts

Designing Lync Jump Start

Deploying Lync Jump Start

Lync 2010 Demos and Interview

Lync in an Enterprise Network

Lync Server 2010 Deployment Best Practices

Edge Show 12 – Enterprise voice and collaboration on any device with Lync

"How Do I" Videos

  1. Lync Server Planning Tool: Part 1 – Design a Site and Create a Topology
  2. Lync Server Planning Tool: Part 2 – Prepare Data for Import into Topology Builder
  3. Topology Builder: Create Your First Pool
  4. Topology Builder: Add an Edge Server
  5. Topology Builder: Deploy a Standalone A/V Conferencing Server
  6. Deploy Enterprise Voice (Part 1)
  7. Deploy Enterprise Voice (Part 2)
  8. Migrating from Office Communications Server 2007 to Lync Server 2010
  9. Migrating from Office Communications Server 2007 R2 to Lync Server 2010
  10. System-Wide Troubleshooting: Lync Call Issues
  11. Monitoring and Managing Jitter for VoIP

TechNet Radio: An Introduction to Lync Mobile Features

Increase the value of your Lync environment by using monitoring, PowerPivot, and Power View

Unified Communications (TechNet Video)

What’s new in Microsoft Lync 2010

What’s New with Lync 2010

  1. What’s new in deployment in Lync 2010
  2. What new with voice in Lync 2010
  3. What’s new in Lync 2010 Server
  4. What’s new in Clients, Devices, Architecture & Interoperability in Lync 2010
  5. What’s new in Microsoft Lync IM and Presence
  6. What’s new in OCS 14 High Definition
  7. What’s new in OCS 14 Client Extensibility
  8. What’s new in OCS 14 Enterprise Voice

Introduction and UC Vision – Why Lync?

How to manage, migrate and maintain your Lync 2010 infrastructure & UC applications

Virtualization and Lync Server 2010

UC Managed API 3.0 with Lync Server 2010

How to secure remote access to your ocs/lync environment

Datacenter & Branch Resiliency in Lync

Unified Communications "14" Labs
  1. Session 1 – Getting Started with Microsoft Lync Server 2010 and Exchange Server 2010 Development
  2. Session 2 – Integrating Microsoft Lync 2010 Features with the Lync Controls
  3. Session 3 – Part 1 – Building Contextual Conversation Applications with the Microsoft Lync 2010 Managed API
  4. Session 3 – Part 2 – Extending the Lync 2010 Conversation Window with the Microsoft Lync 2010 Managed API
  5. Session 4 – Part 1 – Introducing the Lync 2010 Managed API
  6. Session 4 – Part 2 – Starting Microsoft Lync 2010 Conversations Using the Microsoft Lync 2010 Managed API
  7. Session 4 – Part 3 – Using the Microsoft Lync 2010 Object Model
  8. Session 5 – Part 1 – Getting Started with the Exchange Web Services Managed API 1.0
  9. Session 5 – Part 2 – Working with Extended Properties Using the Exchange 2010 Managed API 1.0
  10. Session 5 – Part 3 – Working with the Exchange Free/Busy Service Using the Exchange Web Services Managed API 1.0
  11. Session 5 – Part 4 – Exchange Notifications Using the Exchange Web Services Managed API 1.0
  12. Session 6 – Part 1 – Introduction to the UCMA 3.0 SDK
  13. Session 6 – Part 2 – Anatomy of a UCMA 3.0 Application
  14. Session 6 – Part 3 – Call Control and Presence Events Using UCMA 3.0
  15. Session 7 – Part 1 – Introduction to the UCMA 3.0 Workflow SDK
  16. Session 7 – Part 2 – Anatomy of a UCMA 3.0 Workflow
  17. Session 7 – Part 3 – UCMA 3.0 Workflow SDK Speech and DTMF Grammars
  18. Session 7 – Part 4 – UCMA 3.0 Workflow Prompts, Events and Commands
  19. Session 8 – Part 1 – Building Advanced Communications Solutions with UCMA 3.0
  20. Session 8 – Part 2 – UCMA 3.0 Advanced Communications with Conference Services and Audio Routes
  21. Session 8 – Part 3 – UCMA 3.0 Advanced Communications Using Application Endpoint Draining
  22. Session 9 – Microsoft Lync Server 2010 and Exchange Server 2010: Architecture and Deployment
On-Demand Webcasts
  1. Business Insights Webcast: Introduction to Microsoft Lync 2010
  2. Business Insights Webcast: Making the Switchto Software-Based VoIP
  3. Business Insights: Voice, Video, and Data Conferencing with Microsoft Lync
  4. Deep Dive: Lync Server 2010 Conferencing
  5. Microsoft Lync 2010 High Availability and Resiliency
  6. Microsoft Lync 2010 Voice Deployment
  7. Lync Server 2010: Implementing Call-Admission Control
  8. Lync Server 2010 Architecture Topologies
  9. Lync Server 2010: Migration and Coexistence
  10. Lync Server 2010: Role-Based Access Control (RBAC)
  11. Microsoft Lync Server 2010 Interoperability: Voice, Video, Conferencing, IM, and Presence
  12. Microsoft Lync Server 2010: Transforming the Way People Communicate

Articles and Documentation

Microsoft Lync Server 2010

    1. Glossary
    2. Introduction to Lync Server 2010
    3. New Server Features
    4. New Client Features
  • Planning
      1. Planning Primer: Planning for Your Organization
      2. Determining Your Infrastructure Requirements
      3. Capacity Planning
      4. Planning for IM and Presence
      5. Planning for Conferencing
      6. Planning for External User Access
      7. Planning for Enterprise Voice
      8. Planning for Monitoring
      9. Planning for Archiving
      10. Planning for Virtualization, Management, and Other Features
      11. Planning for Group Chat Server
      12. Planning for Clients and Devices in Lync Server 2010
      13. Planning for Remote Call Control
      14. Planning for Metropolitan Site Resiliency
      15. Planning for Mobility
  • Supportability
      1. Active Directory Support
      2. Supported Lync Server 2010 Topologies
      3. Supported Server Collocation
      4. Supported Migration Paths and Coexistence Scenarios
      5. Supported Hardware
      6. Server Software and Infrastructure Support
      7. Additional Server Support and Requirements
      8. Client and Device Software and Infrastructure Support
  • Deployment
      1. Preparing Active Directory Domain Services for Lync Server 2010
      2. Deploying Lync Server 2010
      3. Deploying Edge Servers
      4. Deploying a Stand-alone A/V Conferencing Server
      5. Deploying Enterprise Voice
      6. Deploying Mobility
      7. Configuring Dial-in Conferencing
      8. Configuring Call Park
      9. Configuring Response Group
      10. Configuring Announcements for Unassigned Numbers
      11. Deploying Branch Sites
      12. Deploying Monitoring
      13. Deploying Archiving
      14. Deploying Group Chat Server
      15. Deploying Clients and Devices
      16. Updating From the Evaluation Version of Microsoft Lync Server 2010
      17. Deploying Remote Call Control
      18. Deploying Lync Server 2010 in a Multiple Forest Environment
  • Migration
      1. Migration from Office Communications Server 2007 R2 to Lync Server 2010
      2. Migration from Office Communications Server 2007 to Lync Server 2010
      3. Migrating Group Chat Server
  • Operations
      1. Lync Server Administrative Tools
      2. Lync Server Control Panel
      3. Lync Server Management Shell
      4. Administering Group Chat Server
      5. Administering the Address Book Service
      6. Configuring Federation Support for a Lync Online 2010 Customer
      7. Managing and Troubleshooting Devices
      8. Enabling Quality of Service (QoS)
      9. Using Monitoring Server Reports
      10. Monitoring Mobility for Performance
      11. Backing Up and Restoring Lync Server 2010
      12. Troubleshooting Lync Server 2010 Control Panel
      13. Uninstalling Lync Server 2010 and Removing Server Roles
  • Security
      1. Key Security Enhancements in Lync Server 2010
      2. Common Security Threats for Lync Server 2010
      3. Security Framework for Lync Server 2010
      4. Addressing Threats to Your Core Infrastructure for Lync Server 2010
      5. Addressing Threats at Your Internet Boundary for Lync Server 2010
      6. Addressing Threats to On-Premises Conferences for Lync Server 2010
      7. Addressing Threats to Group Chat
      8. Addressing Threats to Lync Web App
      9. Addressing Threats to Enterprise Voice for Lync Server 2010
      10. Securing Clients for Lync Server 2010
      11. Additional Security Resources for Lync Server 2010
  • Troubleshooting
      1. Troubleshooting Clients
      2. Troubleshooting Devices
      3. Troubleshooting Lync Server 2010 Control Panel
  • Reference
      1. Call Detail Recording (CDR) Database Schema
      2. Quality of Experience (QoE) Database Schema
      3. Group Chat Database Schema
      1. Lync Server 2010 Logging Tool
      2. Using Lync Server 2010, Best Practices Analyzer
      3. Lync Server 2010 Stress and Performance Tool
  • Microsoft Lync 2010 Dev Center
      1. Lync 2010 SDK Documentation
      2. Lync Server 2010 SDK Documentation
      3. Lync Server 2010 Group Chat SDK Documentation
      4. Unified Communications Enhanced Presence Schemas for Lync Server 2010 Documentation
      5. Unified Communications Managed API 3.0 Core SDK Documentation
      6. Unified Communications Managed API 3.0 Workflow SDK Documentation
      7. Technical Articles

    Virtual Labs

    TechNet Virtual Lab: Microsoft Lync Server 2010 Enterprise Voice Configuration

    TechNet Virtual Lab: New Enterprise Voice Features of Microsoft Lync Server 2010

    TechNet Virtual Lab: Exchange Server 2010 SP1 Unified Messaging and Lync Server 2010 Integration

    TechNet Virtual Lab: The Microsoft Lync 2010 Unified Client

    MSDN Virtual Lab: Advanced UCMA 3.0 Development

    MSDN Virtual Lab: Getting Started with the UCMA 3.0 Workflow SDK

    MSDN Virtual Lab: Getting Started with the EWS Managed API 1.0

    MSDN Virtual Lab: Integrating Microsoft Lync 2010 Functionality

    MSDN Virtual Lab: Introduction to the Microsoft Lync 2010 Managed API

    MSDN Virtual Lab: Introduction to the Unified Communications Managed API 3.0

    MSDN Virtual Lab: Launching Contextual Conversations from the Lync Controls

    Other links and resources

    Lync Samples: Learn Through Code

    Lync for developers

    Microsoft Lync Homepage

    Microsoft Lync Partner Network

    Lync Adoption and Training Kit

    The Lync Team Blog

    The Microsoft Lync Blog

    DrRez: Microsoft Lync Server Technical Reference Hub

    Microsoft Lync Server Documentation Hub

    Lync Server 2010 PowerShell

    SIP Stories

    Lync Server Forums

    Downloads

    Lync 2013 Preview

    These resources are provided "as is" since at the time of this writing Lync 2013 has not yet been released.

    Articles and Documentation

      1. Accessibility for People with Disabilities
      2. Getting Started
      3. Planning
      4. Supportability
      5. Deployment
      6. Migration
      7. Operations
      8. Lync Server Hybrid Deployments
      9. Schema Reference
      10. Glossary
  • Microsoft Lync 2013 Dev Center (Preview)
      1. Lync 2013 Preview SDK Documentation
      2. Lync Server 2013 Preview SDK Documentation
      3. Lync Server 2013 Preview Persistent Chat SDK Documentation
      4. Unified Communications Enhanced Presence Schemas for Lync Server 2013 Preview Documentation

    Downloads

    Continue reading...


     

    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
    0×00000000224000 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...


     

    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...