Other PASS Summit 2022 Days - Pre-Cons | Day 1 | Day 2
--
Day 3 of Summit 2022 was "Community Day" with a "community keynote" given by the amazing Kimberly Tripp (@kimberlyltripp)...
2023-01-02 (first published: 2022-11-19)
202 reads
Day 2 of Summit 2022 started earlier than usual with the "Breakfast with the Microsoft team: SQL Futures and Strategy" - the food was good and the conversations with...
2022-11-30 (first published: 2022-11-18)
215 reads
The first "full" day of PASS 2022 kicked off with a bang when Rohan Kumar (@RohanKData) stepped out on the keynote stage to announce SQL Server 2022 was GA...
2022-11-25 (first published: 2022-11-17)
224 reads
In my blog post last night on Days 1 and 2 of the PASS Summit, I included the following comment:
(Along with that, I think having "hybrid" events like our...
2022-12-02 (first published: 2022-11-16)
140 reads
It's that time again...TUESDAY!
https://www.mememaker.net/static/images/memes/4791280.jpg
I mean...NOVEMBER!
https://tinyurl.com/33hezsje
OK fine...SUMMIT!
https://img.memegenerator.net/images/10802365.jpg
I have very much missed in-person events and I am glad that Redgate (@Redgate) has managed to continue the @PASSDataSummit framework - virtual presentations...
2022-11-16
50 reads
One of the frequently quoted ETL best practices is to disable your non-clustered indexes during a data load. Basically the conventional wisdom is that you disable the non-clustered indexes,...
2021-03-09 (first published: 2021-03-02)
1,140 reads
I am working on an Azure SQL Database migration from an on-premises VM, and at the client's request I am working through the BACPAC Import/Export process rather than using...
2021-02-16 (first published: 2021-02-08)
335 reads
There has been a lot of noise over the last few weeks since it was announced that due to financial constraints related to canceling the in-person Summit due to...
2021-01-15
75 reads
I was just working on a new SQL job, and part of creating the job was adding a few new tables to our DBA maintenance database to hold data...
2020-12-21 (first published: 2020-12-11)
504 reads
I have held various certifications through my DBA career, from CompTIA A+ certification back when I worked help desk (I'm old) through the various MCxx that Microsoft has offered...
2020-12-10 (first published: 2020-12-01)
668 reads
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Comments posted to this topic are about the item An Unusual Identity
Comments posted to this topic are about the item Prompt Requests
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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