Steve Jones explains how SQL Clone can be used to create multiple copies of a database for different testing scenarios, while using just a fraction of the disk space. For example for developers to experiment in sandbox environments, with full copies of large databases, without the hassle and delays of restoring backups or copying database files.
2017-02-14
928 reads
2017-02-14
952 reads
The GitLab crisis has Steve Jones thinking about two things: competence and care.
2017-02-13
120 reads
There’s a group at Redgate that investigates new ideas and products. They’re called the Foundry, and they do some cool...
2017-02-13
475 reads
An updated editorial. The five years are almost up for the prediction that IT departments would be eliminated. Read Steve Jones thoughts on where we are today.
2017-02-10
109 reads
2017-02-10
1,113 reads
This is a cool productivity trip, and one that I ran into by accident. I had heard that I could...
2017-02-09
1,754 reads
DevOps is supposed to help us build better software, faster. Steve Jones looks at one of the other benefits: security.
2017-02-09
98 reads
2017-02-08
166 reads
I saw a question recently about how to allow some users to see the logins on a server without being...
2017-02-08
827 reads
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