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.

23rd Sep, 2024

This guide will teach you about indexing in Microsoft SQL Server and how they can help optimise your queries for better performance.

19th Aug, 2024

Are you looking for ways of optimising MySQL and PHP performance? Discover these 10 strategies for increasing PHP speed and efficiency.

22nd Jul, 2024

Learn about SQL cartesian explosion issues, how it affects performance and what you can do to fix cartesian explosions in Entity Framework.

10th Jun, 2024

Do you have bottlenecks and deadlocks in SQL Server? We will show you how to identify and resolve these problems for database performance.

6th May, 2024

Are you unfamiliar with SQL Server Management Studio? This article will lead you through the basics and have you up and running in no time!

29th Apr, 2024

With this detailed guide on database backup and recovery using Microsoft SQL Server, you can ensure the safety and integrity of your data.

12th Feb, 2024

Learn how to optimise your SQL Server database performance and improve the speed and efficiency of your database.

21st Apr, 2017

New configuration option in SQL Server 2017 called CLR strict security, enabled by default, causes problems when using CLR.

1st May, 2011

How to use CREATE TABLE IF NOT EXISTS in SQL Server which does not provide a complete user-friendly way for testing table existence.

15th Mar, 2010

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.