Search:

An article on Computer and related topics

For additional information and special deals related to some of the items on this article, place your cursor over the double-underlined links. All information supplied by Kontera.com

Useful SQL Server Tools

By: Roberto Garabelli

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL with it's most popular version Sql server 2005.

You can determine what version SQL Server is running by running:

Select @@version (Where @@Version is a system level variable that holds the current version).

How do I restict clients by IP Address?:

As the SQL Server has no built-in support for restricting clients by IP address, the most common work-arounds are firewalls, IPSec, or third-party network layer filters to allow only certain source IP addresses and target TCP ports (the port on which SQL Server is listening).

What are some things I can do to secure my SQL Server?:

- Keep up to date on SQL Server service packs and patches
- Audit SQL Server accounts for weak passwords
- Restrict access to the SQL Server to only trusted clients
- Use Windows Only authentication where possible
- Store SQL Server backup files in a secure location and encrypted
- Disable all netlibs if the SQL Server is local-only
- Regularly scan the installation with Microsoft's Baseline Security Analyzer

Article Source: http://ezine-articles-planet.com

Giles is a Sketch Artist, Asian Blogger and loves SQL Servers.

Please Rate this Article

Not yet Rated

Click the XML Icon Above to Receive Computer Articles Via RSS!

Additional Articles From - Home | Computer

A Quick Introduction to Network Security Measures - By : Gen Wright
The Importance of Photo Recovery Software - By : Gen Wright
Stop! Read These Online Degree Facts Now Before You Invest in the Wrong Program...] - By : ClaraKenpnb
¿Que es HOSTING? - By : eduardo55
workstation- The Human Innovation - By : Roberto Garabelli
Do Not Lose Money Through Distance Learning. Learn How Here... - By : JanetJonespapp
Comparing Motherboards for the Upcoming Core i7 Processors - By : Gen Wright
The Next Generation PC Systems - By : Gen Wright
The Next Generation of Portable Media Players - By : Gen Wright
The Rise of Digital Entertainment - By : Gen Wright

Authors, Sign Up for a free account or learn more.

	Print This Article
	Post Comment
	Add To Favorites
	Email to Friends
	Ezine Ready

Writers/Authors Submission Guidelines
Member Login
Submit Articles
Most Popular Articles

Publishers Article RSS Feeds
Terms of Service

Adsense Secrets 4 - Recurring Top 1% Commissions

Free Affiliate Training

Share This Page:

Site Information Link to Us
About Us
Site Blog
Contact Us
Privacy Policy
Multi Site Article Search
Links Directory

Sponsors from all over the web

Would you like your site listed here?

Is This Site Useful?
If you found this site useful, please consider buy the webmaster coffee and get a free link back to your site!

Thanks for your support!

Please Rate and Vote For Us: