(Chris Webb) Two years ago I blogged about a method to export all the M code for all of your queries in Power Query using the Send A Frown button – useful if you need the code for documentation purposes.

(Ed Elliott) I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database but they had a number of issues, the main was that because management wasn’t sold on the idea and the DBA’s had complete control to push back on all and every idea he had

(Kenneth Fisher) The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues.

(Robert Sheldon) Is ‘Always Encrypted’ SQL Server 2016’s most widely important new feature? It is significant that ‘Always Encrypted’ in SQL Server is in all editions of SQL Server. Because of the increasing importance of encryption to data governance, it allows encryption for the sensitive applicat

(Grant Fritchey) One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty universally denigrated (well, not by Microsoft, but by most everyone else). However, what value should you set yours to?

(Arun Sirpal) Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace, once you get past the learning curve it’s probably the way to go.

(Chris Webb) Last week I received an email from a reader asking how to handle missing members in MDX used in the Excel CubeSet() function. My first thought was that this could be solved easily with the MDXMissingMemberMode connection string property but it turns out this can’t be used with Power Piv

(Kenneth Fisher) When you open SSMS a connection window automatically comes up. Then once you pick your server, connection type, username and password (if needed) you get an object explorer connection.

(Michael Otey) Microsoft software licensing can be tough to manage — so let’s analyze some of the different situations for licensing SQL Server 2016 that enterprises will likely face.

(Jon Gallant) We often need to share database connection strings, system account passwords and whatnot with our team members. People typically put the secret in a DRM’d email, but that’s not secure enough and you can’t copy and paste them. There’s a better way with Azure Key Vault and Azure Key Vaul