Make no mistake – Democrats don’t want to help their constituents, nor do they care about them. They only want to control you and make you subservient to them. The government is NOT Santa Claus, it’s not Mommy and Daddy. They want to dictate what they think is best for you, not what you actually need. Individual freedoms – out the window – it’s what they dictate you will do, say, and think. There is no free education, no free handouts for the chronically lazy, no free healthcare, no matter what they tell you. They’ll take from workers and give to the non-workers. The more they take, the fewer incentive workers have to produce. Think about it. The mid-term election is this Tuesday – do you want freedom, or do you want every facet of your life controlled? The more they get, the more they’ll take.
I’ll take freedom, thank you very much. Vote Republican. #WalkAway
Category: General
One of Microsoft’s buried SQL gems. I was working with a client with serious inter-server Dynamics GP performance issues, so slow as to be virtually unusable, but GP ran fine at the SQL Server. We discovered SQL ODBC was communicating using Named Pipes only.
Without getting into troubleshooting detail, their IT group changed the default SQL port for Microsoft SQL 2016, and Microsoft, in all their infinite wisdom, removed port selection settings from the client ODBC DSN Configuration interface a number of versions back. So how do you tell ODBC what port to connect to?
The answer is simple. During configuration, when you select the server, enter the SQL Server and instance followed by a comma (,) followed by the port number it will connect with – no spaces.
For example, If your SQL Server is on CONTOSO1\GP, but needs to use TCP/IP Port 12345, enter CONTOSO1\GP,12345 in the Server line. If SQL is on the default instance, it would be CONTOSO1,12345. It’s that simple.
There is overwhelming evidence that the recently uncovered priestly perversions happen wherever the Roman Catholic Church exists, not just in Pennsylvania. Their superiors and their superior’s superiors say ‘shame, shame’, but do nothing to clean the sewer they have made, polluted, and continue to live in. The Roman Catholic religion, although almost as old as Christianity itself, is a perverted sham of a religion with the little biblical fact authenticating it to what God through Jesus Christ anticipated. Their belief in Mary as the ‘mother of god’, worshipping a dead Christ on the cross, indulgences, relics, and all manner of devil-inspired lies, many of which make witchcraft pale in comparison. This ‘church’ needs to be fumigated from the top down, its leaders exposed for what they are, and the rotting corpse on their cross torn down to reveal the living Christ seated at the right hand of the living God, not the god of this world that they worship and adore.
Other ‘religions’ are just as guilty of perverting the Gospel. From the mainstream Western religions to the supposedly enlightened non-denominational spirit-filled churches, each has strayed and cannot see its own hypocrisy (see my earlier post – https://raynetcom.blog/2013/02/05/the-last-supper-vs-communion/ )
This is an additional post on the perils of network performance, hardware, and file placement as related to Dynamics GP’s client/server processing algorithm.
While I could use posting, reporting, or data entry as an example, I will use SmartList as an example, since it provides a generic platform for non-technical analysis.
Let’s consider a simple action in Dynamics GP – the version is irrelevant for this scenario, other than the fact that SmartList was introduced in early versions of Great Plains Dynamics and CS+ and is commonly used.
- A normal system – our baseline:
a. You request a Payables Transaction SmartList.
b. The request is sent to the SQL Server Database Engine.
c. Relevant data returns to the user’s temp folder in small packets (25 records each) for processing and temporary storage pending query completion.
d. Results display to screen for further user interaction. - A normal client with active antivirus scanning enabled
a. You request a Payables Transaction SmartList
b. The request is sent to the SQL Server Database Engine
c. Relevant data returns
d. Packet 1 – antivirus scans packet to ensure it is safe, then writes and stores in temp
e. Packet 2 – antivirus engine scans packet
f. Packet 3-400 (assuming default ‘first 1000 records’)
g. Results display to screen - A client with a low-bandwidth NIC (100Mb, Wireless)
a. You request a Payables Transaction SmartList
b. The request is sent to the SQL Server Database Engine
c. Relevant data returns, but is unable to process as fast due to data backed up waiting its turn to get through. Think of the data as water, with the server 1GB+ NIC as a garden hose. With the 100MB NIC we are trying to force all the water passing through the garden hose into a drinking straw. Once the water is shut off (SQL processing finished), the hose will empty, but held back by the diameter of the straw.
d. Packets arrive and results display on screen slowly
4. A client (or server) with slow disk drives or drives busy with other activities
a. You request a Payables Transaction SmartList
b. The request is sent to the SQL Server Database Engine
c. Query runs on server, writes to temporary tables, but both reading and writing data are slowed by the rate the server disks are able to read, write, and process the request. This is most noticeable in 5400RPM drives, but still noticeable in 7200RPM HDDs. If multiple databases are written to simultaneously, performance drops even more. That’s why data and log files, and tempdb should be on their own physical drives or drive arrays.
d. Relevant data returns, but is again hindered by a drive that cannot write fast enough to keep up with the data returned, or writing is hindered by the disk being busy writing other processes to disk, calculating spreadsheets, rendering drawings, etc.
5. Client with roaming profiles
a. You request a Payables Transaction SmartList
b. The request is sent to the SQL Server Database Engine
c. Relevant data returns to the temp folder on a different server
d. Client queries and processes data in the temp folder across the network. This will take many bundles of data, and we’re now shuffling data to another server.
e. Data returns to client and displays on screen for further processing
As you can see from the above examples, there are numerous ways in which data can be slowed down, backed up, or bottlenecked. Keep in mind that any combination of the above scenarios is also possible.
It’s also easy to alleviate many of these trouble spots.
In scenario #2, create Antivirus exceptions for known temporary files.
* In the %temp% folder:
* TNT*.dat
* TNT*.idx
* TNT*.tmp
* In a %temp%\TNT* subfolder:
* ASI*.dat
* ASI*.idx
In scenario #3, make sure the NIC is a minimum of 1GB, and any hubs (old) or switches support 1GB throughput. Most new computers already comply. If you’re connecting to your network on a wireless connection, plug in a network cable. If your notebook doesn’t have a NIC port, there are USB adapters.
In scenario #4, the faster the drive, the better the performance. A Solid-State Drive is fastest. Increased productivity will quickly offset the additional cost of an SSD.
In scenario #5, if your IT requires roaming profiles, make sure your network is as fast as possible, but ask if it’s available to store temp files locally rather than on another server.
Another year, same old same old… A ‘team’ sports event is not the place for personal statements. Act as a team or get out!
I’m not much of a team sports watcher, but we here in the USA have taken ‘pro’ sports to the extreme. When I was attending Pirates ‘knothole’ games, an average baseball player salary was somewhere around $10,000 per year. In the time it’s taken the minimum wage to go from $1.80 to $7.25 per hour, team sports ‘pro’ compensation has gone from that $10,000/yr figure to an average of $2,000,000 + /yr.
Team sports isn’t about the teams anymore, but about the players, their lifestyles, their endorsements. We have so lost the idea of ‘team sports’ that players don’t feel the need to play as a team, but to outperform, outclass, do anything to NOT be a team member.
Today’s ‘pro’ is idolized, worshiped, revered – for what? For the most part, the more lavish and outlandish your lifestyle, the more you align yourself with thugs and infamy, the more…
View original post 156 more words