This paper describes the author’s experiences in performance management and capacity planning for systems based on Microsoft’s SQL Server database management product. The paper covers SQL Server database design, the resource consumption and performance data sources that are available, the way in which a monitoring regime was established, and the important areas that were addressed when tuning f...

Microsoft® SQL ServerTM has evolved to support huge databases and applications, including multiterabyte databases used by millions of people. SQL Server achieves this scalability by supporting scale up on symmetric multiprocessor (SMP) systems, allowing users to add processors, memory, disks and networking to build a large single node, as well as scale out on multinode clusters, allowing a huge...

Traditional database systems can deal with perfect data. But lot of information is present in imperfect form due to vagueness or imprecision. [16] Fuzzy set theory has been applied to deal with imperfections of data and to enhance the accessibility of databases. When users work with usual software tools they have to change their many valued logical thinking (approximate reasoning) into the twov...

In this paper, we present a detailed discussion on different SQL injection attacks and their prevention technique. In addition, we proposed a new technique for prevention of SQL injection attack for web application. To address the problems of SQL injections, we proposed a technique that uses a concept of filter called ―Smart Filter‖, that avoid the SQL injections with static matching and dynami...

With the changing demographics of globalization, the emergence and prevalence of web application have acquired a central and pivotal role in the domains of technology and advancements. It thus becomes imperative to probe deeply into the architecture, significance and different facets of usages. Web applications enclose the functioning between a user and the services provided by the server, whic...