Tables & Chairs
I want to put something into my table. Help!
INSERT
So long, Sybase! We're switching to this database platform instead
Microsoft SQL Server
This group is responsible for organizing this Geek Weekly
Tech Ecosystem
BLKMUSE2K
DSWRITE
This constraint helps me maintain uniqueness across my table
PRIMARY KEY
The year SQL Server made it's fabulous debut on Linux!
2017
For The Culture
BLKMUSE2C
DSREAD
I forgot this and accidentally just updated 8000 records on a table in production!
WHERE clause
Harry Potter's godfather who sadly passes at the end of the film
Sirius Black
The "L" in BLK
(B)Lac(Rock)
ADMMUSE2_DSQ
DSADM
Atomicity, Consistency, Isolation and...
Durability
We use this tool to replicate between Sybase & SQL Server
HVR
The head of Aladdin Engineering in Edinburgh
Kieron Smythe
USHMUSE2_CD
DSCENTRAL
This function allows performing calculations across a set of rows that are related to the current row, without collapsing the result within the output
WINDOW
A function unavailable on Sybase, but used on SQL Server & Snowflake. A key component of HVR replication...
WINDOW functions
This office was the first international location for BlackRock
Edinburgh
BLKMUSE2_HB
DSHIST