Bringing the Redgate Seminar to Brisbane
We’ve been on a Redgate tour this year, running lots of events to interest, educate, and inspire customers. We know that there are challenges in building and operating database...
2024-04-10
22 reads
We’ve been on a Redgate tour this year, running lots of events to interest, educate, and inspire customers. We know that there are challenges in building and operating database...
2024-04-10
22 reads
This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using the automated process. I have other posts on SQL Monitor as well. I heard from...
2024-04-10
54 reads
2024-04-10
455 reads
Today Steve discusses code freezes, those times when you don't allow changes to be made by developers.
2024-04-10
217 reads
This month I had a new host, Pinal Dave. I was surprised to see he hadn’t hosted, but I didn’t see him in the list. His invite is interesting,...
2024-04-09
32 reads
2024-04-08
586 reads
2024-04-08 (first published: 2019-08-21)
939 reads
Thanks to everyone that came to my presentation at SQL Saturday SLC 2024. This post has a few links for you: Code and repo: https://github.com/way0utwest/ZeroDowntime Slides: Architecting Zero Downtime.pptx...
2024-04-06
22 reads
alazia– n. the fear that you’re no longer able to change.. I don’t have alazia. I’m always thinking I change, sometimes even when I don’t want to. Certainly my...
2024-04-05
27 reads
UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar, 10:00am CDT. You can register here and then come watch live with questions or get...
2024-04-05 (first published: 2024-03-26)
235 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