Microsoft Starts Testing its Long-Promised Windows 10 Timeline Feature

At the point when Microsoft reported the Windows 10 Fall Creators refresh, a standout amongst the most intriguing highlights the organization demoed was Timeline, which gives you a chance to discover and continue your current exercises as you move amongst PCs and iOS and Android telephones. It's fundamentally a worldwide undertaking view, sponsored by Microsoft's cloud administrations. Like some different highlights, Timeline wasn't exactly prepared in time for the Fall Creators refresh, however, so it's just today that Timeline is making its presentation in the most recent Windows 10 Insider review assemble (and just for those clients who are in the more trial Fast ring, and additionally the individuals who selected in to the Skip Ahead forms). 

The essential thought here is furnish you with a simple to utilize diagram of all your current exercises, be that a record you were dealing with in Word or a site you were taking a gander at in Edge (possibly on an Android telephone), and after that let you get when you return to your PC or your work area in the workplace. Timetable will feature those reports that you'll likely need to take a shot at, yet it additionally will give you a full rundown of your current exercises, sorted out by hour. Cortana, as well, can help you to remember exercises that it supposes you'll likely need to continue as you switch between gadgets. 

On the off chance that you've just introduced the most recent refresh, the new Timeline view will live behind the new Task View symbol in the undertaking bar, or you can achieve it by squeezing the Windows key in addition to tab. 

It's important that application designers do need to unequivocally bolster this element in their applications. At the present time, this implies just perusing in Microsoft Edge and records from Microsoft Office, and also exercises in Windows 10 applications like Maps, News, Money, Sports and Weather, are upheld. 

Other than various updates to the Edge program, another new component that really looks very valuable is Sets (which the organization initially declared a month ago, however just a subset of Insider clients will get this with this discharge). The thought here, Microsoft says, is to give you a chance to gather archives, different documents and applications that have a place with a given assignment and make those accessible to you with a solitary snap. 

Possibly a superior method to think about this is as general tabs that enable you to aggregate applications like Word, OneNote and your program into a solitary window that enables you to switch between exercises simply like you would between program tabs.

Read More

Microsoft Acquires Cycle Computing

Microsoft today declared that it has procured Cycle Computing, a twelve-year-old Connecticut-construct organization that concentrations with respect to helping undertakings coordinate elite processing occupations, expansive information workloads and other "huge figuring" employments in the cloud. The money related subtle elements of the arrangement were not unveiled.

While Microsoft intends to utilize the organization's mastery to enhance its Azure administration for these sort of top of the line workloads, Cycle Computing's lead CycleCloud benefit constantly bolstered an extensive variety of cloud and on-premises stages, including AWS and the Google Cloud Platform. Microsoft takes note of that the Cycle Computing tech will enable it to enhance its help for Linux-based superior processing workloads.

Current Cycle Computing clients incorporate any semblance of Novartis, Pacific Life, MetLife and other significant assembling, protection, biotech and media organizations. Cycle Computing, which was bootstrapped and never raised a "genuine" financing round, says that its administration will oversee around a billion center hours of figure this year and that it has grown 2.7x at regular intervals.

"We've just observed hazardous development on Azure in the ranges of computerized reasoning, the Internet of Things and profound learning," Jason Zander, Microsoft's corporate VP of Azure, writes in the present declaration. "As clients keep on looking for speedier, more proficient approaches to run their workloads, Cycle Computing's profundity and aptitude around hugely adaptable applications make them an awesome fit to join our Microsoft group."

Cycle Computing fellow benefactor and CEO Jason Stowe composes that his organization will keep on supporting its current clients, however it's vague if this implies Microsoft will likewise keep on developing help for contending stages. We have connected with Microsoft for illumination and will refresh this post once we hear more.

Read More

Microsoft Unveils A Beautiful Cortana-powered Thermostat

Microsoft is banding together with Johnson Controls to assemble an indoor regulator. The product monster divulged the new GLAS indoor regulator in a YouTube video today. It's worked by Johnson Controls, producers of the main electric room indoor regulator. It gives the idea that GLAS will incorporate a translucent touchscreen show that will enable proprietors to change room temperatures, check vitality utilization and air quality, and see schedule data.

