(Jack Vamvas) Using wait stats to identify pressure points on your SQL Server is a common method for troubleshooting. Unfortunately , it is very easy to jump to conclusions about problems on the basis of the highest wait stats.

(Adam Bertram) Have you ever had the need to get an inventory of all of the logins that have been created on a bunch of SQL servers? I have and it wasn’t pretty. I was trying to deploy the System Center Operations Manager client across a datacenter and if you’re familiar with that product it needs a

(Murilo Miranda) In-Memory OLTP (IMOLTP) introduced to SQL Server not only a new engine, but also some new concepts. A database that is truly working with IMOLTP contains several Memory-Optimized Objects including, in SQL Server 2016, memory-optimized tables, memory-optimized table variables, native

(Pinal Dave) While I am getting ready to play with SQL Server 2016, I am finding fresh look and feel for SQL Server Management Studio. I heard that its uses latest version of visual studio shell. There are many enhancements which I am seeing in SSMS 2016 and today I would talk about Scroll Bar setti

(Scott Murray) How do I connect Power BI Online to on premise data sources?

(Kenneth Fisher) Let’s start with a very brief definition of some RAID levels.

(Scott Mattie) This article will provide you with a step-by-step set of instructions on how to upgrade a SQL Server 2012 or 2014 evaluation edition to an Enterprise edition. Similar steps can be used to upgrade to any other licensed editions, Developer, Standard or Enterprise.

(Pinal Dave) Of late some of the troubleshooting scenario I am getting involved is amazing. Though some of them are complex, it gives me a unique opportunity to learn and try something new to share later with you folks. Recently I was contacted by a team who takes care of SQL installations.

(Steve Endow) While researching some performance issues at a Dynamics GP customer, I noticed that the SQL Server tempdb had been setup with four separate files. I hadn’t seen that before, so I looked it up, and apparently it’s a thing.

(Jack Vamvas) Here’s a strange error I experienced when attempting to restart a SQL Server Service. The Service wouldn’t restart , the status was hanging on “Change Pending”.