SQL Server - L&W

Lookup Transformation

https://learn.microsoft.com/en-us/sql/integration-services/data-flow/transformations/lookup-transformation?view=sql-server-ver16

Select into table variable

https://learn.microsoft.com/en-us/sql/t-sql/data-types/table-transact-sql?view=sql-server-ver16

and

Wait stats clear

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver16

//

My Motivational Quote

"Parents are still giving their blessings"

                                                                        \\

This is season to become SQL DBA.

I believe, for being a Professional SQL DBA, all we need to learn from DBA related learning websites and practice.... eg. https://learn.microsoft.com/.

Initially, we can start from Backup and Restore, Azure Basics, Different Type of Joins, Managed Services, Basics of HA, All Basic commands, Performance Monitoring.

Usual Causes for not getting latest Certification.

- Odd Office Hours.

- Busy Schedule.

- Far away from Examination Centre.

For Current Verson, please execute 'select @@version' in query analyser.

Best regards

Amit Vaid