Author Archives: sql010
cmd command: C:\Users\user_name>wmic bios get serialnumber
Error: User ‘DOMAIN/Login_name’ does not have required Permissions. Verify that sufficient permissions have been granted and windows account control (UAC) restrictions have been addressed.
Problem Description: User is suddenly unable to access the SSRS Report Link or URL. User gets below error as shown in screen shot. Error: User ‘DOMAIN/Login_name’ does not have required Permissions. Verify that sufficient permissions have been granted and windows … Continue reading
methods to grant access on SSIS ——————————- https://www.mssqltips.com/sqlservertip/3086/how-to-resolve-ssis-access-denied-error-in-sql-server-management-studio/ https://sysbadmin.wordpress.com/2012/09/04/how-to-grant-access-permission-for-ssis/ http://mssqltrek.com/2011/12/07/connecting-to-the-integration-services-service-on-the-computer-mirrorstand-failed-with-the-following-error-access-is-denied/ https://msdn.microsoft.com/en-us/library/hh213130.aspx below roles need to be granted to user depending on type of access -db_ssisadmin – db_ssisltduser -db_ssisoperator
–Memory metrics to check Pages/sec, Page Faults/sec, Pages Input/sec, Pages Output/sec, Page Reads/sec, Page Writes/sec, Available Memory, Non-pageable memory pool bytes, Pageable memory pool bytes, and Committed Bytes pages/sec (in perfmon) ——————————- ref : http://www.sqlshack.com/sql-server-memory-performance-metrics-part-1-memory- pagessec-memory-page-faultssec/ – it is rate at … Continue reading
starting with very basic programming. topics covered Starting t-sql program SQL JOINS selecting both the table will fetch below records. INNER JOIN syntax & example i.e rows/data common in both tables will be displayed as shown in below screen-shot LEFT … Continue reading
T-SQL to check what access user has on db & its objects ————————————————————————- http://www.pythian.com/blog/httpconsultingblogs-emc-comjamiethomsonarchive20070209sql-server-2005_3a00_-view-all-permissions-_2800_2_2900_-aspx/