Jeff James


Jeff James is industry news analyst for Windows IT Pro. He was previously editor-in-chief of Microsoft's TechNet Magazine, was an editorial director at the LEGO Company, and has more than 15 years of experience as a technology writer and journalist.

SQL Server Backup and Recovery Software 2
Tips from SQL Server backup and recovery experts can help you decide when to upgrade from SQL Server's native backup capability to a third-party solution, and what features to look for.
LINQ (Language Integrated Query)
What is LINQ? We'll describe what LINQ is in this first post to our new SQL Server Magazine online glossary.
SQL Server Hardware Poll: AMD or Intel?
When it comes to powering the most mission-critical SQL Server apps, which CPU brand do you rely on?
Views from the Field: Expert Advice on Virtualizing SQL Server 3
SQL Server and virtualization gurus from Quest Software, Microsoft, VMware, and Rochester General Health Systems offer their suggestions for running SQL Server in a virtual environment.
SQL Server Magazine Forums Updated
We've added a new section devoted to SQL Server 2008 in our SQL Server Magazine forums.
Author Chat with Itzik Ben-Gan, Andrew Kelly, and Michael Otey
SQL Server Magazine invites you to participate in a live chat with SQL Server Magazine authors Itzik Ben-Gan, Andrew Kelly, and Michael Otey on Friday, November 7th, at 7:00pm EST/6:00pm CST.
Awards Recognizee the Best of TechEd Developers 2008
For our seventh annual awards issue, our judges traveled to Orlando to take a close look at the finalists in our Best of TechEd awards process and bring you the top third-party SQL Server development products. The envelope, please!
Embarcadero Completes Acquisition of CodeGear
Roughly two months after it announced that it would acquire CodeGear from Borland, database tools developer Embarcadero Technologies issued a news release on July 1st announcing that it has completed the acqusition.
SQL Farms and Microsoft: Fact or Fiction?
A recent story we posted about Microsoft licensing technology from SQL Farms has generated some interesting responses, chiefly from two of the three parties involved in the supposed licensing deal.
Microsoft Licenses SQL Farms Technology
According to a news release issued earlier today by investment bank DeParis Redinger LLC, Microsoft has purchased technology from SQL Farms LLC, a Herndon, VA-based developer of management tools and utilities for Microsoft SQL Server.
New Products - 27 Jun 2008
Check out new and improved SQL Server–related products from Data Dynamics, iT-Workplace, AVIcode, ApexSQL, and Thomas Smyczek.
Sun Acquires MySQL AB: Now What?
Jeff James discusses the recent acquisition of MySQL AB by Sun Micrososystems.
New Products - 28 May 2008
Check out new and improved SQL Server–related products from Fujitsu, NetPro, Confio, and Secerno.
New Products - 28 Mar 2008
Check out new and improved SQL Server-related products from Datanamic Solutions B.V., CNS International, Caber Computing, and Microsoft.
New Products - 28 Feb 2008
Check out new and improved SQL Server-related products from OmBelt Solutions, Red Gate Software, ScriptLogic, Future IT Software, and Stimulsoft.

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 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
Aug 27, 2015

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....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) ×