These types of people were the first ones we would weed out...When I would interview people and they didn't know the answer I would always follow up with "I don't...

I so agree with Steve. I have not been heavily involved with day to day SQL Server for while now, however, I still educate myself on new functionality, technologies,...

I admire all the work put in to accomplish this stuff.   But now that Polybase is part of SQL Server, why wouldn't you connect directly to Hadoop from SQL...

You do know that if you are going to run SSAS and the database instance on the same server their are instance configurations that you need to make regarding SSAS...

This topic is one of the reasons in a presentation that I often do on the SSIS Catalog, I always begin with how to install the SSISDB and to reset...

The only thing that scares me is that according to Microsoft, for the stored procedure:

Maps an existing database user to a SQL Server login. This feature will be removed in...

I am with Ken on this one. I admire your solution but there are less complex ways of solving the problem. Good work though.

This is exactly why when I initially create environments I create them in TSQL using the SPROCs from SSISDB. In fact I have scripted entire deployments from folders, environments,...

First tried:

select * from $system.DISCOVER_COMMAND_OBJECTS and received

Executing the query ...

Obtained object of type: Microsoft.AnalysisServices.AdomdClient.AdomdDataReader

Execution complete

So then tried XMLA with restriction on SPID:

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">

<RequestType>DISCOVER_COMMAND_OBJECTS</RequestType>

<Restrictions>

<RestrictionList>

<SESSION_SPID>894</SESSION_SPID>

</RestrictionList>

</Restrictions>

<Properties></Properties>

</Discover>

Results:

<return xmlns="urn:schemas-microsoft-com:xml-analysis">

<root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"...

Personally I think executing Powershell scripts within SSIS sets a really bad precedent. There is probably a better solution. Just my opinion, but I would never allow...

If you are dealing with PHI and HIPPA data and the company has put in 'adequate' safeguards, everyone being HIPPA certified for example, then the responsibility does fall on the...

If you turned on package logging then you might want to try looking in dbo.sysssislog in MSDB on the server you are running the packages on.