Call us Today! 201-728-8809 | | Contact | Download | About |

Practical Compliance Solutions

PCS Articles and News Letters

Are your developers hindering database performance?

We started our eNews letter in 2012 as a way to keep folks informed about what we are doing and how we might be able to help.

The articles seemed to be a natural byproduct and a way for us to showcase a little bit of how we can help. As time permits, there will be more articles and of course more eNews as we announce new products and services.

We hope you enjoy and can make use of the information we present.

A word about the name Pragmatics: As everything we do at PCS is practical how else could we express that in the title of our news letter? Everthing we do can be traced to some theory to be sure, but our methods of trouble shooting issues and our approach to solving problems is pragmatic.

prag·mat·ic, [prag'madik]

  • dealing with things sensibly and realistically in a way that is based on practical rather than theoretical considerations. "a pragmatic approach to politics"
  • synonyms:
    • practical, matter-of-fact, sensible, down-to-earth, commonsensical, businesslike, having both/one's feet on the ground, hardheaded, no-nonsense; informalhard-nosed
    • "she remains pragmatic in the most emotional circumstances"
  • antonyms: impractical
  • relating to philosophical or political pragmatism.
  • LINGUISTICS of or relating to pragmatics. {our News Letter}

Volume 1 - Issue 1 - Are your developers hindering database performance? A Guide to properly constructing database transactions.

Volume 1 - Issue 2 - Are your developers hindering database performance? Part II a starting point to discovering root cause.

Volume 1 - Issue 3 - Are your developers hindering database performance? Part III digging deeper.

Volume 1 - Issue 4 - Are your developers hindering database performance? Part IV To Profile or not to Profile.

Volume 2 - Issue 1 - GUIDs GUIDs everywhere, but how is my data unique? After having seen many systems that use GUIDs as the primary key for every table, it is time to say enough is enough.

Volume 2 - Issue 2 - So what is all this CRUD? In the ubiquitous world of acronyms, CRUD is just another one that makes be cringe. Growing up, crud was not a word that described anything desirable. Why do we allow a word with such negative connotations anywhere near our database? Volume 2 - Issue 3 - I thought my database was collation agnostic. How we encountered and solved this error Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.

Corporate Headquarters

Practical Compliance Solutions
One Orient Way - Suite F156 Rutherford, NJ 07070
Phone: 201-728-8809

40.827731 N 74.101029 W
Connect With Us


© 2002 - 2024 - Copyright Practical Compliance Solutions - All rights reserved