Thursday, 31 December 2009
For the SQL geeks out there - Security – Password Policy support
Melville
Wednesday, 30 December 2009
More SQL info - Microsoft SQL Server Documentation
The current version is November 2008 you can download it here.
To learn more about Microsoft SQL Server Technologies, there are white papers and technical documentation available from the link above.
For new users there is also a wealth of information to help with particular features. I posted previously about the SQL Server tutorials to learn more about the common tools used to manage SQL Server.
There are also lots of ‘How Do I’ articles. These are useful to find out about new features or areas you are less familiar with and you can find them here.
This information answers a lot of the questions I get asked by Students. They cover a lot of basic database tasks.
Tuesday, 29 December 2009
SQL Server Management Studio Tutorial
Some useful additional materials that our SQL Tutor, Mel thought you might be interested in:
SQL Server is a client / server Relational Database Management System (RDBMS) which has been developed by Microsoft and is made up several different client and server programs that make up the entire product. It can be a challenging prospect for new users to find their way around. Microsoft have provided excellent documentation to get you started. I would like to highlight some of that information. For ‘SQL Server Management Studio’, there are some tutorials available . I would recommend these to help get you started with the tools.
Lesson 1: Basic Navigation in SQL Server Management Studio
Lesson 3: Using Help
There are also tutorials that provide a step by step walkthrough of some of the SQL Server Tools. Take a look at this Tutorial Link for access to all of them.
Melville Thomson