Category Archives: Programming

Linkdump: BIML, BI, Elastisearch-Kibana, SS Interviews, Data protection

BIML Business Markup Language https://www.mssqltips.com/sqlservertutorial/9089/introduction-to-the-biml-language/ BI – Logi Analytics. Responsive design, Dashboard design https://www.logianalytics.com/art-responsive-design-dzone-archive/ http://go.logianalytics.com/webinar-art-of-dashboard-design.html?mkt_tok=eyJpIjoiTkRJMk56aGpNamd6TkRreiIsInQiOiJSM05kQXBCaTM2SzF5UVBDazhMVGhBdmlFSE1CYU5TdjRKWStPMVwvcktSdWk0RTV1djRLUm1kYU9Bc2xJT0NRVDJOZG9PWkVhOXoyb1VBcG1jQTNtMXZLMWk0VDc4a09IRzdOSlVuNzVDVGVBWE5xUDFzajFwUnpPMEJVczBqV1oifQ%3D%3D Helping your BI Consultant be successful:  http://www.sqlservercentral.com/blogs/data-savvy/2018/01/30/ten-ways-to-help-your-bi-consultant-be-successful/?utm_source=SSC&utm_medium=pubemail Vagrant Command line interface: https://www.vagrantup.com/docs/cli/ Elastisearch and Kibana Client guide: https://www.elastic.co/guide/en/elasticsearch/client/index.html Downloads: https://www.elastic.co/content-pack Getting started: https://www.elastic.co/webinars/getting-started-elasticsearch?baymax=rtp&elektra=docs&storm=top-video&iesrc=ctr Forums: https://discuss.elastic.co/?ultron=es-get-started&blade=touch&hulk=email&mkt_tok=eyJpIjoiTlRCak16WTVNalZrWVdFeSIsInQiOiIxR3BlcW5HZ3IxRDdrbytSRnZpZ3JOcTZaMlNoUkZoTGdFU3VWTU5FMTNDaW5LdzNLTG9VMHhpZm5jek9mVEhCdmNENEo3S3ZqSjJHS3U5RTJKM1JHRk1OaGh3bUdUdk82Tks3Z1YyaFwvVXdGOFwvXC9sR3dFQlBGbUI1aTRwUm5PUSJ9 SS Interview https://mohammaddarab.com/interview-aaron-bertrand/?utm_source=SSC&utm_medium=pubemail Moving … Continue reading

Posted in Business Intelligence, Linkdump, Project Management, SQL Server | Leave a comment

Gartner magic quarter analyses for BI, Q1 2018

Exploring 2017 Gartner BI Magic Quadrant Results   https://www.gartner.com/doc/reprints?id=1-3TYE0CD&ct=170221&st=sb https://www.logianalytics.com/gartner-critical-capabilities/ http://ir.microstrategy.com/releasedetail.cfm?releaseid=953331 https://www.google.com/search?q=microstrategy+logo+gartner+quarter&tbm=isch&source=iu&ictx=1&fir=M4XBdC92LXnx_M%253A%252CAPEOCTs8fj5K-M%252C_&usg=__E5FkJKViA2CKDYucpUjLur1EGas%3D&sa=X&ved=0ahUKEwig3bihv9rYAhVl_4MKHU8LAAYQ9QEITzAC#imgrc=M4XBdC92LXnx_M: https://blogs.gartner.com/cindi-howson/2017/02/23/bia2017mq/ http://www.jenunderwood.com/tag/solution-review/  

Posted in Business Intelligence, Linkdump | Leave a comment

Linkdump: Various learnings: SD, JS. SS/BI/BD

10 books every web developer should read to increase their software IQ Backtracking algorithmic approach: http://blog.dailycodingproblem.com/an-introduction-to-backtracking/?utm_campaign=News%20on%20Monday&utm_source=hs_email&utm_medium=email&utm_content=60133300&_hsenc=p2ANqtz-8wUu0X1MNw7Ka4qWf8k5TgFDmfpiT6ecVsss07oZuypsu4t3kozhxperXdqM_8hp9YYaZbrEcMBuo2C-2sH3Y7QNx1iGWGWHqcJCplbP3RRpSbZ5c&_hsmi=60133300 Javascript framework Comparison: https://javascriptreport.com/js-frameworks-fastest/?utm_campaign=News%20on%20Monday&utm_source=hs_email&utm_medium=email&utm_content=60133300&_hsenc=p2ANqtz-8wUu0X1MNw7Ka4qWf8k5TgFDmfpiT6ecVsss07oZuypsu4t3kozhxperXdqM_8hp9YYaZbrEcMBuo2C-2sH3Y7QNx1iGWGWHqcJCplbP3RRpSbZ5c&_hsmi=60133300 Inferno Javascript framework: https://infernojs.org SQL Server / Business intelligence / Big Data /  Azure Elastic queries: http://www.sqlservercentral.com/articles/Azure/166259/?utm_source=SSC&utm_medium=pubemail SQL Server internals: … Continue reading

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

save to DB & update DT+DGV, vs Total UI requery from DB

Here’s code for this… save to database + update local datatable + update local datagridview = faster than refreshing UI from database if (lblSerialNumberId.Text != “”) { MesQueries.SRUSheetCreation sru = new MesQueries.SRUSheetCreation(_mq); string serial_number_id = lblSerialNumberId.Text; string change_orders = txtChangeOrders.Text; … Continue reading

Posted in C#, Programming | Leave a comment

SQL Server diagnostics notes

This week’s amusement: performance of a recently-implemented Stored Procedure dropped and dropped to intolerable levels. This system cannot be easily upgraded. Significant fragmentation is involved. Memory pressure is involved. Inserts to table variables in multiple stored procs are involved. This … Continue reading

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

Tips for adjusting TableLayoutPanel

UI adjustments feel clumsy until you struggle through several, but there are some techniques that can help. It’s obviously better to see these in use, but a list is at least something to start with. TableLayoutPanel displays a flyout menu … Continue reading

Posted in C#, Musings, Programming | Leave a comment

tip: passive error and warning messages

It’s best to put error/warning messages in very passive, non-blaming language, especially if users might see them. Avoid exclamation marks unless something is seriously wrong and they need to take immediate action, and in that case tell them which actions … Continue reading

Posted in Business, Musings, Programming, System/DB Administration | Leave a comment

List of line endings

programmingScriptText += “\r\n”; //Windows style CRLF line ending. //programmingScriptText += “\n\r”; // Nobody does this. //programmingScriptText += “\r”; // Max style (CR) line ending. //programmingScriptText += “\n”; //UNIX style (LF) line ending.

Posted in C#, Programming | Leave a comment

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

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