Import and Export Tables
Do you find yourself converting data tables between different formats such as Excel or comma separated values? Are […]
tables
Why Use Excel Tables?
Why would you want to use Excel tables? Why not just stick with Excel ranges or just leave […]
Excel Tables Introduction
What is an Excel table? Before answering that I will define the word tabular. If data is in […]
Excel Pivot Tables Introduction
What are Pivot Tables in Microsoft Excel? First of all, let’s discuss tables. In Excel, a table is […]
SQL Server Derived Tables
A derived table closely resembles a subquery. It is a table subquery that is defined in the FROM […]
Itzik Ben-Gan’s SQL Database
In Itzik’s book T-SQL Querying, published by Microsoft Press in 2015, he uses several tables as examples. Here […]
SQL Finding Duplicates across Two Tables One Column
This post discusses the query needed to check if there are any duplicate values in a certain column […]
SQL Server Introduction
Wikipedia says: “Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, […]