If you want more info about Password Security within SQL and it's ability to use the Windows password policy mechanisms, there's an interesting article from the Microsoft MSDN site here
Melville
Thursday 31 December 2009
Wednesday 30 December 2009
More SQL info - Microsoft SQL Server Documentation
One area of Microsoft SQL I am impressed with is the documentation, or books online (BOL). This set of documentation helps you understand SQL Server, and how to implement data management and business intelligence projects.
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.
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.
Happy studying
Melville
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
Subscribe to:
Posts (Atom)
Posts
