Set Up SQL Server Mirroring T-SQL Script

T-SQL Script to create a SQL Mirroring:-

The first thing you need to do when setting up Database Mirroring is perform...

SQL Server : Dedicated Administrator Connections

Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest...

SQL Server 2008 R2 Service Pack 2 Cumulative Update 1

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 1, which is Build 10.50.4260.0. This CU has...

SQL Server Quickies – a new way to learn about SQL Server

We are all living in a fast moving world, especially in the IT industry. We have to learn new technologies...

SQL Server Quickies – a new way to learn about SQL Server

We are all living in a fast moving world, especially in the IT industry. We have to
learn new technologies every...

SQLSailor is exploring(Part4) – Basic DML,DDL operations with SQL Databases on Windows Azure

In this post we will review some basic DML,DDL capabilities of SQL Database on windows Azure.
This post is in continuation with my...

Two New Cumulative Updates for SQL Server 2008

On July 17, Microsoft released two new Cumulative Updates for SQL Server 2008. The first cumulative update is SQL Server...

Bad business practices damage your company, KRG Technology

I just composed and sent this message to eleven members of a single California-based recruitment company. I’ll let the email...

Improve DBA Operation Productivity – Part Two

As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our...

OLAP PivotTable Extensions Update

OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now.  It...