Microsoft Certifications Excel in Four Key Areas

Stop for a minute and consider the range of Microsoft’s offerings and the longevity of its creations. This is a company that has not only given the world what is perhaps the gold standard in desktop publishing and office productivity software (Microsoft Word, Excel, Outlook, etc.) but it’s also infiltrated our home lives as well through gaming and portability. (We’re looking at you, Xbox and Surface!) Microsoft is the foundation for an incredible number of businesses; eighty percent of the Fortune 500 is on the Microsoft Cloud. More than 400 million devices are running Windows 10. In short: Microsoft is everywhere.

Read more

The Unending Challenge of Managing “The Database”

If you’re a large organization, somewhere in the bowels of the IT department is “The Database”. It doesn’t matter what kind of database server it runs on, maybe it’s SQL Server, maybe it’s MySQL, but The Database has something big in it – the output of that exhaustive customer survey you did, or the company’s complete sales history back to 1986. But whatever it is, it has gobs of data, and you likely have no idea what’s in it.

Read more

Fueling a Revolution: R, Rivals and SQL Server 2016

Imagine Romeo Montague calling up toward Juliet Capulet on a balcony, reciting poetry such as “What R through yonder Windows breaks?” or wooing the daughter of that rival family with sweet nothings of statistical data analysis talk of “Big Data, Big Analytics.” Microsoft SQL Server and Oracle Database products vie for market share. Some people consider Microsoft and the Linux community to be rivals. Therefore, when Microsoft joined forces with Google, Oracle and others in June 2015 for a collaborative project under the Linux Foundation, some people expressed confusion. Let’s clear up the realities of this seemingly star-crossed love affair.

Read more

Reporting Services: Clearing Up the Terms

Reporting Services, a feature in SQL Server that supports reporting, can be installed in one of two modes: SharePoint Integrated or Native (non-SharePoint) mode. This option appears at the time of installation and can be changed later. Once selected, the mode determines where users will view deployed reports.

Read more