SQL Server Articles
Setting up Transactional Replication in SQL Server 2008 R2. Replication is one of the High Availability features available in SQL Server. Transactional Replication is used when DML or DDL schema changes performed on an object of a database on one server needs to be reflected on the database residing on another server. This change happens […]
This article demonstrates how the performance benefits of implementing front-end caching in performance.
First part of a three part series demonstrates how to get boost performance using caching in SharePoint.
As DBAs, we are often required to set up alert notification emails for various tasks. For example, there might be a requirement to set up notification alerts if a particular backup job fails. A while back, I came across the situation where I was asked to write a script which sent an email alert to […]
In PowerShell commands are known as CmdLets (pronounced Command Lets). Cmdlets follow the naming convention of Verb-Noun combination: E.g: Get-Help, Get-Service, Get-Process …….
Terms used in this article Execution or SQL Execution represents a call to a Stored Procedure or an SQL Batch. General Description This process creates a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server. The repository lights up your SQL Server’s activity and exposes interesting information […]
Detailed walkthrough on creating a simple application using Visual Studio LightSwitch.
This article demonstrates how to manage database projects with Visual Studio 2010.
This article demonstrates how to manage and optimize IIS pools for running ASP.NET apps.
Prior to .Net 3.0 it was not an easy matter to select a particular technology for communicating between systems due to the number of technologies available from Microsoft. For example, users could have used Web Service to communicate between a Java based application and a .Net application; WSE users could have take advantage of some […]