SQL Server Except
EXCEPT is available in SQL Server starting with SQL Server 2008. EXCEPT returns distinct rows by comparing the […]
database
Distributed Database
What is a distributed database? Here is what Wikipedia says: “A distributed database is a database in which […]
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 […]
SQL Database Design Introduction
Over at the website SQL Server Central they have series of articles that they group into what they […]
SQL Server Introduction
Wikipedia says: “Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, […]
Database Model
Wikipedia says the following about the definition of a Database Model: “A database model is a type of […]
MongoDB Introduction
MongoDB (commonly referred to as simply Mongo), a play on the term “humongous,” is a general purpose NoSQL […]
Excel to SQL Server with Copy Paste
You can import a table of Excel data into a SQL Server database without having to re-type any […]
TSQL Language Notes
Begin Coding Now has a Microsoft Word file with a few pages of crib notes on Microsoft TSQL […]
Contact Form DB Plugin
The “CFDB” plugin saves contact form submissions to your WordPress database and provides and administration page and short […]