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]

adjective

• 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.

• Click here for the entire article.
• Click here to read the news letter.

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

• Click here for the entire article.
• Click here to read the news letter.

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

• Click here for the entire article.
• Click here to read the news letter.

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

• Click here for the entire article.
• Click here to read the news letter.

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.

• Click here for the entire article.
• Click here to read the news letter.

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?

• Click here for the entire article.
• Click here to read the news letter.

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.

• Click here for the entire article.