Anne Grubb

Anne
Grubb

Anne Grubb is a former content manager of Dev Pro. She's currently a freelance writer and editor based in Colorado.

Articles
The Wisdom of SQL Mag Readers
SQL Server Magazine readers are sharing their expertise and helping their peers in the comments section on online articles.
Readers Talk About SQL Server Backup and Tuning 1
Database backup and performance tuning are top-of-mind topics for SQL Mag online readers.
Cloud Computing Comes to SQL Server
Sound off about what cloud computing means for your SQL Server career and share your insights about improving database application performance.
Videos and Reader Comments Give Sqlmag.com Readers Online Help
Stay tuned for videos from SQL Server experts on ITTV.net, and be on the lookout for helpful nuggets of information in online article comments on Sqlmag.com.
What Do SQL Server Magazine Readers Want?
An informal poll shows that SQL Mag readers prefer quality over quantity of articles—and would rather not pay more for a larger magazine.
Readers Talk Back About DBA Roles and Database Tuning
SQL Mag online readers get chatty about the blurring roles of IT pros and developers and database-tuning principles.
BI and Web Site News, and a Tool Time “Thank You”
SQL Server Magazine launches a new business intelligence (BI) e-newsletter, a reader gets help from Tool Time, and we respond to reader feedback about Sqlmag.com and the price of a SQL Mag subscription.
Readers Talk Back to Community Dialog
Readers share their thoughts about recent Community Dialogs, and Itzik Ben-Gan helps a reader out by creating a special "lottery" query.
Query Generates Winning Lottery Numbers!
Itzik Ben-Gan helps out a reader by creating a T-SQL query that generates winning lottery numbers.
"Camp" 'n' Code Event for .NET and SQL Server Pros

If you’re in the Atlanta area—and you love to code—a free-of-charge .NET community event called Code Camp might be just the excuse you need to get out of spring cleaning or that home improvement project you were planning for this weekend.

Readers and Authors Swap Ideas
A reader asks Douglas McDowell a question about his PerformancePoint Server Eye on BI article, forum members debate SQL Server trace methods, and Rodney Landrum updates his repository solution, in direct response to readers' feedback.
SQL Mag Presses the Virtualization Hot Button 2
Although some readers say it’s risky to run production database environments under VMs, other signs point to a breakthrough year for SQL Server virtualization in 2008.
Online vs. Print Content: Finding the Right Mix 2
We answer a reader's question about why parts of some articles in SQL Server Magazine are available only on Sqlmag.com, and SQL Mag editors spark a lively online discussion about women in IT.
SQL Server Innovators Solve Business Problems with Style
Blending ingenuity and skill, the 2007 SQL Server Innovators winners include a T-SQL program that does math for a video poker game, a way to centrally maintain applications' data, a database maintenance tool, and a hospital disaster recovery system.
Want to Talk SQL Server? Check out the Sqlmag.com Forums
The SQL Server Magazine forums have been especially lively lately, with a thoughtful exchange about backup and restore and readers’ feedback. Find out how to join the conversation.

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) ×