SQL Server

Implementing Spatial Data in SQL Server 2008

Overview: “Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications. Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth.”

This free chapter has been selected from Beginning Spatial with SQL Server 2008 by Apress. 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.

Community Manager

Written by Title Published by Published on ISBN-10 ISBN-13

Alastair Aitchison Beginning Spatial with SQL Server 2008 Apress January 21, 2009 1430218290 978-1430218296

DOWNLOAD THE CHAPTER
Chapter 2: Implementing Spatial Data in SQL Server 2008 (Part 1)
Chapter 2: Implementing Spatial Data in SQL Server 2008 (Part 2)

RELATED PEER ADVICE
  → Visit our SQL Server community
  → Need SQL Server answers? Ask your own SQL Server question
  → Browse the Editor Q&A on the SearchSQLServer.com Public Profile

RELATED RESOURCES
  → Visit the SQL Server with Mr. Denny blog
  → Visit the The Multifunctioning DBA blog
  → Browse SQL Server Administration resources
  → Browse SQL Server Development resources
  → Browse SQL Server Platforms resources
  → Browse SQL Server Management Issues resources
  → Visit the SearchSQLServer.com website

RELATED CONTENT
  → IT Definitions: Location-based Service (LBS) (visit the Database Glossary for more)
  → Primer: Microsoft SQL Server 2008 Resource Governor primer
  → Article: Microsoft renames SQL Server release, adds data services
  → Blog: Details emerge about SQL Server 2008 R2
  → eZine: Utilize Analysis Services partitions and aggregations (PDF)
  → Book Excerpt: An overview of SQL Server Report Builder 2.0
  → Audio: Spatial Data in SQL Server 2008 with Denny Cherry
  → Video: Building a data warehousing and BI solution
  → Webcast: 10 Ways Predictive Analytics Can Help You
  → Quiz: Business Intelligence

Tuning database applications for performance

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.

Community Manager

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
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?

Hardening a SQL Server implementation

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.

Community Manager

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
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

How to retrieve data with the SQL SELECT statement

Overview: This book is designed to teach application developers all of the skills they need to use SQL to work with a Microsoft SQL Server 2008 database. But it’s also a great first book for developers who are on the path to becoming a DBA. Unlike most SQL Server 2008 books, this one starts by showing you how to use SQL queries to extract and update the data in a database, because that’s what every application developer needs to know first.”

This free chapter has been selected from Murach’s SQL Server 2008 for Developers by Mike Murach & Associates. Post a comment below letting us know what think about the chapter or any books you’d like to see featured here. Enjoy.

Community Manager

Written by Title Published by Published on ISBN-10 ISBN-13

Joel Murach and Bryan Syverson Murach’s SQL Server 2008 for Developers Mike Murach & Associates November 24, 2008 1890774510 978-1890774516

DOWNLOAD THE CHAPTER
Chapter Three: How to retrieve data with the SQL SELECT statement

RELATED PEER ADVICE
  → Visit our SQL Server community
  → Need answers? Then ask your own SQL Server question

RELATED RESOURCES
  → Visit the SQL Server with Mr. Denny blog
  → Visit the SearchSQLServer.com website
  → Browse these SQL Server 2008 resources

RELATED CONTENT
  → IT Definition: Microsoft SQL Server (visit the Database Glossary for more)
  → Learning Guide SQL and SQL Server Tutorial and Reference Guide
  → Learning Guide SQL Server performance tuning A to Z

How to use Oracle SQL Developer and other tools

Overview: PL/SQL is Oracle’s procedure language that allows you to code loops, if-else structures, and error-handling structures to build more complex scripts. That, in turn, allows you to manage transactions that maintain data integrity in a database. And it allows you to create stored procedures, functions, and triggers - named blocks of PL/SQL code that are stored in the database for ready access.

This shiny new blog is dedicated to providing members with a wide selection of free sample chapters from relevant enterprise IT and development books. I’ve included related resources for additional help. Be forewarned, some chapters may have limited availability — so get them while you can.

This free chapter download is taken from Murach’s Oracle SQL and PL/SQL by Mike Murach & Associates. When you finish reading the chapter, please share your thoughts with fellow members by posting a comment below. Thanks and enjoy the free chapter.

Community Manager

Written by Title Published by Published on ISBN-13

Joel Murach Murach’s Oracle SQL and PL/SQL Mike Murach & Associates August 31, 2008 978-1-890774-50-9

DOWNLOAD THE CHAPTER
Chapter Two: How to use Oracle SQL Developer and other tools

RELATED PEER ADVICE
  → Visit our Oracle community
  → Need answers? Then ask your own Oracle question

RELATED RESOURCES
  → Visit the Eye on Oracle blog
  → Visit the SearchOracle.com website
  → Browse these Oracle PL/SQL resources

RELATED CONTENT
  → IT Definition: PL/SQL (visit the Database Glossary for more)
  → Learning Guide Fast Guide: PL/SQL