SQL Server Logical Query
As a SQL Server practitioner, it is important to understand logical query processing. The following list is found […]
sql
Sample Relational Databases
You can use existing databases for testing purposes. If you are testing queries or just wanting a sample […]
SQL Joins using Geographic Data
In this post we illustrate SQL joins using a common example of geographic data in a Microsoft Access […]
SQL Server Insert Into Select Part 2
This post shows you how to insert data into an existing empty table from two other tables using […]
SQL Server Wrong Server Name
In your SQL Server code are you using @@SERVERNAME? This can return the wrong information. For me it […]
SQL Server Except
EXCEPT is available in SQL Server starting with SQL Server 2008. EXCEPT returns distinct rows by comparing the […]
SQL Server Documentation
There are several ways to document a database. This post will only discuss some of the queries you […]
SQL Server Linked to Excel
You can link Excel to a SQL Server database so that you can read data from SQL Server […]
SQL Server Course at Udemy Philip Burton
If you like watching videos to learn topics, consider Udemy.com This post is about a series of videos […]
SQL Server Duplicates Part 2
This discussion of finding duplicates in SQL Server is a continuation of Part 1. We will look at […]
SQL Server Export to Excel
https://www.microsoft.com/en-us/download/details.aspx?id=23734 Wizard From within SQL Server you can use the wizard to export a tables or tables (using […]