About SQL Server Pro

SQL Server Pro is essential for anyone who builds, supports or integrates world-class SQL database applications.

SQL Server Pro covers the issues that matter to SQL Server database administrators, developers, and architects, as well as BI professionals. SQL Server users at all levels, from novice to advanced, will learn practical, hands-on information straight from SQL Server experts. Online resources include white papers, guides, podcasts, webinars, articles, FAQs, buyers’ guides, and the most extensive knowledge base for SQL Server today.

SQL Server Pro launched in 1999 (as SQL Server Magazine), and is the definitive voice of the SQL Server database community.

Our Penton Technology Digital Properties:

Windows IT Pro    SuperSite for Windows   SharePoint Pro     Dev Pro    myITforum.com

Email Newsletters:

Our newsletters cover a wide variety of Windows technologies, from Exchange and Outlook to SQL Server to security and more. Sign up today.

Online and In-Person Events:

Numerous opportunities available, including online seminars, single- and multiple-day roadshows, and technical conferences. Details.

Advertising Information:

If you would like information about advertising with us please see our media kit. For more information visit www.penton.com

Penton Technology Editorial, Events, Sales Leadership 
Executive Director, Content, Penton Technology  Marcia Parker
Senior Director, Content and Engagement Director, Penton Technology's Windows IT Pro, Share Point Pro, SQL Server Pro, Dev Pro, SuperSite for Windows, and myITforum  Rod Trent 
Senior Contributing Editor, SQL Server Pro  Deb Donston-Miller
Sales Director, Penton Technology Debbie Kane
Advertising Sales

Strategic Accounts Director

Chrissy Ferraro
(970) 203-2883
Enterprise Account Manager Cassandra Schulz
(720) 963-4033
Account Manager Barbara Ritter
(858) 367-8058
West Coast Sales Manager 

Brad Rolfe
(415) 215-7774 

Senior Client Services Manager Michelle Andrews
(970) 613-4964
Online Marketing Manager Greg Davis
(212) 204-4231
Marketing & Customer Service
Vice President, User Marketing & Marketing Analytics Tricia Syed
Customer Service Contact Customer Service
(800) 262-1954 or 913-967-1719


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
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...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) ×