Search:

Home | Technology

Useful SQL Server Tools
Roberto Bell
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

Source: http://easycontentpro.com

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

"Useful SQL Server Tools"
written by Roberto Bell

Not yet Rated

 

Click the XML icon above to receive Technology articles via RSS


Other articles you may find interesting:
Sign Up for a free account or learn more.
Member Login
Submission Guidelines
Submit Articles
Most Popular Articles
Top Authors
Ezine Notifications
Article RSS Feeds
About Us
Blog
Link to Us
Contact Us
Privacy Policy
Terms of Service
Article Directory Software
Start your own article directory today - Click here to download the exact software that powers EasyContentPro for FREE!

Powered by Article Dashboard