Skip to main content

Search This Blog

MSBI Tutor

How to install SQL Server Adviser 2016

Get link
Facebook
X
Pinterest
Email
Other Apps

- February 17, 2017

Step 1:

Step 2:

Step 3:

Step 4:

Step 5:

SQL

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular posts from this blog

Exception deserializing the package "The process cannot access the file because it is being used by another process."

- December 13, 2019

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

SSRS INTERVIEW QUESTIONS

- September 08, 2014

Q: What is SSRS? Ø SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø It is used for preparing and delivering interactive and variety of reports. Ø It is administered through an web based interface. Ø Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...

Failed to execute the package or element. Build errors were encountered

- November 28, 2018

Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element. Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------ Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package

Powered by Blogger

Theme images by Michael Elkan

Balu Challa

Blog Archive

2026 50
- July 5
- June 9
- May 6
- April 12
- March 9
- February 4
- January 5

2025 23
- October 1
- September 2
- August 1
- June 1
- April 4
- March 4
- February 7
- January 3
2024 32
- December 2
- November 1
- October 2
- August 2
- June 1
- May 1
- April 6
- March 4
- February 4
- January 9
2023 31
- December 2
- November 1
- September 3
- August 3
- July 3
- May 1
- March 4
- February 1
- January 13
2022 94
- December 6
- November 13
- October 3
- September 4
- August 10
- July 12
- June 2
- May 4
- April 12
- March 9
- February 7
- January 12
2021 183
- December 12
- November 7
- October 11
- September 24
- August 10
- July 17
- June 15
- May 27
- April 25
- March 33
- February 2
2020 15
2019 31
- December 5
- August 15
- July 4
- March 1
- February 1
- January 5
2018 49
- December 3
- November 2
- October 7
- July 14
- June 21
- February 2
2017 18
2016 39
- August 19
- July 7
- June 5
- April 4
- January 4
2015 2
- March 2
2014 57
2013 2
- December 2

Show more Show less

Labels

2016
2017
2019
2021
2022
2023
2024
2025
2026
Access

Show more Show less

Popular posts from this blog

Query execution failed for dataset DataSet_Name. (rsErrorExecutingCommand)

- August 08, 2016

An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘DataSet3’. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors 1.) Go to the ReportServer Database 2.) Drilldown to Tables and select the dbo.ConfigurationInfo 3.) Open the table and change the EnableRemoteErrors to TRUE in the Value column and run Execute SQL. OR In Management Studio, you must be logon on instance of report server and enable the property EnableRemoteErrors to see more details that error. Connect Management Studio à in screen: Connect to Server, server type: Reporting Services à locate the server instance in Server Name; after...

Exception deserializing the package "The process cannot access the file because it is being used by another process."

- December 13, 2019

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

Track SQL user Login Password Changes in SQL Server

- April 01, 2022

Step 1: Go to Audits under security tab Step 2: Right click on audit and create audit Using SQL script CREATE SERVER AUDIT SQL_PWD_Audit TO FILE ( FILEPATH = 'D:\LogFolder\' ) WITH ( QUEUE_DELAY = 1000 , ON_FAILURE = CONTINUE ); GO Step 3: Create server audit specification Using SQL script CREATE SERVER AUDIT SPECIFICATION Srv_Audit_PWD FOR SERVER AUDIT SQL_PWD_Audit ADD ( LOGIN_CHANGE_PASSWORD_GROUP ); GO Step 4: Enable Audit and server audit specification Step 5: Try to change password any one user Step 6: By using bellow query we can check audit logs SELECT * FROM sys . fn_get_audit_file ( 'D:\LogFolder\*' , default , default ) WHERE action_id = 'PWR' GO Another way to check audit logs

Org apps with audiences for Power BI and Fabric (Generally Available)

- June 21, 2026

Announcing general availability of org apps in Power BI and Fabric, including one of the most requested capabilities: audiences. Figure: Org apps with audiences for Power BI and Fabric. Org apps with audiences set you up to get the right reporting to the right people, in just the right experience. Curate and distribute reporting at scale across your organization—from leadership and management to frontline teams—while securely and efficiently building app experiences that help everyone find the data they need, understand what matters to them, and make better decisions from branded and customized experiences built for how they work. Why audiences matter to you Figure: One workspace app with audiences vs multiple org apps per workspace. When we introduced audiences to workspace apps, many of you told us: audiences are great, but I need multiple apps per workspace. Then when we introduced org apps as items, you told us: multiple apps per workspace are great, but I need audienc...

Temporary enable and disable SSRS subscriptions

- August 11, 2019

--Code Snippet --To Check Subscription Status. USE ReportServer GO SELECT dbo . Subscriptions . Description , dbo . [Catalog] . Name , dbo . Users . UserName , InactiveFlags FROM dbo . Subscriptions INNER JOIN dbo . [Catalog] ON dbo . Subscriptions . Report_OID = dbo . [Catalog] . ItemID INNER JOIN dbo . Users ON dbo . Subscriptions . OwnerID = dbo . Users . UserID --Temporary disables subscriptions while data warehouse is unavailable UPDATE dbo . Subscriptions SET InactiveFlags = 1 GO --After this you can find, all the subscription where disabled until you again enable it. --Again enable subscriptions. UPDATE dbo . Subscriptions SET InactiveFlags = 0 GO

Translate