SQL Compare has a simple premise: it will compare two databases, a source, and a target, and generate a script that, when executed on the target, will make its schema the same as the source. Tony Davis explores all the ways this can be helpful during database development work.
2020-10-01
Learn about how ownership chaining allows you to limit permissions on specific database objects yet give users access through other objects such as views and stored procedures.
2020-10-01
This tip provides a step by step process to create a cross tabulation report in SQL Server Reporting Services.
2020-09-30
You are invited to discover features of SQL Prompt that you may not even know exist. We will will walk you through the treasure map of SQL Prompt and show you where all the great features are buried.
2020-09-30
While everyone knows SQL Prompt for its code completion and IntelliSense features, a lot of its extra value comes from features that allow the development team to standardize coding practices and drive up code quality.
2020-09-29
Containers are being used by more and more organizations to automate build pipelines in their CICD processes. In this article, Mahendran Purushothaman shows how to automate the creation of Docker containers and a Kubernetes cluster in Azure.
2020-09-29
In my last post, I talked about how you can get 43%-67% faster backups. This time, I’m using that same SQL Server setup to discuss how throwing more CPU cores might help you check for corruption faster if you’ve already got modern fast storage.
2020-09-28
When database development is described, the details often get vague when the data gets beyond spreadsheet-size. There is 'hand-waving' talk of providing databases for each developer, but little detail of how you would provision all the databases that would be needed, at the correct version and with the correct development data, and then keep them all in sync with the source code, as developers commit changes. This article explains the requirements, and how SQL Clone can meet them.
2020-09-28
How can you use GitHub to do team-based database development? This article proposes a process that splits development work into task-based GitHub branches, incorporates daily database builds and integration testing, and using Redgate tools to automate tasks such as provisioning, database scripting, and testing.
2020-09-25
Sometimes there is a need to find if a string value exists in any column in your table. This script will help you find all occurrences in all columns in the table.
2020-09-25
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers