Thursday, 10 January 2019

Microsoft 70-461 Question Answer

You use Microsoft SQL Server 2012 to develop a database application.
You create a table by using the following definition:
ActualPrice NUMERIC(16,9),
PredictedPrice NUMERIC(16,9)
You need to create a computed column based on a user-defined function named udf_price_index. You also need to ensure that the column supports an index.
Which three Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and
arrange them in the correct order.)
Select and Place:


Tuesday, 11 September 2018

Microsoft 70-461 Question Answer


You use Microsoft SQL Server 2012 to develop a database application.
You create two tables by using the following table definitions.

Which six Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)

Select and Place:


Wednesday, 21 February 2018

The Microsoft Design Decisions That Caused this Mess

I do not need to spend much space on the merits of the United States v. Microsoft, the case on the extraterritoriality of the email search guarantees that the Supreme Court will decide this term, because Judge Lynch of the Second Circuit, in his concurring opinion in the court below, said almost everything he said.

This is a much closer case that Microsoft or its supporters particularly claim because all those who once litigated the Stored Communications Act ("SCA") understand that their orders operate more like citations than traditional search warrants. This supports the government's arguments, because the lower courts have imposed citations that order companies to present documents in their "possession, custody or control", even if they are stored in another country.

On the other hand, like Judge Lynch, I recognize that even if the Tribunal treats these orders as subpoenas, it could still fail against the United States. The rule that the Court has established in the past (which is free to change or abandon in this case) would seek the "focus" of the SCA, an outdated and notoriously complex statute. In fact, the Court would be more successful in seeking the "focus" of a pile of mulch. There is a high likelihood that, under this focus analysis, the United States will lose and, if so, Congress will have to respond to preserve the ability of law enforcement to access e-mail in many major criminal investigations.

I want to make two comments on the broader context of this case. First of all, it is important to highlight the technical design choices that Microsoft made and could have prevented that led directly to this turbulent international conflict. Second, Microsoft's actions can be read as a secondary declaration of independence from the rule of law, a statement that recruits us all as unwitting revolutionaries.

Microsoft caused this disaster

Like many others who have commented, what I think ultimately about this specific case revolves almost entirely on facts that the judiciary has so far ignored: the nationality and residence of the owner of the email account. If it is a suspicious US drug trafficker operating within the territorial limits of the United States, which is being investigated by the US authorities, using the email provided by a US corporation, then the fact that the owner clicked on a Check box when you created your account should not raise this case to the international incident level. On the other hand, if this case involves an Irish citizen, sitting in Ireland, who clicked on that checkbox honestly, then this becomes much more complicated and more important.

I understand why the courts have not insisted on knowing the answer to the question of nationality. The procedural position of this case - an appeal of a contempt judgment that results after a denial of an annulment motion - means that the proceedings are tentative, wrapped up in the necessary secrecy and without the participation of the person whose nationality and residence we want know, and who, after all, has not yet been accused of any crime, and may never be.

The Supreme Court or Congress could feel differently. Anyone could elaborate a new rule insisting that in cases like this, the parties would be forced to share their best assumptions about the country where the owner of an email account is located, perhaps as part of a multifactorial balance test that try to account for interests of international courtesy.

I hope this happens, as it will shed light on the fact that Microsoft intentionally designed its service in a way that allows users to decide where to store their records and led directly to this disaster.

In the debates on technological and political law, we tend too much to consider the current state of technology as fixed, static and not subject to debate by politics. It is just the product of an intimate and secret conversation between corporations and the invisible hand - pillow talk for the whole Chicago School. This attitude reflects, in part, the hard work of libertarians who continually intimidate the rest of us with the idea that we have to think that technology is "granted to" instead of "created by" ordinary human beings.

Microsoft could have taken some very small steps when it created its first data center outside of the United States that could have told us with much greater certainty the location of the target in this case. If it had, the company could have avoided what is correctly understood as a crisis of manufactured international relations. More importantly, instead of letting users choose the data centers where they store their email messages, Microsoft could have answered that question by making a guess based on the user's IP address, the configuration of language and measured network latency. After all, the company continues to proclaim that its only goal was to reduce network latency. If that is true, why did not the company choose to place each user in the data center with the least network latency?

By not making this simple architectural choice, Microsoft made this case much more difficult than it could have been, even if that was not their intention. If Microsoft had designed to hinder its location in one part of the world while storing communications in another, then a legal rule for access to e-mail could have been designed that would better balance the need to investigate crime while respecting the user. rights and international relations. Under such a rule, first, FBI agents would use a citation to learn from Microsoft the data center used to store a particular account. If this throws a response that the data was within the United States, I would suggest a search warrant. If it were answered that the data were in Europe, a mutual legal assistance treaty (MLAT) request would be in order.

Declare the independence of Microsoft's declaration of independence

There is another issue at play here. The corporate globalists of today are not like yesterday's. Oil tycoons and railroad magnates traded in atoms instead of bits and, as a result, were forced to pay attention to national borders and local rules. This does not mean that they always respected those rules, but at least they had to attend to them. Uber-for all its fundamentally corrupt practices-looks more like iron giants in this respect, fighting and trampling local rules wherever they expand. On the contrary, Microsoft (and Facebook and Google) circumvent the local rule and the rule of law in a much more subtle but equally destructive way: they act as if the global telecommunications network meant that the borders of the world simply do not apply to them , and design their services in ways that frustrate local oversight and transparency.

We know and can oppose what Uber is trying to do; It is more difficult to understand what bit providers do. If we do not start questioning the technological design choices of companies like Microsoft, as I tried to do in this blog post, they could get away with erasing the limits of our maps.

I think it's also useful to think about Microsoft's actions in this case in a different, even more pernicious, light. Microsoft's entire course of conduct - from setting up its remote data centers in a way that allows users to select where to place their data to sue the federal government for seeking an order to investigate a drug-related crime - could be considered a Tactic that is not about respecting the rules of Ireland or the United States or the rights of the Irish or the Americans. It is perhaps part of a much more cynical and pernicious movement to declare the independence of the "tired giant of flesh and steel", echoing the giant John Perry Barlow, who died the day I wrote these words. But the difference between Barlow and Microsoft is the person with the pen. Barlow wrote genuinely about a user's revolution against terrestrial states. That is something very different from being dragged into the revolution by benevolent corporate governors.

This seems more East India Company than Thomas Paine. Revolutions should not be declared by corporations, they should reflect the will of the people, in this case, the users. I am a user, like all of you, and I do not remember registering for the Microsoft revolution. I live in a (mainly) functional democracy; I choose representatives and pay taxes in part to ensure that my wishes are reflected in my society. For me, one thing I need to safeguard is a law enforcement agency with the power to investigate crimes and protect the rule of law. Microsoft also lives here, and could redesign its services to avoid thwarting local government and inflaming international conflict. Maybe Congress should force him to do it. But we, the users, we citizens, should not misinterpret who is to blame for this disaster.

Wednesday, 20 December 2017

Microsoft 70-461 Question Answer

You create the following stored procedure. (Line numbers are included for reference only.)

You need to ensure that the stored procedure performs the following tasks:
If a record exists, update the record.
If no record exists, insert a new record.
Which four Transact-SQL statements should you insert at line 07? (To answer, move the appropriate statements from the list of statements to the answer area and
arrange them in the correct order.)

Select and Place:


Monday, 6 November 2017

Microsoft 'Black Friday' 2017: Early Windows Laptop, Surface Pro, Xbox One Deals

Microsoft MSFT + 0.4% is not about to be excluded from Black Friday 2017. Gatecrash the first deals of its rival Samsung, as well as most of the larger retailers (see my cover here for: Amazon, Kohl, Target, Walmart and Best Buy), Microsoft offers significant discounts on some of its most popular products, such as Surface Pro, Surface Laptop and Xbox.

But are businesses good? Here is my Microsoft Black Friday 2017 guide to help you achieve the greatest savings:

 Note: I thank who worked with me to gather these offers and create order from the inevitable annual chaos.

Microsoft Black Friday 2017 Tips:
Microsoft, like Samsung, will have agreements during November and December and not only during Black Friday or Cyber Monday. Next, I will reveal some of the best current sellers. In addition to buying from the Microsoft Store at, be sure to keep Amazon, Best Buy, Kohl's and Target on your list of potential locations to find your favorite Microsoft product. All of these merchants will have the most popular Microsoft products, including Office 365, Surface Pro and Xbox One S, while all eyes will be on the Xbox One X.

When you buy the Microsoft article on your list, be sure to look for additions and incentives to gift cards that will make the offer even more attractive. For example, I just revealed that Target will offer customers a $ 25 Target gift card when they purchase a 500GB Xbox One S console. It is known that Best Buy makes similar offers, so be sure to monitor that when you reveal to Best Buy the best sellers of your Black Friday advertising leak later this week.

While the Microsoft store has some stores, its Black Friday and Cyber Monday sales are usually concentrated online. Do not forget to check the page of (link) because I suspect that you will begin to reveal the sales of Black Friday and Cyber Monday before November 15th.

If you're looking for a Windows PC, do not overlook Microsoft's Black Friday and Cyber Monday sales. Last year, there were offers for Dell Inspiron laptops and notebooks for Alienware games. The first still has a model for sale, see below.

The best technical offers prior to the sale of Samsung Black Friday 2017

All prices are correct at the time of publication: save on some Xbox One consoles and get two free games of your choice (value up to $ 99) - product link Save up to $ 400 on laptops, desktop computers and games: product link - Surface Pro Essentials Kit (save up to $ 159) - product link - Surface Laptop Essentials package (save up to $ 109) - product link - Studio Surface Kit (save up to $ 99) - product link - Dell Inspiron 15 i5567-3654GRY laptop for $ 499 (save $ 200) - product link - Huawei MateBook Signature Edition 2 in 1 PC, 128 GB / Intel Core m5 for $ 849 (save $ 350) - product link

    Kohl's - Microsoft Xbox One S 500GB Console + $ 45 Kohl's Cash for $ 189.99 (save $ 90) - product link

    Walmart - Choice of 500GB Xbox One S console with bonus game and Microsoft driver for $ 279 (save $ 108.88) - product link
    Target - Scorpion Xbox One X Edition 1 TB (pre-order) for $ 499.99 - product link

What you see above is only the beginning. Microsoft will be great this Black Friday and Cyber Monday both in their own retail stores and through Amazon, Best Buy, Kohl, Sam's Club, Target and Walmart.

I will follow the best offers from Microsoft and all these stores throughout the month of November throughout the shopping period of Black Friday and Cyber Monday. Mark my page and return regularly to see the latest offers with my daily updates. This is going to be the biggest online shopping season in history.

Monday, 11 September 2017

Microsoft 70-461 Question Answer

You use Microsoft SQL Server to develop a database application.
You create a stored procedure named usp_calculategrowth. The stored procedure modifies
rows and can result in several different exceptions.
You need to ensure that when the stored procedure is executed, the following requirements
are met:

Which six Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)


Wednesday, 14 June 2017

Microsoft 70-461 Question Answer

You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerID.
You need to create a query that meets the following requirements:
Returns the CustomerName for all customers and the OrderDate for any orders that they have placed. Results must include customers who have not placed any orders.
Which Transact-SQL query should you use?

A. SELECT CustomerName, OrderDate
FROM Customers
ON Customers.CustomerID = Orders.CustomerID
B. SELECT CustomerName, OrderDate
FROM Customers
JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
C. SELECT CustomerName, OrderDate
FROM Customers
ON Customers.CustomerID = Orders.CustomerID
D. SELECT CustomerName, OrderDate
FROM Customers
ON Customers.CustomerID = Orders.CustomerID

Answer: D

You create a stored procedure that will update multiple tables within a transaction.
You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back.
Which Transact-SQL statement should you include at the beginning of the stored procedure?


Answer: A