SQL and mySql TutorialsDatabase programming tutorials for MySql and Microsoft SQL Server, with tips on performance optimisation and how to use the data in PHP, C#, ASP.Net and JavaScript.
Learn how to optimise your SQL Server database performance and improve the speed and efficiency of your database.
- 12th Feb, 2024
New configuration option in SQL Server 2017 called CLR strict security, enabled by default, causes problems when using CLR.
- 21st Apr, 2017
How to use CREATE TABLE IF NOT EXISTS in SQL Server which does not provide a complete user-friendly way for testing table existence.
- 1st May, 2011
Importing CSV File data into SQL Server table is a commonly asked question that has an easy answer. Find out how to use SQL Bulk Insert.
- 15th Mar, 2010
This visual guide to SQL joins should help you determine which one of the various SQL join types to use for the query you need to run.
- 24th Feb, 2009
