password
username
Sponsored by CakeMail, an email marketing software.
Newsletter preview

Mobile  |  View this email as a web page Please add SQL Server Magazine Update to your
Safe Sender list.

SQL Server Magazine Update
Subscribe Now

This email newsletter comes to you free and is supported by the following advertisers, which offer products and services in which you might be interested. Please take a moment to visit these advertisers' web sites and show your support for SQL Server Magazine.

Red Gate SQL Backup Pro
How can you work faster, smarter?

HiT Software
Perform database integration with SQL Server and other major databases quickly and cost-effectively! Excellent customer support, easy implementation. Download free software trial!

Perspectives
  Multiserver Management with SQL Server 2008's Central Management Server
Community
  SQL Server Magazine Instant Poll
  Take a Look at This Article in the February Issue of SQL Mag
  SQL Server BI: Tomorrow's Microsoft BI Platform
Events and Resources
  Events and Resources

Sponsor: Red Gate SQL Backup Pro

How can you work faster, smarter?

2009 looks set to be the year for budget- and time-conscious DBAs to make the most of their office hours. And that's why Exceptional DBAs love Red Gate SQL Backup Pro. Its faster, smaller, secure backups mean DBAs can create high-performance backup routines, with more time left over for professional development and learning new skills. Find out how you too can work faster, smarter, and download a free 14-day trial of award-winning SQL Backup Pro now.

Perspectives


Multiserver Management with SQL Server 2008's Central Management Server

Kalen De***y, kalen@insidesqlserver.com

My friend Lara Rubbelke, who works for Microsoft in Minneapolis, sent me an email message the other day asking me what I’ve heard from my students and other contacts about one of her favorite SQL Server 2008 features called Central Management Server (CMS). I remembered that I’d seen this feature in a few demonstrations prior to the general release of SQL Server 2008, but I had to reluctantly admit that I hadn’t really spent much time exploring this feature and hadn’t seen a lot of discussion about it, at least not on the blogs that I read. So maybe it’s time to change that.

One of the nicest things about having a CMS is that DBAs and users across an enterprise can have the same registered servers available in SQL Server Management Studio (SSMS). In SSMS 2005, each client stores its own local server groups, so each person in an organization might have different server groups and instances available. When moving to a new client machine, you have a completely different setup of available servers and basically have to start from scratch.

If you set up a CMS in SSMS, you can define server groups and then the definition of your groups will be stored in the msdb database of the server that you’ve defined as the CMS. Then anyone choosing the same servers as the CMS will automatically have the same server groups defined and available. You can take advantage of this feature even if you’re not using SQL Server 2008 in production yet, all you need is SSMS 2008. You can add instances of SQL Server 2000 or later to the server groups managed by your CMS.

Click here to read the rest of Multiserver Management with SQL Server 2008's Central Management Server

Sponsor: HiT Software

Perform database integration with SQL Server and other major databases quickly and cost-effectively! Excellent customer support, easy implementation. Download free software trial!

Read how to set up powerful yet easy-to-use database replication between Microsoft SQL Server 2008 and IBM DB2! HiT Software’s DBMoto database replication solution delivers all the features you need for fast implementation, programming-free maintenance and worry-free replication! Download the free white paper "Integrating Microsoft SQL Server with IBM i."

Community


SQL Server Magazine Instant Poll

What is your favorite type of SQL Server Magazine article?

Go to the SQL Server Magazine home page (www.sqlmag.com) and submit your vote for:

  • Step-by-step technical articles
  • Interviews with SQL Server experts
  • Product reviews where two or more products are compared
  • Reader to reader articles that report on field-tested fixes
  • Articles about how IT can continue to add business value in a down economy
  • Tips and tricks articles



Take a Look at This Article in the February Issue of SQL Mag

More Options for Handling Arrays as Inputs
by Itzik Ben-Gan

