Thursday, February 11, 2016

How do you bring in a database to a SQL Server?


There are several ways you can bring in a database to a SQL Server:
Attaching the database data and data-log files to the server:

  • By restoring a backup of the database
  • By executing a script file
  • Using the Import/Export tool
  • etc..
After installing the SQL Server the first thing you may have to do is bring in some data. Microsoft has provided lots of samples and AdventureWorks is one such database of a hypothetical company and it is bigger than the Northwind database of another hypothetical company.

Here is a Swaytorial that helps you to bring in data to your server. Enjoy!




Monday, February 8, 2016

How do you create a script in SQL Server Management Studio?

  • This presentation is created using Microsoft's latest presentation program SWAY. This is my first shot at SWAY. The presentation may not be smooth. Would you kindly comment? Thanks



Test embed code:

Saturday, February 6, 2016

What is Microsoft Wi-Fi?

It is a wireless connectivity service that allows you to have Internet access via Wi-Fi. It is only available for Windows 10 and you need to download a free app if it is not already on your device. Get it from here:
https://www.microsoft.com/en-us/store/apps/microsoft-wi-fi/9nblgggxw3p8

I had this app already but the Wi-Fi is not available from my current location(home).



MicrosoftWiFiapp

Connection is not free and you should get it from a Windows store in your country. You can buy the amount of Wi-Fi access you need when you are at any of these places:

Hotel
Conference Center
Any location that has Microsoft Wi-Fi

I think this is a nice service. If you browse the list of Wi-Fi connections available you will see a network with the lable,'Buy WiFi from Windows Store". From there you select the amount of WiFi you need.

Here is the Service description(from the Terms of Use document):
"After you select a Service plan and buy it, you will be connected automatically whenever you’re near an access point that provides the Service (and is within the country in which you originally purchased the Service plan) and you have time remaining on your plan. Your connectivity begins immediately after you buy a Service plan through the Windows Store and ends at the specified expiration time, regardless of how long you are actually connected to the Service. You cannot save time for later. You must actively maintain your connection and you must be within range of an access point that provides the Service in order to stay connected. If (i) your usage remains on standby; (ii) your usage is inactive; (iii) or your Service plan has expired, your connection may be terminated. Microsoft reserves the right to terminate your connection following any extended period of inactivity."

Also look up:
FREE TWC WiFi ® Hotspots
with Extreme and Above

Also check up:
http://www.boingo.com/retail/#s7653
This together with Skype should make it a very useful service.

Tuesday, February 2, 2016

How do you create multiple desktops in Windows 10?

By default you have just one desktop displaying folders and files.


However, you can add multiple desktops which you can access from Task Bar.

Click on Task View shown here:


+New Desktop opens far right as shown.


Click on +New Desktop to open a new desktop as shown.


Desktop has an open Notepad document and Desktop 2 has no open document.


Click on Desktop 2 and then open any App or application. That app appears in Desktop 2.

 You can create many desktops to group the apps you are running and getting to it quick from the taskbar.

Desktops created by one user is not accessible by other users.

You can personalize the desktop as shown. Desktop 2 has a different theme.




How do you log on as a different user in Windows 10?

Assuming you have multiple users to a computer/laptop like in a family scenario for example, then you can logon as a different user. The POWER menu items above All Apps does not have this option.

Make a right click on the current user at the top in Tiles as shown.


ChangeLoginWin10.png

Choose one of the other users from the list. The Login page will open for that user.

Monday, February 1, 2016

Which browser supports HTML5 best?

This comparison can be made quite easily by accessing this URL in the browser you want to test. It gives a number the maximum of which can be 555.

http://html5test.com/index.html

This was the score for the latest Microsoft Edge 25.10586.0.0 and MicrosoftEdgeHTML 13.10586:


This one was for Mozilla Firefox 44.0


Well, Firefox does a little better.

There has been a lot of progress made by Microsoft in the past few years.
http://hodentekhelp.blogspot.com/2013/08/which-is-best-browser-to-text-html5.html

Does HTML5 WebSockets work for you?

This is an easy test that will get you the answer in no time at all. I have Mozilla Firefox 44.0 and Microsoft Edge 25.10586.0.0 and Microsoft EdgeHTML 13.10586. Both reported that Web Socket will work on this Windows 10 (x64) computer. Even IE 11 reported the same. However there may be other issues. Here are the results from Firefox and Edge.
Just launch the browser and enter the following for the URL:
websocketstest.com. That's it!

Works on Edge

 Works on Firefox