Articles

General:

PostgreSQL vs. MySQL: Which Is the Best Open Source Database?



Interview:

Database developer interview questions

Questions to ask a SQL Server database developer applicant

Data-Warehousing

Resource

*******************************************************************************
Relational Database:


                          coursera-Stanford University-Introduction to Databases

*******************************************************************************

Relational Database:

 :Schema - database structure, relation of different attributes.)

 :Data type

 :DDL - Data Definition Language (Create,)

: DML - Data Manipulation Language(Select,Insert,Update ,)

 :Querying relational databases

Indexes:

Constraints & Triggers:

Transactions:

Views:

Authorization:

On-Line Analytical Processing (OLAP)

                                 
XML Data:
Querying XML:
JSON Data:

NoSQL Systems

Source Article : Hadoop-NoSQL Software and Services Market Forecast 2012-2017



*******************************************************************************

Treehouse: Learn Web Design, Web Development, and More

Learn HTML, CSS, iPhone apps & more.


Learn how to build websites & apps, write code or start a business.

Source Article: Facebook’s Profit Propelled by Mobile

...
Mobile devices accounted for nearly two-thirds of Facebook’s revenue, which at this point mostly comes from ads shown on the Facebook website and apps. However, the company is beginning to supplement that with ads on other sites.
...

*******************************************************************************

Tutorials for SQL Server 2012

Business Intelligence for SQL Server 2012

Beginner SQL Tutorial

*******************************************************************************

(Beginners) Learn .NET and c# (Csharp) in 60 days - Lab 1 (Day 1)

Learn .NET in 60 days

Oracle Architecture in less than 10 minutes

*******************************************************************************
Queries:

SQL 2008 Retrieving parent-child hierarchy from query  


SQL Server forums  >  Transact-SQL



;WITH EmpCTE(empid, empname, mgrid, lvl)

AS

( 

 SELECT empid, empname, mgrid, 0

 FROM Employees

 WHERE empid = 14 --input the leaf empid

 UNION ALL


 SELECT E.empid, E.empname, E.mgrid, M.lvl+1

 FROM Employees AS E

  JOIN EmpCTE AS M

   ON E.empid = isnull(M.mgrid,0)-- search the mgrid according the mgrid on leaf empid

)

SELECT * FROM EmpCTE


--result

empid    empname          mgrid    lvl
----------- ------------------------- ----------- -----------
14     James           11     0
11     David           7      1
7      Robert          3      2
3      Janet           1      3
1      Nancy           NULL   4


 ----------------------

Departures from Origins and Arrivals at Destinations




*******************************************************************************


                                                Unix Command Summary


                                                  Java Basic Syntax


*******************************************************************************
Erwin Data Modeler:



                                              Erwin Data modeler


                            CA ERwin Data Modeler: Soup to Nuts Demo


                                     ERwin Data Modeler WorkSpace


               Metadata Integration from CA ERwin Data Modeler to Informatica PowerDesigner

Toad World:

ERWin models  to Toad Data Modeler

Importing Erwin Data Model 

Data Modelers - Alternatives to Erwin

What are the TOAD & ERWIN? What are the difference between them?
 posted in BusinessObjects Reporting Tool (BO)

- TOAD is a software tool to connect to Oracle database (Oracle Client side tool)
- Erwin is a tool to do data modeling in logical and physical level

SWITCHING DATA MODELING TOOLS? OUCH!


*******************************************************************************

ETL Tools:


Datastage Tutorials-Datastage ETL Tool Datastage Frequently asked questions, Datastage Interv

*******************************************************************************
Programming Language:


                        The Python Tutorial


                          PL/SQL Tutorial




*******************************************************************************

How to improve LIKE Operator performance

Source : How to improve LIKE Operator performance


I have a ZIPCode list in a temp table (10,000 records) . I need to get all records where the zip code MATCH with the zip codes in the list.
If I do exact match, I get result in 1-2 second ( first query) but if I do a LIKE as in second query it takes more than a minute.

First query use Hash Join where other do Nested Loop.

Any way we can improve the performance of second query?


SELECT count(*) FROM Panelist (NOLOCK)
WHERE   EXISTS (SELECT TOP 1 1 FROM ##ZIPLIST WHERE Panelist.PostalCodeVal = VALUE )
go
SELECT count(*)  FROM Panelist (NOLOCK)
WHERE   EXISTS (SELECT TOP 1 1 FROM ##ZIPLIST WHERE Panelist.PostalCodeVal like VALUE +'%')
go

SQL Server Performance Monitoring Tools - Microsoft's SQL Server Profiler - Query Performance Tuning

Improve SQL Server performance using profiler and tuning advisor

************************************************************************

Query Performance Tuning Performance tuning is half science and half art form


                                        Performance Tuning Tips


SQL Server Performance Monitoring Tools - Microsoft's SQL Server Profiler


                   Optimize SQL Server queries with these advanced tuning techniques

SQL Server 2012 New Features

whats new in sql server 2012

Top 20 exciting features of SQL Server 2012 – Part 1



SQL SERVER – Four Tutorial for SQL Server 2012 New Features


Column Based Database