Found 2044 Articles for Microsoft Technologies

Difference between ETL and ELT in SQL Server

Himanshu shriv
Updated on 21-Jan-2020 09:29:42

665 Views

ETL stands for Extract, Transform and Load. ETL tool is used to extract data from the source RDBMS database and transform extracted data such as applying business logic and  calculation, etc. and  then load data into the target data warehouse. In ETL tool,  transformation of the data performed at the ETL server. It is used for low amount data.ELT stands for Extract, Load and Transform. ELT tool is also used to extract data from source database and then load data into target database without transformation. In ELT, transformation of data is performed at the target database. In general, in an ... Read More

Difference between Star schema and Snowflake schema in SQL Server

Himanshu shriv
Updated on 21-Jan-2020 09:28:49

309 Views

Star schema is relational schema which is follow the concept of facts and dimensions. Fact table is used to store the event like login and dimension tables are used to store the reference data of the partitural event. In star schema , tables are completely denormalized because of this query performance time is very fast.Snowflaking is a method of normalizing the dimension tables in a STAR schema. When we normalize all the dimension tables entirely, the resultant structure resembles a snowflake with the fact table in the middle. In the snowflake schema , one fact table is linked to multiple dimension ... Read More

Are You Ready For Cloud Computing?

Sharon Christine
Updated on 20-Jan-2020 06:25:21

111 Views

Cloud computing can be characterized as the utilization of high-end remote servers and other virtually hosted network services over the web to efficiently manage, process and store information in a highly versatile manner. Cloud computing makes it feasible for enterprises to utilize extremely computable network remote infrastructure and fully scalable atmosphere for mission critical complex business applications. Resources like virtual machines (VMs), storage units, shared utilities and intelligent applications are some of the computing resources provided by the cloud computing environment.Cloud Adoption TrendsCloud computing is emerging as a major industry trend in IT modernization and digital transformation strategies among enterprises. ... Read More

Outlook Tips and Tricks for Efficient Work Productivity

Sharon Christine
Updated on 17-Jan-2020 10:58:56

114 Views

Millions of people use Microsoft Outlook for managing their email, meetings, and contacts. It offers so many features but few of us really know how to make the most of its features. When you use these useful features effectively, Microsoft Outlook enables you to do your work seamlessly and as efficiently as possible.Few of tips and tricks are listed belowAvoid Repeated Typing with Quick PartsIf you need to use a standard passage of text over and over again, save it as a Quick Part for easy insertion in emails. To do so, simply highlight the text in the composer window, ... Read More

Microsoft’s Surface Studio for Creative Professionals

Sharon Christine
Updated on 17-Jan-2020 09:59:52

57 Views

Microsoft’s Surface Studio is an elegant and mature all-in-one desktop PC with built-in touch screen specially designed for creative professionals. Microsoft first release was the Microsoft PixelSense formerly called as Microsoft Surface back in 2008. The next release was the Microsoft surface tablet followed by the Surface Book. The latest upgraded release is the Surface Studio.The Studio is a 28-inch sharp, incredibly thin display mounted on a pair of “zero gravity” hinges that allows it to act as a regular monitor or tilt down into a type of drafting table. Without doubts Microsoft studio will be a clear challenge to ... Read More

Learn Why ‘less’ is Faster Than ‘more’ Command for Effective File Navigation

Sharon Christine
Updated on 17-Jan-2020 09:35:54

60 Views

More is a command to view (but not modify) the contents of a text file, one screen at a time. It is available on Unix and Unix-like systems, DOS, OS/2, and Microsoft Windows. Programs of this sort are called pagers. More is a very basic pager, originally allowing only forward navigation through a file, though newer implementations which allows for limited backward movement.The basics of more command should be like this –$ more /var/log/dkpg.logThe sample output should be like this –2016-12-02 11:30:45 startup archives unpack 2016-12-02 11:30:45 install python-ptyprocess:all 0.5-1 2016-12-02 11:30:45 status half-installed python-ptyprocess:all 0.5-1 2016-12-02 11:30:45 status ... Read More

Windows in safe mode troubleshoots all system issues

karthikeya Boyini
Updated on 14-Jul-2020 07:22:43

147 Views

Now, because of heavy or 24 hours uses of computer at corporate or home place, it becomes a complex and delicate machine. This complex and delicate machine sometime goes wrong while updating BIOS, downloading new drivers, or just surfing the Web. To resolve these issues user does not have to buy an expensive device or replace it with a new one.Microsoft provides a very useful Windows functions called Safe Mode functions. It’s always good to start windows in a safe mode to troubleshoot any kind of issues which give bad effects on the system. Although, using this mode only certain ... Read More

Share confidential folders in windows 7 homegroup

Sharon Christine
Updated on 16-Jan-2020 10:50:08

77 Views

It’s true, at present people are so busy with their work and they definitely want some easy ways to reduce their work. Windows 7 tried to help those people who are really busy with their work and they don’t have time to manually send some important files and folders using share file and folder option. Unlike the previous version of Windows (XP and Vista), Windows 7 facilitates to easily share files and folders with friends and family at home or with co-workers at the office over network without having to follow tedious process of setting up IP address on network ... Read More

Microsoftwindow eyes awesome tool for blind user

karthikeya Boyini
Updated on 13-Jan-2020 10:02:38

66 Views

Microsoft collaborated with GW Micro, this collaboration brought GW Micro’s Window-Eyes screen reader tool which will be available at free of cost to Office users.GW Micro’s Window-Eyes facilitates blind or visually harmed user to access Windows based computers by speaking the contents of the computer’s screen. This tool allows blind users to access all applications like; word processors, Internet, email, etc. Window-Eyes provides full command on what user hear, when to hear, and how to hear.Microsoft said that, users who have licensed version of Microsoft Office 2010, Office 2013 or Office 365 on their systems can only take the advantage ... Read More

Microsoft Office Web Apps Renamed As Office Online

Sharon Christine
Updated on 13-Jan-2020 07:26:16

82 Views

Microsoft has officially renamed Office Web Apps as Office Online which includes the online versions of its popular Word, PowerPoint and Excel apps, using this user can find their free online experience. Also, name “SkyDrive” has become “OneDrive”. The new name doesn’t come up with lots of new features, but there are some changes that come with renaming.Just visit the Office.com site: https://www.office.com/start/default.aspx, and start using the Microsoft Word Online, Excel Online, PowerPoint Online and OneNote Online. Users just need a Microsoft Account(available with any email address) to use the Office Online. After creating a Microsoft Account, just log in, ... Read More

Advertisements