This article offers a build-and-fill method for development databases, where each developer will subsequently want to alter the data or metadata in his or her copy of the database. Read more
Phil Factor provides a PowerShell script that uses SQL Doc produce database documentation and then pandoc to publish it in ePub format. Read more
A PowerShell script to automatically populate a SQL Server database with dummy data, for database development and testing work. Read more
The final part of Alex Yates's three-part series tackles the complicated issue of automating deployments when the same table might have a different structure, in different production versions of the database. Read more
Phil Factor uses PowerShell and SQL Doc to automatically generate database documentation, and update it on every successful build. Read more
Steve Jones proves that SQL Clone can create a clone from a TDE-protected SQL Server database backup. Read more
Steve Jones proves that SQL Clone can create a clone from a SQL Server database that is protected by Transparent Data Encryption (TDE). Read more
How to extract a database migration script, or a database build script, from a DacPac and then use it in a PowerShell-automated database deployment. Read more
How to eliminate false positives, and avoid making unintended changes to a database, when comparing the schema of two SQL Server databases. Read more
It’s sometimes too easy to close SQL Server Management Studio (SSMS) without saving your work. It’s also easy to get rid of tabs and scripts that you later wish you had back. SQL Prompt can help with both these problems. Take a look at the Options for SQL Prompt and you’ll find a set of Read more
