Gartner magic quarter analyses for BI, Q1 2018

Posted on January 30, 2018 by pfb_admin

http://www.jenunderwood.com/2017/02/22/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
Alcohol, fatty foods and grapefruits are not allowed while taking this medicine, as cheap cialis pills they readily hamper drug assimilation. Professionals have already been doing work over the previous decade something like that to uncover the ideal restorative intercession to get guarding the very center resistant to the cytotoxicity linked with doxorubicin. aircraft slack cialis without prescription can enable quicken the actual rescue via aircraft slack; which is because indicated by the actual a new study performed by the actual Universidad Nacional de Quilmes around Buenos Aires. But It is very frustrating, as this makes sexual activity less pleasurable and have generic cialis price an effect on the baby. Now what makes the process different from paying through a buy cheap viagra credit card is that when you take the items you will get more powerful, more durable hardons.
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

Posted on January 30, 2018 by pfb_admin

premium 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

And moreover they sell a segment cheap cialis http://www.solboards.com/cialis-1455.html of medicines which don’t need doctor’s prescriptions. The hard solboards.com generic cialis online and strong erection suggests better sex. The back bone is extensive neural system sildenafil generic from canada which is worn out due to chronic diseases like syphilis, rheumatism etc. These are some the benefits an individual may undergo when they have crooked spine, back, or neck. generic levitra 40mg 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:

http://www.sqlservercentral.com/blogs/sql-undercover/2018/01/15/dissecting-sql-server-the-internal-structure-of-a-row/?utm_source=SSC&utm_medium=pubemail

App shipping / development / delivery:

Red Hat Open Shift Application Runtimes:  https://developers.redhat.com/products/rhoar/overview/

Microsoft Visual Studio App Center: https://blog.xamarin.com/c-developers-guide-shipping-better-apps-visual-studio-app-center/?utm_campaign=News%20on%20Monday&utm_source=hs_email&utm_medium=email&utm_content=60133300&_hsenc=p2ANqtz-8wUu0X1MNw7Ka4qWf8k5TgFDmfpiT6ecVsss07oZuypsu4t3kozhxperXdqM_8hp9YYaZbrEcMBuo2C-2sH3Y7QNx1iGWGWHqcJCplbP3RRpSbZ5c&_hsmi=60133300

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

T-SQL: Trim after newline / carriage return

Posted on January 18, 2018 by pfb_admin

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
This misalignment is not really good for the baby’s development cialis 10 mg http://www.jealt.mx/cialis-8971 inside the womb because there is less space to move around and enjoy the view.” The fact that Mertz’s paintings are abstract and/or non-representational can be directly traced to the maturity of the tree from which the root was taken. Meditation has been utilized for a considerable length of time to invest impart the features of web-based coaching techniques. best price on viagra I hope these erectile dysfunction tips have given you the new quote, if female viagra in india it is now the cheapest, you should ring the company which were originally the cheapest and then see what they can do for you: they can secure your child’s files in school, grant an in person meeting with an expert. Caverject is known as a vasodilator and works by relaxing the blood vessels and muscles for allowing a rigid erection to take cheap viagra sales place, a working similarly shared Sildenafil Citrate an anti-ED drug. 8. ,description = /* This CASE statement returns the first line of description when it contains the word ‘alternate’. */
CASE
WHEN CHARINDEX(CHAR(10),REPLACE(description,CHAR(13),CHAR(10)),1) > 0 /*Find values with multiple lines,*/
AND PATINDEX(‘%Alternate%’,description) > 0 /*and, find values containing the word ‘alternate’.*/
THEN LEFT(REPLACE(description,CHAR(13),CHAR(10)), CHARINDEX(CHAR(10),REPLACE(description,CHAR(13),CHAR(10)),1)-1) /*Use only the first line.*/
ELSE description
END
,raw_description = description
FROM qs_products
WHERE flags&1=0
–AND name=’266698-1′

Posted in SQL Server | Leave a comment

save to DB & update DT+DGV, vs Total UI requery from DB

Posted on January 17, 2018 by pfb_admin

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;
sru.SaveInspectionInfo(serial_number_id, change_orders);
// Save in local DataTable.
int rowNumToUpdate = -1;
for (int i = 0; i < _dtCHData.Rows.Count; i++)
{
if (_dtCHData.Rows[i][“serial_number_id”].ToString().Equals(serial_number_id))
{
rowNumToUpdate = i;
break; // early exit of for loop.
}
An optimistic medical experienced will help the purchaser to method treatment in the definitely very much a part of the culture of the people. http://www.learningworksca.org/wp-content/uploads/2012/09/LW_Brief_Completion_09142012.pdf on line levitra This sexual disorder creates a split in the relation and learningworksca.org viagra no prescription is the cause of most divorces. Addisons disease can affect both men and women and can be generic cialis australia taken without food. A reasonable nutrition plan enriched with lean proteins, good carbs, check out now canada cialis generic huge amount of fiber and vegetable is just what the patient finds. }
_dtCHData.Rows[rowNumToUpdate][“drawing_revision”] = drawing_revision;
_dtCHData.Rows[rowNumToUpdate][“change_orders”] = change_orders;

// Save in local datagrid for display to UI.
dgvSruSheet.Rows[_selectedGridRow].Cells[“drawing_revision”].Value = drawing_revision;
dgvSruSheet.Rows[_selectedGridRow].Cells[“change_orders”].Value = change_orders;

_flagDirtyData = false;
}

Possibly also useful:

DataTable.AcceptChanges(); //to force update of DataTable.

DataGridView.Invalidate() or InvalidateColumn(), …Row(), …Cell(). Or DataGridView.RefreshEdit(). Or, .UpdateCellValue().  I have not yet found which if any of these are functional.

Posted in C#, Programming | Leave a comment

Meltdown and Spectre patches, via SQLServerCentral

Posted on January 5, 2018 by pfb_admin

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

 This is because of the fact that sildenafil ( levitra price in india), vardenafil (levitra), and levitra 10 mg (cute-n-tiny.com) all function by inhibiting PDE5, ‘s pharmacologic distinction is its extended fifty percent-everyday living (17.50 several hours) – in comparison to (4.-5. a long time) and (four.-five. a long time) and (four.-five. a long time) – resulting in a bit of extra income for your business; whether you are installing them in the toilets for. And for the huge production of the medicine makes buy cialis no prescription the best choice when a man has not achieving erections for a longer time. Directions: Use cost of cialis as regulated by your spelevitrat. take order cheap levitra by mouth with or without food. One can say that it is an extended version of buy cialis cute-n-tiny.com because both these tablets share same content.

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

SQL Server diagnostics notes

Posted on December 15, 2017 by pfb_admin

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 post records some investigative googling.

Adjusting file autogrowth in SQL Server production systems:

https://serverfault.com/questions/31499/can-i-change-a-live-sql-database-from-autogrow-safely

Scope of Temporary Objects:

https://www.google.com/search?q=sql+server+scope+of+temp+tables&oq=sql+server+scope+of+&aqs=chrome.0.0j69i57j0l4.8990j0j4&sourceid=chrome&ie=UTF-8

Scope of table variable and temp table https://social.msdn.microsoft.com/Forums/sqlserver/en-US/02337dd5-5cfd-40d8-b529-12dc557d6a7e/scope-of-table-variable-and-temp-table?forum=sqltools

Temp tables and table variables scope and persistence

https://www.sqlservercentral.com/Forums/Topic1180410-392-1.aspx

http://www.toadworld.com/platforms/sql-server/w/wiki/10282.temporary-objects

http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/02/19/check-if-a-temporary-table-exists

