The Current Book
Search this blog
Steve’s tweets
- @gethyn_ellis @SQLMelody @YatesSQL @sqlgirl @sqlpass small. It always is. Usually 400-500 will win a seat. Membersh… twitter.com/i/web/status/1… 1 hour ago
- @IrishSQL @lmlewis517 @SQLServerCentrl Anytime, and always happy to help. I mentor lots of authors, but haven't rea… twitter.com/i/web/status/1… 1 hour ago
- Just watched the #PASSWIT lunch talk from #PASSSummit If you haven't seen @lmlewis517, take a lunch and watch. I'd… twitter.com/i/web/status/1… 1 hour ago
Friends of Redgate
SQL in the City Summit
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career
- cell phone
- Cloud Computing
- computers
- containers
- continuous delivery
- continuous integration
- data
- data analysis
- database design
- databases
- Database Weekly
- dbatools
- deployment
- Dev Connections
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- 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 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
- virtualization
- webinar
- windows
- work
Tag Archives: deployment
Practice Those Scripts
I’ve written lots of scripts that were deployed to production. I’ve often had another set of eyes look them over, and still, we made mistakes. In fact, a recent Salesforce outage was blamed on a poorly written database script that … Continue reading
Posted in Editorial
Tagged deployment, DevOps
Rolling Back Migrations
I happen to be a fan of database migrations as a way of making and deploying database changes. This is an approach that tracks each of the scripts run by developers in their working environments and the replays these scripts … Continue reading
Posted in Editorial
Tagged deployment, DevOps
Are Indexes Actually Changes to the System?
I haven’t thought about this in some time, but Brent Ozar raises an interesting question: should index changes require change control? I’ve worked in an organization that didn’t consider an index change to be an item that was presented as an … Continue reading
Posted in Editorial
Tagged deployment, DevOps
Dark Reads During a Migration
I caught a post from the Slack Engineering team titled: Re-architecting Slack’s Workspace Preferences: How to Move to an EAV Model to Support Scalability. In the post, an engineering intern describes the move from a blob table (actually a table storing … Continue reading
Posted in Editorial
Tagged deployment
