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.

NEW! Free Trial of Total Data Quality for SQL Server 2008

Business Process Automation: Managing Cost in Your Enterprise
Perspectives
  SQL Server 2008 System Views Map Availability and More
Community
  SQL Server Magazine Instant Poll
  Check Out These Articles in the March Issue of SQL Mag
  See What Your Peers are Discussing on the SQL Server Magazine Forums
  Product Watch: Developer Training Solutions Without the Instructor
Events and Resources
  Events and Resources

Sponsor: Melissa Data

NEW! Free Trial of Total Data Quality for SQL Server 2008

Learn about the full range of data transformation and cleansing functionality available in the Total Data Quality Integration Toolkit for SSIS. View demonstration videos on Profiling, Parsing, Cleansing, Matching, and Monitoring – then request your free trial of the most affordable, single platform solution for your data quality and MDM initiatives.

Learn more now

Perspectives


SQL Server 2008 System Views Map Availability and More

by Brian Moran, bmoran@solidq.com

Microsoft published the SQL Server 2008 System Views Map a few weeks ago, and it’s available for download from www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en. Kudos to Boris Baryshnikov from Microsoft for pulling the poster together with support from SQL Server MVP Ron Talmage. These posters are perennial favorites within the SQL Server community, so I’m sure you’ll want to grab a copy. You can download the file in PDF or XPS format from Microsoft, although you’ll be stuck with a lot of taped together pages if you’re want the poster to grace your wall for easy reference. You can’t order a printed version directly from Microsoft, but Kinko’s or a commercial printer can get you a copy suitable for hanging on your wall. Also, SQL Server Magazine told me it’s working on making print copies of the System Views Map available through Left-Brain.com, Penton Media’s new storefront. I don’t know when the poster will be orderable, but I’ll be sure to let you know once it’s available on Left-Brain.com. I know many of you are still running SQL Server 2005, and there’s a system table poster available for that version as well at www.microsoft.com/downloads/details.aspx?familyid=2EC9E842-40BE-4321-9B56-92FD3860FB32&displaylang=en.

While we’re on the topic of documentation, I would also like to point out that a new version of SQL Server 2008 Books Online (BOL) is now available at www.microsoft.com/downloads/details.aspx?familyid=765433F7-0983-4D7A-B628-0A98145BCB97&displaylang=en.

Click here to read the rest of SQL Server 2008 System Views Map Availability and More

Sponsor: Windows IT Pro

Business Process Automation: Managing Cost in Your Enterprise

This ebook gives you a solid foundation on the basics of business process automation, a look at the way BPA tools work, and how they can be utilized to 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.

Step-by-step, the process necessary to implement and deploy a BPA solution, providing valuable tips and tricks that can be applied to your own computing environment and that can be applied to make your business processes more efficient.

Learn more!

Community


SQL Server Magazine Instant Poll

Are you planning to attend DevConnections in March?

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

  • Yes, my company is paying for my travel and conference expenses
  • Yes, but I have to pay for my travel and conference expenses
  • I haven't decided yet
  • I'm still waiting to hear if my company will pay for my travel and conference expenses
  • No, my organization has cut the travel budget because of the economy
  • No, I never go to DevConnections
  • What's DevConnections?



Check Out These Articles in the March Issue of SQL Mag

SQL Server Freebies at Microsoft's CodePlex Site
by Michael Otey

Microsoft’s AdventureWorks series of sample SQL Server databases is now available at its open-source website CodePlex—which is where you can find these 7 great downloads, plus more tools and utilities.
http://www.sqlmag.com/Article/ArticleID/101222/sql_server_101222.html


SQL Data Generator
by Michael K. Campbell

For generating sample and testing data for SQL server databases, this product will win you over as quickly as it produces data.
http://www.sqlmag.com/Article/ArticleID/100517/sql_server_100517.html


See What Your Peers are Discussing on the SQL Server Magazine Forums

What is the difference between bulk insert and BCP?

Find out here


Can stabos execute a SQL Server report in SQL Server Reporting Services through a SQL Server Integration Services (SSIS) package?

See what your peers think


Product Watch: Developer Training Solutions Without the Instructor

Brian Reinholz, products@sqlmag.com

If your organization is like most, you've probably either been hit by layoffs and benefit cuts, or if nothing else a few "cost savings initiatives." Whether IT has taken a direct hit or been battered indirectly by the strain put on the rest of the company, you're most likely now expected to do more with less, including things you've never had formal training for.

One of the most common cases now is being asked to implement, customize, and train an entire workforce to use SharePoint. Now.

Click here to read the rest of Product Watch: Developer Training Solutions Without the Instructor

Events and Resources


Events and Resources

SQL Connections, March 22-25, 2009, Orlando, Florida
The first 800 paid attendees receive SQL Server 2008 Standard with one CAL. SQL Connections is co-located with SQL Server, Microsoft ASP.NET, Visual Studio & .NET, Architect, and SharePoint Connections. Register for one and attend sessions of concurrent events FREE.

Register for SQL Connections


Refer a Friend to SQL Server for Non-DB Specialists eLearning!
SQL MVP Allan Hirt heads up 6 fundamental SQL Server lessons tailored to pros new to SQL Server on March 26 and April 30, 2009! For only $99 each day, you'll learn how to plan, deploy, and administer SQL Server. The discussion will include aspects of SQL Server 2000, SQL Server 2005, and SQL Server 2008.

Seats are limited to allow for lots of live Q&A at the end. Tell your friends to register today!


Improve Desktop Security and Maintain End User Productivity
Removing end users’ administrator rights is an easy solution for desktop security but can also hinder everyday tasks and productivity. In this free online seminar, Microsoft MVP Derek Melber discusses best practices for ensuring high security and maximum availability for everyday client operations plus expert strategies for effectively removing administrator rights so that users can perform all necessary tasks for their jobs.

Learn what you need to know about security and administrative privileges on desktops. Register for this free seminar today!



FEATURED WHITE PAPER
Get a Unified Solution for Managing Active Directory and Group Policy on non-Windows Computers
The growing popularity of Mac computers in the business world presents unique challenges to IT administrators who have to integrate them into a Windows-based system. This white paper explains the benefits of utilizing an integration solution that allows administrators to extend Active Directory and Group Policy to Macs, simplifying identity management, security, and compliance.

Download this white paper today to learn how easily you can you can assimilate Macs into your Windows environment!



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


Free Software Trial Download: SureSync Makes Data Backup and Management a Breeze
Do you need to find a backup solution that ensures the high availability of your data to everyone in your enterprise while maintain data integrity? SureSync from Software Pursuits will allow you to maintain uniformity of web content, file permissions, and files modified by users in real-time.

Try this software free for 30 days!


Data Protection and Disaster Recovery Tips
Learn how to protect and secure data in the event of a disaster by making plans based on the expected duration of recovery, the impact of the disaster on your facilities and the surrounding area, and other factors. Even if you don't live in a disaster-prone area, you should still be prepared for things such as structure fires, major traffic accidents, and the like.

Make a disaster plan that works for your organization–Download this eBook today!

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.