Approaching Zero: Wrapping Up
This is part nine in a series on near-zero downtime deployments. What Have We Learned?
2019-03-30
DevOps and Continuous Delivery (CI/CD)
4 top tips for starting your database DevOps journey
If you’ve read the Accelerate State of DevOps Report from DORA and the 2019 State of Database DevOps report from Redgate, you’ll see how they resonate in terms of the benefits to be gained from adopting DevOps.
2019-03-30
How to get Database DevOps implemented at your business
Starting the process of implementing database DevOps doesn’t need to be a daunting five-year task that completely disrupts your business. Read the latest article from Redgate with 4 top tips for beginning your journey.
2019-03-30
The Problem with Continuous Delivery: Defining Continuous
The IT community should spend time thinking about what continuity actually means in the context of continuous delivery.
2019-03-28
SQL Server DevOps with Production Databases and Git
Learn how to start using DevOps techniques to upgrade your database containers with the latest version of your code from a git repository.
2019-03-11
2,525 reads
Data Governance, DevOps, and Delivery
Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to...
2018-06-29
2,318 reads
“Full Stack” Means “Part Time” – or Why DBAs Might Wanna Learn DevOps
Brent Ozar explains that if you're going to do continuous integration or deployment, you've got a rocky road ahead of you.
2018-04-10
4,855 reads
Creatures of habit, snowflakes, and integration tax
Why are practices like version control, continuous integration and automated deployment being introduced to application development but left on the shelf when it comes to the database? In search...
2017-09-08
4,133 reads
Protecting production data in non-production environments
In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production...
2017-09-04
4,570 reads
Top 10 DevOps Operational Requirements
One of the key tenets in DevOps is to involve the Operations team in the full software development lifecycle and, in particular, to ensure that operational requirements are incorporated...
2017-07-11
4,304 reads
Blogs
Using SQL Alerts to Spot Suspicious Activity in SQL
SQL doesn’t really give us too many tools out of the box to allow...
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can change the browser used by SQL Server Management...
Typing with Your Tongue Part 2: Voice Access
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Forums
Azure SQL database AAD user management
I have an Azure SQL DB where I have set up the Azure active...
Use a recursive CTE to produce 1 update statement using dynamic SQL
I want to be able to generate 1 merge statement rather than loop through...
Query to Update balance based on columns from two different rows.
Hello All, Below is the my existing table structure from which I am trying...
Ask SSC