T-SQL Tuesday #85–Cross Version Restores
It’s T-SQL Tuesday time, and this month Ken Fisher hosts. His topic is backups, and while I’m sure there will...
2016-12-13
590 reads
It’s T-SQL Tuesday time, and this month Ken Fisher hosts. His topic is backups, and while I’m sure there will...
2016-12-13
590 reads
I like ReadyRoll, and this week at SQL in the City 2017, I get to show some of the product...
2016-12-13
438 reads
2016-12-13
898 reads
2016-12-12
98 reads
I’ve got my work cut out for me. This week is SQL in the City 2017. One of the sessions...
2016-12-12
493 reads
I’m getting excited, with the announcement that SQL Bits 2017 is scheduled. The conference goes back to Telford, which I...
2016-12-12
529 reads
Is your IT department outdated? There's a prediction that they won't be around in five years. Steve Jones doesn't agree.
2016-12-12 (first published: 2013-06-13)
382 reads
2016-12-12
912 reads
Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy.
https://channel9.msdn.com/Blogs/vsppstories/Including-the-database-in-your-DevOps-pipeline/player
Filed under: Blog Tagged: DevOps,...
2016-12-09
713 reads
Measuring the performance of systems isn't always just CPU, RAM, and Disk IO. Today Steve Jones looks at business based metrics.
2016-12-09
109 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