SQL Archive
11 Nov 2010
SQL Injection Attacks And Prevention Methods
SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution. The vulnerability is present when user input is either incorrectly filtered for string literal escape characters embedded in SQL statements or user input is not strongly typed and
09 Nov 2010
Database Cache Technology
Cache is a new generation of ultra-high-performance database technology. It combines an object database, high-performance SQL, and powerful multidimensional data access – all of which can simultaneously access the same data. Data is only described once in a single integrated data dictionary and is instantly available using all access methods. Cache provides levels of performance,
20 Oct 2010
Using Microsoft SQL Server PowerPivot for Business Intelligence and Data Warehousing
For years together now the Microsoft Office Excel spreadsheet has been a trusted tool for most data analysis needs. Not only are the features of Excel extremely user friendly to perform analysis but also it allows data to be imported and exported to various other formats, which makes it a favored tool among the business
19 Oct 2010
Data Warehousing 2.o and SQL Server
Disk storage came in forte when online transactions were being processed for the first time. Many will agree that the reason for online transactions to be come successful is disk storage technology. Whenever this processing happens the data is accessed from the storage in a random fashion. The data therefore is stored on the disk
03 Oct 2010
SQL Server 2008 SP2 released – Fully Loaded
The SQL team has let one more out of the bag. This time it is an Service Pack 2 (SP2) release of their flagship product – SQL Server 2008. The SQL Server 2008 SP2 comes close to the release of many other key products coming out for the past couple of weeks, including the Windows
15 Sep 2010
What is “Project Houston”?
Project Houston is a Microsoft project and lightweight, easy to use database management tool for SQL Azure databases. This is specifically designed and developed for web developers and other technology professionals looking for a quick solution to develop, deploy and manage their database driven application in the cloud. It is nothing but a web based
13 Sep 2010
SQL (Structured Query Language) Introduction
Most commonly, we come across situations where in we need to store huge data in database and we need some means to manage the data stored in the database. There are several tools which can be used to manage the data in the database generally termed as “Database Management System” (DBMS). Some of the DBMS
13 Sep 2010
State Management in ASP.NET
State Management is an important aspect in ASP.NET to be used and taken care of when developing web applications.We can manage the state of objects in ASP.NET using a variety of ways either on client-side (basically the web browser) or on the server-side. Web applications in general use the HTTP protocol for sending web requests