Practice Those Scripts
A database script caused a large outage for Salesforce. Steve wonders if you have ideas on how to prevent this type of issue in your environment.
2019-06-21
429 reads
DevOps and Continuous Delivery (CI/CD)
2019-06-11
5,970 reads
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
1,178 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
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers