Move SQL Server Database Files
Do you need to move one or more of your SQL Server database files? For example, are the […]
database
SQL Server Error 5123
Are you trying to attach a database to SQL Server Management Studio and getting Error 5123? Are you […]
MySQL Introduction
MySQL is a database management system (DBMS). A database is an organized collection of data. MySQL, one of […]
SQL Server Pages and Extents
The page is the fundamental unit of data storage in SQL Server. An extent is a collection of […]
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 […]
Sample Relational Databases
You can use existing databases for testing purposes. If you are testing queries or just wanting a sample […]
Blockchain Implementation
How do you get started using blockchain? First of all you want to be sure that your specific […]
SQL Server Except
EXCEPT is available in SQL Server starting with SQL Server 2008. EXCEPT returns distinct rows by comparing the […]
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 […]