Author Archives: sql010

cmd command to get serial number of laptop

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

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

t-sql – links/URL to learn from basics

http://www.techumber.com/2013/05/t-sql-tutorial-for-beginners.htmlhttp: http://www.sqlcourse.com/select.html

Posted in t-sql learnings | Leave a comment

backup wordpress blog

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

Posted in Uncategorized | Leave a comment

WordPress Learnings –

write code in wordpress Continue reading

Posted in wordpress blogging | Tagged | Leave a comment

t-SQL Basic Programming for beginners

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

Posted in t-sql learnings | Tagged | 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