(WaterOx) Once you have a query that is returning the data you like in SSMS you have a few options to move the result set into a format that you can use in other tools.

(Pinal Dave) Here is another question I received via email.

(Jeremy Kadlec) I am aspiring to become a SQL Server DBA. I have seen numerous sets of information related to SQL Server tests, conferences, user groups, your tips and more, but what does it really mean to be a SQL Server DBA? What should I really aspire to become as a SQL Server DBA?

(Guy Glantser) Five years ago the term “cloud” was still a buzzword, and there was a lot of uncertainty and misconception around it. I remember many DBAs, including myself, asking themselves what this revolution means for them. People asked themselves how a DBA role will look like in five years, or

(Pinal Dave) I have been quite a few comments on my Facebook page and here is one of the questions which instantly caught my attention.

(Ali Mazaheri) Recently I was asked by a customer if there is a way to allow SharePoint Online users to connect to an on-premises SQL database without using BCS and avoid the overhead configuring that.

(Thomas LaRock) A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I’ve been sharing some scripts recently, I decided to verify that this script still works for finding long running jobs in SQL Agent for SQL Server 2014.

(Kenneth Fisher) In order to speed up our backups on a large database our team decided to stripe the backup files. In case you weren’t aware of this particular backup feature it his means that a single backup is written to multiple files which can dramatically speed up your backups and restores.

(Chris Webb) In one of my first posts on Power Query (and still my favourite) I found the top 100 words in the complete works of Shakespeare. As always when you’re learning a new tool, though, I look back at what I wrote then and realise there are better ways of doing things… one of which is removin

(Pinal Dave) Here is one more question I recently received in an email-