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

(Rick Heiges) Stretch database (StretchDB), a new feature coming in SQL Server 2016, allows a database to exist partially on-premises and partially in the cloud as an Azure SQL Database.

(K. Brian Kelley) We ran into a case recently where we had the logins scripted out on my SQL Server instances, but we didn’t have the server roles nor their members. As a result, our recovery efforts were only partially successful.

(Kris Wenzel) In this article we explore the OFFSET and FETCH clauses. OFFSET and FETCH are used in conjunction with the SELECT statement ORDER BY clause to provide a means to retrieve a range of records.

(Kenneth Fisher) A question came up at work the other day, mostly as a mind game, but you never know it might actually come up at some point. So here is the idea.

(David Postlethwaite) On the Database Scale page we can decide on the performance level that we want our database to have.

(Pinal Dave) Couple of week back, I was playing around with using Powershell for some simple activities. The fall out of that was the ability to search the SQL Server Error Logs. Though we can search for anything, I just showed you a case of usage.

(Manvendra Singh) A user with SQL Server db_owner access has a requirement to run SQL Server Profiler on a frequent basis to do some development work in a lower life cycle environment.

(Pinal Dave) Sometimes the best way to learn is by taking some of the capabilities to the extreme. This blog post is one of those explorations which I would like to share.

(James Serra) Massive parallel processing (MPP) is the future for data warehousing.