IT Bookworm Blog


May 14, 2009  5:00 AM

Tuning database applications for performance



Posted by: BrentSheets
Data access, Database applications, Database performance, Database scalability, DB2, John Goodson, MySQL, Oracle, Prentice Hall, Robert A. Steward, SQL Server

Overview: “Performance and scalability are more critical than ever in today’s enterprise database applications, and traditional database tuning isn’t nearly enough to solve the performance problems you are likely to see in those applications. Nowadays, 75-95% of the time it takes to process a data request is typically spent in the database middleware. Today’s worst performance and scalability problems are generally caused by issues with networking, database drivers, the broader software/hardware environment, and inefficient coding of data requests. In The Data Access Handbook, two of the world’s leading experts on database access systematically address these issues, showing how to achieve remarkable improvements in performance of real-world database applications.

Drawing on their unsurpassed experience with every leading database system and database connectivity API, John Goodson and Rob Steward reveal the powerful ways middleware affects application performance and guide developers with designing and writing API code that will deliver superior performance in each leading environment. In addition to covering essential concepts and techniques that apply across database systems and APIs, they present many API examples for ODBC, JDBC, and ADO dot NET as well as database system examples for DB2, Microsoft SQL Server, MySQL, Oracle, and Sybase.”

This free chapter has been selected from The Data Access Handbook: Achieving optimal database application performance and scalability by Prentice Hall. Enjoy the chapter and be sure to check out the related database and development resources listed below. Voice your feedback on this chapter or let us know of other books you’d like to see featured on the IT Bookworm Blog by leaving a comment. Thanks.

Signature
Community Manager

The Data Access Handbook Written by
Title

Published by
Published on
ISBN-10
ISBN-13
John Goodson and Robert A. Steward
The Data Access Handbook
Achieving Optimal Database Application Performance and Scalability
Prentice Hall
March 26, 2009
0137143931
978-0137143931

Download the chapter DOWNLOAD THE CHAPTER
Chapter 4: Tuning for performance

RELATED PEER ADVICE
→ Visit our Development community
→ Need answers? Ask your own Database development question

RELATED BLOGS
→ Visit the .NET Developments blog
→ Visit the SQL Server with Mr. Denny blog
→ Visit the Eye on Oracle blog
→ Visit the Software Quality Insights blog
→ Visit the Custom Application Development blog
→ Visit the The Multifunctioning DBA blog

RELATED RESOURCES
→ Browse .NET Framework database programming resources
→ Browse Data architecture for SOA resources
→ Browse Software performance, load and stress testing resources
→ Browse New and updated tutorials from SearchSOA.com
→ Visit the SearchWinDevelopment.com website
→ Visit the TheServerSide.com website
→ Visit the TheServerSide.NET website
→ Visit the SearchSOA.com website
→ Visit the SearchOracle.com website
→ Visit the SearchSQLServer.com website
→ Visit the SearchSoftwareQuality.com website
→ Visit the Ajaxian.com website

RELATED CONTENT
→ IT Definitions: ODBC, JDBC and ADO (visit the Software Development Glossary for more)
→ Blog: Persevere’s JavaScriptDB: Impressive JSON Performance
→ Article: Componentized XML Query tool takes a step forward
→ Learning Guide: SOA Data Integration Tutorial
→ Quiz: SOA: What do you know?

May 7, 2009  5:00 AM

Oracle on Linux: Analyzing Server Performance



Posted by: BrentSheets
Apress, Bernard Lopuz, Charles Kim, Darl Kuhn, Linux, Oracle on Linux

Overview: “Linux Recipes for Oracle DBAs is an example-based book on managing Oracle Database in a Linux environment. Covering commonly used distributions such as Red Hat Enterprise Linux and Oracle Enterprise Linux, the book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of Linux documentation. The book is task-oriented: Look up the task to perform. See the solution. Read up on the details. Get the job done.”

This free chapter has been selected from Linux Recipes for Oracle DBAs by Apress. Enjoy the chapter and be sure to check out the related Linux and Oracle resources listed below. Voice your feedback on this chapter or let us know of other books you’d like to see featured on the IT Bookworm Blog by leaving a comment. Thanks.

Signature
Community Manager

Book by Author Written by
Title
Published by
Published on
ISBN-10
ISBN-13
Darl Kuhn, Charles Kim and Bernard Lopuz
Linux Recipes for Oracle DBAs
Apress
November 14, 2008
1430215755
978-1430215752

