SQL Server Source Control Basics



Bookstore > Books > SQL Server Source Control Basics

SQL Server Source Control Basics
Free Download
Buy
Preview
Price$0.99 - $20.50
eBookFree
Rating
AuthorsRobert Sheldon, Rob Richardson, Tony Davis
PublisherSelf-publishing
Published2014
Pages296
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101910035017
ISBN-139781910035016
EBook Hardcover Paperback

Few software developers would build an application without using source control, but its adoption for databases has been slower. Yet without source control to maintain the scripts necessary to create our database objects, load lookup data, and take other actions, we cannot guarantee a reliable and repeatable database deployment process, let alone coordinate database upgrades with changes to the application. We also run the risk that our "ad hoc" database patching will cause inconsistencies and data loss. Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started. It provides 'just enough' detail about the core components of a source control system and how to incorporate that system into the database development and deployment processes, covering: Database Source Control architecture - what to include, how to structure the components Collaborative editing - teamwork on a database project, while minimizing change conflicts and data loss. Change auditing - what changed between versions and who changed it? Branching -work independently on separate features and control what to deploy and when Merging - what happens if one user changes a column name while another updates its data type? A merge operation lets the team decide the correct outcome Building and Deploying databases - building new databases and upgrading existing ones from source control Every chapter follows the same "half-theory, half practice" template, so you learn the concepts then see how they work.


  1. (2 books)
  2. (2 books)



5 5 2

Similar Books


Beginning SQL Server Modeling

Beginning SQL Server Modeling

by Bart Weller

Beginning SQL Server Modeling will help you gain a comprehensive understanding of how to apply DSLs and other modeling components in the development of SQL Server implementations. Most importantly, after reading the book and working through the examples, you will have considerable experience using SQL Modeling components, because the book...

Price:  $17.99  |  Publisher:  Apress  |  Release:  2010

Microsoft SQL Server 2012 with Hadoop

Microsoft SQL Server 2012 with Hadoop

by Debarchan Sarkar

With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indee...

Price:  $23.99  |  Publisher:  Packt Publishing  |  Release:  2013

SQL Server Execution Plans, 3rd Edition

SQL Server Execution Plans, 3rd Edition

by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the informati...

Publisher:  Self-publishing  |  Release:  2018

A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

by Eric Johnson, Joshua Jones

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL...

Price:  $6.15  |  Publisher:  Addison-Wesley  |  Release:  2008

Expert SQL Server Transactions and Locking

Expert SQL Server Transactions and Locking

by Dmitri Korotkevitch

Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you devel...

Price:  $24.23  |  Publisher:  Apress  |  Release:  2018

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

by Andy Leonard

Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom SSIS ...

Price:  $34.99  |  Publisher:  Apress  |  Release:  2021

Getting Started with SQL Server 2014 Administration

Getting Started with SQL Server 2014 Administration

by Gethyn Ellis

The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such ...

Price:  $16.99  |  Publisher:  Packt Publishing  |  Release:  2014

SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials

by Basit A. Masood-Al-Farooq

SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. The variety of new in-memory features enable you to design high performance database applications that can improve ...

Price:  $26.99  |  Publisher:  Packt Publishing  |  Release:  2014