Require Information About Your SQL Server Instance?

Once you are responsible for an instance of SQL Server, whether it is an Enterprise edition or an Express edition, you should know some basic information about the instance.  There are various reasons why this information may be necessary so it is important that you know how and where to find it.

Some of the basic information such as the instance name, SQL Server edition, SQL Server version, etc. can be found on the General Page of the Server Properties dialog box.

To access this dialog box, perform the following steps:

1. Start SQL Server Management Studio (SSMS).
2. Connect to your instance using the necessary Authentication.
3. Right-click the server name in the Object Explorer View and select 'Properties' (see diagram below).

Continue Reading →

First TTSSUG Meeting For 2011!

This meeting, which is being held on the 15^th of March 2011, will be focusing on SQL Server Analysis Services (SSAS).  SSAS, an important component of The Microsoft Business Intelligence Platform, is used to create comprehensive analytic solutions which can drive actionable insight to users through familiar tools. This event is recommended for Developers, Database Developers and Database Administrators. See the invite below for more details. To register click here.

Continue Reading →

SolidQ Journal - February 2011 Edition

The February Edition of the SolidQ Journal is out! It is available online at http://www.solidq.com/sqj/Pages/Home.aspx

Continue Reading →

Back to Basics

In life there are some tasks that  seem difficult to complete initially but as time goes by it becomes easier due to various reasons such as knowledge, understanding and of course practice. The easier it is for us to complete, the easier it is for us to forget how difficult it was initially. Many people take it for granted that what is easy or simple for them should be easy or simple for other people as well.

Continue Reading →