Microsoft: Top 8 Features of SQL Server 2016

Fascinating technical materials from Microsoft on the latest SQL Server.

“SQL Server 2016 will deliver breakthrough, mission-critical capabilities with improved performance, security, scale, and operational analytics. The new and improved features in SQL Server 2016 will enable Microsoft IT and the ESBI team to create BI solutions that support advanced analytics directly within databases and help users gain deeper insights into their data. “

Summary:

  • In-Memory OLTP helps ESBI meet their users’ business requirements for increased agility.
  • Columnstore Indexes reduce the amount of time it takes to run and render SRSS reporting data.
  • Temporal data reduces the amount of support tickets received from the field due to inaccurate data.
  • Row-Level Security provides a more reliable and standardized method to easily control which users can access data.
  • Dynamic Data Masking helps limit exposure of sensitive data, preventing users who should not have access to the data from viewing it.
  • Query Store provides better insight into the performance differences caused by changes in query plans.
  • Active Query Statistics allows a view of active query execution plans and helps identify and fix blocking issues while queries are running.
  • SQL Stretch Database helps improve performance to frequently used data while preserving access to archived data.

Read The Full Article

 

This is a wonderful overview of the “Darknet” and the Thor browser.

Darknet 101: Your guide to the badlands of the internet

“Hacked login details. Cybersecurity exploits for hire. Drugs, guns and ammo. If there’s something shady going on online, chances are it’s happening on the darknet.”

Read it Here

New Thinking On Password Changes

I really like this way of thinking outside the box! Some of the old, and current, concepts on password complexity, length, history etc. are being revised. There is some new thinking on the matter, based mainly on trends and analytics Microsoft has done via millions of hack attempts on Azure based resources.

New Microsoft recommendations:

  • “Maintain an 8-character minimum length requirement (and longer is not necessarily better).
  • Eliminate character-composition requirements.
  • Eliminate mandatory periodic password resets for user accounts.
  • Ban common passwords, to keep the most vulnerable passwords out of your system.
  • Educate your users not to re-use their password for non-work-related purposes.
  • Enforce registration for multi-factor authentication.
  • Enable risk based multi-factor authentication challenges.”

Read it here 

Thousands of Hacked Home Routers are Attacking WordPress Sites

Thousands of Hacked Home Routers are Attacking WordPress Sites

Fascinating blog from WordFence, one of the best WordPress firewall out there. They uncovered attacks coming from various countries and regions. The target is home networks. There is a router vulnerability called “Misfortune Cookie” [really] that is being exploited. It appears many home routers are hacked with this vulnerability and they in turn launch attacks. The tricky part here is that the launched attacks are actually small per home router, so detection is difficult.

The really weird thing is that the IPS are coming from all over the place, but attacks from Algeria [!] are increasing dramatically.

Read the WordFence Blog here

LinkedIn Integration with Office Applications

Now that the Microsoft ‘LinkedIn’ purchase is completed, Microsoft is aggressively pursuing more relevant and very forward-thinking usage of all its applications in the SaaS [Office 365] world.

Nutshell: lots of resume / job searching /social profile types of integration between ‘LinkedIn’ and Office applications.

“With its $26 billion acquisition of LinkedIn getting the thumbs up from EU regulators, Microsoft is wasting no time in integrating the social platform with its productivity software.

The goal — as described by the tech giant’s CEO Satya Nadella — is to utilize LinkedIn’s networking and learning resources to help people “develop new skills online, find new jobs, and easily connect and collaborate.” “

Read it here

Microsoft Wants Us to Move Away from VMware

Yeah, I see no reason for people to stay with VMware. You get free virtualization with the latest Windows Server 2012 and [soon to be released] 2016, especially if you purchase the Datacenter version.

‘Microsoft offers free Windows Server 2016 licenses to VMware switchers’

Read it here

Ukraine In The House

There are hundreds and hundreds of these WordFence Firewall entries on Riguy.Com. I blocked some IPs here and there; that will work for a while. I wonder what these nice people from Ukraine would ever want with my most humble of web sites? Regardless, thanks WordFence [awesome security plugin]!

WFence1

 

WFence2 WFence1

 

Activate Plugins after Update

Memo to self: be sure to double check updated WordPress plugins immediately after doing the update!

It is like stating the obvious, but nonetheless very important to remember the above. I just updated the Captcha and WordFence plugins. I saw an error, but remembered to check the Plugins section to verify they are running. Once activated the plugins are fine. Some seem to need this, while others activate ‘automagically’.

WordPress Security – WordFence

WordFence Security hard at work, on my humble website ;>

I love this Plugin [although I use the free version for my personal website, our work pays for it because it is worth every penny].

Wordfence2