(blobeater) A small but nice little feature I have been using recently can be found within Query Store.

(Kenneth Fisher) tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add AND ColName IS NOT NULL to the constraint of the table that holds the data you are SWITCHing in.

(Manvendra Singh) I explained how to install SQL Server vNext on Ubuntu in my last tip and in this tip we will look at how to install SQL Server tools on the Ubuntu server.

(NEERAJ Sharma) Learn what is the importance of primary key, why we should use it and how to create Alter and drop the primary key in SQL Server.

(Jack Vaughan) There are bits of DocumentDB at the foundation of Microsoft’s Azure Cosmos DB, a multimodel database that supports multiple modes of data processing.

(Pinal Dave) When I was on-site for the performance tuning workshop, few DBAs suddenly got call as there was an unexpected downtime of SQL Server. As per them, after some maintenance activities were scheduled, the SQL Server resource failed to come online on both nodes.

(Arshad Ali) Azure SQL Data Warehouse is Microsoft’s new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes.

(Koen Verbeeck) At our company we’re using Master Data Services (MDS) 2016 to manage and store our master data. We have a rather large entity storing our employees. For each employee, we need to indicate his or her manager using a dropdown menu.

(Pinal Dave) This was really one of the issue where I was totally confused because SQL Server was raising incorrect error message. Let me first tell you what I was doing. I was trying to move TEMPDB database files to a new location.

(James Serra) Previously available were two tiers, Power BI Free and Power BI Pro ($10/user/month). The problem with Power BI Pro is that for large organizations, this can add up.