SQL Server Source Control Basics
| Price | $0.99 - $20.50
|
| eBook | Free |
| Rating |  |
| Authors | Robert Sheldon, Rob Richardson, Tony Davis |
| Publisher | Self-publishing |
| Published | 2014 |
| Pages | 296 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1910035017 |
| ISBN-13 | 9781910035016 |
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.
- Robert Sheldon (2 books)
- Rob Richardson (2 books)
- Tony Davis
5 5 2
Similar Books
Beginning Microsoft SQL Server 2008 Administration
by Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger
SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation a...
Price: $5.17 | Publisher: Wrox | Release: 2009
Microsoft SQL Server 2008 Management and Administration 
by Ross Mistry, Hilary Cotter
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 f...
Price: $9.87 | Publisher: SAMS Publishing | Release: 2008
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
Pro SQL Server 2012 Integration Services
by Francis Rodrigues, Michael Coles, David Dye
Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You'll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid comm...
Price: $49.10 | Publisher: Apress | Release: 2012
Pro SQL Server 2012 Reporting Services, 3rd Edition
by Brian McDonald, Shawn McGehee, Rodney Landrum
Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you'll want to take advantage of if you're ru...
Price: $25.17 | Publisher: Apress | Release: 2012
Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition
by Marco Russo, Alberto Ferrari
Create a semantic model and analyze data using the tabular model in SQL Server 2016 Analysis Services to create corporate-level business intelligence (BI) solutions. Led by two BI experts, you will learn how to build, deploy, and query a tabular model by following detailed examples and best practices. This hands-on book shows you how to u...
Price: $45.42 | Publisher: Microsoft Press | Release: 2017
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
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...
Free ebook | Publisher: Self-publishing | Release: 2018