Microsoft Tools

Sometimes you need to Extract/Transform/Load data en masse. In these scenarios, you will be doing bulk operations for performance. There i...

XML is an expandable/extendable syntax. You need to meet certain rules to qualify as being well formed XML. Elements are placed between na...

There are multiple ways to generate an identifier to unique refer to a row in a table. You could define a column as a numeric type with th...

Metadata for the system is stored in views that reside in the sys schema. Some examples of these are sys.objects, sys.tables, sys.queries,...

There are two broad categories of functions in SQL Server: Scalar functions Tabular functions Scalar functions are those that return ...

Let's talk about Common Table Expressions (CTEs). A table expressions is a named query. A CTE is a query you put at the front of the s...

I have previously described how to use subqueries to connect two tables. You can also accomplish the same thing with derived tables. The...