What do you think?
Rate this book
Beginning Microsoft SQL Server 2012 Programming
Get up to speed on the extensive changes to the newest release of Microsoft SQL ServerThe 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, "Beginning Microsoft SQL Server 2012 Programming" begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012.
You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications.Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements Addresses essential topics including managing keys, writing scripts, and working with store procedures Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services
"Beginning Microsoft SQL Server 2012 Programming" demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.
You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications.Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements Addresses essential topics including managing keys, writing scripts, and working with store procedures Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services
"Beginning Microsoft SQL Server 2012 Programming" demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.
864 pages, Paperback
First published April 9, 2012
7 people are currently reading
23 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 4 of 4 reviews
February 24, 2017
As a beginner I found myself looking for a book that could introduce me to SQL querying and perhaps a bit more. I bought 2 different books and they were utter garbage until I decided to invest into this one. Third luck is the charm.
The big plus is the simplicity of the book and examples used. If you follow examples you will have no problem reaching even intermediate level of SQL knowledge. The minus is that there are some chapters that were, by my opinion redundant. Those chapters cover the administration of databases and all charming stuff that goes with it.
However 80% of the book is useful, thus 4/5.
The big plus is the simplicity of the book and examples used. If you follow examples you will have no problem reaching even intermediate level of SQL knowledge. The minus is that there are some chapters that were, by my opinion redundant. Those chapters cover the administration of databases and all charming stuff that goes with it.
However 80% of the book is useful, thus 4/5.
July 2, 2015
As far as programming books go, this was one of the better ones I've read. It's well-written and uses diagrams and screenshots in just the right ratio to text. There are helpful notes and asides that provide some real-world context to the topics. I also very much appreciated when the authors called out which features were new, which features were deprecated, and provided notes on considerations for backwards compatibility. I did a lot of SQL Server work from 2000 to early 2008, and these notes helped me to easily see what's been added in the years and versions since.
As far as the material that is covered, this book starts with basic database concepts, covers T-SQL syntax with some notes on optimizing your queries, and then proceeds to briefly touch on pretty much every advanced feature that is available--including Analysis Services, Reporting Services, and Integration Services. The authors give you a summary of these more advanced features, a few examples, and then move on. There are entire books about each of these topics, but it was very nice to get an introduction.
Overall, it was oddly enjoyable to read this book. I'm a geek.
As far as the material that is covered, this book starts with basic database concepts, covers T-SQL syntax with some notes on optimizing your queries, and then proceeds to briefly touch on pretty much every advanced feature that is available--including Analysis Services, Reporting Services, and Integration Services. The authors give you a summary of these more advanced features, a few examples, and then move on. There are entire books about each of these topics, but it was very nice to get an introduction.
Overall, it was oddly enjoyable to read this book. I'm a geek.
May 11, 2016
This is the perfect book for a beginner. This book goes fairly deep and will require a lot of effort from a beginner to read through. After reading through this book, the beginner will have become the master.
The work experience of the author is flowing through the different scenarios described in these books. Most of these scenarios, problems and solutions are gold for a beginner to know and apply on the job when necessary.
Would definitely suggest this book to a beginner.
The work experience of the author is flowing through the different scenarios described in these books. Most of these scenarios, problems and solutions are gold for a beginner to know and apply on the job when necessary.
Would definitely suggest this book to a beginner.
May 13, 2015
Better coverage of Analysis Services (SSAS) Cubes, BISM Tabular, ROLAP, etc.
Displaying 1 - 4 of 4 reviews