Welcome!

Microsoft Cloud Authors: Pat Romanski, Andreas Grabner, Nick Basinger, Kevin Benedict, Liz McMillan

Related Topics: Microsoft Cloud

Microsoft Cloud: Blog Feed Post

Book Review: SQL Server 2008 for Developers

The book will be useful for instructors who train students

As always, Murach publishing updates their books as and when a new version of the software is released. SQL Server 2008 for Developers is an updated book of its 2005 edition. The book consists of 22 chapters divided into five sections providing solid coverage of SQL Server 2008. The book looks similar to that of its 2005 edition except the content and syntaxes targets 2008.

Inside the Book

Section 1 provides a crisp introduction to relational databases including various SQL statements. It also demonstrates the usage of SQL with the help of an ADO.NET application. The section also provides the usage of various aspects of SQL Server Management Studio. The chapters in section 2 provide a detailed coverage of Summary query, Subquery, Datatypes and functions. You will learn the procedure involved with the retrieval of data from tables and also the various aspects involved with inserting, updating and deletion of data.

While Section 3 provides a comprehensive coverage of database design and its usage and implementation with SQL Server Management Studio, Section 4 examines the working of Views, Scripts, Stored Procedures, Functions, Triggers, Cursors, XML and BLOBS including management of transactions, locking and database security.

Section 5 provides a brief overview of CLR integration including the usage of CLR Stored procedure, functions, triggers, aggregate function and user defined types. I hope these topics will be useful for advanced developers. The book includes three appendixes including a list of coding and syntax conventions. I would suggest the author provides a list of errors which may occur during the installation and usage of SQL Server 2008.

Each section begins with a detailed introduction followed by relevant syntax, examples, and screenshot of output and ends with a concise description in bulleted format. I feel readers will find it easy to go through the bulleted list rather than reading a lengthy paragraph. The book will be useful only if you have time to go through detailed content provided with each concept.

The book will be useful for instructors who impart training for students and I would suggest computer training centers keep a copy of the book on their library bookshelves. This book will not be useful for advanced developers and database administrators who are already well versed with SQL Server 2008. I would suggest the author provides a list of new features included with SQL Server 2008 so that developers can compare it with SQL Server 2005.

Conclusion

If you have read the previous edition of the book then you should buy the new edition to update yourself. From my point of view, it is always better to refer to a book rather than spending time online to get information about syntax updates and also to know about the new features included with SQL Server 2008.

Title – SQL Server 2008 for Developers
Author – Bryan Syverson and Joel Murach
Publisher – Murach Publishing
Edition – December 2008
Pages – 778
Price – US $52.50
Rating – ****

Reproduced from ASPAlliance.com

sql server 2008, murach publishing, sql

No related posts.


More Stories By Anand Narayanaswamy

Anand Narayanaswamy, a Microsoft Most Valuable Professional (MVP), works as an independent consultant based in Trivandrum, India. He also works as chief technical editor for ASPAlliance.com and is the author of Community Server Quickly (http://www.packtpub.com/community-server/book), published by Packt Publishing. He runs http://www.Learnxpress.com, http:/www.dotnetalbum.com and http://www.csharpfaq.com. Find out more about him and his other websites at http://www.visualanand.net.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


IoT & Smart Cities Stories
The platform combines the strengths of Singtel's extensive, intelligent network capabilities with Microsoft's cloud expertise to create a unique solution that sets new standards for IoT applications," said Mr Diomedes Kastanis, Head of IoT at Singtel. "Our solution provides speed, transparency and flexibility, paving the way for a more pervasive use of IoT to accelerate enterprises' digitalisation efforts. AI-powered intelligent connectivity over Microsoft Azure will be the fastest connected pat...
There are many examples of disruption in consumer space – Uber disrupting the cab industry, Airbnb disrupting the hospitality industry and so on; but have you wondered who is disrupting support and operations? AISERA helps make businesses and customers successful by offering consumer-like user experience for support and operations. We have built the world’s first AI-driven IT / HR / Cloud / Customer Support and Operations solution.
Codete accelerates their clients growth through technological expertise and experience. Codite team works with organizations to meet the challenges that digitalization presents. Their clients include digital start-ups as well as established enterprises in the IT industry. To stay competitive in a highly innovative IT industry, strong R&D departments and bold spin-off initiatives is a must. Codete Data Science and Software Architects teams help corporate clients to stay up to date with the mod...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Druva is the global leader in Cloud Data Protection and Management, delivering the industry's first data management-as-a-service solution that aggregates data from endpoints, servers and cloud applications and leverages the public cloud to offer a single pane of glass to enable data protection, governance and intelligence-dramatically increasing the availability and visibility of business critical information, while reducing the risk, cost and complexity of managing and protecting it. Druva's...
BMC has unmatched experience in IT management, supporting 92 of the Forbes Global 100, and earning recognition as an ITSM Gartner Magic Quadrant Leader for five years running. Our solutions offer speed, agility, and efficiency to tackle business challenges in the areas of service management, automation, operations, and the mainframe.
The Jevons Paradox suggests that when technological advances increase efficiency of a resource, it results in an overall increase in consumption. Writing on the increased use of coal as a result of technological improvements, 19th-century economist William Stanley Jevons found that these improvements led to the development of new ways to utilize coal. In his session at 19th Cloud Expo, Mark Thiele, Chief Strategy Officer for Apcera, compared the Jevons Paradox to modern-day enterprise IT, examin...
With 10 simultaneous tracks, keynotes, general sessions and targeted breakout classes, @CloudEXPO and DXWorldEXPO are two of the most important technology events of the year. Since its launch over eight years ago, @CloudEXPO and DXWorldEXPO have presented a rock star faculty as well as showcased hundreds of sponsors and exhibitors! In this blog post, we provide 7 tips on how, as part of our world-class faculty, you can deliver one of the most popular sessions at our events. But before reading...
DSR is a supplier of project management, consultancy services and IT solutions that increase effectiveness of a company's operations in the production sector. The company combines in-depth knowledge of international companies with expert knowledge utilising IT tools that support manufacturing and distribution processes. DSR ensures optimization and integration of internal processes which is necessary for companies to grow rapidly. The rapid growth is possible thanks, to specialized services an...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...