Community Circle
Search this blog
Steve’s tweets
- Daily Coping 20 Jan 2021 voiceofthedba.com/2021/01/20/dai… 1 hour ago
- @stridergdm I agree. Any setup ought to require a default to be changed. 21 hours ago
- @stridergdm That "install SQL Server without a password" was one of the worst. Now I tend to see default passwords… twitter.com/i/web/status/1… 21 hours ago
The Current Book
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career
- cell phone
- Cloud Computing
- 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
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- patching
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Change Automation
- SQL Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Tag Archives: SQL Compare
Setting Defaults for New SQL Compare Projects
Recently I wrote about ignoring comments in SQL Compare. That seems like something I want to do in all my projects, so I went looking for how to set this as a default. It wasn’t obvious to me, but since … Continue reading
Ignoring Comments in SQL Compare
Recently I had a client that wanted to know how they could use SQL Compare to catch actual changes in their code, but not have comments show up as changes. This is fairly easy to do, and this post looks … Continue reading
Adding ApplicationIntent=readonly to SQL Data Compare
Recently someone asked a good question about SQL Data Compare. How can they add applicationintent to the connection? If you are using Data Compare, and you are reading from production systems, load is a concern. With Availability Groups (AG), we … Continue reading
Posted in Blog
Tagged Redgate, SQL Compare, syndicated
Comments Off on Adding ApplicationIntent=readonly to SQL Data Compare
Exchanging Schemas with SQL Compare Snapshots
Recently I was working with a customer and they asked if they could somehow package up their schema without the data and send this to a colleague. Absolutely, and that’s one reason we have SQL Compare snapshots. Here’s a quick … Continue reading
Posted in Blog
Tagged Redgate, SQL Compare, syndicated
Comments Off on Exchanging Schemas with SQL Compare Snapshots