A book mainly addressed to developers, especially to those who want to switch roles to software architecture, in an agile environment.
Read more on my LinkedIn article.
Wednesday, June 26, 2019
Wednesday, June 19, 2019
Designing Autonomous Teams and Services
A review of Designing Autonomous Teams and Services book by Scott Millett and Nick Tune (O'Reilly, 2017)
Read it on my LinkedIn profile article.
Tuesday, June 18, 2019
SQL SELECT / UPDATE formatting trick
Many times I'm using this very simple SQL formatting for both SELECT & UPDATE (usually with MS SQL Server using SQL Server Management Studio or some other tool, interactively):
SELECT Count(*) -- TOP 20 A.*
-- UPDATE A SET A.Field1=B.Field1
FROM A INNER JOIN B ON A.ID=B.ID
WHERE <condition>
By default, all query is just a SELECT Count(*) which doesn't change anything but give you an idea of the number of records selected or updated later.
If I comment out the first part to something like this:
SELECT /*Count(*) --*/ TOP 20 A.*
it gives me some records that will be updated.
Then just undo the change and select the query from the UPDATE and execute the selected text. Also, the number of records updated should match the number displayed with Count(*).
It's like 3-in-1, which can easily go in comments of the ticketing system or emails.
SELECT Count(*) -- TOP 20 A.*
-- UPDATE A SET A.Field1=B.Field1
FROM A INNER JOIN B ON A.ID=B.ID
WHERE <condition>
By default, all query is just a SELECT Count(*) which doesn't change anything but give you an idea of the number of records selected or updated later.
If I comment out the first part to something like this:
SELECT /*Count(*) --*/ TOP 20 A.*
it gives me some records that will be updated.
Then just undo the change and select the query from the UPDATE and execute the selected text. Also, the number of records updated should match the number displayed with Count(*).
It's like 3-in-1, which can easily go in comments of the ticketing system or emails.
Achieving DevOps: A Novel About Delivering the Best of Agile, DevOps, and Microservices
If you are interested in modern software development, with 2019 methodologies, practices and tools, especially using Microsoft technology stack, this is the book to read. It may have something for you, as it covers a lot of ground of Agile & DevOps, but also everything else that comes with them, chapter by chapter, section by section: teams, processes, tools, testing, automation, infrastructure as code, configurations, continuous integration, continuous delivery & deployment, life / work balance, and more.
Continue reading on my LinkedIn profile article.
Saturday, June 15, 2019
Accelerate: The Science of Lean Software and DevOps
A review of highly recommended book Accelerate: The Science of Lean Software and DevOps (2018), by Nicole Forsgren PhD, Jez Humble and Gene Kim.
It's based on Puppet State of DevOps Reports between 2015 and 2018, which I also recommend (read 2018 report here)
If you think of using Agile & DevOps practices to accelerate software development and continuous delivery this book is a 'must-read'.
Read full article on my LinkedIn.
Subscribe to:
Posts (Atom)