SQL Server 2008 Management Studio | Technology tips

Wednesday, April 7, 2010

SQL Server 2008 Management Studio

SQL Server  2008 Management Studio is free version from Microsoft you can access, manage and administer your database, there are some limitation as Microsoft has released  sql server  management studio for free, this tools solely used by sql server developer and administrator as they could see graphical user interface once they install it and they can easily work with the database.
Ideal scenario of using sql server management studio, you have sql server running on machine A and you want to access your database from developer machine B with visual studio like you want to view data before manipulation. Then you need to install sql management studio on machine B and access you data from there.

If you want to access data that has been stored in sql server 2005 then you need this version otherwise you need SQL Server 2008 express is also a free tool if your data has been stored in SQL Server 2008.

There are different version available on Microsoft site of this free tool but recently sqlserver management studio express edition can the best choice for anyone who is going to manipulate data using this tool,but before mentioning all details I will elaborate how you can make auditing done with SQL Server 2008 and then you can find fine more details on Microsoft site.

Why audit has been very prominent in the entire life of DBA- it gives them detail about who has accessed and attempted to access your data, I will also outline few more things about regularity compliance why they are related with audit and all this.

There are many acts in the world in relation with the audit mentioned here- it means how they can monitor data stored in databases – so these compliances ensure the real audit theory as per the organization type.
SSMS can help you audit on sql server database level and sql instance level when you configure audit you have option at what level you want to trace it.

This audit is life for DBA's because they can track many events with this functionality.
You can create audit object by using ssms just point your location to security folder and right click on audit folder and create new option, and it's done.

SQL Server 2008 R2 has been supported and compliance with HIPPA, please read other article on this site for HIPAA and PCI.
There are many feature for auditing in SQL Server 2005 like SQL Trace and all.
With SQL Server 2008 and it’s auditing feature you can just use granular approach to audit data like you audit the users and roles and groups and DB objects and they can monitor at table level. This means you can further narrow down your approach at object level (means metadata too) and find out who has done what with db and its tables. And you can know this who has manipulated your data stored in table.
sql server management studio info-graphics animated version
sql server management studio

Another issue has been with the audit log where to store the log traditionally it’s been stored in a log file but now you can send the audit data at file share to which only SQL’s DBA has write access it means a share resource with write access permission can write log to a file- so ideally keep this share resource separate on network with RW permission further you encrypt it- so 0 percent chances are for any disaster.
I will outline more details about audit next time but now you can download SQL Server  Management Studio from principal vendor Microsoft.


Anonymous said...


SQLServerStudio said...

Sorry Anonymous, I think it's

Privacy Standard/Rule (HIPAA)

Health Insurance Portability and Accountability Act (HIPAA)- please correct me any one else ...

Anonymous said...


Anonymous said...

so your idea of a download link is microsoft.com?


SQLServerStudio said...

Sorry Lame, if you could not find a download link from Microsoft, basically we can not mention the exact URL for Microsoft.
But thank you for taking interest in our site.

USMAN said...

can someone please guide me or direct me towards a good resource to learn how to get started with sql server 2008 management studio..

sharepoint said...

Wonderful content about sql server management studio, been trying something which could distinguish among these products and finally we come up with the perfect version of sql server management studio we should use with our environment.

Jack T said...

good learning on this site, but I want to install sql server 2008 management studio on my client so I could access from remote server because our databases are there on remote location.. any idea

Anonymous said...

Great info about SSMS please keep it up.
Abbas, Abu Dhabi- UAE

Anonymous said...

please post all previous version of sql