Brian Moran

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.

Articles
SQL Server Storage Options
As a DBA, one of your many tasks is to manage your SQL Server databases’ ever-expanding storage requirements. In this book, we’ve pulled together four articles from SQL Server Magazine to give you an overview of SQL Server storage options.
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.
NEW: John Savill's Microsoft Stack Master Class

Get 30 hours of detailed instruction covering the complete Microsoft solution stack. Invest a few hours each week and become THE Microsoft expert in your organization.

Thursdays, October 2nd to December 11th

John Savill will cover topics including:

* Deploying, Managing, and Maintaining Windows
* Key Features of Active Directory from Windows 2000 to Windows Server 2012
* Key elements of System Center 2012 and System Center 2012 R2
* Deploying, Migrating to and Managing Hyper-V in Your Organization
* Implementing a Private Cloud
* Using PowerShell to Automate Common Tasks

Enroll by September 25th and SAVE $245!
 

Upcoming Conferences

Register now to get the best rates available!

Windows Forums

The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.

Sponsored Introduction Continue on to (or wait seconds) ×