An emerging discipline called DataOps is taking a page out of the DevOps playbook. The latter is all about accelerating the time to software delivery, and the former about accelerating data flow. And just as DevOps replaces the waterfall method of software delivery, DataOps replaces the waterfall approach of delivering data to the data consumer.
2019-05-03
Kendra Little gets a bit closer to a meaningful definition of automation, as it applies to the software development process.
2019-05-02
In my last post I showed how to build an Azure DevOps Pipeline for a Terraform build of an Azure SQLDB. This will take the terraform code and build...
The...
2019-04-22
I started this series with the title “Azure DevOps, SSIS, and Git” in a post titled Azure DevOps, SSIS, and Git Part 0 – Getting Started. I am renaming...
2019-04-21
Want to get database DevOps implemented where you work but unsure where to start or how? We’ve written a handy blog to help you begin your database DevOps journey....
2019-04-15
Continuous delivery and automation are a couple of core concepts of DevOps. As a Data Professional, Derik Hammer has spent countless hours pushing through the resistance of people who feel the data tier should be left out of source control, automated deployments, and who feel the need to make the data tier a separate work stream from applications.
2019-04-05
This is part nine in a series on near-zero downtime deployments. What Have We Learned?
2019-03-30
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
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 IT community should spend time thinking about what continuity actually means in the context of continuous delivery.
2019-03-28
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
I've read a few posts regarding what we use to design DB models and...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers