Other News

Uncategorized

Good Enough Upgrade Thoughts, SQL Agent, SQL 2005 Admin Tools

Featured Article(s) Understanding the SDLC Phases of a Software Project [Part III] This is the concluding part of this series that discusses the remaining SDLC phases and sums up what we have learnt so far in this series of articles on the standard SDLC phases in the life cycle of a Software Project. Watch Now: Using SQL Agent to Automate […]

Community

Using an XML File

After creating an XML file, you can use it. One way you can do this is to display it in a grid-based window such as the DataGrid control. Another way you can display an XML file is in a browser. To do this, if you see the file in Windows Explorer, in My Computer, or in My Documents, you can […]

Community

Oracle 11g – PIVOT and UNPIVOT

(Venkatakrishnan J) If you had noticed, one of the most important new features of Oracle Database 11g from a SQL perspective is the introduction of PIVOT and UNPIVOT operators into SQL constructs. So, now one can have cross tab views, that we are so used to in reporting tools (like OBI EE), from sql