Search this blog
The Current Book – Do Hard Things
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Search this blog
Steve’s Tweets
- RT @GFritchey: Call for Speakers for SQL Saturday Columbus 2023 is open on Sessionize and I've just submitted a session! https://t.co/uFvj… 1 day ago
- @dduensingIII Enjoy the trip 1 day ago
- Another crowded morning in the office https://t.co/aztmgEdSEs 1 day ago
- Pre flight https://t.co/RndxQ6u6qE 1 day ago
- RT @tjaybelt: anyone?? #sqlfamily 1 day ago
- RT @bweissman: If anybody wants a second pair of eyes for their @PASSDataSummit abstracts - you know where to find me :) 1 day ago
- @dgmelkin @SQLBek Safe travels 1 day ago
- @codegumbo Congrats. Hope it goes well and we see you getting back to blogging. Maybe a new job series like @TracyBoggiano wrote 1 day ago
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Older Posts
Meta
Tag Archives: SQL Compare
A SQL Compare Picklist
Recently a customer was trying to sync up production and development. They’d somewhat lost control of both environments and wanted to build a plan of how to sync them. This post covers a process I suggested to them to tackle … Continue reading
Posted in Blog
Tagged development, Redgate, SQL Compare, syndicated
Comments Off on A SQL Compare Picklist
Search and Replace Three Part Names with SQL Compare
A customer had an interesting challenge in their codebase recently, and I thought this would make a good post. This involves SQL Compare and three part names. The Scenario A customer was using SQL Compare and they wanted to update … Continue reading
Posted in Blog
Tagged Redgate, SQL Compare
Comments Off on Search and Replace Three Part Names with SQL Compare
Ensuring SQL Compare Checks Synonyms
I was running a PoC for a customer and they noticed that synonyms were being missed when they changed the database being used. It was surprising to me, but it turns out the solution is simple. This post explains how … Continue reading
Posted in Blog
Tagged Redgate, SQL Compare, syndicated
Comments Off on Ensuring SQL Compare Checks Synonyms
Ignoring System Generated Key Names in SQL Compare
Recently I ran into a customer that was having issues deploying code from their development system to their production system. The issue was that they often found that the deployment script wanted to drop and recreate their keys. This wasn’t … Continue reading
Posted in Blog
Tagged Redgate, SQL Compare, syndicated
Comments Off on Ignoring System Generated Key Names in SQL Compare