Now just exercise patience, take the cotton out of your ears and put it in your mouth.

It just sucks to see daddy’s lover, right?

Stop meddling with congress and then they will pass border legislation- you fool!

Avoid SQL divide by zero errors using CASE WHEN or NULLIF functions to substitute zero for another value in our expression.

There is more to being a Junior DBA than knowing SQL. The DBA works at the intersection of the database, server, operations group, and developers.

Always carry your key. 😉

Its is easy to get confused between inner join vs outer join clauses as both are used to combine data from two or more tables.

SQL Left Joins includes all rows to the left of the join, matching rows for those to the right, and NULLS for un-matched values.

SQL joins are used to combine columns from separate tables. Learn why joins are important, and how to use various join types.

Use ISNULL to replace missing values due to NULL. It works well with numeric and text data, and is handy when dealing with expressions.

The SQL RTRIM function trims all the trailing spaces from the right side of the input character expression.

The SQL LTRIM Function remove blanks from the front of string or character expression. Use it to clean data and remove leading spaces.

The SQL GETDATE function returns the current system date and time. To get the current date CCONVERT or CAST GETDATE as DATE.

It is easy to find duplicate rows in SQL using ROW_NUMBER(). This window function make it simple to find the duplicate row's primary key.

Use the SQL CONVERT Function to change a value from one data type to another. It is useful when working with dates, numbers, and strings.

Not sure fear and Adrenalin are senses. 🧐

Use SQL DATEADD to add days, weeks, months, or any timespan specified by datepart to a date to get another. IT returns a new date.

The SQL UPDATE statement is used to modify column values within a SQL Server table. Learn the basic command as well as a UPDATE with JOIN.

Automatically Format Your SQL ed.gr/cvzms

What is the difference between an inner and outer join? ed.gr/cph6v