Punch Line
Fill in the blank: A DBA walks into a bar, stands between two tables and asks ______
Can I join you?
This type of index maintenance reorders leaf-level pages, but not intermediary-level pages
Reorganize
Non-clustered index seek (or index seek)
Non-clustered index seek (or index seek)
The datamodel shown in Figure 2 is of this type, one typically used in data warehousing
Snowflake
This Enterprise feature encrypts SQL Server data at rest in a way that does not require any application modifications.
Transparent Database Encryption (TDE)
If you wanted to kill a DBA, how would you do it?
Pull a trigger (thank you Michael L John)
This type of index includes a WHERE clause, limiting the values stored in the index to a smaller subset
Filtered Index
Parallelism (Distribute Streams)
Parallelism (Distribute Streams)
Hibernate, Doctrine, and Entity Framework, for example.
ORMs (Object-Relational Mappers)
This encryption feature provides end-to-end security – data is encrypted by drivers at the client and data values are not revealed to the SQL Engine nor to privileged users connecting directly to the database.
Always Encrypted
Fill in the blank: Did you see the movie about the database? No, but I plan to watch _____
The SQL
This type of index contains all the data needed to satisfy a particular query. It means we don’t need a bookmark lookup back to the clustered index!
Covering index
Nested Loop Join
Nested Loop Join
Daily Double!
MongoDB, Couchbase, DynamoDB, and Cosmos, for example
Daily Double!
Adding a login to this server level role turns off permission checks for that login
Why shouldn’t you ask developers to help you move?
They’ll probably drop your table
This action occurs when a row needs to be added to a specific index page and it is already full.
Page Split
Table Scan
Table Scan
The datamodel shown in Figure 3 violates this normal form.
1st Normal Form (the value of each attribute contains only a single value from that domain)
If you wish to use EXECUTE AS to assume the permissions of a different login, you must have this permission
IMPERSONATE
Fill in the blank: I prefer Count Star to Count Dracula, because I don't like having to consider which Draculas are _____.
NULL (thank you Rob Farley!)
The pattern used when creating the root, intermediate, and leaf nodes. It ensures that the distance from the root node to the leaf node is the same no matter what path you traverse.
B-tree
Key (Bookmark) lookup
Key (Bookmark) lookup
This special edition of SQL Server is a lightweight version of SQL Express that runs as a user process (not a service).
LocalDB
If Password Policies are enforced for a SQL Login, the password must be at least this length.
8 characters