2019-06-11
5,225 reads
DevOps and Continuous Delivery (CI/CD)
Why DBAs Must Embrace DevOps
A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement in either situation is bad. In a perfect world, a DBA will be productive and not spending most of their time “putting out fires.” (And fires are never a good idea on a flight!)
2019-06-10
Unit Testing, Databases, and You
As database changes are added to the DevOps pipeline, unit testing of those changes becomes crucial. In this article, Adam Hafner describes unit testing and how it applies to databases.
2019-06-06
The Change Failure Rate
The number of times that you have a failure when deploying changes is a good metric to watch.
2019-06-03
118 reads
Enhance your database development by using coding standards
Establishing coding standards can help remove blockers to understanding code, improving quality and reducing maintenance. Faris Hilmi explains how having consistently formatted code plays a larger role in database development and how Redgate tools can best equip you for the task.
2019-05-30
Bringing certainty to the uncertainty of Brexit
These are tough times for businesses in the EU. Is the UK going to be in or out? Quite simply, businesses are finding it difficult to plan anything when everything is up in the air, and no one can confirm what will happen next. All of which is making many businesses wary of making a decision to invest in their IT infrastructure. Enter DevOps.
2019-05-21
Six reasons to version control your database
For application developers it is unthinkable to work without version control. Yet, only 55% of database developers are version controlling their database changes? Mary Robbins provides six reasons why you should version control your database.
2019-05-13
DevOps Is About Communication
I spend a lot of time showing how to use tools to automate database deployments in support of DevOps. However, the one message that I always try to deliver...
2019-05-13
Database Delivery with Docker and SQL Change Automation
Phil Factor demonstrates the basics of how to automate database builds into a Linux SQL Server container running on Windows, and then backup the containerized database and restore it...
2019-05-13
Why DBAs Must Embrace DevOps
A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement in either situation is bad. In a perfect world,...
2019-05-09
Blogs
What is a container anyway?
Recently there was a thread on Twitter which established that a lot of IT...
Comparing Execution Plans
When you run a query twice, and get dramatically different run times, your first...
What permissions do temp stored procedures use?
In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Optimize a stored procedure
I have a stored procedure that is called multiple times to get all the...
Status Update 19 Jun 2019
My apologies. I have completely slacked off here, but since the 17th of May,...
Ask SSC