Month February 2014

In this post, we will be explaining what triggers are and how to create them.

In order to fully maximise the effect of a SQL Server back-end, we are going to need to be able to called stored procedures from MS Access. In this post we show you how to do it.

In this post I will be discussing Stored Procedures, how to create them and the benefits of using them. Stored Procedures in SQL Server are similar to sub procedures in MS Access. We often have code that needs to be…

In this post I will be discussing Built-in functions in SQL Server and showing you how to create a User-Defined function. Featured Videos Built-In Functions User-Defined Functions

In this post we will be explaining how to migrate your MS Access database to your new SQL Server application. Featured Videos: Connecting To SQL Server Migrating To SQL Server Linking Tables In Access Featured Downloads HotelBookings.accdb

In this post we will be explaining how to install SQL Server Migration Assistant. In the video I show you where to download the assistant from but if you want you can download it from this page (below the video).…

In this post we will be explaining how to add a new user to your database.

In this post we will be explaining some basic SQL commands that will help you create the kind of tables you want to see.

In this post we will explain how to create a table in our newly installed SQL Server instance.

In this post I will explain how to create a database in our newly installed SQL Server instance.

In this post I will explain how to log on to your SQL Server installation. Ok, so you have installed your SQL Server with no issues (we hope) and now need to log on. Not exactly tricky but worth its…

In this post I will be explaining how to install SQL Server 2012. Featured Videos: Installing SQL Server