Home
Posts RSS
Comments RSS
Oracle Query
SQL Server Query
Oracle Quiz
SQL Server Quiz
MySQL Query
Business Quote
SAP FI Quiz
Color T-SQL

Database Knowledge

How to become a good database administrator (DBA)? To me, you must love this job and update DBA knowledge frequently. Most of my job is related to database design/development and business analysis, so I mostly focus on database query and business analysis in this blog. You may find a lot of queries here as well as some query quizzes. Hope you enjoy it! (Best with screen resolution 1280 by 1024)

Categories

Access (4) Active Directory (1) Administration (1) Agile (2) Backup (2) Check (1) CLR (2) DB2 (1) DBA Tasks (44) Domain Controller (1) EPM (6) FI (1) FICO (1) Fun (1) Gadget (1) linked server (4) Management (1) My OpenERP Setting (3) My Oracle Setting (1) MySQL (44) MySQL Query (42) MySQL Quiz (2) News (1) Online database (1) OpenERP (7) OpenERP:CRM (1) OpenERP:HRM (3) Oracle (90) Oracle Query (86) Oracle Test (12) PL/SQL (78) Pligg (1) PostgreSQL (26) PostgreSQL Query (11) PostgreSQL Quiz (6) PostgreSQL Tip (15) Project Management (2) Project Server 2007 (8) psql (1) Python (1) Quiz (3) Restore (1) Salesforce (1) Salesforce Object Query Language (2) SAP (1) SCRUM (2) Security (1) SharePoint (6) SharePoint Designer (3) SOQL (2) SQL Server (155) SQL Server 2000 (21) SQL Server 2005 (69) SQL Server 2008 (26) SQL Server Test (83) SQL Server Tip (173) SQL Tips (5) SQLite (1) T-SQL (48) Video (3) Virtual Machine (1) VirtualBox (1) vtigerCRM (16) YQL (1)

Archive

▼ 2015 (2)
- ▼ April (2)
  - Life Quote
  - SAP FI Practice

► 2014 (2)
- ► February (1)
- ► January (1)

► 2013 (1)
- ► January (1)

► 2012 (33)
- ► December (7)
- ► November (2)
- ► October (13)
- ► September (10)
- ► March (1)

► 2011 (25)
- ► November (3)
- ► October (10)
- ► September (5)
- ► July (2)
- ► June (1)
- ► May (4)

► 2010 (160)
- ► December (2)
- ► October (2)
- ► July (25)
- ► June (3)
- ► May (3)
- ► April (8)
- ► March (20)
- ► February (59)
- ► January (38)

► 2009 (150)
- ► December (26)
- ► November (31)
- ► October (2)
- ► September (10)
- ► August (5)
- ► July (16)
- ► June (8)
- ► May (7)
- ► April (29)
- ► March (2)
- ► February (9)
- ► January (5)

► 2008 (6)
- ► December (5)
- ► November (1)

► 2007 (11)
- ► November (1)
- ► October (2)
- ► September (3)
- ► August (5)

Followers

Showing posts with label News. Show all posts

Showing posts with label News. Show all posts

Sunday, February 15, 2009

What Can Database Developers and DBAs Do About SharePoint?

If you are a DBA and are using it. Do you like it or dislike it?
Read here
Source: Redmond Developer News

at 10:11 PM 0 comments

Labels: News, SharePoint

Older Posts Home

Subscribe to: Posts (Atom)

Search This Blog

About Me

タオ　チューン: I love information system such as ERP, CRM, SCM, HRM, Accounting, etc very much and would like to share my knowledge about ERP, CRM, HRM, SCM, ... which I knew to everyone.

View my complete profile

Popular Posts

PostgreSQL: Replace multiple spaces with one

If you want to use a single query to replace multiple spaces with one on SQL Server, you can read the articles here http://www.sqlservercent...
Trigger quiz

Your company uses a SQL Server database to manage data on e-Commerse site. This database contains a trigger named tgInsertOrder, which fires...
PostgreSQL - VACUUM ANALYZE EXPLAIN NOTIFY

Select the correct statement that records the space occupied by deleted or updated rows for later reuse, and also updates statistics. A. VAC...
#Oracle quiz

The contact table contains these columns: First_Name VARCHAR2(25) Sales_Commission NUMBER(3,2) Evaluate this SQL statement SELECT firs...
Create SQL Server linked server to PostgreSQL database

1. Download ODBC Driver at this address http://www.postgresql.org/ftp/odbc/versions/msi/ Choose the suitable version with your PostgreSQL ...
Get current queries executing on PostgreSQL

SELECT datname "Database Name" , usename "User Name" , procpid "Process ID" , client_addr "Client ...
RTRIM

What will be the output of the following script? SELECT RTRIM('TestxxXXxxx','x') FROM dual; A. Test B. TestxxXX C. Te...
Reference to another server

You have two SQL Server 2005 computers. One server is SQL1 and another is SQL2. You need to access SQL2 from SQL1. You have enough permissio...
Get vtigerCRM Contact List

The following query gets vtigerCRM Contact List SELECT t1.contact_no , t1.firstname , t1.lastname , t1.title , t4.accountname , ...
PL/SQL quiz

The employee table contains these columns: LAST_NAME VARCHAR2(50) FIRST_NAME VARCHAR2(50) SALARY NUMBER(8, 2) You need to display the na...

Wikipedia

Search results

Let's study and review database knowledge