MySQL Introduction
MySQL is a database management system (DBMS). A database is an organized collection of data. MySQL, one of […]
sql
Create Table SQL Script in Excel
You have some data in Excel that you need to import into SQL Server. You don’t have a […]
SQL Server B-Tree
When you think of B-trees, think “clustered index”. All indexes in SQL Server on disk-based tables are structured […]
SQL Server Pages and Extents
The page is the fundamental unit of data storage in SQL Server. An extent is a collection of […]
SQL Server Left Joins Simplified
In order to more easily understand left joins we will modify Itzik Ben-Gan’s database from the previous post […]
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 Server Burton’s Database
There exists a SQL Server online course at Udemy.com that prepares you for the 70-461 exam. The couse […]
SQL Server Create Table
You can create a table using the SSMS GUI, or you can use T-SQL code. This post describes […]
SQL Server COUNT
In T-SQL, COUNT returns the number of items in a group. COUNT works like the COUNT_BIG function. The […]
SQL Server Collation
Collation is not a simple topic in SQL Server. There is an article written by Robert Sheldon called […]
SQL Server Apply
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause. APPLY allows the […]
SQL Server Error 15517
There is a good article at SQLServerCentral.com that helps you troubleshoot this error 15517 on SQL Server. I […]