SQL Server 2012 introduced the new feature called AlwaysOn. AlwaysOn provides High Availability & Disaster Recovery alternative to Database Mirroring. What is Database Mirroring? Database Mirroring is a technique to increase High Availability of database. The topology consists of three server roles. Witness Server Principal Server Mirror Server Transaction Logs will be synchronized from Principal […]
In this article we can explore another feature of SharePoint 2010 – Business Connectivity Services. This service allows data reading and writing from external data sources. Using BCS we can access and modify data from: · WCF Service · Database · Business Applications · .Net Assembly connecting to Business Data · Custom Connectors BCS Architecture […]
The Enterprise Management studio provides an option to shrink the database. Step 1: Open Enterprise Management Studio (i am using sql server 2008) and select database, right click and choose Tasks>Shrink Step 2: In the appearing dialogue press Ok to start the shrink process.
I would like to take a moment to explain the following problem I am facing: I do have a table named Equity which contains the company name and the current PE Ratio. The PE Ratio will be updated daily or weekly based on the wish of user through a web application in ASP.NET. When the […]