SQL Server for the Oracle DBA Links

BuckWoody — Wed, 28 Apr 2010 14:29:00 GMT

I do a presentation (and a class) called "SQL Server for the Oracle DBA". It's a non-marketing overview that gives you the basics of working with SQL Server if you're already familiar wtih how Oracle works. This class and these links DO NOT help you with "Why should I use Oracle/SQL Server instead of Oracle/SQL Server" - I'll assume you're already there, and if not, there are LOTS of sites to help you make that decision.

Although these links might contain slight marketing slants (I don't control them) I've tried to get the best links I can. Feel free to comment here to add more/better links.

As such, these aren't links that help you work with Oracle - they are links to help you work with SQL Server. Some of them contain more information than you actually need, others don't have near enough. Taken together (and with the class) you're able to get done what you need to do.

"Practical SQL Server for Oracle Professionals" - A Microsoft Whitepaper, probably the best place to get started: http://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/SQLServer2008forOracle.docx

Free Training: http://technet.microsoft.com/en-us/sqlserver/dd548020.aspx

Classroom training (will cost you): http://www.microsoft.com/learning/en/us/course.aspx?ID=50068A&locale=en-us

Terminology Differences: http://www.associatedcontent.com/article/2383466/oracle_and_sql_server_basic_terminology.html

Datatype mapping between Oracle and SQL Server: http://msdn.microsoft.com/en-us/library/ms151817.aspx

The "other" direction - can still be useful for the Oracle professional to see the other side: http://blog.benday.com/archive/2008/10/23/23195.aspx

Data Design

BuckWoody — Tue, 02 Feb 2010 14:31:00 GMT

I give series of classes and presentations on Data Design. I say “data” design instead of “database” design because we should consider more than just the database. Data might actually be stored in non-relational stores, such as Excel or XML files, and it might also be located in remote data stores like “cloud” technologies.

Here are the links I use in that presentation. Although this isn't a comprehensive list of Data Design topics, I’ll visit this topic from time to time so you may want to bookmark this page in your favorites:

Evidence and Comments:

http://tinyurl.com/ygvbadc

http://tinyurl.com/ydeh9ut

http://tinyurl.com/ycu9apq

http://tinyurl.com/ya7a9xc

http://tinyurl.com/ydlumyp

Importance:

Yes, it matters: http://tinyurl.com/yb5ucvn

Classic software development mistakes: http://tinyurl.com/y9x9vn8

Necessity of Good Design: http://tinyurl.com/yac3um3

Importance of Database Design Ranked high for BA/Dev interaction: http://tinyurl.com/yex4sjf

Structured Methods: