Monthly Archives: July 2017

Returning errors codes in .Net apps

https://msdn.microsoft.com/en-us/library/system.environment.exitcode(v=vs.110).aspx https://msdn.microsoft.com/library/ms681381(v=vs.85)

Posted in Uncategorized | Leave a comment

ClickOnce, Crystal Reports, and dependent projects

Problem causing failure to install ClickOnce project after adding a reference to another project: ERROR DETAILSERROR DETAILS Following errors were detected during this operation. * [7/17/2017 12:01:25 PM] System.Deployment.Application.InvalidDeploymentException (RefDefValidation) – Reference in the manifest does not match the identity … Continue reading

Posted in C#, Linkdump, Programming, System/DB Administration | Leave a comment

Linkdump: Dynatrace- app monitoring with AI

https://info.dynatrace.com/apm_wc_ai_webinar_na_registration.html  

Posted in Business Intelligence, Linkdump | Leave a comment

Google handoff to Site Reliability Engineering (SRE)

Part 1: https://cloudplatform.googleblog.com/2017/06/why-should-your-app-get-SRE-support-CRE-life-lessons.html Part 2: https://cloudplatform.googleblog.com/2017/06/how-SREs-find-the-landmines-in-a-service-CRE-life-lessons.html Part 3: https://cloudplatform.googleblog.com/2017/07/making-the-most-of-an-SRE-service-takeover-CRE-life-lessons.html  

Posted in Uncategorized | Leave a comment

Linkdump: Business Intelligence

https://www.simple-talk.com/blogs/statistics-sql-simple-linear-regressions/ Dashboard Design Rules Power BI Dashboard Design Video Course A collection of graph/visual types compared in PDF: http://www.sqlbi.com/wp-content/uploads/videotrainings/dashboarddesign/visuals-reference-may2017-A3.pdf https://www.red-gate.com/simple-talk/sql/bi/deploying-securing-updating-power-bi-reports/    

Posted in Uncategorized | Leave a comment

Linkdump: SQL Server T-SQL tips and tricks

SQL Server Row Count for all Tables in a Database https://www.mssqltips.com/sqlservertip/2537/sql-server-row-count-for-all-tables-in-a-database/ One of several techniques posted by Dattatrey Sindo: SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + ‘.’ + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount] FROM sys.objects AS sOBJ INNER JOIN sys.partitions AS sPTN … Continue reading

Posted in Linkdump, SQL Server | Leave a comment

Linkdump: Docker, Puppet, SQL Server hosting

http://www.sqlservercentral.com/blogs/the-database-avenger/2017/06/13/orchestrating-sql-server-with-kubernetes/?utm_source=SSC&utm_medium=pubemail http://www.sqlservercentral.com/blogs/the-dba-who-came-in-from-the-cold/2017/06/14/changing-default-location-for-docker-containers/?utm_source=SSC&utm_medium=pubemail https://www.red-gate.com/simple-talk/sysadmin/containerization/overcoming-challenges-microservices-docker-containerisation/?utm_source=DBW&utm_medium=pubemail    

Posted in Linkdump, SQL Server, System/DB Administration | Leave a comment

Onboarding tasks: SQL Server

https://www.mssqltips.com/sqlservertip/4871/sql-server-dba-onboarding-checklist/  

Posted in Business, Linkdump, SQL Server | Leave a comment

Backup in SQL Server – advanced concepts/techniques

Introducing sp_AllNightLog: Log Shipping at Scale, Open Source   https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server http://www.sqlservercentral.com/articles/SQL+Server/158068/?utm_source=SSC&utm_medium=pubemail  

Posted in Uncategorized | Leave a comment

How to Read the Transaction Log File

Whoa, nice. How to Read the Transaction Log File Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file?  Well there is a way to read the transaction log file … Continue reading

Posted in Linkdump, SQL Server | Leave a comment