The big question rises how to become the Microsoft certified , All Microsoft certifications are acquired by simply taking a series of exams. If you can self-study for said exams, and then pass them, then you can acquire the certification for the mere cost of the exam (and maybe whatever self-study materials you purchase).
You’ll also need, at minimum (in addition to the MCTS), the CompTIA A+, Network+ and Security+ certs; as well as the Cisco CCNA cert.
Microsoft Certified Technology Specialist (MCTS) – This is the basic entry point of Microsoft Certifications. You only need to pass a single certification test to be considered an MCTS and there are numerous different courses and certifications that would grant you this after passing one. If you are shooting for some of the higher certifications that will be discussed below, then you’ll get this on your way there.
Microsoft Certified Professional Developer (MCPD) – This certification was Microsoft’s previous “Developer Certification” meaning that this was the highest certification that was offered that consisted strictly of development-related material. Receiving it involved passing four exams within specific areas (based on the focus of your certification). You can find the complete list of courses and paths required for the MCPD here.
Microsoft Certified Solutions Developer (MCSD) – This is Microsoft’s most recent “Developer Certification” which will replace the MCPD Certification (which is being deprecated / retired in July of 2013). The MCSD focuses within three major areas of very recent Microsoft development technologies and would likely be the best to persue if you wanted to focus on current and emerging skills that will be relevant in the coming years. You can find the complete list of courses and paths required for the MCSD here.
The Microsoft Certifications that you listed are basically all of the major ones within the realm of development. I’ll cover each of the major ones and what they are :
Most people, however, take some kind of course. Some colleges — especially career and some community colleges — offer such courses (though usually they’re non-credit). Other providers of such courses are private… some of them Microsoft Certified vendors of one type or another, who offer the courses in such settings as sitting around a conference table in their offices. Still others specialize in Microsoft certification training, and so have nice classrooms set up in their offices.
There are also some online (and other forms of distance learning) courses to help prepare for the exams.
The cost of taking classes to prepare can vary wildly. Some are actually free (or very nearly so), while others can cost hundreds of dollars. It all just depends on the provider.
And here’s a Google search of MCTS training resources (which can be mind-numbing in their sheer numbers and types, so be careful what you choose):
There are some pretty good, yet relatively inexpensive, ways to get vendor certificate training. Be careful not to sign-up for something expensive and involved when something cheaper — like subscribing to an “all the certificates you care to study for one flat rate” web site — would, in addition to purchasing a study guide or two at a bookstore, likely be better.
If you want a career in IT, then you need to have both an accredited degree in same (preferably a bachelors over an associates), and also a variety of IT certifications. The MCTS is but one that you will need.
You should probably also get the Microsoft MCSE and/or MCSA. The ICS CISSP. And the ITIL.
There are others, but if you have those, you’ll be evidencing a broad range of IT expertise that will be useful, generally. Then, in addition, if the particular IT job in which you end-up requires additional specialist certification, then you can get that, too (hopefully at the expense of your employer who requires it of you).
Then, whenever (if ever) you’re interested in a masters in IT, here’s something really cool of which you should be aware…
There’s a big (and fully-accredited, fully-legitimate) university in Australia which has partnered with Microsoft and several other vendors to structure distance learning degrees which include various certifications; and in which degrees, considerable amounts of credit may be earned simply by acquiring said certifications. It’s WAY cool.
One can, for example, get up to half of the credit toward a Masters degree in information technology by simply getting an MCSE (though the exams which make it up must be certain ones which correspond with the university’s courses). I’ve always said that if one were going to get an MCSE, first consult the web site of this university and make sure that one takes the specific MCSE exams that this school requires so that if ever one later decided to enter said school’s masters program, one will have already earned up to half its degree’s credits by simply having the MCSE under his/her belt. Is that cool, or what?
I wouldn’t rely on them over experience (which is far and away the most valuable asset out there) but they are worth pursuing especially if you don’t feel like you have enough experience and need to demonstrate that you have the necessary skills to land a position as a developer.
If you are going to pursue a certification, I would recommend going after the MCSD (Web Applications Track) as it is a very recent certification that focuses on several emerging technologies that will still be very relevant (if not more-so) in the coming years. You’ll pick up the MCTS along the way and then you’ll have both of those under your belt. MCPD would be very difficult to achieve based on the short time constraints (passing four quite difficult tests within just a few months is feasible, but I don’t believe that it is worth it since it will be “retired” soon after).
No job experience at all is necessary for any of the Microsoft Certifications, you can take them at any time as long as you feel confident enough with the materials of the specific exam you should be fine. The tests are quite difficult by most standards and typically cover large amounts of material, but with what it sounds like a good bit of time to study and prepare you should be fine.
Certifications, in addition to degrees, are so important in the IT field, now, that one may almost no longer get a job in that field without both. The certifications, though, are so important that one who has a little IT experience can get a pretty good job even without a degree as long as he has all the right certs. But don’t do that. Definitely get the degree… and not merely an associates. Get the bachelors in IT; and make sure it’s from a “regionally” accredited school.
Then get the certs I mentioned (being mindful, if you think you’ll ever get an IT masters, to take the specific exams that that Strut masters program requires so that you’ll have already earned up to half the credit just from the certs).
If you already have two years of experience in working in the .NET environment, a certification isn’t going to guarantee that you will get employed, a salary increase or any other bonuses for achieving the honor. However, it can help supplement your resume by indicating that you are familiar with specific technologies enough to apply them in real-world applications to solve problems.
If your ready for career change and looking for Microsoft MCTS Training, Microsoft MCITP Training or any other Microsoft Certification preparation get the best online training from Certkingdom.com they offer all Microsoft, Cisco, Comptia certification exams training in just one Unlimited Life Time Access Pack, included self study training kits including, Q&A, Study Guides, Testing Engines, Videos, Audio, Preparation Labs for over 2000+ exams, save your money on boot camps, training institutes, It’s also save your traveling and time. All training materials are “Guaranteed” to pass your exams and get you certified on the fist attempt, due to best training they become no1 site 2012.
You work for a company named ABC.com. Your role of Lync Administrator includes the
management of the Microsoft Lync Server 2013 infrastructure.
Two Windows Server 2012 servers named ABC-DB01 and ABC-DB02 run SQL Server 2012.
ABC-DB01 and ABC-DB02 host a mirrored database for the Lync Server Central Management
Store (CMS). ABC-DB01 currently has the principle database and ABC-DB02 currently has the
mirror database. The mirrored database does not use a witness instance.
You need to manually failover the mirrored database to enable you to perform maintenance on
Which of the following Windows PowerShell cmdlets should you run?
You work for a company named ABC.com. The company has a Microsoft Lync Server 2013
infrastructure that includes two Lync Server pools. Your role of Lync Administrator includes the
management of the Microsoft Lync Server 2013 infrastructure.
An Edge server named ABC-Edge1 is configured to use a pool named ABC-LyncPool1.ABC.com
as its next hop. You plan to failover to a second pool named ABC-LyncPool2.ABC.com. Before
failing over the pool, you need to reconfigure the next hop for ABC-Edge1 to be ABCLyncPool2.
Which of the following Windows PowerShell cmdlets should you run?
B. Set- CsAVEdgeConfiguration
You work for a company named ABC.com. The company has two Active Directory sites in a
single Active Directory Domain Services domain named ABC.com. Your role of Lync
Administrator includes the management of the Microsoft Lync Server 2013 infrastructure.
The Lync infrastructure consists of a single pool named ABC-LyncPool1.ABC.com.
You have been asked to design a disaster recovery (DR) plan in the event of a failure of ABCLyncPool1.
ABC.com. Part of the DR plan would be to configure a backup pool.
Which three of the following Windows PowerShell cmdlets would you need to run to recover the
CMS (Central Management Store) and the Lync user accounts? (Choose three)
You work for a company named ABC.com. The company has a single Active Directory Domain
Services domain named ABC.com. The company has a datacenter located in New York.
The New York datacenter hosts two Microsoft Lync Server 2013 pools named ABCLyncPool1.
ABC.com and ABC-LyncPool2.ABC.com. ABC-LyncPool1.ABC.com hosts the CMS
(Central Management Store). All of the company’s 70,000 users are enabled for Lync. Your role
of Lync Administrator includes the management of the Microsoft Lync Server 2013 infrastructure.
The servers in ABC-LyncPool1.ABC.com suffer irreparable hardware failure. You need to recover
the Lync environment by failing over ABC-LyncPool1.ABC.com. All users will be hosted
permanently on ABC-LyncPool2.ABC.com.
Which of the following Windows PowerShell cmdlets should you run? (Choose all that apply)
You work for a company named ABC.com. Your role of Lync Administrator includes the
management of the Microsoft Lync Server 2013 infrastructure.
You receive reports from users that they are sometimes unable to make outbound calls. You
discover that the failures are caused by there being no available trunks.
To help troubleshoot the issue, you plan to run performance monitor counters to monitor the total
number of calls and the total number of inbound calls to determine trunk usage.
Against which server should you run the performance monitor counters?
A. Edge Server
B. Front End Server
C. Database Server
D. Mediation Server
The world’s most popular OS exits ‘mainstream’ support Jan. 13, marks midpoint of 10-year support lifetime
Windows 7 will reach the midpoint of its support lifetime this week when it shifts from what Microsoft calls “mainstream” to “extended” support.
The world’s most popular personal computer operating system exits mainstream support on Tuesday, Jan. 13. After that, although Microsoft will continue to issue security updates to all users for another five years, it will not add new features to Windows 7, and any non-security fixes — such as reliability and stability updates — will be issued only to organizations that have signed support contracts.
Next week thus marks the halfway point of Windows 7’s decade-long support stretch, which ends Jan. 14, 2020.
Windows 7 will continue to run, of course: The migration into extended support does not make it inoperable.
Windows 7’s user share is at a near-record high. In December, it accounted for 56% of all personal computer operating systems, and 62% of all versions of Windows. Since the debut of Windows 8, its purported successor, Windows 7 has increased its user share by about 12 percentage points, representing a gain of 26%.
That increasing share may not bother Microsoft, but it should businesses that decommissioned Windows XP PCs and replaced them with Windows 7 systems, ignoring Windows 8. With Windows 7’s life half over, those enterprises now have five years to complete a transition to another OS, probably Windows 10, the upgrade Microsoft will release this fall.
Five months ago, in fact, Gartner began urging corporations to start their post-Windows 7 planning if they wanted to prevent a recurrence of the end of Windows XP’s support, when many had to either hustle to make the support deadline, or worse, continued running the aged OS after patching ended.
“While this feels like it’s a long way off, organizations must start planning now,” said Gartner analysts Michael Silver and Stephen Kleynhans in August.
And the failure of Windows 8 to win enterprise hearts and minds has created one oddity: Even though Windows 7 has made middle age, Microsoft continues to let OEMs (original equipment manufacturers) sell PCs running the business edition.
Microsoft has yet to name an end date for OEM sales of machines powered by Windows 7 Professional. But because it has promised a 12-month notice, those PCs can still be sold at least until early January 2016, when the OS has but four years of life left.
With the new technologies coming in the market every other day, life has become advanced these days. In this modern era, you have to be on your toes all the time especially if your career in related to the field of IT: one has to stay updated with all the latest programs and their features in order to stay ahead of his peers. For instance, there was a time when Gramophone was the invention of the century but then it was replaced with mobile phones. Similarly, the invention of television and radio created quite a heap in the early 20th century but later on, the thunder was stolen by computers in the late 20th century.
In this day and age, computers and internet have become the center of attention. Consequently, IT has become the most popular field. IT experts are quite in demand these days; but with the emergence of new programs every other day, they have to keep up with the latest technology in order to stay ahead in the race. One way of staying ahead is the certification courses. These courses ensure that the candidate has attained all the latest knowledge and is ready to roll in the world of technology.
This article will discuss some of the most popular certification courses offered by Microsoft.
Microsoft Technology Associate
This is a certification course designed for the starters: people who want to start their line of business in the field of technology. Accordingly, it tests the fundamentals of IT and validates that the candidates have a basic understanding of the essentials. This course has been divided into three tracks and the candidates can choose any one of the tracks, depending on their preference. The tracks are: IT infrastructure, Database Design and Developer.
Microsoft MCSA- Windows Server 2008
This exam is designed for the IT personnel and it validates their skills in Server Networking management. IT professionals and System Administrators are suggested to take MCSA- Windows Server 2008 exam especially if they are looking forward to earning their MCSE certification.
Microsoft MCSA- Windows Server 2012
This certification exam is an advanced level exam which validates that the candidates have sufficient knowledge of Windows Server 2012 for its proper installation, configuration and working. MCSA- Windows Server 2012 certified can easily get the position of Network Administrator, Computer Systems Administrator or Computer Network Analyst.
Microsoft MCSE- Server Infrastructure
This certification course is designed for IT experts and it will get you the title of ‘Solutions Expert’. It tests individual’s skills in effectively and efficiently running a modern data center with some experience in virtualization storage and networking, identity management and systems management.
Microsoft MCSE- Desktop Infrastructure
This course validates that the individuals can manage desktops and devices, while maintaining their security and integrity, from anywhere around the globe. It also tests individuals’ expertise in application and desktop virtualization together with remote desktop services. With this certification in hand, you can easily qualify for a job of Data and Application Manager or Desktop and Device Support Manager.
Microsoft MCSE- Messaging
This certification is an expert level certification and it validates that the applicant has relevant skills in order to increase user productivity and flexibility. It also validates that the person has sufficient knowledge as to how to improve data security and reduce data loss. After passing this certification exam, candidates can easily qualify for the position of Network and Computer System Administrator.
Microsoft MCSE- Communication
This certification validates candidates’ expertise in using Lync Server to create an effective communication path that can be accessed from all around the globe. This certification is also an expert level certification and you can easily qualify for the position of Network and Computer System Administrator with it.
Microsoft MCSE- SharePoint
This Microsoft Certified Solutions Expert certification course verifies that the candidates have the necessary expertise to share, synchronize and organize the data across the organization. SharePoint 2013 is the updated version of Microsoft Office, and passing this certification can get you a job of Systems or Network Analyst.
Microsoft MCSD- SharePoint Application
This Microsoft Certified Solutions Developer certification course is another of expert level certification courses which validates individuals’ expertise in web programming. It also requires the individuals to design and develop applications with Microsoft SharePoint. With this certification, you can easily secure the position of Software Developer or Web Developer.
Microsoft Private Cloud
MCSE- Private Cloud certification course tests candidates’ expertise to manage Private Cloud computer technologies. It also verifies that the candidate can implement these technologies in a way to optimize service delivery. You can easily get the position of Server Administrator and Network Manager with this certification on your resume.
Microsoft System Center Configuration Manager
Microsoft System Center Certification focuses on the skills to manage computer and clients. The candidates should be able to configure, administer and deploy System Center 2012 in order to pass this exam. You can earn the title of Microsoft Certified Technology Specialist through this certification.
Microsoft Server Virtualization
This certification verifies that the candidate is familiar with Server Virtualization, both on Windows Server and System Center. This course expands individual’s expertise and skills in order for him to meet the rapidly modernizing technological business needs, and it can get him the title of Microsoft Specialist in no time.
Microsoft Office Certifications
Microsoft offers many certifications that verify candidates’ skills in handling and using Microsoft Office Applications. These certifications start from beginners level and go up to the master level. Microsoft Office Specialist is a beginner level certification whereas Microsoft Office Specialist Expert is an advanced level certification. Last but not the least; Microsoft Office Specialist Master is a master level certification.
Microsoft MCSA- Office 365
This course focuses on individual’s skills in handling Office 365 together with productivity tools and cloud-based collaboration. This certification can easily get you the position of Cloud Application Administrator or SaaS Administrator.
This Microsoft Certified Technology Specialist certification confirms an individual’s expertise in Microsoft dynamics: a specific module can be chosen for this certification. However, this certification will be withdrawn from the market, at the end of this year, and replaced with the new ones.
Some countries that can’t get Surface Pro 2 yet never will, Microsoft says.
Microsoft says that in some countries where its Surface Pro 2 tablet is not yet available, it never will be; the Surface Pro 3 will have to do.
Rather than introduce the device then end-of-life it within months, the company will skip the earlier version of the device altogether in those countries and go with the newer model announced last week, says Cyril Belikoff, the director of Surface marketing at Microsoft.
Presented by Riverbed Technology
10 Common Problems APM Helps You Solve
Practical advice for you to take full advantage of the benefits of APM and keep your IT environment
That still means at least months of waiting for those countries that don’t yet have access to Surface Pro 2 despite its being available in the U.S. since last October. The newer Surface Pro 3 ships first in the U.S. and Canada June 20, and then to 31 other regions into which Microsoft divides the world. But that won’t be for two or three months at the earliest, Belikoff says.
The unavailability of the device rankles some in countries where it’s not sold. For example, a participant in a Reddit Ask Me Anything session this week, Deniz Yakamoz wanted to know when Surface would be available in her country, Turkey. The answer, written by the Surface Team in Turkish and translated by another AMA participant, was, “Since our plans aren’t finalized, I definitely can’t answer your question, but be certain it’s at the top of my list.”
Belikoff says that demand for Surface Pro 2 in countries where it is already available is strong enough that Microsoft will continue selling it and not relegate it to end-of-life.
Surface Pro 3 is larger (12-inch screen v. 10.5-inch) and has more processor options. Surface Pro 2 comes with Intel Core i5, while Surface Pro 3 has options for i3, i5 and i7 processors.
Meanwhile the company has put Surface Pro 2 on sale in the U.K., according to a ZDNet report by dropping the price of the 64GB version from 771 pounds to 569 pounds, although it’s unclear whether that’s to reduce inventory in anticipation of Surface Pro 3 demand.
Belikoff says in the Surface Blog that corporate customers Avande, BMW Group, The Coca-Cola Company, Louis Vuitton Moët Hennessy and Seattle Children’s Hospital have chosen Surface Pro 3 as one of the devices their organizations issue. Despite the devices being unavailable for a month, they have committed to deploying between hundreds and thousands of them to select groups within the companies, he says.
Anti-malware vendors advise about downloaders used to infect PCs
Microsoft is placing makers of downloader software on observe when it sees that their softwares are getting used to infect PCs, and it is effective anti-virus vendors that maybe these downloader agenda ought to be tagged as malware.
In its latest Security Intelligence Report the corporation comments that the use of previously benign downloaders has ever more become a means to infect computers with malware, mainly click-fraud programs and ransomware in which assailant extort cash from wounded in return for return their equipment to a useful state.
As part of its manufacturing teamwork, Microsoft shares the data it gathers from its clients about infections with related parties. In this case it tells the downloader makers in hopes they can restrict use of their products to legitimate purposes.
It tells anti-malware vendors so they are aware that certain downloaders represent a threat and should be removed from computers protected by their products, says Holly Stewart, a senior program manager in Microsoft’s Malware defense Center.
A downloader called Rotbrow was the one mainly often used to help malicious actions throughout the last partially of 2013, most usually by downloading a click-fraud app called Sefnit. Before that Rotbrow didn’t record at all as a tool use by attackers, Stewart says.
characteristically the downloaders are bundled with useful freeware such as software to unzip archive. The downloaders might be used legitimately to download updates to the unzip programs, or to download malware, Stewart says.
The dominant types of malware Microsoft observed being downloaded in this way during the last half of 2013 were BitCoin miners and click-fraud programs.
Bitcoin miners run in the background of infected computers to confirm and process Bitcoin transactions in exchange for earning Bitcoins. The attacker reaps the Bitcoins earned by the infected computers. Click fraud forces the infected computer’s browser to automatically click on advertisements that earn cash for each click logged. In both cases indication of the infections can decrease performance of the engine involved.
Microsoft also experimental the proliferation of ransomware, with one called Reveton important the pack and enjoying a 45% raise in use during the last half of 2013, Stewart says. The need to disinfect Microsoft computers of ransomware tripled during the same time period, according to the Security Intelligence Report.
Microsoft procedures prevalence of malware by including the number of computers cleaned per 1,000 computers that are execute Microsoft’s Malicious Software Removal Tool. For ransomware in general, that count rose from 5.6 to 17.8 between the third and fourth quarters of last year, Stewart says.
Ransomware attacker’s goal picky regions with particular ransomware platforms, she says. For example, the one called Crilock is aimed mostly at computers in the U.S. and U.K. while Reveton aims at the likes of Spain, Belgium, Portugal, Hungary and Austria.
Microsoft cheaper to use than open source software, UK CIO says
British government says every time they compare FOSS to MSFT, Redmond wins.
A UK government CIO says that every time government citizens evaluate open source and Microsoft products, Microsoft products forever come out cheaper in the long run.
Jos Creese, CIO of the Hampshire County Council, told Britain’s “Computing” publication that part of the cause is that most staff are already familiar with Microsoft products and that Microsoft has been flexible and more helpful.
“Microsoft has been flexible and obliging in the means we apply their products to progress the action of our frontline services, and this helps to de-risk ongoing cost,” he told the publication. “The tip is that the true charge is in the totality cost of ownership and exploitation, not just the license cost.”
Creese went on to say he didn’t have a particular bias about open source over Microsoft, but proprietary solutions from Microsoft or any other commercial software vendor “need to justify themselves and to work doubly hard to have flexible business models to help us further our aims.”
He approved that there are troubles on together sides. In some cases, central government has developed an undue dependence on a few big suppliers, which makes it hard to be confident about getting the best value out of the deal.
On the other hand, he is leery of depending on a small firm, and Red Hat aside, there aren’t that many large, economically hard firms in open source like Oracle, SAP, and Microsoft. Smaller firms often offer the greatest innovation, but there is a risk in agreeing to a significant deal with a smaller player.
“There’s a huge dependency for a large organization using a small organization. [You need] to be mindful of the risk that they can’t handle the scale and complexity, or that the product may need adaptation to work with our infrastructure,” said Creese.
I’ve heard this argue before. Open source is cheaper in gaining costs not easy to support over the long run. Part of it is FOSS’s DIY ethos, and bless you guys for being able to debug and recompile a complete app or distro of Linux, but not everyone is that smart.
The extra problem is the lack of support from vendors or third parties. IBM has done what no one else has the power to do. 20 after Linus first tossed his creation on the Internet for all to use, we still don’t have an open source equivalent to Microsoft or Oracle. Don’t say that’s a good thing because that’s only seeing it from one side. Business users will demand support levels that FOSS vendors can’t provide. That’s why we have yet to see an open source Oracle.
The part that saddens me is that reading Creese’s interview makes it clear he has more of a clue about technology than pretty much anyone we have in office on this side of the pond.
You have been instructed to make sure that the auditing requirements of usp_UpdateArtistName
are supported by ABC-SR13.
Which of the following actions should you take?
A. You should consider including the Distributed Transaction Coordinator (DTC) in the solution.
B. You should consider including the Kernel Transaction Manager Resource Manager in the
C. You should consider including the Remote Procedure Call (RPC) service (RpcSs) in the
D. You should consider including the Component Object Model (COM) in the solution.
You have received instructions to make sure that server-side paging is supported by the
usp_SelectArtistsByName stored procedure. You want to make sure that actual development is
reduced as much as possible.
Which of the following actions should you take?
A. You should consider including an OFFSET-FETCH clause.
B. You should consider including a DISTINCT clause.
C. You should consider including and COLLATE clause.
D. You should consider including a ROLLUP clause.
You are in the process of writing code to create a table, named Performers. The table will include
a stored procedure, named usp_ PerformersReport.
You have to make sure that the code allows for a reduction in the length of time required for usp_
PerformersReport to complete.
Which of the following should be included in the code?
A. The nvarchar data type.
B. The bit data type.
C. The int data type.
D. The char data type.
You are writing code to create two tables, named Sets and Artists. You need to make sure that
referential integrity exists between the two tables.
Which of the following should be included in the code?
A. You should consider including a primary-key constraint.
B. You should consider including a foreign-key constraint.
C. You should consider including a unique-key constraint.
D. You should consider including a CHECK constraint.
You are writing code to add a column, named Verified, to the Performers table. The column should
allow for disk space usage to be reduced, and have a default value of False.
Which of the following actions should you take?
A. You should consider adding an int column.
B. You should consider adding a bit column.
C. You should consider adding a char column.
D. You should consider adding an nvarchar column.
You are employed as a database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com.
A current ABC.com application is configured to host item information, which is saved in XML
format, will be transformed into mechanical drawings for engineering purposes. This process will
be facilitated by making use of a newly developed Microsoft .NET Framework assembly, named
ProcessItems.dll, which was generated via the use of the ProcessItem.es source code file.
ProcessItems.dll includes a single class, named ProcessItem, and a method, named Transform().
Furthermore, the drawings are to be stored as illustrations.
You are informed that every XML should include a single item with a root element, named Item.
You have generated a schema for the items xml, named Production.ItemSchema. The items xml is
configured to have a product type of eleven characters.
•The first five characters reference the category of the product.
•The last six characters refer to the subcategory of the item.
You are planning to create a new database on a server running SQL Server 2012 to support the
application. You have, however, detected that the application includes a number of performance
and security concerns. You are planning to create two tables, named Items and
ManufacturingStages. The Items table will include the following columns:
•ItemID, which is configured as the primary key.
The ManufacturingStages table will include the following columns:
A sequence, named Production.ItemID_Seq, will also be added. You are also planning to generate
a certificate, named ABCItemsCert, in master and a certificate, named ABCDBCert in
ABC.com wants an application to be configured to perform dynamic T-SQL statements against the
You are required to make sure that all stored procedures are signed, and that the original item
specifics are stored in the database. You also have to make sure that an XML schema is
employed to authenticate the item specifics, and that the assembly is accessible via T-SQL
You have been informed that a table-valued function should be created to search products by
type, and that dynamic T-SQL statements should be converted to stored procedures. You have
also been informed that indexes should be boosted from time to time according to their fragmentation.
You need to configure the highest level of encryption to safeguard backups. Furthermore, you
have to make sure that the manufacturing stages stored in the ManufacturingStages table relates
to an item via an identical identifier employed by the Items table
Lastly, you have to make sure that the consumption of disk space and administrative effort is kept to a minimum.
But extends end-of-sales date for business PCs running Windows 7 Professional
Microsoft has set Oct. 31 as the end of sales of new consumer-grade Windows 7 PCs, but for now has left open the do-not-sell-after-this-date for business machines.
On the site where it posts such policies, Microsoft now notes that Oct. 31, 2014, is the end-of-sales date for new PCs equipped with Windows 7 Home Basic, Home Premium or Ultimate. All three are consumer-oriented versions of Windows 7; Home Premium has been the overwhelming choice of OEMs (original equipment manufacturers) for consumer systems.
Microsoft’s practice, first defined in 2010, is to stop selling an older operating system in retail one year after the launch of its successor, and halt delivery of the previous Windows edition to OEMs two years after a new version launches. The company shipped Windows 8, Windows 7’s replacement, in October 2012.
The setting of a deadline for consumer Windows 7 PCs followed a glitch last year when Microsoft named the same Oct. 31 date for all Windows 7 PCs, but then quickly retracted the posting, claiming that the notification had been posted “in error.”
Some OEMs, notably Hewlett-Packard, have made headlines for marketing consumer-grade Windows 7 PCs, a sign of the fragmentation of the once-dominant Windows oligarchy, which always pushed the newest at the expense of older editions.
But while it has established an end-of-sales date for consumer PCs with Windows 7 pre-installed, Microsoft has yet to do the same for business PCs.
Microsoft will give a one-year warning before it demands that OEMs stop selling PCs with Windows 7 Professional, the commercial-quality version. Under that rule, Microsoft will allow computer makers such as Lenovo, HP and Dell to continue selling PCs with Windows 7 Professional until at least February 2015.
It’s likely that the extension will be much longer.
Windows 7 has become the standard version for businesses, which have spurned Windows 8, largely because of its two-user interface (UI) model, which they consider disruptive to productivity and a needless cost that would require employee retraining.
Most analysts believe that Windows 7 will remain the most popular Microsoft operating system deployed by companies for years to come.
“There’s a good chance that enterprises will stay on Windows 7 as long as possible,” said Gartner analyst Michael Silver in an October 2013 interview. If his prediction turns out to be accurate, Windows 7 may reprise the stubborn persistence of Windows XP, the nearly-13-year-old OS that Microsoft will retire in April.
Even after Windows 8’s launch, Windows 7’s user share, a rough measurement of the prevalence of the OS on operational machines, has continued to grow. From October 2012 to January 2014, Windows 7’s user share increased nearly 3 percentage points, representing a 6% gain during that period, according to data from analytics company Net Applications.
Some of Windows 7’s gains certainly came at the expense of Windows XP, which has fallen more than 11 percentage points, a 28% decline, since October 2012 as users abandoned the old OS.
By making Windows 7 available, Microsoft and its OEMs not only continue to serve customers who want the OS, but make sure that new PC sales do not slump even more dramatically than they have already.
Consumer PC sales have plummeted — last month Microsoft said sales of consumer-grade Windows licenses fell 20% in the December quarter compared to the same period the year before — while the Redmond, Wash. company’s business line of operating systems grew 12% year-over-year. In effect, enterprise spending kept PC shipments from tanking even more than the 10% contraction the industry experienced in 2013.
Extending Windows 7 Professional’s availability on new hardware will also give Microsoft breathing room to continue its retreat from Windows 8’s radical shift to a touch-first, tile-based UI, and to roll out a successor that caters even more to customers who rely on keyboard and mouse.
Microsoft is expected to unveil an update to Windows 8.1 this spring, perhaps in April, that will restore several desktop-oriented features and tools. Some reports based on leaked builds of this Windows 8.1 Update 1 have noted that on non-touch devices, the boot-to-desktop option will be enabled by default; if accurate, most users of traditional PCs will skip the colorful, tile-style Start screen. Windows 9 may appear as early as April 2015.
Retail sales of Windows 7 by Microsoft to distributors and customers were officially halted as of Oct. 31, 2013, but that deadline has been meaningless, as online retailers have continued to sell packaged copies, sometimes for years, by restocking through distributors who squirreled away older editions.
As of Saturday, for example, Amazon.com had a plentiful supply of various versions of Windows 7 available, as did technology specialist Newegg.com. The former also listed copies of Windows Vista and even Windows XP for sale through partners.
Even after Microsoft pulls the plug on Windows 7, there will be ways to circumvent the shut-down. Windows 8.1 Pro, the more expensive of the two public editions, includes “downgrade” rights that allow PC owners to legally install an older OS. OEMs and system builders can also use downgrade rights to sell a Windows 8.1 Pro-licensed system, but factory-downgrade it to
Windows 7 Professional before it ships.
And enterprises with volume license agreements will never be at risk of losing access to Windows 7, as they are granted downgrade rights as part of those agreements, and so will be able to purchase, say, Windows 8.1 or Windows 9 PCs in 2015 or 2016, then re-image the machines with Windows 7.
The end-of-sales dates for Windows 7 are not linked in any way to the support schedule for the 2009 operating system. Microsoft will provide free non-security bug fixes and vulnerability patches for Windows 7 until Jan. 13, 2015 — called “mainstream support” — and follow that with a five-year stretch of “extended support” during which it will ship free security updates until Jan. 14, 2020.
Will automatically push malware cleanup tool to Windows XP until July 2015
Microsoft will be able to silently reach into Windows XP PCs for more than a year after it stops patching the aged OS to clean malware-infected machines, sources close to the company confirmed Friday.
The Malicious Software Removal Tool (MSRT) will continue to be updated and deployed via Windows Update through July 14, 2015, 15 months after the Redmond, Wash. company serves its final public security patches for XP on April 8 of this year.
By extending the life of the MSRT — and more importantly, automatically running it each month — Microsoft will be able to clean some PCs if massive malware outbreaks hit Windows XP after it’s retired from support.
MSRT is updated monthly as Microsoft targets one or more major malware families it believes are the biggest current threats. The tool is posted for manual download on Microsoft’s website and distributed through the Windows Update service on “Patch Tuesday,” the second Tuesday of each month when Microsoft pushes security patches to customers running still-supported editions of Windows. MSRT automatically installs on PCs with Automatic Updates enabled, and then runs a seek-and-destroy mission in the background without any action on the part of the user.
MSRT is not an antivirus program, but rather a cleaning utility designed to eradicate malware that has already snuck onto a Windows PC. The tool was first released in 2005, but was last updated Jan. 14, 2014, when Microsoft added detection and deletion capabilities for the “Bladabindi” malware family.
The extension of MSRT availability was part of the firm’s decision earlier this month to offer new anti-malware signatures to XP customers who run the company’s free Security Essentials antivirus (AV) software.
Previously, Microsoft said it would stop shipping Security Essentials’ signature updates to XP PCs after April 8. But in a tacit nod to XP’s widespread use, Microsoft postponed the cut-off until July 14, 2015.
With MSRT, Microsoft will have a weapon at the ready in case widespread malware infections strike XP machines after April 8, something the company has said is likely. If new malware pops up, or an older virus, worm or Trojan horse begins infecting large numbers of Windows XP systems — perhaps because they exploited a vulnerability that will never be patched — Microsoft can at least use the MSRT to try to disinfect those PCs.
Extending MSRT’s life on XP will not only help customers still running the 13-year-old OS, but is also smart for Microsoft, which could face a public relations backlash if large numbers of compromised Windows XP machines are used by hackers to infect other devices running Vista, Windows 7 and Windows 8.
Although Microsoft has not stopped urging customers to dump XP, it has recognized that millions of machines will continue to run the ancient OS for months and maybe even years to come.
According to metrics company Net Applications, Windows XP’s user share — the percentage of all personal computer owners who went online with that OS — stood at 29% at the end of December 2013. Computerworld has predicted that about 20% of all personal computers will be running the operating system at the end of 2014.
Andreas Marx, CEO of AV-Test, a German company that evaluates security software, said Microsoft’s decision to continue providing signatures for Security Essentials was prompted by the still-large numbers of PCs running XP.
“It’s a significant move, which is likely driven by the (still) high market share for Windows XP, especially in countries like China or India, as well as the millions of users who are using Security Essentials as anti-virus protection on Windows XP,” said Marx in an email reply to questions earlier this month.
Security Essentials has performed poorly in AV-Test’s recent exams, and Marx cautioned users who plan to reply on it to keep their systems safe after Microsoft stops patching XP. “[Security Essentials] is baseline protection and well-suited for people who are not often using the Internet,” Marx said. “But if you’re online quite often and for long times, if you do financial transactions with your system and the like, I would strongly recommend switching to a commercial security suite.”
Most antivirus vendors will continue to provide customers running Windows XP with up-to-date signatures for years after Microsoft pulls the patch plug in April.
Kaspersky, BitDefender and Avira — the last is free — were the top-scoring consumer antivirus programs for Windows XP in AV-Test’s latest head-to-head comparisons. For business PCs, Kaspersky, Symantec and Trend Micro ranked 1-2-3.
Instructions for turning on XP’s Automatic Updates can be found on Microsoft’s support site, along with a “Fixit” tool that takes care of the chore with a single click.