Jones and Bartlett Announces Microsoft Transact-SQL: The Definitive Guide Publishing March 2010 from Tampa Author

FOR IMMEDIATE RELEASE
(Free-Press-Release.com) November 20, 2009 -- SQL Server 2008 is a database management system (DBMS) which has enormous and increasing market penetration worldwide for corporations from one-person startups to Fortune 10 corporations. It is used to contain and manage data. Transact-SQL is the proprietary language extension with which database code is written.

“70-80% of database performance problems are caused by poorly written transact-SQL code. My book is a comprehensive guide to the T-SQL language written for the MS SQL Server 2008 developer having performance problems with SQL,” says Jeffrey Garbus
.

The text includes case studies and examples demonstrating how to write or rewrite T-SQL source code. It demonstrates several ways of writing code for optimal performance and maintainability such as stored procedures versus dynamic SQL as well as subqueries versus joins. Advanced SQL programming techniques including characteristic functions, common table expressions, refactoring, cubes, and dynamic queries are also covered.

Microsoft Transact-SQL: The Definitive Guide ($46.95) may be ordered through the Jones and Bartlett website at www.jbpub.com or by phone at 1-800-832-0034.

About the Author:

Jeffrey Garbus is a database consultant and the CEO of Soaring Eagle Consulting, Inc, based in Tampa, Florida. He has spoken at numerous user conferences, and has written many acclaimed magazine articles and books. He is also the lead author for Administrator’s Guide to Sybase ASE 15 and the Jeffrey Garbus’ Official Sybase ASE 12.5 Library from Wordware Publishing (recently acquired by Jones and Bartlett), which includes the Administrator’s Guide to Sybase ASE 12.5 and Sybase ASE 12.5 Performance and Tuning.

About Soaring Eagle Consulting:

Soaring Eagle Consulting, Inc. is a Tampa Bay based consulting firm specializing in database performance and optimization. For more than 12 years, Soaring Eagle has been helping clients of all sizes in the US and internationally address a broad range of database performance issues in order to maximize business productivity, performance and profitability. The range of services Soaring Eagle offers includes; Database performance & tuning, database planning & strategy, emergency repair, training, mentoring, managed database services, and staffing. Soaring Eagle has an exceptionally qualified team of consultants at the expert level helping clients address challenges with SQL Server, Sybase, Oracle and DB2.

Contact Ray Rannala at (941) 981-3913 to arrange for an interview.

database     optimization     Oracle     SQL Server     Sybase     Transact SQL