Back to Top

ROBIN DEWSON

Developer, author, tech reviewer, release and change management and rugby coach


WELCOME!

Recent books authored

Beginning SQL Server for Developers

Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL Server, including the in-memory features that are introduced in SQL Server 2014.


Within the book, there are plenty of examples of tasks that developers routinely perform. You’ll learn to create tables and indexes, and be introduced to best practices for securing your valuable data. You’ll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code.


    Takes you through the entire database application development lifecycle

    Includes brand new coverage of the in-memory features

    Introduces the freely-available Express Edition

Beginning SQL Server 2012 for Developers

Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Now in its third edition, the book is enhanced to cover the very latest developments in SQL Server 2012.


Also new in the book is coverage of the no-cost Express Edition. Whether you have no knowledge of databases, or have knowledge of desktop databases such as Microsoft Access, or even come from another brand such as Oracle Database, Beginning SQL Server 2012 for Developers provides the insights to get up and running with SQL Server 2012.


Within the book, there are plenty of examples of tasks that developers routinely perform. You’ll learn to create tables and indexes, and best practices for securing your valuable data. You’ll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code.


Beginning SQL Server 2012 for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you’ll be able to design and create solid and reliable database solutions using SQL Server 2012.


    Takes you through the entire database application development lifecycle

    Includes brand new coverage of SQL Server 2012 features

    Introduces the freely-available Express Edition

Beginning SQL Server 2008 for Developers

Beginning SQL Server 2008 for Developers is the starting-point in the Apress roadmap of titles for developers who wish to base their projects upon Microsoft's flagship database management system. The book takes developers from the point of installing SQL Server 2008, through the process of storing, retrieving, and securing data, to the point of being able to serve up business reports using SQL Server 2008 Reporting Services. The author has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He maintains visibility in the field through his website and his other books.

Beginning SQL Server 2008 Express for Developers

Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a database administrator, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource commonly used by students, developers of small systems, and those transferring skills from other databases. This book focuses on the features within the Express Edition and therefore will not confuse readers with coverage of features found only in the Development Edition. By the end of the book, readers will be ready to move on to Accelerated SQL Server 2008 as well as other books within the Apress SQL Server lineup such as Pro SQL Server 2008 Reporting Services.


    Covers using the free Express Edition of SQL Server

    Describes creating a database from scratch and builds on this

    Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you and your business


OTHER BOOKS AUTHORED

These are other fully authored or co-authored on

Pro SQL Server 2005

First book to provide comprehensive, deeply practical coverage on all major new SS2005 features.


Gets the DBA and developer up and running with SS2005 in the fastest possible time.


The facts, not the evangelism.

Pro SQL Server 2005 Assemblies

Pro SQL Server 2005 Assemblies provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on building assemblies in C#, but also provide the equivalent VB .NET code in the supplied code download.


Assemblies are not a complete replacement for T-SQL stored procedures and triggers; rather, they’re enhancements, to be used at the right place and right time. This book examines the ins and outs of assemblies when they should and should not be used, what you can do with them, and how you can get the most out of them.

Beginning Server 2005 for Developers

The only truly Beginning level book on the market that is tailored to the needs of aspiring developers with little or no experience. Assumes no prior SQL Server knowledge.


* Explores the new 2005 features fully but also suitable for SQL Server 2000 users.


* The book provides everything an aspiring developer needs to start building SQL Server database applications

Beginning Server 2005 Express for Developers

Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provides a major subset of full SQL Server 2005 functionality.


This book is a comprehensive guide that covers installing and configuring SQL Server 2005 Express, creating, backing up, and restoring databases, creating tables, then querying and manipulating them with T-SQL, coding stored procedures and triggers, and using Reporting Services to deliver information to end users. Detailed, clear, and highly readable, this book will make you a competent and confident database administrator and programmer.

SQL Server 2000 Stored Procedures Handbook

Shows you how to write more effective stored procedures and functions


Tackles issues barely covered in existing books, such as optimizing and debugging, concurrency and transactions.

ASP.NET 1.1 Solutions Toolkit

Includes 15 controls (programs) covering a wide range of situations; provides both a working coded solution to their problem as well as the thinking behind it


Controls can be ‘cut and pasted’ or used as templates for readers to build their own controls