Project Plans


The A-Z on planning, implementing and management of technology migrations.

SQL Server Pro


Migrating to SQL Server 2012

SQL Server 2012 includes several groundbreaking new features, such as AlwaysOn and Power View, that customers want to take advantage of in their environments. This Project Plan walks customers through the process of planning for and migrating to SQL Server 2012, and then walks customers step-by-step through the process of implementing each of the key new features in this release.

Details

SQL Server 2008 & 2008 R2 Migration

This SQL Server Magazine Project Plan is a comprehensive online guide to help you successfully upgrade to Microsoft SQL Server 2008 R2. If you haven't installed SQL Server yet, we suggest you begin with the "Planning" section of this site to familiarize yourself with some of the significant changes in the latest software release.

Details

Windows IT Pro


Migrating to Windows Server 2012

Anytime Microsoft rolls out a new OS, IT professionals face a learning curve. With Server 2012, there are numerous new features and enhancements that IT pros will want to leverage. Server 2012 has the biggest and the fundamentally most important changes in Windows Server since Windows 2000. The entire management paradigm has completely changed.

Details

I Installed System Center 2012: Now What?

System Center 2012 is Microsoft’s gigantic systems management suite, comprised of Orchestrator, Virtual Machine Manager, App Controller, Operations Manager, Configuration Manager, Service Manager, and Data Protection Manager. It’s a sprawling product that IT pros will need guidance to understand.

Details

How to Implement IPv6 in Your Windows Server Environment

Although IPv4 is the foundation upon which the Internet is built, it’s mathematically running out of addresses. IPv6 is your inevitable future, a new protocol that will drastically increase the number of available addresses, as well as introduce new features to make the IPv6-enabled Internet more scalable. In this project plan, you’ll learn about the inherent problem of IPv4 web, learn how to begin your transition to IPv6, and start getting the most out of the new addressing scheme in the latest Windows Server releases.

Details

Exchange Server 2010 Migration

Microsoft Exchange Server 2010 migration is a big project. This Windows IT Pro Project Plan will walk you through the process, from planning which of Exchange 2010's features to implement, through the steps of the actual migration process, and on into the new administration practices that Exchange 2010 brings with it.

Details

Dev Pro


Using HTML5 and jQuery for Practical Web Development

HTML5 brings new benefits such as improved accessibility, the ability to write cleaner code, the ability to include more interactive elements than ever before, and better cross-platform support. This project plan is meant to help web developers understand how to leverage HTML5 and jQuery effectively to start taking advantage of those benefits today.

Details

 

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×