Azure SQL Database – Aborting Scale Request
Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy...
2018-11-07
287 reads
All About SQL
Azure SQL Database – Who Changed My Auto Tuning Settings?
One of the features Microsoft wants us to use for Azure SQL Database is Automatic Tuning. Automatic Tuning is a...
2018-11-01
291 reads
Whirlwind Tour of Azure SQL Database
I have finally uploaded my Azure SQL Database presentation, apologies for the delay. I am already working on an improved...
2018-10-24
804 reads
Azure SQL DB – Failed to update database because the database is read-only
Quite an interesting situation I found myself in where I was perplexed for about 5 minutes. I was connected to...
2018-10-22
424 reads
SQL Server – Reading BACPAC Files
If you have been reading my blog for a while now you would know that a common technique to move...
2018-10-19
274 reads
Auto-Scaling Azure SQL DB
When I was presenting my Azure SQL Database session at DataRelay (used to be SQLRelay) I was asked (over coffee)...
2018-10-11
964 reads
Giant Azure SQL Databases
Okay it is not really called Giant Azure SQL Database but its close. There is a new public preview vCore...
2018-10-04
335 reads
Testing Failover for Azure SQL Database
It is always a good idea to test your failover processes when you have setup failover groups in Azure. I...
2018-10-02
355 reads
Using Microsoft Azure – Twitter Analysis
Time for a fun post, I have been working on a mini-project using technology from Microsoft Azure to hook into...
2018-09-27
413 reads
Accidentally deleted an Azure SQL DB?
Okay honestly I have done this once. I have deleted Azure SQL Databases and then try and find the quickest...
2018-09-24
261 reads
Blogs
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Forums
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Question of the Day
An Unusual Identity
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