Validating a Set of Database Scripts using DLM Automation
The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or...
2016-12-09 (first published: 2016-11-28)
1,888 reads
The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or...
2016-12-09 (first published: 2016-11-28)
1,888 reads
2016-12-09
1,143 reads
It seems that everyone has a different idea on how to interview people. Today Steve Jones looks at the technique of having someone improve some code in real time.
2016-12-08
106 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-08
679 reads
2016-12-08
981 reads
Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free...
2016-12-07
498 reads
2016-12-07
1,073 reads
I got a link recently from Microsoft on building apps easily for SQL Server. At the top of the page,...
2016-12-06
1,383 reads
2016-12-06
1,139 reads
2016-12-05
922 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