SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

SharePoint Performance Tuning – Part 1

First part of a three part series demonstrates how to get boost performance using caching in SharePoint.

SQL Server Email Alerts Notifications

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 […]

PowerShell Tutorial – CmdLets

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 …….

Notifications for SQL Server Agent Restarts

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 […]

Create a Performance Baseline Repository

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 […]

Visual Studio LightSwitch Tutorial

Detailed walkthrough on creating a simple application using Visual Studio LightSwitch.

Manage Database Projects With Visual Studio 2010

This article demonstrates how to manage database projects with Visual Studio 2010.

IIS Application Pools for ASP.NET Apps

This article demonstrates how to manage and optimize IIS pools for running ASP.NET apps.

WCF Tutorial

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 […]

Unicode Compression in SQL Server 2008 R2

 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. […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |