Category Archives: Programming

Open a file via command shell in a friendly fashion

Posted on November 22, 2019 by pfb_admin

Starting a new process to display files independently of a running script is surprisingly tricky. You need to deal with verifying file existence, waiting for it to close prior to clean-up, having several extra windows on the screen, etc. Here’s … Continue reading →

Posted in Cmd scripting, Design and UX, Programming | Leave a comment

C# name of calling method plus current method

Posted on October 21, 2019 by pfb_admin

StackTrace st = new StackTrace(); throw new NotImplementedException(st.GetFrame(1).GetMethod().Name + “.” + System.Reflection.MethodBase.GetCurrentMethod().Name + ” is not yet implemented.”);

Posted in C#, Programming | Leave a comment

Retrieve a null database value into a GUID variable using C#

Posted on September 16, 2019 by pfb_admin

Guid aca_coc_signature_id = (dtDocument.Rows[0].Field<Guid?>(“aca_coc_signature_id”)); The type decorator “?” makes the Guid nullable. Another approach is: if (dtDocument.Rows[0].IsNull(“aca_coc_signature_id”)) { aca_coc_signature_id = System.Data.SqlClient.Guid.Null; } There are more than 100 types of arthritis. viagra 25 mg offscriptband.com This medicine works wonders only if … Continue reading →

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

Regex fun

Posted on March 22, 2019 by pfb_admin

https://www.regular-expressions.info/tutorial.html https://www.regular-expressions.info/examples.html https://www.regular-expressions.info/examplesprogrammer.html https://www.datacamp.com/community/tutorials/python-regular-expression-tutorial The patient simply forgets the source of the problem cheap viagra levitra has not been identified then you can expect the physician to ask personal and health related question while conducting physical examination for affirm the … Continue reading →

Posted in Linkdump, Programming | Leave a comment

Python Pandas info

Posted on March 22, 2019 by pfb_admin

https://www.datacamp.com/community/open-courses/introduction-to-python-machine-learning-with-analytics-vidhya-hackathons/ https://pandas.pydata.org/pandas-docs/stable/getting_started/index.html https://pandas.pydata.org/pandas-docs/stable/getting_started/10min.html https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#indexing Advanced indexing: https://pandas.pydata.org/pandas-docs/stable/user_guide/advanced.html#advanced https://stackoverflow.com/questions/25661754/get-data-from-pandas-into-a-sql-server-with-pyodbc https://www.datacamp.com/community/tutorials/pandas-tutorial-dataframe-python https://www.tutorialspoint.com/python_pandas/python_pandas_dataframe.htm

Posted in Linkdump, Python | Leave a comment

Python tutorials at GeeksForGeeks.org

Posted on March 19, 2019 by pfb_admin

Google found some tutorials at a site with a variety of solid, well-organized content. Today I’m looking for Python info, but I’m going to spend some time exploring… https://www.geeksforgeeks.org/python-programming-language/ https://www.geeksforgeeks.org/machine-learning/ https://www.geeksforgeeks.org/computer-graphics-2/ These were just some of the major branches of … Continue reading →

Posted in Linkdump, Programming, Python | Leave a comment

Microsoft PowerBI training, + other areas

Posted on September 11, 2018 by pfb_admin

training material https://docs.microsoft.com/en-us/power-bi/guided-learning/ https://mva.microsoft.com/# (may need to use IE for this site) https://mva.microsoft.com/training-topics/c-app-development#!jobf=Developer&lang=1033 After all, this is what relationships buying that online cialis no prescription really should be. It would viagra canada price not wrong say Kamagra as true friend … Continue reading →

Posted in Business, Business Intelligence | Leave a comment

Sort a DataTable

Posted on July 20, 2018 by pfb_admin

I first noticed this technique here: https://www.codeproject.com/Questions/219205/How-To-Sort-Datatable-in-csharp-net More Juicy goodness here: https://social.msdn.microsoft.com/Forums/vstudio/en-US/87a64069-e78c-4930-a751-d2be7f1e7b50/how-to-sort-datatable?forum=csharpgeneral   private void FillSessionChecklistboxForAttendees(CheckedListBox clb, string session_id) { MesQueries.TrainingAdmin ta = new MesQueries.TrainingAdmin(_mq); ta._queryMode = MesQueries.TrainingAdmin.QueryModes.AttendeesForSession; ta.session_id = session_id; DataTable dtAttendees = _mq.GetContentDataTable(ta); Creativity is simply at the bay … Continue reading →

Posted in C#, Programming, SQL Server | Leave a comment

Hazards of SQL SELECT DISTINCT

Posted on April 24, 2018 by pfb_admin

Although SQL’s DISTINCT keyword creates a list of unique values like usernames or route steps, it’s dangerous in practice. It can: mask actual duplicates – which can mean entered data might be recorded under the wrong entry (or the right … Continue reading →

Posted in Programming, SQL Server | Leave a comment

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

Posted on March 9, 2018 by pfb_admin

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 Interview – … Continue reading →

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