SQL Server Articles
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 …….
Introduction In this article we will set up an email notification at the SQL Server level whenever SQL Server and the SQL Server Agent Restarts. The article will useful for DBA’s who support a large number of database servers which they cannot manually connect to daily to check the SQL Server status, SQL job status […]
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 […]
Introduction Data Compression was first introduced in SQL Server 2005 with Service Pack 2 when Microsoft introduced a new storage format called VARDECIMAL to store decimal and numeric data types as variable length columns. In SQL Server 2008, Microsoft enhanced Data Compression feature to compress fixed length data types such as INTEGER, CHAR and FLOAT. […]
Detailed guide to shared, VPS and dedicated hosting.
Introduction One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user […]