(Kris Wenzel) All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database. You can get started using these free tools using my Guide Getting Started Using SQL Server.

(Dinesh Asanka) In many database systems, it is a requirement to grant read permission for all databases. To achieve this, there is no other way but grant read permission to each and every database.

(Chris Shaw) This article is part 3 of 10 in a series on the most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I see and is not all inclusive.

(Kevin Kline) Just in case you missed the latest news from Microsoft, SQL Server 2014 has finally gone RTM (Released to Manufacturing). I’ve been telling you about the new features planned for this release since late summer of 2013.

(Derek E Wilson) Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and 2014. SQL Server allows for the deployment of 2 or more servers running SQL Server Reporting Services to increase the performance of your reporting environment.

(Feodor Georgiev) It is quite common to have an OLTP database that must store large amounts of data which pile up into hundreds of millions, even billions, of rows. What do we do in such cases? In this article I will describe a way to deal with constant flows of OLTP data into production systems, an

(Arshad Ali) There are different techniques to optimize the performance of SQL Server queries, like keeping required and updated statistics, creating required indexes, partitioning tables, etc., but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries

(Jeffrey Yao) What are the common DBA tasks suitable for SQL Server PowerShell? How can I start to learn about these tasks in SQL Server?

(Pinal Dave) I cannot get enough of working with TempDB and the learning never stops. Previously, when I wrote about SQL SERVER – Is tempDB behaving like a Normal DB?, SQL SERVER – Inside Temp Table Object Creation and Difference TempTable and Table Variable – TempTable in Memory a Myth many did ask

(Thomas LaRock) I love learning new things. I feel like a kid again at times, my eyes get wide as I imagine new possibilities using whatever things it is I have found. This is how I felt last week when I came across a feature of SQL Server Management Studio (SSMS) that I had not seen before despite