Skip to main content

Posts

Can You Create WEB Garden

Hi Friends ,  Few month before  this question was asked to me  , at that time it was totally surprising for me, so my answer was No IDEA sir.. I thought this is Non-Technical question because by name its like any kind of Garden and I am aware about such garden... But This is very interesting Topic in  IIS and Web Technology.. This question forced me to searched and share about this GARDEN .. So,  I planned to implement and test in our current Organization..  he he.... Actually , When a single Application pool contain multiple Worker process is called web garden and  Web application hosted on multiple server and access based on the load on servers is called Web Farms.. Difference between Web Farm and WEB Garden.. Web FARM : When we hosting our single web site on multiple web server over load balancer called WEB FARM . Think if we have only one   web server and multiple clients   requesting for the resources from the server. But when there is huge numbers of 

What is syspolicy_purge_history

When   we   installation or upgrade Sql Server   from a previous version   into 2008, by default a job will be created syspolicy_purge_history.   What does it do? Sql Server 2008 introduced a new feature called Policy Based Management.  For example, one could define a policy that says all tables must have a clustered index.  Once defined, the policy can be evaluated against targets to check for compliance. Each evaluation of compliance will be recorded in below tables :- 1. msdb, 2. syspolicy_policy_execution_history_details_internal,  3. syspolicy_policy_execution_history_internal, and  4. syspolicy_policy_category_subscriptions_internal  The evaluation condition is built on top of object facets, which is predefined by Microsoft. The purpose of that job, syspolicy_purge_history, is to remove records in those tables to maintain so it does take up space unnecessarily .  Happy Readding. @Sumnjha

Disadvantages of Normalization

Dear Friends, We allready know Normalization is the process to optimize the storage and increase the performance of system by eliminating redundancy from database. But there is also circumstances when Normalization can reduce database performance.Due to Joins-Jonis-Joins system makes complex to select a simple record-set. A normalized database requires much more CPU , memory ,  and I/O to process transactions and database queries than does a normalization database. Ref:  1.)  advantages-disadvantages-normalizing-database 2.)  www.informit.com/articles

Serial number or row number

Sometimes there would be a requirement to add serial number (or) row number to the result set. Example: The requirement would be to select some columns from the database tables along with Serial Number like below SNo Customer_Name Customer_Phone_Number 1 aaa xxx-xxx-xxxx 2 bbb xxx-xxx-xxxx So, in this post we will see how we can select that using T-SQL on Microsoft SQL Server 2008 We can achieve this in several ways: 1) Using  Row_Number ()   Row_Number() Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.  T-SQL Script:          SELECT ROW_NUMBER() OVER (ORDER BY CUSTOMER_ID) AS [S.No]                         ,CUSTOMER_NAME                         ,CUSTOMER_PHONE_NUMBER         FROM database.dbo.tblTableName 2) Using  Identity (Property)   Identity() property creates an identity column in the table. So, first we need to cre

OLTP Vs OLAP

Enterprise Systems and IT Application can be categories in two types OLTP and OLAP . In General Terms OLTP is day to day Record Keeping of any organization and OLAP is the Historical Data of Warehouse..   OLTP (On-line Transaction Processing)   is characterized by a large number of transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF) OLAP (On-line Analytical Processing)   is characterized by relatively low volume of transactions. Queries are often very complex and involve aggregations(DISTINCT,GROUP BY,SUM,COUNT ..). For OLAP systems a response time is an effectiveness measure. OLAP applications are widely used by Data Mining techniques. In OLAP database ther

Re-engineering with SSMS

Dear Friends , Last week I was doing Database Re-Engineering of our few Legacy Applications. Actually Re-engineering is a set of activities that are carried out to re-structure a Legacy System to a new system with better functionalities and conform to the hardware and software quality constraint. I tested 3 Tools for Data-Modeling for this process. (1) Toad Data Modeler 4.1 (2) Microsoft Visio and (3) SSMS 2008 . Data Modeling is a process used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations. All are the good software for Data-modeling but I liked all time favorite SQL Server Management Studio Relationship Diagrams simple-easy, free and having good options.. A little formatting in SSMS database diagrams editor As more tables will be added, these may not be arranged for easy viewing. To change the arrangement of the diagrams you can right click in the

Enabling and disabling logins in SQL Server 2005

I n SQL Server, much like other services with users, login accounts can be enabled or disabled. An enabled login can be authenticated and allowed access to database resources. A disabled login is not allowed to establish a connection to the SQL Server instance. For example, let's create a login called  sumank . CREATE LOGIN sumank WITH PASSWORD = 'ipl5@2012' ,DEFAULT_DATABASE = AdventureWorks USE AdventureWorks; CREATE USER sumank In the first statement, the sumank login was created with a fairly complex password and a default database of AdventureWorks. Afterward, we switch to the AdventureWorks database and create a new user for the database. If we attempt to login to SQL Server using these credentials, we can. Next let's disable the login with the following statement. ALTER LOGIN sumank DISABLE If someone attempts to login to SQL Server using the  sumank    login, the connection attempt is rejected and Error 18470 is returned - &q