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 2008 Delayed Until Q3 2008
According to a posting on the Data Platform Insider Microsoft employee blog, the final RTM of SQL Server 2008 has been pushed back to Q3 2008.
New Products - 18 Dec 2007
Check out new and improved SQL Server–related products from GridApp Systems, O'Reilly Media, SqlLabs, Tableau Software, and xSQL Software.
SQL Server Performance Monitors - 18 Dec 2007 3
Use this comprehensive list of SQL Server performance monitors to begin your product research and make the right purchasing decision.
Quest Software Files Suit Against Idera
In a civil suit filed on November 6th, 2007, Quest Software claims that BBS Technologies Inc.--the parent company of Idera--committed patent infringement and violated the Computer Fraud and Abuse Act.
New Products - 20 Nov 2007
Check out new and improved SQL Server-related products.
SQL Server Trends in 2008
Learn which Microsoft and third-party products will have the tools you need to stay on top of SQL Server development, administration, and business intelligence (BI) challenges in the coming year.
2007 PASS Community Summit: Event Wrap Up
The 2007 Pass Community Summit draws to a close, but not before we cover some Dell/Microsoft news and an expert panel on SQL Server virtualization in the Enterprise.
2007 PASS Community Summit: SQL Server, Orange Vests and the Blue Bear
The SQL Server Magazine editors attend the 2007 PASS Community Summit in Denver, Colorado. What do Quest Software, Idera Software and a gigantic blue bear have in common? Read on to find out....
New Products - 20 Sep 2007
Check out new and improved SQL Server–related products.
Does Your Database Need a Defrag? 2
Database performance can slow over time, caused by everything from limited server system memory or storage to performance-throttling server load driven by an increasing number of users. Could index defragmentation be the answer?
DataKraft Studio Aims to Streamline Database Application Development
Newcomer DataKraft hopes to speed up SQL Server application development with their DataKraft Studio development platform.
computer keyboard with green key and read key with security emblems
SQL Server 2005 Security Tips
These four tips from Microsoft security experts can assist your compliance efforts.
Database Auditing and Compliance Products
An emerging selection of software- and appliance-based products augment SQL Server 2005’s basic auditing capabilities, to help you keep data secure and in compliance with government regulations.
Auditing and Compliance Features in SQL Server 2008
Enhancements in SQL Server 2008 will make every action auditable and provide transparent data encryption.
SQL Nitro Claims to Supercharge SQL Network Performance
DBA 24 Hours has developed a new software product--SQL Nitro--that the company claims will improve SQL application response times and network performance at a lower cost than network acceleration appliances.

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