Azure IaaS Premium Storage Test
I thought I would share the output of some DiskSpd tests that I conducted on Azure VMs that ultimately will...
2016-09-19
557 reads
All About SQL
Restoring Azure SQL Database
A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering...
2016-09-23 (first published: 2016-09-16)
1,223 reads
More PowerShell for the Azure World
The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use...
2016-09-15
483 reads
PowerShell to create Azure SQL DBs
Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So...
2016-09-14
515 reads
DBCC CHECKFILEGROUP
Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to...
2016-09-14 (first published: 2016-09-13)
1,227 reads
Query Performance Insight
It is really easy getting insight into Query performance within your Azure SQL DB. I think Microsoft have done a...
2016-09-12
759 reads
DBCC HELP
I was going through some online courses and came across Erin Stellato’s Course on DBCC commands.http://www.sqlskills.com/blogs/paul/new-course-understanding-and-using-dbcc-commands/ I learnt something new!...
2016-09-09
544 reads
CHECKDB is slow!
Running the usual consistency checks on a database (with a new release code applied from an ISV) I noticed slower...
2016-09-01
405 reads
Talking of checkpoint
I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine...
2016-08-25
189 reads
Do YOU Checksum?
I am going to show you why you should be using checksum options on your backups (and restores). I AM...
2016-08-11
202 reads
Blogs
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...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Prompt Requests
Comments posted to this topic are about the item Prompt Requests
T-SQL in SQL Server 2025: JSON_OBJECTAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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