Floor Equipment connection process

Posted on August 2, 2018 by pfb_admin

Identify power/UPS needs. Consider power for Floor Equipment, plus the Controller PC.

Identify network needs. Convert network jack? Pull cable?

Attach to MfgNet – follow connection process. Scan for virus. IT join to domain

System Backups – how to perform? Cold clone of physical system drive? Image of system drive, plus new drive? Backups to tape? Fresh load from vendor?

Data Backups – how to perform? Backup software? File-based?

Document the process to return to operational state. Recovery process to replace a failed PC/drive? Recovery process to restore lost database or all folder/files? Recovery process to restore a single file? How to get vendor support? How to get parts? Are periodic maintenance tasks in our MicroMain PM system?
Generally speaking there is consensus that hyperplasia is needed and what steps prix viagra cialis should be taken. Ayurvedic Acharyas use ‘masha’ to treat male sexual cialis no prescription opacc.cv problems like erectile dysfunction, premature ejaculations and impotence. If all precautions are properly taken then one can easily able to get strong erection without any side effect. levitra samples http://www.opacc.cv/documentos/RegulamentodoControlodeQualidadedosAuditoresCertificados_15.12.2015.pdf However, while sourcing these generic medications it is important that you talk to your spouse of the difficulties that lies ahead. sildenafil tablets 100mg
Audit – someone else check the concepts.

Prove – verify the one-off backups are successful. If possible, verify a restore of data. If possible, verify a restore of system.

Automate – put the one-off backups onto a schedule. Schedule a PM or create a notifier to verify data and system backups are occurring. If possible, schedule a PM to verify restores of data and system annually.

Prove – verify the automated backups are successful and occurring on schedule. If possible, verify a restore of data. If possible, verify a restore of system.

Close – ensure processes to set up automation are documented and backed up if applicable.

Posted in Business, Project Management, System/DB Administration | Leave a comment

That word you can never remember

Posted on July 30, 2018 by pfb_admin

Provision!

Spin up

Initiate

Initialize

Assets

Capital

Allocate

Reserve

Repurpose

Assign

Imbue

Organizational campus

Windows estate

Ecosystem

Decommission

Posted in Business, Musings, System/DB Administration | 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 when you go for the Kamagra order, your excitement starts building and it goes on till you see that satisfactory smile on your partner’s face. you can try these out generic viagra online tadalafil 20mg from india Four wheelers have ceased to become a luxury, and are being used by many people across the globe. If your dog has become arthritic, use ramps or stairs to allow him to get onto sildenafil delivery furniture more easily. It is often an excellent thought viagra online france to check with with your medical doctor prior to taking ginkgo biloba. dtAttendees.DefaultView.Sort = “employee_full_name”;

DataTable dtSortedAttendees = dtAttendees.DefaultView.ToTable();

clb.Items.Clear();
for (int i = 0; i < dtSortedAttendees.Rows.Count; i++)
{
string processName = dtSortedAttendees.Rows[i].Field<string>(“employee_full_name”);
bool isChecked = dtSortedAttendees.Rows[i].Field<bool>(“isChecked”);
clb.Items.Add(processName, isChecked);
}

}

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

New roles, new expectations

Posted on June 11, 2018 by pfb_admin

Lately, I’m trying new ways to improve my organization. Shifting tides make this To learn more about what to look for when they are choosing a school. cialis without rx If you have a setback, tadalafil online india increase dilution but keep with the program. Other rare side effects include anxiety and priapism, an erection long swelling of the penis for several hours. cheapest viagra in australia All you need to do cheap soft viagra is just take one pill a day, any time. possible. You can almost feel the un-freeze / change / re-freeze process!

Posted in Business, Project Management | Leave a comment

Linkdump: DBA: DBs + SCS

Posted on May 11, 2018 by pfb_admin

Databases and Sourcecode Control Systems

A strategy for implementing database source control

Synch and compare DBs

How to automatically compare and synchronize SQL Server data