Download the chapter DOWNLOAD THE CHAPTER
Chapter 8: Analyzing Server Performance

RELATED PEER ADVICE
  → Visit our Oracle community or Linux community
  → Need answers? Ask your own Oracle or Linux question

RELATED RESOURCES
  → Visit the Eye on Oracle blog
  → Visit the Enterprise Linux Log blog
  → Visit the Open Source Software and Linux blog
  → Browse Oracle on Linux resources
  → Browse Linux databases resources
  → Visit the SearchOracle.com website
  → Visit the SearchEnterpriseLinux.com website

RELATED CONTENT
  → IT Definitions: Oracle and Linux (visit the Database Glossary and Linux Glossary for more)
  → Article: Oracle releases VM virtualization templates, boasts Linux momentum
  → Article: Firm dumps MySQL on Red Hat for Oracle Database on Oracle Linux
  → Article: Oracle beefs up Linux partnerships to expand Linux customer base
  → Article: Oracle Enterprise Linux displaces Red Hat at publishing company
  → Quiz: Oracle Enterprise Manager
  → Quiz: Linux databases


April 30, 2009  5:00 AM

The Gathering Storm: Get your head into the clouds



Posted by: BrentSheets
CIO, Cloud computing, Data Center design, Meghan-Kiffer Press, Peter Fingar

Overview: “In Dot.Cloud: The 21st Century Business Platform, business strategy expert and former CIO Peter Fingar explains the main ideas of Cloud Computing in lay terms. Peter also does some old-fashioned reporting to bring together the ideas of the movers and shakers who are actively building the Cloud.

But this is not a technical book about Cloud Computing technologies; it’s a business book. It’s about what the Cloud portends for business … about transformation in the ways companies are managed … and about business models for the 21st century. It’s about how companies carry out their work in the Cloud instead of office buildings and skyscrapers, and how they deliver their “services” in the Cloud. It’s also about human interactions in the Cloud, and about the end of management and the rise of self-organizing, self-managed “Bioteams.”

Even more, it’s about unlocking human potential in business, about unleashing passion. All this points to your company’s future, and your future, set in the context of the biggest economic downturn since World War II. So ultimately, it’s about lighting a fire under all of us.”

This free chapter has been selected from Dot Cloud: The 21st Century Business Platform by Meghan-Kiffer Press. Enjoy the chapter and be sure to check out the related Cloud Computing resources listed below. Voice your feedback on this chapter or let us know of other books you’d like to see featured on the IT Bookworm Blog by leaving a comment. Thanks.

Signature
Community Manager

Dot Cloud by Peter Fingar Written by
Title
Published by
Published on
ISBN-10
ISBN-13
Peter Fingar
Dot Cloud: The 21st Century Business Platform
Meghan-Kiffer Press
February 18, 2009
0929652495
978-0929652498

Download the chapter DOWNLOAD THE CHAPTER
Chapter 2: The Gathering Storm: Get your head into the clouds

RELATED PEER ADVICE
  → Visit our Virtualization community
  → Need answers? Ask your own Cloud Computing question

RELATED RESOURCES
  → Visit the Cloud Computing Adviser blog
  → Visit the SearchServerVirtualization Blog
  → Browse Cloud Computing resources
  → Browse Cloud Computing, grid and utility computing resources
  → Visit the SearchServerVirtualization.com website
  → Visit the SearchDataCenter.com website

RELATED CONTENT
  → IT Definitions: Cloud Computing (visit the Cloud Computing Glossary for more)
  → Special Report: Cloud Computing Special Report
  → Article: Who’s who in cloud computing: Understanding the market’s players
  → Article: Data center panel weighs cloud computing risks, rewards
  → Video: Future cloud challenges
  → Video: IBM keynote explores cloud computing, virtualization
  → Blog: Disruptive technologies of 2009: Virtualization and cloud computing
  → Blog: Cloud computing versus colocation: What’s the right fit?
  → Article: Does cloud computing reduce IT staffing and costs?
  → Article: Sun Microsystems pulls plug on grid, enters cloud
  → Article: Sun exec pushes cloud to leery data center managers
  → Article: Google et al. pitch cloud computing to wary IT pros
  → Article: Hardware standardization benefits cloud computing, virtualization
  → Article: Analysts debate merits of cloud computing for large data centers
  → Quiz: Virtualization and the private cloud: A quiz for enterprise CIOs


April 23, 2009  5:00 AM

