Brian Moran


Brian Moran is chief servant officer and co-owner of both Linchpin People and SQL People. He is a contributing editor for SQL Server Pro and has been involved in the SQL Server community for more than 20 years. Brian co-founded what might be the first SQL Server user group in the world, was one of the first SQL Server MVPs in the world, and was on the SQL Server Magazine launch team. Brian's roles in the SQL Server community include technologist, author, community leader, entrepreneur, and executive.

Microsoft Trumps Oracle’s Record-Breaking TPC Score

Microsoft announced its latest TPC-H benchmark score, which was quite impressive. Microsoft’s latest score—posted on May 21, 2007—was 60,359 queries per hour (QphH) @3t with a Price/QphH of $32.60 compared with Oracle’s best score—posted on May 14, 2007—of 37,813 QphH @3t with a Price/QphH of $38.00. Almost double the performance for a lower cost per query? Sign me up!


No Joking About SQL Server Security - 26 Feb 2007
Security—or arguably the lack thereof—has long been an area in which Joe Public likes to poke fun at Microsoft.
Promoting Interoperability with JDBC - 22 Jan 2007

In a perfect world (or at least the World According to Bill), everyone would use All Microsoft Products All the Time and you’d never need silly things like interoperability software. Alas, the world isn’t perfect, and small pockets of renegades still use non-Microsoft software to run their businesses.

SQL Server Tips & Tricks
Check out these SQL Server timesavers, which you can use with SQL Query Analyzer, SQL Server Profiler, and the command line.
SQL Server Savvy - 19 Dec 2001
Create a SQL Server 2000 extended property, retrieve specific rows within a resultset, capture a SQL trace, report a table's column size, and more.
SQL Server Solutions
Employ a fast data-load mechanism, transfer integers to event class names, view connections inside a transaction, and more.
Microsoft Testing SQL Server 6.5-to-2000 Upgrade - 18 May 2000
Brian Moran reports that Microsoft is offering free upgrade testing to encourage the many customers still running SQL Server 6.5 to move to the upcoming SQL Server 2000 release and to make sure the process goes as smoothly as possible.
Read the Fine Manual - 11 May 2000
Brian Moran says SQL Server professionals have an excellent, but underused, resource in SQL Server Books Online--also available in hard copy.
Phasing Out Support for Older SQL Server Versions - 04 May 2000 4
Most of us have plenty of time to plan how we're going to move to SQL Server 2000, but those of us on older versions of SQL Server may need to map out our migration strategy sooner rather than later.
In Defense of Database Kin - 27 Apr 2000
Brian Moran chastises organizations that treat database integration as an afterthought rather than a key element of a complex whole.
Database Deja Vu - 20 Apr 2000 2
Brian Moran says the database revolution UNIX folks fanned 10 years ago has reignited under the banner of Windows technologies.
Time to Speak Up - 13 Apr 2000
Brian Moran says that whether you hang your hat in the consulting world or at a “real job,” the occasional technology presentation gives your resume and career a boost.
Questions, Answers, and Tips About SQL Server - 30 Mar 2000 4
Stabilize nullability, monitor tables to find script triggers, make SQL Server and Oracle data compatible, implement custom application-locking schemes, and create indexes that use functions or expressions.
Should You Upgrade to SQL Server 7.0 SP2? - 30 Mar 2000
SP2 contains many fixes for miscellaneous performance and tuning problems as well as the patch for a recently discovered security hole.
Microsoft Patches SQL Server Security Hole - 23 Mar 2000 2
Without the patch, anyone can run a particular type of query using a particular form and gain sa rights.
Microsoft Stack Master Class

Master-Level Microsoft Stack Class with John Savill
Online Class: Thursdays Oct. 12th-Dec. 21st
30 Hours of Training for $995!

Understand the complete Microsoft solution stack, how the products work together, and how to implement and maintain for a total datacenter and desktop solution. This course covers the latest technology updates including Windows Server 2016 and Windows 10 and will enable the new capabilities to be leveraged in your organization.


Join the Conversation

Sponsored Introduction Continue on to (or wait seconds) ×