Category Archives: Linkdump

Cleaner than client-side bookmarks or favorite. Less client clutter, accessible from anywhere, no issues with TOO MANY, and better for things that I don’t access every day.

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

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

Windows 10 wireless displays

https://www.hanselman.com/blog/UseASecondLaptopAsAnExtendedMonitorWithWindows10WirelessDisplays.aspx Cool!

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

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 Lab Guide Working with Containers on Windows 10–Includes Docker and Nano Step-By-Step https://github.com/docker/labs/blob/master/windows/windows-containers/Setup-Server2016.md  

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