Daily Coping 20 Feb 2023
Today’s coping tip is to appreciate the good qualities of someone in your life. We have a person in Redgate that does a lot of work to support our...
2023-02-20
10 reads
Blog Posts
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31 March each year to provide the list of their annual contributions. For 2023, the deadline...
2023-02-20 (first published: 2023-02-01)
140 reads
Rotating a Certificate Used by TDE
In terms of encryption, Key Rotation is the process of replacing your encryption keys on a periodic basis. This is considered good practice and is required by many security...
2023-02-20 (first published: 2023-02-06)
292 reads
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...
2023-02-17 (first published: 2023-01-31)
615 reads
Daily Coping 17 Feb 2023
Today’s coping tip is to support a local business with a positive online review or friendly message. When I discover a business I like or one that delivers value...
2023-02-17
16 reads
Using SQL Data Compare from the Command Line with a Project
SQL Data Compare (SDC) is a great way to sync data among tables. It’s a software utility analogous to SQL Compare, but working with data rather than schema. I...
2023-02-17 (first published: 2023-01-25)
744 reads
Daily Coping 16 Feb 2023
Today’s coping tip is to focus on being kind rather than being right. This is one of the things that grows my wisdom over time. I don’t need to...
2023-02-16
15 reads
Context Info Across Databases–#SQLNewBlogger
Does Context Info work across databases? This post shows it does. Another post for me that is simple and hopefully serves as an example for people trying to get...
2023-02-15 (first published: 2023-02-01)
208 reads
Daily Coping 15 Feb 2023
Today’s coping tip is to look for good in others, particularly when you feel frustrated. We all deal with conflicts with others throughout out lives. How we handle those...
2023-02-15
15 reads
Why Managed Identities are Awesome
For the first workdays of this new year, I had the pleasurable task of resetting a bunch of passwords. The passwords belong to Azure AD users, service principals, SQL...
2023-02-15 (first published: 2023-02-01)
511 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