Getting started with SQL Server Management Studio

A few instructions on how to fire up SQL Server Management Studio (SSMS) in order to create a database, create a database table and perform various operations Creating a new database Open SSMS, right-click on Databases and select New Database… Give the database a name (‘People’ in this example) and select OK: Creating a new …

Continue reading ‘Getting started with SQL Server Management Studio’ »

Configuring Microsoft SQL Server to perform full text searches in documents

This post describes the steps needed to install and configure Microsoft SQL Server to perform full text searches within documents like Word, pdf, rich text format etc. These instructions require no prior knowledge of using or installing SQL Server – all steps from installation to implementation are included. 1. Install SQL Server. Go to MSDN …

Continue reading ‘Configuring Microsoft SQL Server to perform full text searches in documents’ »