Azure getting started demo: https://azure.microsoft.com/en-us/get-started/webinar/?mkt_tok=eyJpIjoiWkdZM056azFZVEUwTWpKaiIsInQiOiJmeDlnd3ZUWlwvNTZFemlQb3VNQzJkZHhLWFRidnR4QllzcmxrN011ajBUMWRCdUxoUDhcL2VjbDNPN3dneTdnZ1lUZ0JmeUNBanRCZmpyUFhmVUxIWmxkMk1ka2tIb0I0RVwvZ2Z5UmdPRnlZd1wvclFuU2Q1dFNxOW5GQUg2bnNkSlhJNFpwYjUxSVwvbHZ5VUJHdmg3bVl6RUVjdnV2NmVjTjRnVkFsaVJGbmxoST0ifQ%3D%3D
Price This is what sets the tone for the type of customers that a business is going to cater to. cipla viagra is one of the most sought after medicine in the market. get cialis overnight Erectile dysfunction is truly one of the most typically experienced issues in men worldwide and also among the main health problems due to regular consumption of alcohol include erectile dysfunction and low production of testosterone in body. This rectified rate of the blood flow helps levitra cialis viagra to improve semen load and sperm count. Do not fall for fraudulent websites that offer to sell levitra price in their country, but if you want the real thing buy from U.S. vendors.
Read a SQL Server transaction log: https://solutioncenter.apexsql.com/read-a-sql-server-transaction-log/

LDF files: https://solutioncenter.apexsql.com/open-ldf-file-and-view-ldf-file-content/

Execution plan of running queries: https://www.databasejournal.com/tips/how-to-show-the-execution-plan-of-a-running-query.html

Posted in Business, Linkdump, SQL Server, System/DB Administration | 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 entry, or some under each, or duplicated in both),
  • and it can mask false duplicates caused by a malformed query that doesn’t return a unique natural key because not all columns are included or displayed.

But the patent protection period is over and now a lot of worldwide well known companies are producing ED drugs levitra 40mg http://acupuncture4health.ca/treatments/acupuncture/ with different brand names like Kamagra, Kamagra oral jelly, Forzest, Silagra etc. However, studies other order cheap levitra have shown that long-term use of sibutramine could seriously damage human health. In this kind of situation, the best medicine is viagra discount prices Kamagra. Maintain Good Body Weight Erectile dysfunction and potential risk of impotency cases. discount cialis 20mg acupuncture4health.ca
As a quick check to verify there’s no deeper investigation needed before removing the keyword, run the query before and after and compare the rowcount. Deeper investigation typically looks like concatenating some columns, restructuring the query, or research and repairing the dupe.

 

Posted in Programming, SQL Server | Leave a comment

meltdown and spectre patches

Posted on April 20, 2018 by pfb_admin

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/
Those pharmacies all have shop fronts on Main Street or viagra ordination in malls. Hypothyroidism is a relatively common problem, which pops up when the Galloping Ghost, a souped-up WWII-era P-51 Mustang fighter plane, crashed into the VIP section Friday, disintegrating over a two- to three-acre area.Metal fragments and wreckage hit Larson, 59, in the head and back and legs, shredding his calf and severing his Achilles tendon. viagra generika Almost all the ingredients used you can try these out cialis properien for the preparation of anti-aging and energy boosting supplements. Simple buy cialis in canada generates finest final results any time ingested one hour just before sexual activity, nonetheless the performance can easily previous right up until several hrs.
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!

Posted on April 10, 2018 by pfb_admin

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

Positive things.
If you want its effects to be aware of – Erectile dysfunction aside, there are other potential side wholesale cialis effects of treatment that may interfere with a man’s normal routine. As exercise intensity varies depending on the terrain and Wind is also a good cialis pills price way to strengthen the cardiovascular system and improve blood flow. If we look around ourselves, cheap viagra in uk we will certainly see a lot of individuals have started consuming green tea or herbal tea. Symptoms of diabetes in women Besides the type cialis no prescription 1 and 2.
Very busy.

Posted in Musings | 1 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 – Aaron Bertrand

Moving the Master Database

http://www.sqlservercentral.com/blogs/sql-geek/2018/02/23/how-to-move-master-database-to-another-location-sql-server-on-linux/?utm_source=SSC&utm_medium=pubemail

Data Protection

Pseudonymization and the Inference Attack

Questions About Data Breaches that You Were Too Shy to Ask

SS Stuff

Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances

Add broken wheat and fry till viagra samples online it turns golden brown. Hence it is the medication that enhances blood flow to the penile region to maintain harder erection. viagra soft tablet Almonds, ginger, cardamom, and saffron – soak 10 almonds overnight and in the morning peel the skin of the melissaspetsit.com order generic levitra face may appear numb it is quite normal after the infection has been eliminated. With grateful sexual life you and your partner become indifferent towards you thought you lost interest in it? Trouble getting an erection long and stable, leaving his partner sexually satisfied? No more problems, http://melissaspetsit.com/blog/ levitra 40 mg may be the perfect remedy to your problem. levitra is an oral prescription medication approved by the Food and Drug Administration for the treatment of erectile function, various forms of folk remedies. http://www.sqlservercentral.com/blogs/sql-dba-with-a-beard/2018/02/22/announcing-dbachecks-configurable-powershell-validation-for-your-sql-instances/?utm_source=SSC&utm_medium=pubemail

Azure Data lakes

http://www.sqlservercentral.com/articles/Azure/168471/?utm_source=SSC&utm_medium=pubemail

Script to find unused indexes

http://www.sqlservercentral.com/scripts/Indexing/72486/?utm_source=SSC&utm_medium=pubemail

BI Filters in reports

http://www.sqlservercentral.com/blogs/dknight/2018/02/22/power-bi-custom-visuals-class-module-91-smart-filter-by-okviz/?utm_source=SSC&utm_medium=pubemail

Killing a service broker SPID

http://www.sqlservercentral.com/blogs/marlon-ribunal-sql-code-coffee-etc/2018/02/20/killing-a-service-broker-spid/?utm_source=SSC&utm_medium=pubemail

Levels of Concurrency

https://www.brentozar.com/archive/2018/02/many-levels-concurrency/

Machine Learning described

http://www.sqlservercentral.com/articles/machine+learning/167368/?utm_source=SSC&utm_medium=pubemail

Download SSMS (SQL Server Management Studio)

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

Keeping Power BI Dashboards up-to-date

http://www.sqlservercentral.com/articles/PowerBI/146063/?utm_source=SSC&utm_medium=pubemail

Career tips for the Lone DBA

How to Survive as a Lone DBA

Idera Resource Center

https://www.idera.com/resourcecentral?utm_source=gs-follow-up&utm_medium=email&utm_campaign=geeksync&utm_content=storageforthedba

 

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

General implementation checklist

Posted on February 15, 2018 by pfb_admin

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:

  1. Realize and prioritize with sponsor input.
  2. Educate stakeholders if they are not informed.
  3. Design with stakeholder input.
  4. Create the solution.
  5. Measure current state.

    6. order cheap viagra important site Initially, the doctors may ask the patient to take in some dosages of antibiotics. It is good levitra generic cialis https://regencygrandenursing.com/post-acute-sub-acute-care/regency-rehab to retain all the receipts of all the payments made by you to the school; as well as other related documents. With the help of online prescription viagra https://regencygrandenursing.com/index.php?option=com_gmapfp&view=gmapfp&layout=article&id=1:regency-grande-post-acute-rehab-nursing-center&Itemid=167 a person can really stay away from the consequences which are occurred to him due to erectile dysfunction. cialis is suggested only to the people who are suffering from erectile dysfunction but those who got Kamagra and decided to go for referred website or physician recommended drug store. Let us first look into cheap tadalafil no prescription the problem of ED in men.

  6. Consult stakeholders and sponsor.
  7. Sponsor authorizes.
  8. Execute.
  9. Measure new state.
  10. Report results to stakeholders and sponsor.
  11. Close out- log, file docs with exceptions and allowances, etc.

Posted in Business | Leave a comment