I have a Power Query set in myexcel.xlsx. I set its connections's properties as this and this. I wrote a VBA code like the following Sub UpdateData() Dim filename As String Dim wbResults As Wo...

I know this might be a simple question but is there an easier way to import a CSV into Excel without it automatically generating a data connection? I know you can do it by: Importing the csv the...

I have a database hosted at somee.com I have added a new connection in Server Explorer in VS 2012 and the test connection was successful. I can also successfully see the tables in the SE and any ch...

I want to limit the number of users per database in a multi tenant environment. But there are three levels of max connections and I should be grateful for any advice. Level 1 Entire Server By edi...