chrisschmidt

7 Topics

Monitoring Azure Analysis Services with Log Analytics and Power BI
First published on MSDN on Apr 02, 2018 How do you monitor Azure Analysis Services? How many users are connected and who are they? These are great questions to understand around your AAS environment.
Chris-Schmidt-MSFT
Apr 28, 2020 Place Core Infrastructure and Security Blog
14KViews
0likes
0Comments
SSISDB Reporting with Power BI
First published on MSDN on Apr 18, 2017 Back in 2012 when the project deployment model came out for SSIS, many questions were asked regarding its advantages vs the old legacy deployment model.
Chris-Schmidt-MSFT
Apr 28, 2020 Place Core Infrastructure and Security Blog
4.8KViews
0likes
0Comments
SSIS: Capturing PerfMon Counters During Package Execution
First published on MSDN on Mar 15, 2017 While troubleshooting SSIS package performance, having the ability to view the performance monitor counters can be handy for determining where bottlenecks may be occurring.
Chris-Schmidt-MSFT
Apr 28, 2020 Place Core Infrastructure and Security Blog
7.4KViews
1like
0Comments
SSIS: Setting the same variable in multiple projects in the catalog
First published on MSDN on Feb 14, 2017 Recently I was assisting a customer with a review of their SSIS implementation and one the security implementations that they had in place was service accounts for SQL Server Integration Services packages.
Chris-Schmidt-MSFT
Apr 28, 2020 Place Core Infrastructure and Security Blog
2.7KViews
0likes
0Comments
The EXECUTE permission was denied on xp_msver
First published on MSDN on Jan 24, 2017 Recently after installing SQL Server and configuring SSIS for project deployment in a SQL Server 2012 environment, a customer was experiencing issues when attempting to execute a package deployed to the Integration Services catalog or through SQL Agent calling the package.
Chris-Schmidt-MSFT
Apr 28, 2020 Place Core Infrastructure and Security Blog
19KViews
0likes
0Comments
Find users under a specific database role for all the servers in my environment
First published on MSDN on Aug 11, 2016 Recently I was working with a customer who wanted to know all the users in their environment who had ssis_admin permissions within their Integration Services environment.
Chris-Schmidt-MSFT
Apr 28, 2020 Place Core Infrastructure and Security Blog
1.5KViews
0likes
0Comments
Load Testing SSAS with PowerShell
First published on MSDN on Jul 26, 2016 Over the years, there has been much confusion as to the best way to load test Analysis Services.
Chris-Schmidt-MSFT
Apr 28, 2020 Place Core Infrastructure and Security Blog
3.9KViews
0likes
0Comments