GLAS will keep running on Microsoft's Windows 10 IoT Core working framework, and will have Cortana voice administrations incorporated with the indoor regulator. It's one of the main indoor regulators to incorporate Cortana coordination, after Microsoft uncovered its intends to convey its computerized associate to ice chests, toasters, and indoor regulators. Microsoft takes note of that GLAS has sensors that recognize when you're in the room or not, and the indoor regulator will always screen indoor and outside air quality. These sensors are intended to spare vitality by changing settings on the fly, much like a Nest indoor regulator or the Ecobee4. Johnson Controls' GLAS indoor regulator contrasts from the Nest by including Cortana voice controls, yet contenders like the Ecobee4 do incorporate Alexa fabricated straight in.

Microsoft's special video seems to advertise this as an indoor regulator for organizations and business properties, because of the reality it's intended to be controlled by the organization's Azure cloud administrations. It's not clear if GLAS will be accessible to shoppers, or when the indoor regulator will dispatch. We've contacted Microsoft for more data, and we'll refresh you appropriately.

Read More

Microsoft 70-461 Exam Questions

Question No: 23

You develop a database for a travel application. You need to design tables and other database objects. You create a view that displays the dates and times of the airline schedules on a report. You need to display dates and times in several international formats. What should you do?

A. Use the CAST function.
B. Use the DATE data type.
C. Use the FORMAT function.
D. Use an appropriate collation.
E. Use a user-defined table type.
F. Use the VARBINARY data type.
G. Use the DATETIME data type.
H. Use the DATETIME2 data type.
I. Use the DATETIMEOFFSET data type.
J. Use the TODATETIMEOFFSET function.

Answer: C

Read More

Microsoft 70-461 Exam Questions

Question No: 22

A table named Profits stores the total profit made each year within a territory. The Profits table has columns named Territory, Year, and Profit. You need to create a report that displays the profits made by each territory for each year and its previous year. Which Transact-SQL query should you use?

A. SELECT Territory, Year, Profit,
LEAD(Profit, 1, 0) OVER (PARTITION BY Territory ORDER BY Year) AS PrevProfit FROM Profits

B. SELECT Territory, Year, Profit,
LAG(Profit, 1, 0) OVER (PARTITION BY Year ORDER BY Territory) AS PrevProfit FROM Profits

C. SELECT Territory, Year, Profit,
LAG(Profit, 1, 0) OVER (PARTITION BY Territory ORDER BY Year) AS PrevProfit FROM Profits

D. SELECT Territory, Year, Profit,
LEAD(Profit, 1, 0) OVER (PARTITION BY Year ORDER BY Territory) AS PrevProfit FROM Profits

Answer: C

Read More

Microsoft 70-461 Exam Questions

Question No: 21

You develop a database for a travel application. You need to design tables and other database objects. You create a view that displays the dates and times of the airline schedules on a report. You need to display dates and times in several international formats. What should you do?

A. Use the CAST function.
B. Use the DATE data type.
C. Use the FORMAT function.
D. Use an appropriate collation.
E. Use a user-defined table type.
F. Use the VARBINARY data type.
G. Use the DATETIME data type.
H. Use the DATETIME2 data type.
I. Use the DATETIMEOFFSET data type.
J. Use the TODATETIMEOFFSET function.

Answer: C

Read More

Microsoft 70-461 Exam Questions

Question No: 20

You are developing a database that will contain price information. You need to store the prices that include a fixed precision and a scale of six digits. Which data type should you use?

A. Float
B. Money
C. Smallmoney
D. Numeric

Answer: D

Read More

Microsoft 70-461 Exam Questions

Question: 19

You are writing a set of queries against a FILESTREAM-enabled database. You create a stored procedure that will update multiple tables within a transaction. You need to ensure that if the stored procedure raises a runtime error, the entire transaction is terminated and rolled back. Which Transact-SQL statement should you include at the beginning of the stored procedure?

A. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
B. SET XACT_ABORT OFF
C. SET TRANSACTION ISOLATION LEVEL SNAPSHOT
D. SET IMPLICIT_TRANSACTIONS ON
E. SET XACT_ABORT ON
F. SET IMPLICIT TRANSACTIONS OFF

Answer: E

Read More

Microsoft 70-461 Exam Questions

Question: 18

You develop three Microsoft SQL Server 2012 databases named Database1, Database2, and Database3. You have permissions on both Database1 and Database2. You plan to write and deploy a stored procedure named dbo.usp_InsertEvent in Database3. dbo.usp_InsertEvent must execute other stored procedures in the other databases. You need to ensure that callers that do not have permissions on Database1 or Database2 can execute the stored procedure. Which Transact-SQL statement should you use?

A. USE Database2
B. EXECUTE AS OWNER
C. USE Database1
D. EXECUTE AS CALLER

Answer: B

Read More

Microsoft 70-461 Exam Questions

Question: 17

You develop a Microsoft SQL Server 2012 database.You need to create a batch process that meets the following requirements:Returns a result set based on supplied parameters.Enables the returned result set to perform a join with a table.Which object should you use?

A. Inline user-defined function
B. Stored procedure
C. Table-valued user-defined function
D. Scalar user-defined function

Answer : C

Read More

Microsoft 70-461 Exam Questions

Question: 16

You work as a database administrator at manufacturing company named ABC.com. ABC.com has a SQL Server 2012 database named ProductionDB. The ProductionDB database has a table named Sites that was created using the following Transact-SQL code:CREATE TABLE Sites (SiteID int NOT NULL PRIMARY KEY,Location int NOT NULL,Manager nvarchar(200) NOT NULL,Week smallint NOT NULL,ItemsProduced int NOT NULL )You want to write the Transact-SQL query that returns the number of items produced at each location for each week. In addition, you want the result set to include a column named PrevItemsProduced that holds the number of items produced at each location for the week before.What Transact SQL statement would accomplish this task?

A. SELECT Location, Week, ItemsProduced,LEAD(Items Produced, 1, 0) OVER (PARTITION BY Location ORDER BY Week) ASPrevItems Produced FROM Sites

B. SELECT Location, Week, ItemsProduced,FIRST_VALUE(ItemsProduced) OVER (PARTITION BY Location ORDER BY Week) ASPrevItems Produced FROM Sites

C. SELECT Location, Week, ItemsProduced,LAG(ItemsProduced, 1, 0) OVER (PARTITION BY Location ORDER BY Week) ASPrevItemsProduced FROM Sites

D. SELECT Location, Week, ItemsProduced,LAST_VALUE(ItemsProduced) OVER (PARTITION BY Location ORDER BY Week) ASPrevItemsProduced FROM Sites

E. SELECT Location, Week, ItemsProduced,CUME_DIST( ) OVER (PARTITION BY Location ORDER BY Week) AS PrevItemsProduced FROM Sites

Answer: C

Read More

Microsoft 70-461 Exam Questions

Question: 15

You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of user should you create?

A. User mapped to a certificate
B. SQL user without login
C. Domain user
D. SQL user with login

Answer: C

Read More

Microsoft has its own 'Bing Assistant' bot in the works

Microsoft is building a "caretaker Bing Bot" which is much like the Google Robot recently announced assistant.

Microsoft is building a robotic assistant that, at least on the surface, is very similar to the recently announced Google robot assistant

Called "Bing Bot Concierge," the productivity of the agent will be able to communicate through a variety of platforms conversations, including Skype, Messenger, SMS, WhatsApp and Telegram, a recent study by Microsoft in looking for an engineer to join the team building larval blowfly.

