Category Archives: Uncategorized

cmd command to get serial number of laptop

cmd  command: C:\Users\user_name>wmic bios get serialnumber

Posted in Uncategorized | Leave a comment

how to create a sample/test SSRS report

simple way to create SSRS report Continue reading

Posted in Uncategorized | Leave a comment

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

Posted in Uncategorized | Leave a comment

SSIS – access/privileges to grant.

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

Posted in Uncategorized | Leave a comment

performance issue – Memory Metrics to check for MSSQL

–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

Posted in Uncategorized | Leave a comment

backup wordpress blog

https://css-tricks.com/back-wordpress-database/

Posted in Uncategorized | Leave a comment

T-SQL to check what access user has on db & its objects

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/

Posted in Uncategorized | Leave a comment

drop the Default constraints in MSSQL code.

when there is a need to drop the default constraint on a column in MSSQL code, please check whether you have created a name for Default constraint. please not that i had not created a name for default constraint, instead … Continue reading

Posted in Uncategorized | Leave a comment

List MSSQL instances installed in server using COmmand Prompt

use below command in CMD prompt to get the list of MSSQL instances in server. Servers: test_User1 test_User1\MSSQLSERVER1 Note – ‘L’ is capital letter in above Command.

Posted in Uncategorized | Leave a comment

T-SQL to start/Stop SQL services.

— to start/stop service using SSMS –See below example to check non-SQL Service excellent article by author here!! http://www.mssqltips.com/sqlservertip/2036/monitor-start-and-stop-sql-server-services-using-xpservicecontrol/

Posted in MSSQL | Leave a comment