Hardening a SQL Server implementation



Posted by: BrentSheets
Database security, Hilary Cotter, Ross Mistry, Sams Publishing, SQL Server, SQL Server 2008, SQL Server security

Overview: “If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won’t find anywhere else.”

This free chapter has been selected from Microsoft SQL Server 2008 Management and Administration by Sams Publishing. Enjoy the chapter and be sure to check out the related SQL Server resources listed below. Voice your feedback on this chapter or let us know of other books you’d like to see featured on the IT Bookworm Blog by leaving a comment. Thanks.

Signature
Community Manager

Microsoft SQL Server 2008 Written by
Title
Published by
Published on
ISBN-10
ISBN-13
Ross Mistry and Hilary Cotter
Microsoft SQL Server 2008 Management and Administration
Sams Publishing
January 2, 2009
067233044X
978-0672330445

Download the chapter DOWNLOAD THE CHAPTER
Chapter 8: Hardening a SQL Server implementation

RELATED PEER ADVICE
  → Visit our SQL Server community or Security community
  → Need answers? Ask your own SQL Server or Security question

RELATED RESOURCES
  → Visit the SQL Server with Mr. Denny blog
  → Visit the The Multifunctioning DBA blog
  → Visit the Security Bytes blog
  → Browse SQL Server security resources
  → Browse SQL Server 2008 resources
  → Browse Database Security Management resources
  → Visit the SearchSQLServer.com website
  → Visit the SearchSecurity.com website

RELATED CONTENT
  → IT Definitions: Data corruption and Data hiding (visit the Database Glossary or App Security Glossary for more)
  → FAQ: How to troubleshoot and grant SQL Server permissions
  → Guide: Test for a Trojan horse on your SQL Server
  → Article: Enforcing data integrity in a SQL Server database
  → Article: SQL injection attacks targeting Flash, JavaScript errors
  → Article: Imperva assigns security risk levels to databases
  → Article: Microsoft updates code analysis tool, SQL injection XSS library
  → Security School: Free online information security training courses
  → Quiz: Database Basics or Security Basics


April 16, 2009  5:00 AM

But aren’t Mainframes dead?



Posted by: BrentSheets
CICS, David Stephens, IBM zSeries, Longpela Expertise, Mainframe, z/OS

Overview: “Confused about zSeries Mainframes? Need to understand the z/OS operating system – and in a hurry? Then you’ve just found the book you need. Avoiding technical jargon, this book gives you the basic facts in clear, light-hearted, entertaining English. You’ll quickly learn what Mainframes are, what they do, what runs on them, and terms and terminology you need to speak Mainframe-ese. But it’s not all technical. There’s also invaluable information on the people that work on Mainframes, Mainframe management issues, new Mainframe trends, and other facts that don’t seem to be written down anywhere else.”

This free chapter has been selected from What on Earth is a Mainframe? by Longpela Expertise. Enjoy the chapter and be sure to check out the related Mainframe resources listed below. Voice your feedback on this chapter or let us know of other books you’d like to see featured on the IT Bookworm Blog by leaving a comment below. Thanks.

Signature
Community Manager

What on Earth is a Mainframe? Written by
Title
Published by
Published on
ISBN-10
ISBN-13
David Stephens
What on Earth is a Mainframe?
Longpela Expertise
August 18, 2008
1409225356
978-1409225355

Download the chapter DOWNLOAD THE CHAPTER
Chapter 1: But aren’t Mainframes dead? An introduction to the mainframe.

RELATED PEER ADVICE
→ Visit our Mainframe community
→ Need answers? Ask your own Mainframe question

RELATED RESOURCES
→ Visit the Mainframe Propeller Head blog
→ Browse Mainframe computer hardware resources
→ Browse Mainframe jobs resources
→ Browse Mainframe operating systems and management resources
→ Browse Mainframe security and disaster recovery resources
→ Browse Mainframe migration project resources
→ Browse Modern mainframe: SOA and Linux resources
→ Visit the SearchDataCenter.com website

RELATED CONTENT
→ IT Definitions: Mainframe, z/OS and CICS (visit the Data Center Glossary for more)
→ Guide: Mainframe Management
→ Author Q&A: Making the case for the mainframe
→ Trends: Mainframe 2008 year in review
→ Article: Mainframe users share z/OS 1.10 stories
→ Article: Tuning mainframe applications cuts software costs
→ Quiz: Mainframe Acronym-o-phobia


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: