(Jos de Bruijn) We are happy to announce that SQL Server 2016 removes the size limitation on user data in memory-optimized tables. You can grow your memory-optimized tables as large as you like as long as you have enough available memory. This means that with Windows Server 2016 you can leverage all

(Pinal Dave) These past weeks the number of errors I have been getting when attaching a database has been far too many. But the best part of this learning experience is that I get to write about them one after another. There are no right or wrong answers sometimes, but am learning every time.

(Arshad Ali) Query Store is a new feature in SQL Server 2016, which once enabled, automatically captures a history of queries, execution plans, and runtime statistics, retaining them for your troubleshooting performance problems caused by query plan changes. This new feature greatly simplifies perfo

(Manoj Pandey) Today while running an ETL I encountered an error I’d never seen before. The Informatica ETL triggers a Stored Procedure with 2 parameters which takes table names and creates a dynamic MERGE statement.

(Sudha Rani Polapragada) When it comes to releasing and delivering an Entity Framework application, you will be faced with the problem of deploying it to several delivery environments such as test or staging as part of the delivery pipeline. How do you cope with managing, error-free, all the environ

(Manvendra Singh) We have completed the prerequisites and required pre-checks including cluster validation in this previous tip. Now we will begin the installation of SQL Server 2014 on the two node cluster and this tip will explain the steps to install SQL Server.

(Pinal Dave) It is about a few weeks back that I wrote about how InMemory OLTP Hash Collisions can happen and how it can affect performance.

(Kalen Delaney) Finally, we have a download available.

(Erin Stellato) One of the SQL Server trace flags that’s been around for a while is 2389. It’s often discussed with 2390, but I just want to focus on 2389 for this post.

(Vinay Singh) Let’s start with creating an Employees table with following schema: