Author: SutoCom

SutoCom (aka Sutoprise), has been in business since 1999. With the expertise in team building in business development in Sales, Marketing and customer service evolving in technology with cloud base automation and reaching a wide customer with effective tools. Working with a wide cross section of industries and clientele. We strive not just only producing solo rock stars in business but rock orchestras that carry the tune of generating revenue & exceeding goals. A cliche, but in business there is no "i" in teamwork. The site will be addressing both "best practice" as well as "risk" taking in order to bolster revenue as well as mitigating waste. For example, we do not believe in burning out or using talent till it is all dried up. Nurturing talent and guidance will make a company stronger and solid.

Clearing Caches in SQL Server — mattthehackdev


The following are a few useful commands for Database Performance testing: DBCC FREEPROCCACHE – Clears the procedure cache and forces SQL Server to recompile procedure plans the next time a respective procedure is run DBCC DROPCLEANBUFFERS – Clears the SQL Server data cache i.e any data that exists in the buffer cache from previous execution […]

via Clearing Caches in SQL Server — mattthehackdev

Advertisements

Getting a Substring in MySQL — jinahya


I just learned how to get substring of specific range using LOCATE() and SUBSTRING(). Let’s say we have email addresses and want to get username part from them. Step 1 Locate the index of ‘@’ character LOCATE(‘@’, email) Step 2 Get substring using it. SUBSTRING(email, 1, LOCATE(‘@’, email) – 1) Note that the starting index is 1 and […]

via Getting a Substring in MySQL — jinahya

Creating a SQL Server Test Lab On Your Workstation – Part One, Installing The Domain Controller — SQL Undercover


One of the most useful tools to the DBA when we need to test new features, recreate a fault that we’ve seen in production or just want to see ‘what if…?’ is a test lab. Some of you are going to be lucky enough to have a few servers kicking around or a chunk of […]

via Creating a SQL Server Test Lab On Your Workstation – Part One, Installing The Domain Controller — SQL Undercover

Connecting to Secure MySQL from Java JDBC. — BigData Analytics Simplified


Like any other enterprise database, mysql supports secure jdbc connections using ssl/tls. I had a requirement to connect to Mysql using secure JDBC, the initial setup took longer than I anticipated due to the requirement of converting .pem files to jks . I had to look up multiple articles, not satisfied with quality of available […]

via Connecting to Secure MySQL from Java JDBC. — BigData Analytics Simplified

How billow impacts APIs and microservices — Tech Analysis World


What strategies are companies employing for brief bequest apps to the cloud?

via How billow impacts APIs and microservices — Tech Analysis World

How to Select Current Column in Microsoft Excel and Google Sheet! — POWER TIPS N TRICKS


Another super easy Keyboard Shortcut to Select Current Column in Microsoft Excel and Google Sheet try yourself with both Spreadsheet programs and also try in whatever Spreadsheet Program you are using, share and write your experience in comments box. Press CTRL + SPACEBAR to Select Current Column in your Microsoft Excel / Google Sheet or any other Spreadsheet Program: share it with your friends on SOCIAL NETWORKS click […]

via How to Select Current Column in Microsoft Excel and Google Sheet! — POWER TIPS N TRICKS

Automate Chatter Post That @Mentions Several Users — Jenwlee’s Salesforce Blog


[Note: This use case/solution can be implemented in both Classic and Lightning Experience.] While process builder has the ability to post to chatter, its capabilities are a bit simplistic. In process builder, you can post to a user, a chatter group or the record. There is no ability to @mention multiple users dynamically. Users can […]

via Automate Chatter Post That @Mentions Several Users — Jenwlee’s Salesforce Blog