Handy TSQL for Azure SQL Database
I do not always use the Azure portal to make database changes or to check for certain information. I use...
2018-05-14
323 reads
All About SQL
Extended Events – Using Azure Storage
Last year I wrote about Azure SQL Database extended events (https://blobeater.blog/2017/02/06/using-extended-events-in-azure/) and gave an example where I was capturing deadlocks...
2018-05-21 (first published: 2018-05-08)
1,429 reads
Getting my Twitter Data via Azure Logic Apps
As a mini project I wanted to use Azure logic apps to pull tweets from my twitter account when people...
2018-05-02
333 reads
Azure SQL Database – A Copying “Gotcha”
Creating copies of your Azure SQL Database is a common and relatively simple process. You can issue a TSQL statement...
2018-04-24
354 reads
Azure SQL Database vCore
vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The...
2018-04-24 (first published: 2018-04-16)
2,375 reads
Azure SQL DW – Let’s Shuffle?
Initially, the main focus of this post was going to be quick and about using the latest version of SSMS...
2018-04-12
875 reads
Azure SQL Database and Columnstore Indexes
I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many...
2018-04-19 (first published: 2018-04-09)
2,233 reads
4 Improvements to Azure SQL Database
If I was a wizard I would make these 4 improvements to Azure SQL Database. They are in no particular...
2018-04-12 (first published: 2018-04-05)
2,182 reads
Azure SQL Database – Failed to Delete Database Nightmare
After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs....
2018-04-03
372 reads
Database Has Been Paused
I was looking forward to do some work with Azure SQL Data Warehouse (DWH) when I hit the new query...
2018-04-03 (first published: 2018-03-27)
3,464 reads
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
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...
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