SQL Server 2008 archives - IT Bookworm Blog

IT Bookworm Blog:

SQL Server 2008

Jul 16 2009   5:00AM GMT

Implementing Spatial Data in SQL Server 2008



Posted by: Brent Sheets
SQL Server Spatial Data, Alastair Aitchison, Apress, 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.

Signature
Community Manager

Beginning Spatial with SQL Server 2008 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 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

Apr 23 2009   5:00AM GMT

Hardening a SQL Server implementation



Posted by: Brent Sheets
SQL Server security, Ross Mistry, Hilary Cotter, Sams Publishing, SQL Server 2008, SQL Server, Database 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


Mar 18 2009   3:00AM GMT

How to retrieve data with the SQL SELECT statement



Posted by: Brent Sheets
SQL Server 2008, Joel Murach, Bryan Syverson, Mike Murach & Associates, SQL Server

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.

Signature
Community Manager

SQL Server 2008 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 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