You can create foreign keys using TSQL roughly the same way as you created primary keys. You can either use the ALTER TABLE statement to add the foreign key,...
2021-06-07 (first published: 2021-05-24)
437 reads
As a SQL database administrator, it’s your responsibility to maintain and secure the databases. However, you may still experience database corruption. If not handled correctly and on time, you...
2021-05-24
27 reads
As a SQL database administrator, it’s your responsibility to maintain and secure the databases. However, you may still experience database corruption. If not handled correctly and on time, you...
2021-05-24
5,848 reads
On Tuesday I'm looking forward to presenting again at GroupBy Americas on a topic that was voted on by the attending public. This presentation "SQL Server Admin Best Practices...
2021-05-24
46 reads
Where I’ve Been Since January 1, 2012 I’ve been the principal consultant at Centino Systems. Jokingly, I refer to myself as The Centino of Systems. I learned a lot...
2021-05-22
7 reads
Where I’ve Been Since January 1, 2012 I’ve been the principal consultant at Centino Systems. Jokingly, I refer to myself as The Centino of Systems. I learned a lot...
2021-05-22
30 reads
I get asked this question all the time, so I figured it was time to write a blog post, record a video and write some code to automate the...
2021-06-09 (first published: 2021-05-22)
318 reads
Here is a short but sweet post on how to change the drive letter of a partition. Despite using my best Google skills I couldn’t find an example that...
2021-06-07 (first published: 2021-05-21)
374 reads
(last updated: 2021-05-31 @ 19:00 EST / 2021-05-31 @ 23:00 UTC ) Many of us that work with Microsoft SQL Server, especially those of us working on systems with...
2021-05-21
202 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-21
19 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Telp/Wa 62 8218200233 Gedung Millennium Centennial Ground Floor Unit C, Jl. Jenderal Sudirman No.Kav....
Telp/Wa 62 8218200203 Komp. Cipulir Permai, E Jl. Ciledug Raya No.9, RT.9/RW.5, Ulujami, Kec....
Telp/Wa 62 8218200233 The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt....
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers