Category Archives: SQL Server

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

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

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

Clone programming steps

— list products that might need to be programmed. SELECT name,revision, product_id FROM qs_products where name like ‘277000-200-%’ — list current programming steps select p.name,p.revision,steps.* from [dbo].[ACA_swprg_programming_steps] steps INNER JOIN qs_products p ON p.product_id = steps.mes_product_id — after updating the … Continue reading

Posted in SQL Server | Leave a comment

Populate NULL component_ids from related tables

Needed to populate a new column in one table from a semi-related existing table, based on a value in another related table. I do this once in a blue moon and needed a refresher. Thanks, Pinal Dave, for your post … Continue reading

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

Onboarding tasks: SQL Server

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

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