WPF Read a SQL Server Table into a DataGrid
This post is about how to connect to a local SQL Server database and read a table from […]
sql
SQL Server Installation
As of February 2019, the time of this writing, the current version of SQL Server is 2017. There […]
MySQL Introduction
MySQL is a database management system (DBMS). A database is an organized collection of data. MySQL, one of […]
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 […]