Download code to create sample databases and also the lesson example scripts for my book.
DISCLAIMER:
The code is provided "AS IS" without any warranty of any kind, express or implied. The Grumpy Old IT Guy Publishers, and the author(s) are not responsible for any damage, data loss, or intended consequences resulting from the use or modification of this code in production or other environments.
By using this code, you understand and acknowledge that it is for instructional purposes only and that you assume full responsibility for any use beyond the intended learning scope.
Download code to create sample databases and also the lesson example scripts for my book.
DISCLAIMER:
The code is provided "AS IS" without any warranty of any kind, express or implied. The Grumpy Old IT Guy Publishers, and the author(s) are not responsible for any damage, data loss, or intended consequences resulting from the use or modification of this code in production or other environments.
By using this code, you understand and acknowledge that it is for instructional purposes only and that you assume full responsibility for any use beyond the intended learning scope.
Download code to create sample databases and also the lesson example scripts for my book.
DISCLAIMER:
The code is provided "AS IS" without any warranty of any kind, express or implied. The Grumpy Old IT Guy Publishers, and the author(s) are not responsible for any damage, data loss, or intended consequences resulting from the use or modification of this code in production or other environments.
By using this code, you understand and acknowledge that it is for instructional purposes only and that you assume full responsibility for any use beyond the intended learning scope.
Download code to create sample databases and also the lesson example scripts for my book.
DISCLAIMER:
The code is provided "AS IS" without any warranty of any kind, express or implied. The Grumpy Old IT Guy Publishers, and the author(s) are not responsible for any damage, data loss, or intended consequences resulting from the use or modification of this code in production or other environments.
By using this code, you understand and acknowledge that it is for instructional purposes only and that you assume full responsibility for any use beyond the intended learning scope.
Download the lesson code, database creation instructions, and lesson examples.
Appendices and code examples for volume 1.
The Grumpy Data Modeling Handbook cuts through the fluff and gives you real-world, battle-tested advice on building durable, high-performance databases. Whether you're designing a transactional system, a financial ledger, or a data warehouse, this handbook takes you from raw requirements to fully normalized (or properly denormalized!) physical models—complete with SQL Server DDL examples, diagrams, and field notes from the trenches.
This section contains selected Microsoft SQL Server scripts from the book to create databases and tables, and to load the tables.
This section also contains the T-SQL scripts to query system views and data management views (DMV) discussed in the book.