(Chris Webb) When I’m working with XML files, or web pages, or any data with columns containing nested tables in Power Query, I often end up having to expand every expandable column in the table and then expanding any new columns that are revealed after that to find the data that I’m looking for.

(Pinal Dave) I currently have SQL Server 2012 and SQL Server 2014 both installed on the same machine. My job requires me to travel a lot and I like to travel light. Hence, I have only one computer with all the software installed in it.

(Tim Smith) We import a file once a day and after importing the file, we need it moved to an archive folder with a date stamp appended to the file name. We have had trouble in the past with this process, so we’d like this to run as its own step to help troubleshoot it if there are issues.

(Kenneth Fisher) Typically when you see a heading like this you know the answer is “No” or “False” but in this case it’s more of a “hu?” You see a primary key and a table being a heap have nothing to do with each other. Well very little anyway.

(Arshad Ali) Encryption brings data into a state that cannot be interpreted by anyone who does not have access to the decryption key, password, or certificates. Though encryption does not restrict the access to the data, it ensures that if data loss happens, then in that case data is useless to the

(Chris) Did you know that you can add hyperlinks to your web parts that PerformancePoint creates for you? This makes it so you can redirect to either an online location or to more descriptive information about what that dashboard represents.

(Daniel Farina) My company bought new storage and we were instructed to move our SQL Server databases to it. The problem arose when we needed to move a 2 TB database with a time frame of 15 minutes. In this tip I will show you how I managed to successfully do it with the native SQL Server options.

(Itzik Ben-Gan) Supporting your query filters with the correct indexes is essential for optimal query performance. When your query filter has a single predicate that’s a search argument (SARG), things are straightforward: You create an index with the filtered column as the key.

(Scott Murray) What are SQL Server Analysis Services Perspectives? What do they do and how can they be used? Check out this tip to learn more.

(Kenneth Fisher) Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon triggers can be dangerous if you aren’t careful. They can be really useful and are a great tool, but if you mess up you can REALLY mess up.