WPF Read a SQL Server Table into a DataGrid with ...This post is about how to connect to a local SQL Server database and read a table from […] May 3, 2020 in Dapper tagged database / server / sql / WPF / read / grid / datagrid / Dapper / Dapper by Mike
WPF Read a SQL Server Table into a DataGridThis post is about how to connect to a local SQL Server database and read a table from […] May 1, 2020 in WPF tagged T-SQL / table / read / grid / datagrid / open / data / table read / database / connection / server / itemssource / sql by Mike
ACID DatabasesACID (atomicity, consistency, isolation, durability) is a set of properties of database transactions intended to guarantee validity even […] April 20, 2020 in Database tagged database / transaction / ACID by Mike
Move SQL Server Database FilesDo you need to move one or more of your SQL Server database files? For example, are the […] January 11, 2020 in SQL Server tagged move / mdf / ldf / database / files by Mike
SQL Server Error 5123Are you trying to attach a database to SQL Server Management Studio and getting Error 5123? Are you […] February 17, 2019 in SQL Server tagged access / SSMS / administrator / run / 5123 / attach / denied / database / error / security by Mike
MySQL IntroductionMySQL is a database management system (DBMS). A database is an organized collection of data. MySQL, the most […] October 21, 2018 in Database tagged database / sql / MySQL / RDBMS by Mike
SQL Server Pages and ExtentsThe page is the fundamental unit of data storage in SQL Server. An extent is a collection of […] April 1, 2018 in SQL Server tagged extents / database / pages / sql / internal / SQL Server Data Structures by Mike
Itzik Ben-Gan’s SQL DatabaseIn Itzik’s book T-SQL Querying, published by Microsoft Press in 2015, he uses several tables as examples. Here […] March 6, 2018 in SQL Server tagged customers / orders / details / database / suppliers / sql / products / diagram / relationship / Itzik / tables / SQL Itzik Database by Mike
SQL Server Burton’s DatabaseThere exists a SQL Server online course at Udemy.com that prepares you for the 70-461 exam. The couse […] February 24, 2018 in SQL Server tagged diagram / relationship / department / employee / database / sql / transaction / burton by Mike
Sample Relational DatabasesYou can use existing databases for testing purposes. If you are testing queries or just wanting a sample […] November 22, 2017 in Database tagged sql / sample / dataset / relational / database by Mike
SQL Server ExceptEXCEPT is available in SQL Server starting with SQL Server 2008. EXCEPT returns distinct rows by comparing the […] August 11, 2017 in SQL Server tagged database / sql / table / except by Mike
Distributed DatabaseWhat is a distributed database? Here is what Wikipedia says: “A distributed database is a database in which […] August 7, 2017 in Database tagged database / distributed / blockchain by Mike