March 2010

Sunday, March 28, 2010

You will understand Microsoft SQL Server Management Studio and Supported Operating System-
In the last post I have mentioned details of SQL Server Management Studio- and here you will find the detail of supported operating system - when you install SQL Server on server operating system so try to install Latest Windows server if you are installing SQL Server 2008- this is very clear now – to install SQL Server on a Windows OS you should have latest windows Server by Microsoft like Windows 2003 see the compatibility issue on Microsoft site.
Only one point I want to mention here – if you have installed Windows CE as OS then go for SQL Server CE edition if you want to work with.

Now you will see some others Operating System supported by SQL as a client- it means you are going to install SQL’s client software to query Database. Some details are mentioned below.

Operating Systems supported by Microsoft SQL Server:

Novel Netware, UNIX, AppleTalk, OS/2, Banyan VINES- these are the operating systems supported by Microsoft if you want to work with SQL Server as a client.

Protocols for SQL Server:

Now I will mention details of protocol supported by SQL server.


NW Link(Netware Link) is a protocol, supported by SQL Server- Microsoft has written this protocol.

NWlink for compatibility with Novell’s native protocol – so if someone wants to interact with SQL server using different operating system then you should have NWlink protocol working and installed on your system so user could run queries on SQL server Database.

TCP/IP: The one artistic protocol and HERO protocol supported by SQL Server and developed by ARPA.

NetBUI: Supported by SQL Server but written by IBM- mostly runs on all Microsoft operating system, it is very fast protocol, but suited to organizations with few computers in the enterprise.

Appletalk: Developed by Apple, Microsoft SQL server works with the protocol properly.

Banyan VINES: It is used in Banyan VINES networks- if you have installed SQL Server you have different Operating System and Banyan VINES protocol then U can go ahead and executes Queries and talk SQL Server.

Please stay connected with the site and leave your question or comments - our team has expertise of Sharepoint and SQL Server technology- so we will try to answer your query as per our experience.

Monday, March 15, 2010

SQL Server Management Studio has been released in another form that is for free which is called sql server management studio express edition, as you are familiar with the earlier released the same product for SQL Server 2005(express) and SQL SERVER 2000 were for free, but now in 2008 Microsoft has introduced new feature as well with the free version of SQL Server management studio express edition.
You need to install .net framework 2.0 and MSXML Parser if you want to install express edition on your server.
Let’s go through with the feature of SQL Server Management Studio Express edition only.
  1. You can not update the full text catalog with Sql server management studio Express edition, rather you will have to use command type utility sqlcmd or windows scheduler to update the text catalog.
  2. Free version of SQL Server management studio can not manage the analysis services, Integration services and reporting services.
  3. You can not resolve conflicts manfully during on-demand synchronization in Microsoft windows synchronization manager is not support in sql server management studio
  4. SQL Server Management Studio Express edition, object explorer only support DB instances, and connect to server dialog prevents connecting to other services like AS (analysis services)

 Please stay connected to know more from this site or leave comments about this activity.

Wednesday, March 10, 2010

Sophisticated SQL Server Management Studio has many features we have outlined few new features added in SQL Server Management studio with latest release of SQL Server Management Studio 2008 R2.
Microsoft has introduced many features in it but few mentioned below.
In SSMS with 2008- Microsoft has introduced Intellisense for Query Editor Interface.
Query Editor with Intellisense functionality is oxygen for people who are writing complex queries in the editor.
This feature will make DBA’s life easier while writing query based on 100 lines; I mean lengthy query can be written easily with the intellisense functionality in Query Editor.
If you point your location in SQL Server Management Studio’s EDIT menu and then Intellisense and further you will find 5 more options there.
List Members, parameter info, quick info, complete word, refresh local cache.
MultiServer Query: a good one option for those DBA who has been facing dame problem when they have been working on multiple server, means one DBA managing more than 50 Server instances and run various queries to get the right information of each server now U need to open 50 different windows to run same command on each server, so MultiServer Query feature has made your life more easy and under one roof you can manage 50 different sql server instance and run various commands simultaneously.

Object explorer is another feature added in SQL Server Management Studio with many more options available there including this, OE result can be copied to excel and review there at later for a report type activity.

So far I could explore such feature in SQL Server 2008, please stay tuned to get to know more.

Please stay connected with this site because we are small team of MCSD, MCP and MCTS Sharepoint, have been invited by Microsoft for beta Exams, we will share our experience with you.