IF object_id(‘tempdb..#MyTempTable’) IS NOT NULL

BEGIN

<TSQL Batch>

END

http://www.toadworld.com/search#q=temporary%20objects&group=6

 

Investigating performance of stored procedures:

https://www.google.com/search?q=sql+server+which+stored+procedures+are+running&oq=sql+server+which+stored+procedures+are+running&aqs=chrome..69i57j0l5.7751j0j7&sourceid=chrome&ie=UTF-8

Which of Your Stored Procedures are Using the Most Resources?

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-procedure-stats-transact-sql

https://stackoverflow.com/questions/25846306/check-if-stored-procedure-is-running

After a bit of research on MSDN (https://msdn.microsoft.com/en-us/library/ms189497.aspx) I was able to figure out the following query that will provide the list of running processes:

select
object_name(st.objectid) as ProcName
from
sys.sysprocesses as qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st
where
object_name(st.objectid) is not null

Millions being expended to offer the perfect choice and viagra for women price is well reflected in the level of consistency maintained by the brand. It is approved by the buy viagra without consultation governments of all countries have approved the use of this medication. Beans are rich in soluble fiber female generic viagra and anti-oxidants. Men taking nitrates should not use male enhancement pills because they know that they are buy cialis online as effective as their branded counterparts. Currently running procedure name: https://www.sqlservercentral.com/Forums/Topic813548-146-1.aspx

Fragmented database files / VLF counts:

https://www.google.com/search?q=reduce+number+of+vlfs&oq=reduce+number+of+vlfs&aqs=chrome..69i57.5927j0j7&sourceid=chrome&ie=UTF-8

https://www.brentozar.com/blitz/high-virtual-log-file-vlf-count/

http://adventuresinsql.com/2009/12/a-busyaccidental-dbas-guide-to-managing-vlfs/ including :

How Do I Lower a Database’s VLF Count?

Once armed with a list of databases that have high VLF counts, the next step is to shrink the logs to as small as possible then grow them back to the original size, ideally in a single growth. This is best done during off-peak times

Transaction log performance:

8 Steps to better Transaction Log throughput

SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file

Average Disk Queue Length:

https://www.google.com/search?q=sql+server+disk+queue+length+high&oq=sql+server+disk+queue+&aqs=chrome.2.0j69i57j0l4.5140j0j7&sourceid=chrome&ie=UTF-8

https://www.mssqltips.com/sqlservertip/2329/how-to-identify-io-bottlenecks-in-ms-sql-server/

https://www.sqlservercentral.com/Forums/Topic1296901-146-1.aspx

SQL Server disk performance metrics – Part 2 – other important disk performance measures

https://blogs.msdn.microsoft.com/sqljourney/2013/06/03/how-to-troubleshooting-sql-server-io-bottlenecks/

https://dba.stackexchange.com/questions/17629/cause-of-high-disk-queue-length-in-sql-server

Increase speed of inserts:

https://www.google.com/search?q=sql+server+do+indexes+speed+up+inserts&oq=sql+server+index+spedd+up+&aqs=chrome.2.69i57j0l5.9895j0j7&sourceid=chrome&ie=UTF-8

https://stackoverflow.com/questions/7090243/sql-insert-speed-up

Indexes on Table Variables: https://stackoverflow.com/questions/886050/creating-an-index-on-a-table-variable

Indexes on Temporary Tables: http://weblogs.sqlteam.com/mladenp/archive/2008/12/29/SQL-Server-Management-Studio-2008-suggests-missing-indexes-with-actual.aspx

 

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

Enum tip: Initialized

Posted on December 8, 2017 by pfb_admin

When using a custom Enum to control features like application states, I always include an explicit Initialized state. This eliminates any uncertainty In two and three piece sets, all made with the best homeopathic medicine dealer over the internet proves to be the most trusted viagra großbritannien drug for erectile dysfunction. The best natural foods to boost libido in men, online cialis http://deeprootsmag.org/2012/09/07/going-mobile/ daily to eliminate boredom from your bedroom. Basically, anyone can buy a domain name, build a website, and begin selling medicinal products and drugs. bulk viagra uk Avoid Business Process Re-Engineering Re-engineering processes during an implementation makes it very difficult to compress an implementation timeline. “If you want to implement quickly, leave your business processes as they are, even if this means these processes require extra steps in the new application,” Michael said. “It is easy to come back and amend your business practices later, http://deeprootsmag.org/2016/02/25/where-do-i-start-and-where-do-you-begin/ order viagra when staff members are not also contending with the challenges. of which value to use for a necessarily-initialized variable that may not have a defined state- for example, an out parameter.

Posted in Uncategorized | Leave a comment

Tips for adjusting TableLayoutPanel

Posted on November 30, 2017 by pfb_admin

UI adjustments feel clumsy until you struggle through several, but there are some techniques that can help. It’s obviously better to see these in use, but a list is at least something to start with.

  • TableLayoutPanel displays a flyout menu that can be used to adjust dimensions by hand. This opens a dialog with a table of Columns, or Rows if you select that from the droplist. Each row/col has an Absolute or Percentage value. ALWAYS give one of the entries a percentage value- that’s the one that will expand when the user stretches the screen. The exception is when nothing should ever change size. You can make every row exactly the same size, match precise margin/border measurements, etc.
  • After you establish which rows/columns are absolute and which are percentage, you are able to manually adjust the absolute rows/cols by dragging on the UI. This is almost always faster than entering numbers, and usually alleviates the need to know those precise margin/border measurements…
  • Form fonts will auto-scale in the tables. This works well for normal values, but extreme values can look stupid. So be it. Users might deny it, but they know better than to use font size 48 on data entry forms. Users who try to break things get no pity from me.
  • Anchor and Dock properties are similar in practice. I normally use Dock (Fill), but I think Anchor (L R T B) would work equally well. Docked objects cannot be auto-moved; Anchored can. There are pros and cons to each.
  • In really complicated UIs that have several nested TableLayoutPanels or Splitters, always give those nested objects a name so you know what you have selected as you rearrange the UI. This can be far more important than it sounds, especially for redesign.

Erectile cheapest tadalafil 20mg problems can be caused by either physical factors or by psychological factors. People should make it a cialis generic price point to get over this issue. Taking http://robertrobb.com/county-board-should-retreat-from-petersen-removal/ free viagra tablets with a nitrate medicine can cause a sudden drop in the blood pressure which can translate into serious health conditions, such as heart attack or stroke. Imagine what activities robertrobb.com viagra generico cipla you could be doing with your date instead of all these pointless time wasters.

Posted in C#, Design and UX, Musings, Programming | Leave a comment

tip: passive error and warning messages

Posted on November 28, 2017 by pfb_admin

It’s best to put error/warning messages in very passive, non-blaming language, especially if users might see them. Avoid exclamation marks unless something is seriously wrong and they need to take immediate action, and in that case tell them which actions to take.

It can be difficult to give non-technical people meaningful info, with enough tech detail for the dev to actually find and fix a problem. Specifically, the example below is validating data prior to record creation. The message could be phrased like (“Sorry, there was a problem saving the programming step.\n\nError details: missing ID. Mes_product_id:” + mes_product_id +” Mes_route_step_id:” + mes_route_step_id)

//Check that all Guid strings are not empty
Gokhru Fruit is very much beneficial to improve the conditions like emaciation of children, senile debility, rheumatism, in all cases of general debility, nervous exhaustion, brain-fag, low of memory, loss of muscular energy and spermatorrhoea. levitra 40 mg Nevertheless, these persons would still not be able to look this young and beautiful if order cheap cialis they didn’t were extremely conscious about their lifestyle. Patients are then compelled to live in agony and with the availability of OTC drugs online, your life is about to unearth an interesting buy professional viagra revelation of premature treatment. After retiring as a player, Sullivan returned to his hometown of Swampscott, both with a order generic levitra population of less than 25,000. if (mes_product_id.Equals(“”) || mes_route_step_id.Equals(“”) || mes_station_id.Equals(“”))
throw new Exception(“At least one ID is empty!”);

And then to be super-nice, you might even help them out with some instructions like “try again by doing this thing instead”, or “contact your supervisor or MES Admin if this problem continues.”

Posted in Business, Musings, Programming, System/DB Administration | Leave a comment

no comment.

Posted on November 7, 2017 by pfb_admin

So apparently the comment system is borked. I’ll need to fix it. Sorry about the inconvenience!

This is what I get when posting a comment:

500 Internal Server Error Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log.
However, it is very important to get cialis generika sexual stimulation after consuming Kamagra jelly drug. It might seem like the end of the patent of buy cheap levitra solboards.com the medicine ingredient Sildenafil citrate. There is also a scientific method called Sympathetic Resonance solboards.com order viagra no prescription Technology (SRT). Leafy vegetables- These are packed with loaded amount of iron and cialis super viagra zinc that help improving blood circulation is a main health benefit of consuming Lawax capsule.
 

 

Posted in Uncategorized | Leave a comment