Home Core Expertise
PDF Print E-mail

Decision Support Databases

Microsoft SQL Server 6.5-2008 (Beta) - Oracle 7–11g (Since 1999) - Microsoft Analysis Services - DB2 - Teradata - MySQL 

Extract Transform and Load Expertise (ETL)

SSIS - DTS - Sagent - Oracle Warehouse Builder - Informatica

Methodologies

OLTP / OLAP / MOLAP - Access - Warehouse - Relational - Object Oriented - GIS - Network - File - Entity Relationship (ER) - IE/IEE - IDEF1X - Dimensional - Data Flow - Function - Event - Object Role - Process - Structure - State Transition and Systems Modeling - UML - BPM - CASE - Function Hierarchies - Contextual Modeling - Fact/Qualifier Matrix

Languages/Interfaces

ANSI SQL - Transact-SQL(T-SQL) - PL/SQL - MDX - .NET Framework 1.0 - .NET Framework 2.0 - .NET Framework 3.5 - Embedded SQL - SQL-DMO - Active Server Pages (ASP) - VBScript - ActiveX - OLE and OLE Objects - OLE DB - Active Data Objects (ADO) - Remote Data Objects (RDO) - Data Access Objects (DAO) - VB.NET - XML - COM/COM+ - JDBC - ODBC - Python - Java - JavaScript - OLE - Cold Fusion - HTML XBRL - PERL - X-Query - SQL-DMO - SMO

Microsoft Specific Tool

SQL Server 6.5-2008 - SQL Server 2005 Information Services (SSIS) - SQL Server Studio Manager - SQL Server Enterprise Manager - BizTalk Server - Analysis Services - Data Transformation Services (DTS) - Notification Services - Visio - Query Analyzer - Reporting Services - Data Analyzer - Visual Studio .NET 2005 - Service Broker - Visual SourceSafe - Profiler 

Oracle Specific Tools

Oracle 7–11g - SQL+ - Procedure Builder - App Development - Database Admin - Enterprise Manager - Extended Administration - Migration - Network Admin - Data Mart Suite - Designer - Forms - Discoverer - Reports - Developer.

Other Tools

TOAD - Sagent - Computer Associates ERWin - Business Objects - Crystal Reports - Embarcadero - Red Gate - Apex SQL - Quest Central - Spotlight - WinSQL - UltraEdit - Informatica - Active Reports - Performance Monitor - Actuate - J Developer - Excel - Report Writer - Data Junction - OR Express - Crystal Reports - Rational Rose - Cognos - Ab Initio - Brio

Servers/Environments

NET Enterprise Edition - MS Internet Database Connector (IDC) - MS Internet Information Server (IIS) - All Windows O/S’s - AIX - HP-UX Sun UNIX O/S’s - Linux - FreeBSD - PalmOS - Windows CE
 

Knowledgy SQL RSS

SearchSQLServer: Expert advice on database development
Technical advice to simplify SQL Server developer tasks involving stored procedures, T-SQL, XML, SQL tuning and more.
SearchSQLServer.com
  • Utilize SSAS for data predictions and classification using Excel
    Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007. Useful reading for users who are not typically creating data mining algorithms and SAS/SCL programmers

  • The sqlcmd utility in SQL Server
    The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures. Robert Sheldon provides a guide to getting started using sqlcmd in interactive mode, and shows you have to use sqlcmd in Management Studio.

  • Top 10 SQL Server Tips of 2008
    Here are the top 10 SQL Server tips of 2008. From stored procedures that determine table and log file size to the basics of DATETIME and SMALLDATETIME in SQL Server 2005 and date/time value data conversions, these are the most viewed SearchSQLServer.com tips of the year.