(Michael J. Swart) I’ve got a program here that finds SQL in procedures with missing column specifications.

(Kenneth Fisher) My recent post on why SQL logins aren’t working has generated a couple of follow up posts. The first one was on how to create a connect item and then this one. It was pointed out to me that the errors in the log have quite a bit more information than the ones displayed while trying

(Arshad Ali) Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In my last article of the series, I discussed the traditional way of creating a data warehouse an

(Ben Forta) Learn how to connect and log into SQL Server, how to issue SQL Server statements, and how to obtain information about databases and tables.

(Arun Sirpal) I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more specifically Physical disk:Avg sec/read(orange/yellow line) and Physical disk:Avg sec/write(blue line), yes it was very busy, much busier than normal.

(Melissa Coates) I have been getting more familiar with the encryption-at-rest capabilities in Azure for virtual machines (VMs). This post covers two options: Storage Service Encryption (SSE) and Disk Encryption.

(Erin Stellato) Last summer, after SP2 for SQL Server 2014 was released, I wrote about using DBCC CLONEDATABASE for more than simply investigating a query performance issue.

(Alex Grinberg) The feature formerly known as Hekaton, now In-Memory OLTP can provide very useful performance gains where you carefully select the tables to become memory-optimised. How do you set about the job of converting existing tables to become memory-optimised tables? the process isn’t entire

(Louis Li) Last week, I have had one mystery challenge while creating Availability Group listener in Azure. We followed Configure one or more Always On Availability Group Listeners – Resource Manager and found out the listener didn’t work as expect. Let me walk you through what we have experienced.

(Chris Webb) In part 1 of this series I showed how you can use Profiler to find out which MDX calculations are being evaluated when a query runs on SSAS Multidimensional. In this post I’ll show a practical example of why this is so useful: a situation where SSAS evaluates a calculation that isn’t ne