(Arshad Ali) In the previous article on AlwaysOn Availability Groups in SQL Server 2012, we looked at The Environmental Setup for An AlwaysOn Availability Group. In this article we turn our attention to the creation and configuration of the Availability Group.

(Rohatash Kumar) In this article I provide a quick overview of how to add a number in a string in SQL Server. In this article you will take a string and add a number before the string or after the string.

(John Pertell) One of my favorite features in the new SQL Server Data Tools is the query window. Specifically, what I like is the ability to rearrange the panes to better see query results and different sections of a long query or procedure.

(Adamgorge) During the process of restoring SQL Server databases, data is copied from a backup and changes are then made to this data by applying logged transactions. Backups comprise transaction log records that can be used to roll forward any active transactions or roll back any uncommitted transa

(Brady Upton) I’m trying to tune my SQL Server and I’m having a hard time deciding if my CPU is under a lot of stress. What’s a quick and easy way to detect CPU pressure?

(John Sansom) I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known technique and I wanted to share it with you here.

(Arshad Ali) Continuing from AlwaysOn Part 1 the series continues with a step-by-step guide to setting up the environment for an AlwaysOn availability group.

(Paul Randal) It’s no secret that DBCC CHECKDB has some performance quirks based on the schema of the database being checked and various kinds of corruptions..

(Sivaraman Dhamodaran) In SQL Server we call a complete set of actions as a transaction. The complete set of actions together form a meaningful change to the database.

(Thomas LaRock) Many novice administrators make the common mistake of believing that the upgrade process for a database server is as easy as pressing a few buttons.