Category: Sharing
-
Search in MSSQL tables
Sometime we need to reverse engineering in the database tables to find a specific values, we can find the column name easily but in large database, to search a specific key value is too hard. From below query we can easily search value in all tables, it will list column with table in the result.…
-
How to get list of all always encrypted columns in SQL Server
We do have “Always encrypted” feature in SQL 2016 and later versions, from this feature we can encrypt the column data instead of encrypting whole database. Sensitive data like credit card numbers, SSN. We need to prepare a list of encrypted columns at some where to track for future. Without tracking anywhere in the documents…
-
How to fix apache drill startup error on windows-10
Apache Drill can be downloaded from here. It will works fine on windows 7 but it is giving error when you install it as embedded mode on Windows-10. Error is something like that after running the command: sqlline.bat -u “jdbc:drill:zk=local” Error during udf area creation [/C:/Users/<user>/drill/udf/registry] on file system [file:///] (state=,code=0) After googling I found…
-
How to display negative time in excel cell
While working with excel application I found that if we find difference between 2 times is negative then excel doesn’t display time, it shows “##########” instead of values. For positive difference we don’t have any issue. There are 2 ways to handle this, using 1904 date system and other using custom formula. To change the…
-
Only Office Error: Server connection lost. The document cannot be edited right now
After hosting of Only Office some time users can get the error “Server connection lost. The document cannot be edited right now“.? To resolve this error we can remove 2 values from the web.config key of the Document Server setup. By default values: <add key=”editor.settings.coauthoring.url” value=”/coauthoring” /> <add key=”editor.settings.spellchecker.url” value=”/spellchecker” /> Remove values like that:…
-
How to recover an archived email from your gmail account
Most of the people in the world are using GMAIL for their email, its a free and support unlimited storage (15 GB). Some times while viewing the email on desktop / handheld devices, archived option is clicked accidentally. If you want to recover that email from archived folder, just use these steps: Open your gmail…
-
Only Office – Multifunctional service for business with low cost
Only Office is a great tool which can use by any small scale organization for Project management, online editors, documents management, emails and few more things. Like all the features are available in other products too like Google, Microsoft Office Online, Microsoft SharePoint. All these products stores data to their own cloud servers, they are…