Techgalery.com by @adm.uiux

Microsoft SQL Server It is not a hard task to restore our backuped SQL Server database data, but it's a bit tricky for a newbie because sometimes the error message provided by SQL Server is sometimes not straightforward and can lead to confusion for beginners. The first time I tried to restore a database was literally quite a stressful experience. so i don't want you to spinning your head like i did, these are main advice for doing restoring database in SQL server using SSMS: - Don't create the database - Put the backup file in the right location In my machine it is C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup (It depends on your version of Sql-server) It is easy to restore database from SSMS, here’s how: 1. Right click on the ' Databases ' then ' Restore database ' 2. After popup open, on the Source field, select Device 3. Then click the three dotted button to browse your backup database 4. After that just press...

Before wrapping the long text Sometimes when we are working on Microsoft Excel, when we have long words to write it on an excel cell, without formatting it just looks messy, so we need to format the column that has long description of text, wrap the text to make it more readable on our computer screen. Here's how to wrap the text on excel column so that we can make it look beautiful and readable. 1. Just select or block the column that contains long words, in this example is column C, click on the column C 2. On the home tab, select Wrap text 3. Now you can adjust the width of the column based on your needs. After wrapping the text As a programmer or whatever your job, spreadsheet is one important and handy program we can use, I am still using spreadsheets to do some data export and import from XLS or CSV document to the application I developed. Sometimes I use it for writing to do list or tasks that I need to work on it, it's much more clear writin...

Microsoft SQL Server is one of the best relational database system in the market. Even though from the beginning of installation it is not easy to do, even creating new user is challenging task to do for the first timer using SQL Server. The syntax of SQL they are using is so weird and different than many other database system like MySQL or PostgreSQL. I used SQL Server mostly for just in development process. And if your struggle to create new user in SQL Server. Here's how you create a new SQL Server user using SSMS : 1. Login to using your existing SQL Server user 2. Object explorer > Security > Logins 3. Right click on Login and New login 4. Fill in the Login name with your desired login username 5. Choose SQL Server authentication 6. Enter desired Password and confirm the password, bot must be matched 7. Unchecked the Enforce password policy SQL server add new remote login 8. On the left side Select a page Server roles SQL server login roles 9. Check...