Author Archives: pfb_admin

C# Make a SplitContainer dragbar visible to users

/// /// Given a SplitContainer, /// set the color of its background to make the splitter dragbar visible to users. /// Set the color of the splitter’s panels to the original color of the splitter, /// to keep their backcolors … Continue reading

Posted in C#, Programming | Leave a comment

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    

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