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 we can run the simple SQL query which returns all the columns in respective tables and encryption type.

SELECT
t.name AS TableName,
c.name AS ColumnName,
k.name AS KeyName,
c.encryption_type_desc,
c.encryption_algorithm_name
FROM sys.columns c
INNER JOIN sys.column_encryption_keys k ON c.column_encryption_key_id = k.column_encryption_key_id
INNER JOIN sys.tables t ON c.object_id = t.object_id
WHERE encryption_type IS NOT NULL

 

 

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 this is related to ownership and missing folder on users directory. To resolve it we need to manually create the folders and update the ownership of them. Below are the commands which we need to run before start.

mkdir “%userprofile%\drill”
mkdir “%userprofile%\drill\udf”
mkdir “%userprofile%\drill\udf\registry”
mkdir “%userprofile%\drill\udf\tmp”
mkdir “%userprofile%\drill\udf\staging”

takeown /R /F “%userprofile%\drill

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 date system you need open Advance options of excel and enable the 1904 date system box.

Use the formula:

=IF(D2-A2<0, "-" & TEXT(ABS(D2-A2),"hh:mm"), D2-A2)

 

 

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:
<add key=”editor.settings.coauthoring.url” value=”” />
<add key=”editor.settings.spellchecker.url” value=”” />

and reset the IIS.

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 account
  • Go to left panel and click on “All Mails”
  • Search your email and open it
  • After opening, click on “Move to Inbox” button.
  • Now you can see your archived email to inbox folder

Archive folder is good for keeping the emails, if you want to delete the emails which is not used, without deleting permanently them move to archived folder.

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 some expensive for the start-ups or small companies, also their model based on subscription. We need to pay them monthly or yearly subscription.

Only office also host on their cloud machines but we can setup this on our machines too. ?A subscription model of this application also cost effective. Any small scale company can afford it. If they want to setup their own machine then it can also be possible.

If we have a small team and would like to share docs between them without worrying about versions, sharing permissions, we can do it easily with this tool. It also support web editors where anyone can open and edit documents without installing the required software?s on local machines. This will help to reduce resources as well.

Only office also easily integrated with existing applications using iframe without worrying and wasting lot of time. It has application programming interface (API) too, so programmers can easily integrate it. Programmers can easily create real time users, upload files, sharing permission to the file without going to portal.

Only office installation is also easy, it provides single click installation for beginners, setup will take case all the things, we need to provide public IP and credentials to start that.

Only office comes with two applications, first Community Server and second one is document server. Community server will take care of all the things like project management, users, sharing, emails, authentication and authorizations. Document server serve the documents online with the support of Iframe.

If anyone wants to use the application for editors only then he can setup document server ONLY. Both application needs to install on separate machines. They are internally responsible for data transfer.

See more about only office please click here?