Workstation applications and services Group:
 
 "In Bing Bot Concierge Our team are building a very intelligent productivity of agents that communicates with the user through a platform of discussion as Skype, Messenger, SMS, WhatsApp, telegrams, etc. The agent would a human wizard: runs errands on behalf of the user, by automatically completing tasks for the user users talk with the natural language agent, and the agent answers natural language to gather all the information, once ready, it automatically. the task of the user by connecting to service providers, for example, the user can request "I make a reservation for one night Italian restaurant", and the agent will respond. for how many people '; after several such results back to confirm and book the restaurant that the user has chosen. "

Microsoft officials showed progress in a series of robots built with disposable Bot part of Microsoft, which is currently available in draft form at the company's Build conference in late March. Microsoft began Bot fill your directory with a number of robots developed by the company image as Bing Bot Bot Bot Bot Music Legend Summarize and Bing.

Earlier this week, Kik Interactive has announced that there is now an official channel Kik available on the Microsoft Bot connector. Kik is an email application that is widely used by teenagers and pre-teens.

From May 18 Kik blog about their work with Microsoft:

"After a month of close collaboration between the platform teams of Microsoft bot Kik and engineers, it is now possible for new and existing developers Bot executives have their robots work Kik with minimal effort."

In the same way that the Google search engine Google is able to feed Wizard, Bing is the secret ingredient for new and upcoming Microsoft robots.

In the same way that the Google search engine Google is able to feed Wizard, Bing is the secret ingredient for new and upcoming Microsoft robots.

The Bing team has developed a series of cognitive services and applications that Microsoft programming interfaces is available to bots manufacturers. Some of them include academic programming knowledge interface; interactive search structured data; entity relationship between services; recommendations; image search and news; and the Microsoft Translator service.

The Bing team also led the charge on the way to discern the intentions of users. For this, a service must be understood as a place of fields, time and others. (This is where Cortana received a lot of intelligence.) From Microsoft "Satori" - similar to the graphic knowledge of Google - is what helps translate search queries in a database of entities and relationships between entities data .

Because of its roots in the business world, Microsoft has also increased the knowledge of the entities associated with the activity around areas such as documents and meetings to help with users bots queries like "remind me to send my They document boss I was working last night. "

However, the company also has accumulated more / general knowledge entity consumers through searches using Bing and Cortana in areas such as sports, politics, entertainment and more.

I asked Microsoft for more information on Bot and Bing Concierge update this post if and when I hear back. I am particularly interested in whether the Bing Bot Concierge will be something that the powers of other robots under Microsoft Bot propulsion, or if it will be something that users interact directly.

Read More

Microsoft 70-461 Exam Questions

Question: 14

You develop a Microsoft SQL Server 2012 server database that supports an application.
The application contains a table that has the following definition:
CREATE TABLE Inventory (ItemID int NOT NULL PRIMARY KEY, ItemsInStore int NOT NULL, ItemsInWarehouse int NOT NULL) You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row. The new column is expected to be queried heavily, and you need to be able to index the column. Which Transact-SQL statement should you use?

A. ALTER TABLE Inventory
ADD TotalItems AS ItemslnStore + ItemsInWarehouse

B. ALTER TABLE Inventory
ADD TotalItems AS ItemsInStore + ItemsInWarehouse PERSISTED

C. ALTER TABLE Inventory
ADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse) PERSISTED

D. ALTER TABLE Inventory
ADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse)


Answer: B

Read More

Microsoft 70-461 Exam Questions

QUESTION 13

You are a database developer at an independent software vendor. You create stored procedures that contain proprietary code.
You need to protect the code from being viewed by your customers.
Which stored procedure option should you use?

A. ENCRYPTBYKEY
B. ENCRYPTION
C. ENCRYPTBYPASSPHRASE
D. ENCRYPTBYCERT

Answer: B

Read More

Microsoft 70-461 Exam Questions

QUESTION 11

You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters. What should you do?

A. Use the CAST function.
B. Use the DATE data type.
C. Use the FORMAT function.
D. Use an appropriate collation.
E. Use a user-defined table type.
F. Use the VARBINARY data type.
G. Use the DATETIME data type.
H. Use the DATETIME2 data type.
I. Use the DATETIMEOFFSET data type.
J. Use the TODATETIMEOFFSET function.

