View courses

SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. It was first launched in 1989 and continues to be popular to this day.

SQL stands for Structured Query Language and is used to communicate with the database. SQL Server fully supports this language and allows you to perform CRUD operations using INSERT, SELECT, UPDATE and DELETE statements.

SQL Server is popular at being used in conjuction with .NET applications and allows the two to work side by side, transfering data between the application and the database.

Other features include the use of profiler tools to debug usage, supporting multiple databases per server, and being able to support large amounts of data.
Create a custom database logging provider with ASP.NET Core ILogger Create a custom database logging provider with ASP.NET Core ILogger Create & implement a .NET custom logging provider with ILoggerProvider. Use ASP.NET Core, C# & ILogger to log to a SQL Server database. 31st March 2022
Log Data Changes in Entity Framework Core – Part 3 - Ignore, Reference, SQL Server JSON and Testing Log Data Changes in Entity Framework Core – Part 3 - Ignore, Reference, SQL Server JSON and Testing Functionality to include reference properties when logging data changes in Entity Framework. Also look at merging JSON keys into SQL Server columns. 17th August 2020
Round The Code Which Date and Time Type to Use in SQL Server 2019? Examining the precision, storage bytes and accuary of the different SQL Server 2019 Date and Time Types, including date, datetime datetime2 and datetimeoffset. 30th June 2020
Round The Code Examples Using the sys Schema in SQL Server Use objects in the sys Schema to retrieve information about database tables, columns, views, stored procedures and info about clients connected to your DB 20th October 2019
Round The Code SQL: Joining and Grouping Learn and following examples about using left joins, inner joins and outer joins in SQL and how to use the SUM and COUNT functions. 18th September 2019
Tools to Improve Slow SQL Queries in SQL Server Tools to Improve Slow SQL Queries in SQL Server You can use tools such as Activity Monitor, SQL Server Profiler and Execution Plan in SQL Server Management Studio (SSMS) to help improve SQL performance 20th August 2019
Three SQL Server features you may not use too often Three SQL Server features you may not use too often Find out how you can use Check Constraints, Index Types and Triggers to help performance and data integrity of your SQL Server database 16th July 2019

Categories