SQL Sprocket is an open source template-based code generating tool designed specifically for SQL Server Database Developers. I have been using this tool for years to enforce standards, reduce errors, and quickly generate any stored procedures required by my development projects.
Introduction Real Application Clusters (RAC) allows multiple computers to run Oracle software simultaneously while accessing a single database, therefore providing a clustered database. In the previous non-RAC oracle database, a single instance accesses a single database. And we know that clustering is the task of assigning a set of objects into groups. In an Oracle […]
I came across this very handy way of dynamically formatting and converting tables rows into columns for a PIVOT statement. No CURSOR or CTE is required, just a single variable. Run the example against a SQL 2012 instance and you will get the idea.
The Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book aims to be a sure selection for the Associate level Oracle professionals aspiring for Professional level. The topics covered and demonstrated are in line with the Oracle University prescription for Oracle Professional certification, which justify the […]
For the technical purpose of database developers and administrators, a database is simply a collection of operating system files. Database files are normally stored in a proprietary binary format that can only be mounted by an instance of the relational database software that created them. The purpose of the database instance is to manage and deliver […]
I finally got around to installing SQL Server 2012 RC 0 on VMware Fusion 4 yesterday. Like a kid on Christmas, I started looking for the enhancements that do not get much marketing attention, but will improve my development workflow or put an end to some administration pains. This is what I found so far: […]
This post came out of the difficulty to find the information needed to prepare myself for a week long Exadata proof of concept I have scheduled next month at the Oracle Technology Center in Menlo Park. The topics listed below should confirm your suspicion that there is significant learning and study required to understand Exadata. […]
Introduction to Constraints Oracle constraints are defined as the rules to preserve the data integrity in the application. These rules are imposed on a column of a database table, so as to define the basic behavioral layer of a column of the table and check the sanctity of the data flowing into it. The data […]
Data mining, processing and its presentation are the key activities in a production environment. The views and analytic integrals of the information through multiple spectacles can help in better business forecasting and strategic implementations. This innovative exercise of creating varying views might involve aggregation, data transposing, or cross tabulation reporting. Data Pivoting, one of the […]
Cursors are one of the most common and fundamental terms in the database terminology. It is one of the core database programming concepts, which forms a basic unit of execution of SQL statement. A cursor is a pointer, which points towards a pre allocated memory location in the SGA. For transparent understanding, it is a […]