SQL Server for Not Yet Techies

"Computer Careers: Managing Data With an Open Source Relational Database Management System"

by Richard Stooker, President Info Ring Press and author of Secrets of Changing to a Computer Career

SQL Server is Microsoft's database management system (DBMS), and Bill must be proud of it, since it is the most popular one, having captured 68% of the market. Its major competition is Oracle, the leading database software producer, whose President Larry Ellison reportedly hates Bill Gates. SQL Server is highly scalable, fast and reliable.

SQL Server originated through a partnership between Microsoft and Sybase to create a DBMS for IBM's OS/2 operating system. Sybase and Microsoft when their separate ways and then IBM and Microsoft went their separate ways.

Microsoft kept developing the project and eventually came up with their own DBMS solutions.

It is a client/server database engine, supports XML and uses its own language, Transaction SQL (T-SQL).

Three major SQL Server administration tools:

Books Online (reference)
Enterprise Manager (primary management tool)
Query Analyzer (command line interface)

SQL Server also has Analysis Services which uses OLAP (Online Analytical Processing) to create multidimensional cubes of data sets.

Normalizing data means organizing it into relational tables. Enough of these and you have a full data warehouse.

SQL Server data mining of its data warehouse goes beyond OLAP, however. It looks through the cells of the cube to detect more patterns.

Next: StarOffice

Use Your New Computer Career as a Stepping Stone to Even Greater Success

Send off for your free 7-part Techie Plus eCourse now. So that you can learn:

The 7 most important skills to even greater business achievement -- not to mention wealth and (maybe) fame
Why techies are expendable in bad times and how to protect yourself from them
Why the world's richest computer programmer has not written any code in ages
How one ex-engineer now makes $500,000 a year
The abilities most techies don't even realize they don't have -- which confines their success to their technical abilities
Why techies are expendable in bad times and how to protect yourself from them

It's fast and easy. You will receive the first part in your email box within minutes.

I respect your privacy. I will never sell, rent or trade your email address.

After you subscribe, the form will redirect you to a thank you page.

Thank you!

Rick Stooker

Permission is granted to reprint the above article in an ezine or on a website as long as it is reprinted in full, with no changes, with full credit and with this contact information and link included at the bottom. All other rights reserved.

Computer Careers (Home) Sitemap Contact Privacy

Info Ring Press

Richard Stooker

PO Box 617

130-G Ballwin Manor Dr

Ballwin, MO 63011

(636) 394-2052

rick@inforingpress.com