With 2020 just around the corner, organizations of all shapes and sizes are considering what the next 12 months plans should look like. Here is what you need to know about including the database in your plans.
2019-11-11
Before including the database in your DevOps pipeline, you’ll need to decide if you are going to use a state-based or migrations-based approach. In this article, Robert Sheldon explains the difference between them and discusses the benefits of each.
2019-11-07
Is DevOps central to your 2020 IT Digital transformation? How does your IT strategy underpin the business objectives? Read our latest blog to ensure you’re ready for success next year.
2019-11-05
Microsoft has grown and changed their culture in the last few years, which greatly impresses Steve.
2019-11-01
310 reads
DevOps might sound intimidating if your organisation has not yet begun on its DevOps journey. In this article, Rahul Varshneya explains some of the benefits and reviews the stages all DevOps organisations go through to achieve it.
2019-10-28
Organizations are looking for help with their DevOps implementation, including Redgate tools, knowing where they want to go with their production and deployment but not sure where to start. Clear Measure have designed a 30-point DevOps Inspection & Report to provide you with the feedback and guidance you need to take your software development and deployment to another level. Request your inspection now.
2019-10-25
When you struggle with a software task, the best advice is to do it more often and get better at the task, not avoid doing it.
2020-11-10 (first published: 2019-10-22)
266 reads
You’ve probably heard of Compliant Database DevOps, but to take it from buzzword to boardroom relies on demonstrating value across your business. IT leaders must think more broadly than cost savings and ROI calculations when investing in scaling DevOps across database teams.
Our latest whitepaper explains how to lay the foundations for a successful DevOps implementation, and how to track success against global metrics that demonstrate your team’s impact across the business.
2019-10-14
Azure SQL Database can be patched without stopping the sqlsrvr.exe process. Quite a feat of engineering.
2019-10-08
184 reads
Culture change is hard, and it's one of the most difficult things to implement when trying to get your team to work in a DevOps fashion.
2019-10-01
225 reads
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and...
By Steve Jones
Imagine this situation, someone edits a stored procedure on a production server to “fix”...
By Brian Kelley
If you're not having success in convincing your organization to send you to this...
Good morning, I've noticed my CDC job running for 17 days. I've noticed it...
We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly...
Not sure if this is my misunderstanding or an error in my process: Create...
I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
CREATE TABLE CustomerLarge ( CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) , creditlimit INT , discount numeric(4,2) , lastorderdate DATETIME , lastorderamount NUMERIC(10,2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT) GOIf I want to detect that the creditlimit was updated, what IF statements should I use? See possible answers