Use a Common Language Runtime (CLR) split user-defined function (UDF) or SQL Server 2008’s new table-valued parameters to handle arrays as inputs.
http://www.sqlmag.com/Article/ArticleID/100975/sql_server_100975.html


SQL Server BI: Tomorrow's Microsoft BI Platform

by Derek Comingore
A Current Forecast of the Next Generation Microsoft Business Intelligence Platform.

Click here to read the rest of SQL Server BI: Tomorrow's Microsoft BI Platform

Events and Resources


Events and Resources

Oracle Enterprise 2.0 European Virtual Conference—February 19, 2009
How can traditional portals and existing content management solutions go one step further? Will solid and affordable current information systems meet the flexibility and speed of the collaborative tools that every worker requires? Learn more at Oracle's first E2.0 Live Virtual Conference! Registration is free. Sessions available in five languages.

Register for this free event


Empower Your Processes with PowerShell!
Join MVP Paul Robichaux on February 26, 2009, at 11:00 AM Eastern time as he equips you with PowerShell how-tos in 3 informative lessons—all on your own computer! For only $99, you'll learn how to

  • execute commands a set number of times or until a preset condition changes
  • master tools for formatting and displaying data
  • import and export data in CSV and XML formats
and much more!

Seats are limited to allow for lots of live Q&A at the end. Register today!


WinConnections, March 15-18, 2009, Orlando, Florida 9
The first 500 paid attendees receive SQL Server 2008 Standard Edition with one CAL. Windows Connections will be co-located with Microsoft Exchange Connections. Register for one event and attend sessions of the concurrent event FREE.
Sign up now!



FEATURED WHITE PAPER
Find the Right SSL Solution for Your Security Needs
Secure Sockets Layer (SSL) is the world standard for web security. In this white paper, we discuss the latest SSL advances such as server gated cryptography, Extended Validation SSL, and third-party trust marks to help you decide which would be best for your organization.
Download this white paper today to explore these SSL solutions.



ANNOUNCEMENTS
Yesterday's Data Transfer Isn't Sufficient for Today's Business
A new approach to data transfer is critical to the success of your business. Change data capture (CDC) is an innovative new software technology that is changing the data integration landscape. In this free white paper, you’ll learn about the need for CDC, typical use cases, and the ideal CDC solution for your business based on your unique needs.

Download today and take advantage of this new information-management development!


Manage Cost in Your Enterprise with Business Process Automation
Discover the basics of business process automation, how BPA tools work, and how they can benefit both IT and overall business efficiencies. You'll learn where BPA can fit into your existing business process model, how BPA differs from other basic scripting and scheduling techniques, and what benefits your business model can derive from implementing a BPA solution.

Download this free eBook today and make your enterprise more efficient.


Windows IT Pro Master CD New Release: Take the Experts with You!
Find the solutions you need within the thousands of searchable articles, helpful bonus content, and loads of expert advice on the Windows IT Pro Master CD. A Master CD subscription buys you portable access to the entire Windows IT Pro article database plus access to all the new articles that we publish exclusively on WindowsITPro.com every day. It's like having a team of consultants in your pocket! Get real-world solutions fast—order the Windows IT Pro Master CD today.
Subscribe now!

Contact Us

Subscribe to SQL Server Magazine


SQL Server Magazine UPDATE is brought to you by SQL Server Magazine, the only magazine devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today. subscribe


To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add SQLServerMag_UPDATE@lists.sqlmag.com to your list of allowed senders and contacts.

Manage Your Account
You are subscribed as tayllorcriss@gmail.com.
To *** from this email newsletter, click here


To manage your email account, simply log on to our Email Preference Center.
Manage

View SQL Server Magazine's privacy policy.
Privacy

SQL Server Magazine is a division of Penton Media, Inc.
221 East 29th Street
Loveland, CO 80538
Attention: Customer Service Department

Copyright 2009, Penton Media, Inc. All Rights Reserved.