Earlier this year, I embarked on a bit of a project to tidy up the indexes in a sizeable database. This database has over 900 tables, and there are...
2024-08-12 (first published: 2024-07-29)
430 reads
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mala Mahadevan
(blog) asks how we manage our database-related code.
Where do you keep...
2024-08-12
13 reads
As a data professional, you’ll often get a phone call, email, or trouble ticket that says “SQL Server is slow, my query is slow, or things are slow”. This...
2024-08-12
14 reads
hiddled – adj. feeling of loneliness of having to keep a secret to yourself. I don’t know I am often hiddled. I don’t tend to keep secrets by myself....
2024-08-09
20 reads
As someone attending the event since 2011, I would like to share my personal experience, the value of attending, and how the event has helped me throughout my career....
2024-08-09 (first published: 2024-07-24)
118 reads
What will the technology world look like in 2030? Cloud computing will naturally be the backbone of the world but I think with variants in “decentralising” concepts. By this...
2024-08-09 (first published: 2024-07-31)
123 reads
Doc Pop and Evan Prodromou discuss the past, present, and future of ActivityPub and the fediverse.
2024-08-09
31 reads
Why am I focussing on RWA (real world assets) as the next big thing? The WEF predicted that by 2027, 10% of the world’s GDP could be stored on...
2024-08-09
21 reads
We all know that choosing the right basic SQL training is absolutely crucial if you want your SQL journey to be a success story, especially when you're starting from...
2024-08-08 (first published: 2024-08-07)
171 reads
Seven things every WordPress user should know about Gravatar
2024-08-08
26 reads
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers