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.
This guide will teach you about indexing in Microsoft SQL Server and how they can help optimise your queries for better performance.
Are you looking for ways of optimising MySQL and PHP performance? Discover these 10 strategies for increasing PHP speed and efficiency.
Learn about SQL cartesian explosion issues, how it affects performance and what you can do to fix cartesian explosions in Entity Framework.
Do you have bottlenecks and deadlocks in SQL Server? We will show you how to identify and resolve these problems for database performance.
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!
With this detailed guide on database backup and recovery using Microsoft SQL Server, you can ensure the safety and integrity of your data.
Learn how to optimise your SQL Server database performance and improve the speed and efficiency of your database.
New configuration option in SQL Server 2017 called CLR strict security, enabled by default, causes problems when using CLR.
How to use CREATE TABLE IF NOT EXISTS in SQL Server which does not provide a complete user-friendly way for testing table existence.
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.