(Tim Radney) Back in August 2015, I wrote an article introducing the new Stretch Database feature in SQL Server 2016. In that article, I discussed how to get started with Stretch Database in SQL Server 2016 Community Technology Preview 2 (CTP2). SQL Server 2016 was released on June 1st 2016, and the

(Pinal Dave) I have always felt the social media has a bigger impact on the current generation. It can easily spoil their time on one side or it can be awesomely productive if utilized the right way. As there are two sides to the coin, social media also have a similar effect on people.

(Gerald Britton) Python is a mature, open source language. It has found broad application in an increasingly diverse community, including business, government and academia, where it supports operations automation (though sophisticated scripting), data mining and analysis (often combined with other p

(Koen Verbeeck) I’d like to write data to a table using SQL Server Integration Services where some of the columns are encrypted with the new Always Encrypted feature of SQL Server 2016. However, I constantly get errors. How can I solve this issue?

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

(Pinal Dave) One of the most sought after blog is around Wait Stats when it comes to performance troubleshooting. The place to bookmark would be – SQL SERVER – Wait Stats – Wait Types – Wait Queues – Day 0 of 28.

(Mohammed Moinudheen) I would like to get a detailed report of all the SQL Server components that are installed on the local server. Is there any easy way by which I could get this done?

(Pinal Dave) Sometimes the best of learnings are based on people’s questions. I always feel when questions are asked, more the learnings are. In a recent session for a customer who had implemented SQL Server 2014 InMemory OLTP in their systems, they were getting bad performance even when they were u

(Diana Moldovan) Unfortunately the SQL Server Agent error logging can be deceiving for job steps when you run PowerShell scripts. I had a situation where the job looked like it finished properly, but after investigating I noticed that the job did not run as planned.

(Stefan Cronjaeger and Michael Hlobil) Shopping basket analysis typically asks questions like: “If a customer bought product A what might she also be interested in?”. This is typically used for recommendation engines or for arrangement of products in the shelves of the shop.