Author Archives: pfb_admin

meltdown and spectre patches

https://www.howtogeek.com/339559/how-to-stop-the-meltdown-and-spectre-patches-from-slowing-down-your-pc/ https://www.howtogeek.com/346465/windows-spectre-patches-are-here-but-you-might-want-to-wait/ https://www.bleepingcomputer.com/news/microsoft/how-to-check-and-update-windows-systems-for-the-meltdown-and-spectre-cpu-flaws/

Posted in Uncategorized | Leave a comment

Busy springtime!

Many, many things are keeping me very busy this time of year. Positive things. Very busy.

Posted in Musings | 1 Comment

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

General implementation checklist

A group that shall remain unnamed at my organization has really borked some recent implementations.  My thoughts on a general implementation checklist they could have considered to radically improve execution: Realize and prioritize with sponsor input. Educate stakeholders if they … Continue reading

Posted in Business | 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

T-SQL: Trim after newline / carriage return

USE [db_mes_sandbox] GO EXEC [dbo].[usp_CompleteHierarchy3] @pSerial_number = N’110160766′, @pFlag_IncludeCcaComponents = 0, @pFlag_IncludeReplacedParts = 0, @pDebug = 1 GO SELECT product_id ,name ,revision ,description = /* This CASE statement returns the first line of description when it contains the word ‘alternate’. … Continue reading

Posted in 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

Meltdown and Spectre patches, via SQLServerCentral

http://www.sqlservercentral.com/articles/SQL+Server/166822/?utm_source=SSC&utm_medium=pubemail  

Posted in Linkdump, SQL Server, System/DB Administration | 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