Your Guide to Microsoft SQL Server

sql Microsoft SQL Server is an application for Windows that can be used to host and manage relational databases. The free express version can be used by developers to create complex databases without any up front costs, while the full SQL Server can be used to host huge amounts of data. This data is quite often accessed using the Structured Query Language (often abbreviated to SQL - hence the name SQL Server).

In this guide you will find information on how to access data using SQL, how to setup Microsoft SQL server, and how to query the server from a number of different programming languages.

Hardening Your SQL Server Need to lock down your SQL Server 2005 or 2008? SQL Servers are a prime target for hackers and worms. Corporations assets are generally customer data which is stored in databases...	SQL Server 2005 and SQL Server 2008 Encryption Are your SQL applications truly secure? In this article, the advancements in SQL's ability to encrypt data is discussed. Now native to SQL Server 2005 and 2008, SQL provides...
Creating Tables Using SQL Server Within a SQL database, tables are how you define and store individual data records. In this article you will learn how to create tables using SQL Server Management Studio....	How to Get SQL Results into an XML File You have probably tried to create a XML file from SQL and found it is not as standardized as you thought it should be. This does not mean it is a difficult task. Have a look at this...

Connecting Microsoft SQL Server To An Access Database

Microsoft Access is great for creating a simple front end, but what if you already have a SQL database you can use? This article will walk you through setting up an ODBC connection for Access to use...

How to Transpose a Table in SQL

Have you ever looked at the schematics and contents of a table and notice how disorganized it all is? You then wonder, “What were they thinking?” In that case, its best to perform an...

Setting Up Microsoft SQL 2008 in VirtualBox

Need to setup a SQL Server but don't have the hardware? You can setup a database server and use virtualization to expand your server farm without any additional hardware. This tutorial shows how...

Using Microsoft Access to Connect to a SQL Database

Have you outgrown Microsoft Access and upgraded to SQL? Microsoft Access still plays a critical role and can be used for specialized queries. No matter how many 'built in' queries database...

MS Access - its Advantages and Disadvantages

There are very strong views about MS Access. Its detractors call it a toy database; good for playing with but not for serious corporate use. Yet there are people with equally strong opinions who swear...

A Step-By-Step Guide To Importing Excel Data Into a SQL Server Database

Importing data from Excel to SQL Server is not difficult as you might think. If you have data in an Excel spreadsheet that you want to import into SQL Server, this article will walk...

Connecting Microsoft SQL Server To An Access Database

Microsoft Access is great for creating a simple front end, but what if you already have a SQL database you can use? This article will walk you through setting up an ODBC connection...