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.
Hyper-V Master Class

Hyper-V Master Class with John Savill
Live Online Training: Thursdays, April 27th to May 18th
Register by April 20th and Save 20%!

John Savill provides 12 hours of detailed instruction covering all the key aspects of a Hyper-V based virtualization environment covering both capabilities in Windows Server 2012 R2 and Windows Server 2016. John will walk attendees through resource allocation and architecture, storage, networking (including Network Virtualization), clustering, migration technologies, replication, private cloud, session virtualization, migration from other technologies, integration with Microsoft Azure, and more. At the end of this class, attendees will be able to architect and manage an enterprise-level Hyper-V environment.


Join the Conversation

Sponsored Introduction Continue on to (or wait seconds) ×