Answer: E

Read More

Microsoft 70-461 Exam Questions

QUESTION 10

You develop a database for a travel application. You need to design tables and other database objects.
You create the Airline_Schedules table.
You need to store the departure and arrival dates and times of flights along with time zone information.
What should you do?

A. Use the CAST function.
B. Use the DATE data type.
C. Use the FORMAT function.
D. Use an appropriate collation.
E. Use a user-defined table type.
F. Use the VARBINARY data type.
G. Use the DATETIME data type.
H. Use the DATETIME2 data type.
I. Use the DATETIMEOFFSET data type.
J. Use the TODATETIMEOFFSET function.

Correct Answer: I

Read More

Microsoft 70-461 Exam Questions

QUESTION NO: 9

You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation.
You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?

A. CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP EXISTING
B. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE
C. ALTER INDEX ALL ON OrderDetail REBUILD
D. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD


Correct Answer: B

Read More

Microsoft 70-461 Exam Questions

QUESTION NO: 8

Your database contains a table named Purchases. The table includes a DATETIME column named
PurchaseTime that stores the date and time each purchase is made. There is a non- clustered index on the
PurchaseTime column.
The business team wants a report that displays the total number of purchases made on the current day.
You need to write a query that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?

A. SELECT COUNT(*)
FROM Purchases
WHERE PurchaseTime = CONVERT(DATE, GETDATE())
B. SELECT COUNT(*)
FROM Purchases
WHERE PurchaseTime = GETDATE()
C. SELECT COUNT(*)
FROM Purchases
WHERE CONVERT(VARCHAR, PurchaseTime, 112) = CONVERT(VARCHAR, GETDATE(), 112)
D. SELECT COUNT(*)
FROM Purchases
WHERE PurchaseTime >= CONVERT(DATE, GETDATE())
AND PurchaseTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))

Answer: D

Section: (none)
Explanation

Explanation/Reference:
Explanation:
Two answers will return the correct results (the "WHERE CONVERT..." and "WHERE ... AND ... "answers).
The correct answer for Microsoft would be the answer that is most "efficient". Anybody have a clue as to
which is most efficient? In the execution plan, the one that I've selected as the correct answer is the query
with the shortest duration. Also, the query answer with "WHERE CONVERT..." threw warnings in the
execution plan...something about affecting CardinalityEstimate and SeekPlan.
I also found this article, which leads me to believe that I have the correct answer:
http://technet.microsoft.com/en-us/library/ms181034.aspx

Read More

Microsoft begins To Publicly Launch Of Window 10 Share Points

Microsoft today launched a website dedicated to keeping track of Windows 10 Release Notes. For more features, improvements and changes the company has grown, now you can only visit the historic upgrade Windows 10.

"After listening to comments on the level of disclosure for Windows 10 updates, we decided to implement a new communication system, which updates the operating system," a Microsoft spokesperson told VentureBeat. "We now present the historical update Windows 10, a center for the release notes that accompany each update and serve as a historical record of notes from the previous version."

The "feedback" that Microsoft refers to fund amounts to complaints from users of Windows 10 who wanted to know more about what the company pushed to their devices. In the future, each updating of the list is a summary of significant developments with links to product details.

Because Windows 10 updates are cumulative, you may need to scroll down a bit to find exactly when something has changed. For now, Microsoft lists only two changes (also released today as part of the monthly Patch Tuesday cycle of Microsoft), as there are two windows 10 branches:

The first part of July launch (build 10240) and updated in November (build 10586) branch. We have introduced new features of the operating system in November after seeing, or "flighted", insiders with windows between July and November. Most customers have moved automatically from July to November Rama Rama. Windows 10 Professional, Enterprise and Education customers publishers may postpone updating the branch in November and stay in the SET's role in July - up to 10 years for some corporate customers.

Windows 10 is a service. As we wrote in our deep dive into how Microsoft is still working on Windows 10, Windows are started then new construction, even if the operating system launched in July 2015.

Read More