Create new user for Microsoft SQL Server database

With Microsoft SQL Server Management Studio, in default, you can use Windows account or default SQL Server administrator account to connect your computer database engine and manage databases. However, if you want to share a database with any people via network connection (LAN or Internet), you shouldn't share the default account information with them. Then, you need to create a new user for your database and share it.

Open Microsoft SQL Server Management Studio, connect the database engine by a default administrator account. Browse to Security > Logins on the left panel. Right click on Logins folder, choose New Login

Creating new user account on opened New Login windows:
- In General page: input your new account name and password. Select the Default database which you want to share. You may also check in Enforce password expiration and User must to change password at next login for security reason.

Important: In User Mapping page: on Users mapped to this login gridview, check in the database which you allow the new account to manage. Then choose an database role for the new account. Public or db_owner role is recommended.

That's all. Now try to login and share your database with your friends.
Wish succeed! Video version here:

Turn off AutoPlay on Windows

On Windows, when you insert an USB or a CD/DVD into your computer, they are usually opened automatically. So the computer maybe infected autorun virus. To avoid that, you should turn off AutoPlay function.

Install and play Pokemon Go on unsupported device

Pokemon Go is great mobile game for smart devices (Android, iOS...). Many people can install and play it normally. However, some device has not been supported yet (Intel inside smartphone: Asus Zenfone, Dell Veune, ...; Windows Phone devices...). Here we show you how to play it in all your devices. For Android devices: Enable “Unknown sources” in the settings. Download Pokemon Go app setup: Link 1 / Link 2 Open the downloaded file to install app. Enable all the settings when promted. Now you can open and run Pokemon Go to catch 'em. ... That's all. Wish succeed!

Dislay snow effect on your blog/website

When Christmas season is going to come, many blog/website masters will want to make a change on their website interface. If you want to display snow storm effect on your site, you just need use below simple steps with Javascript to do that.

nguyentienAugust 2, 2012 at 10:29 PM
It's useful.
Thanks!
VeemSeptember 9, 2012 at 8:58 AM
Hey, thank you Polo!I realized that from time to time you may face this kind of small issue and stulggre for hours to get a fix So, I'm glad if I can help :) This is what Dukeo is about after all: helping and giving back to the community!

SomeT.I.P.

Search This Blog