News

What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 3

Innovations of the 2010s (SQL Server 2012 – 2019)

What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 3 What You Need to Know about the Batch Mode Window Aggregate Operator in SQL Server 2016: Part 3

To me, one of the most exciting improvements in SQL Server 2016 is the introduction of the batch mode Window Aggregate operator, which significantly improves the performance of most window functions. This article is the third in a three-part series on the topic.

byItzik Ben-Gan

Aug 10, 2016

|

22 Min Read

Survey Ship for Amazon’s Transpacific Cable Sets Sail

Archived Assets

Survey Ship for Amazon’s Transpacific Cable Sets Sail Survey Ship for Amazon’s Transpacific Cable Sets Sail

Aug 9, 2016

2 Min Read

How To: Make Project Fi Your Wireless And Voice Service When Traveling

Endpoint Security

How To: Make Project Fi Your Wireless And Voice Service When Traveling How To: Make Project Fi Your Wireless And Voice Service When Traveling

Aug 9, 2016

4 Min Read

ITPro Today logo

Archived Assets

Alibaba Offers to Help Global Tech Companies Navigate China Alibaba Offers to Help Global Tech Companies Navigate China

Aug 9, 2016

1 Min Read

Microsoft Begins Prep Work For Next Cycle of Windows Development

Microsoft Begins Prep Work For Next Cycle of Windows Development Microsoft Begins Prep Work For Next Cycle of Windows Development

Aug 9, 2016

2 Min Read

Fast, Slow & Release Preview Rings for Windows 10 Current Branch Get Build 14393.67

Archived Assets

Fast, Slow & Release Preview Rings for Windows 10 Current Branch Get Build 14393.67 Fast, Slow & Release Preview Rings for Windows 10 Current Branch Get Build 14393.67

Aug 9, 2016

1 Min Read

Windows 10 Anniversary Update Receives its First Public Cumulative Update

Archived Assets

Windows 10 Anniversary Update Receives its First Public Cumulative Update

Windows 10 Anniversary Update Receives its First Public Cumulative Update

Patch Tuesday First Look: Edge, IE, Kernel-Mode Drivers, Windows Authentication, PDF Library

Networking & Security

Patch Tuesday First Look: Edge, IE, Kernel-Mode Drivers, Windows Authentication, PDF Library

Patch Tuesday First Look: Edge, IE, Kernel-Mode Drivers, Windows Authentication, PDF Library

Kid Tested, Father Approved: Syncwire Nylon Braided Micro USB Cable

Endpoint Security

Kid Tested, Father Approved: Syncwire Nylon Braided Micro USB Cable

Kid Tested, Father Approved: Syncwire Nylon Braided Micro USB Cable

Microsoft Delivers Android Support for Azure Rights Management

Microsoft Delivers Android Support for Azure Rights Management

Microsoft Delivers Android Support for Azure Rights Management

Flash Storage As a Strategic IT Asset

Archived Assets

Flash Storage As a Strategic IT Asset

Flash Storage As a Strategic IT Asset

Evergreen Storage A New Approach

Evergreen Storage A New Approach

Evergreen Storage A New Approach

Quick Tip: How To Customize Mobile Notifications on Your Desktop

Endpoint Security

Quick Tip: How To Customize Mobile Notifications on Your Desktop

Quick Tip: How To Customize Mobile Notifications on Your Desktop

The WSUS Client for Windows 10 Anniversary Pulls Updates from Network Peers by Default

The WSUS Client for Windows 10 Anniversary Pulls Updates from Network Peers by Default

The WSUS Client for Windows 10 Anniversary Pulls Updates from Network Peers by Default

Surface 3 Gets an August Firmware Update

Cloud Computing

Surface 3 Gets an August Firmware Update

Surface 3 Gets an August Firmware Update

Software Vulnerabilities in the US: Oracle Java JRE, VLC Player & Adobe Reader in Top Three

Oracle Cloud Infrastructure

Software Vulnerabilities in the US: Oracle Java JRE, VLC Player & Adobe Reader in Top Three

Software Vulnerabilities in the US: Oracle Java JRE, VLC Player & Adobe Reader in Top Three

Microsoft Edge Extension Toolkit UWP App Released

Microsoft Edge Extension Toolkit UWP App Released

Microsoft Edge Extension Toolkit UWP App Released

Live Tile Bug Reveals a New Notification Counter for Microsoft Health App

Live Tile Bug Reveals a New Notification Counter for Microsoft Health App

Live Tile Bug Reveals a New Notification Counter for Microsoft Health App

Which cloud provider stands out from the pack in pricing

Breaking Down Cloud Infrastructure-as-a-Service Pricing

Breaking Down Cloud Infrastructure-as-a-Service Pricing

byMichael Morisy

Google Research Finds Free Software Bundles Come with Security Cost

Software Development

Google Research Finds Free Software Bundles Come with Security Cost

Google Research Finds Free Software Bundles Come with Security Cost

byNicole Henderson

How businesses need to adapt to actually put their Big Data to work

Cloud Computing

How businesses need to adapt to actually put their Big Data to work

How businesses need to adapt to actually put their Big Data to work

byMichael Morisy

Resource: Using Windows Defender Advanced Threat Protection After a Breach

Vulnerabilities & Threats

Resource: Using Windows Defender Advanced Threat Protection After a Breach

Resource: Using Windows Defender Advanced Threat Protection After a Breach

Use Windows 10 Anniversary’s Connect App to Cast Your Smartphone Screen to Your PC

Use Windows 10 Anniversary’s Connect App to Cast Your Smartphone Screen to Your PC

Use Windows 10 Anniversary’s Connect App to Cast Your Smartphone Screen to Your PC

Why CIOs Don’t Pick Up the Phone

Endpoint Security

Why CIOs Don’t Pick Up the Phone

Why CIOs Don’t Pick Up the Phone

Image by Nxn 0405 chl and licensed under the Creative Commons AttributionShareAlike 30 License

Active Directory

Check for unused AD accounts

Check for unused AD accounts

HP’s New Backpack is a Portable Power Station for your Laptop and Devices

Endpoint Security

HP’s New Backpack is a Portable Power Station for your Laptop and Devices

HP’s New Backpack is a Portable Power Station for your Laptop and Devices

Quick Tip: How To Pick Default Storage Locations in Windows 10 Anniversary Update

Quick Tip: How To Pick Default Storage Locations in Windows 10 Anniversary Update

Quick Tip: How To Pick Default Storage Locations in Windows 10 Anniversary Update

What Every Accidental DBA Needs to Know Now: Backups

What Every Accidental DBA Needs to Know Now: Backups

What Every Accidental DBA Needs to Know Now: Backups

Deprovision VMs that are stopped in Azure after 20 minutes.

Server Virtualization

Deprovision VMs that are stopped in Azure after 20 minutes.

Deprovision VMs that are stopped in Azure after 20 minutes.

Will new branches be installed automatically on Nano Server?

Archived Assets

Will new branches be installed automatically on Nano Server?

Will new branches be installed automatically on Nano Server?

Create custom structure in PowerShell

Create custom structure in PowerShell

Create custom structure in PowerShell

Tell Azure fabric VM Agent installed in ARM VM

Server Virtualization

Tell Azure fabric VM Agent installed in ARM VM

Tell Azure fabric VM Agent installed in ARM VM

SharePoint & Office 365 | What’s New for ECM & Your Mobile Workforce

SharePoint & Office 365 | What’s New for ECM & Your Mobile Workforce

SharePoint & Office 365 | What’s New for ECM & Your Mobile Workforce

Curbing Server Sprawl with HPE Superdome X Scale-up

Cloud Computing

Curbing Server Sprawl with HPE Superdome X Scale-up

Curbing Server Sprawl with HPE Superdome X Scale-up

Hands on with the Windows 10 Anniversary Update Refresh Windows Tool

Hands on with the Windows 10 Anniversary Update Refresh Windows Tool

Hands on with the Windows 10 Anniversary Update Refresh Windows Tool

Sign up for the ITPro Today newsletter

Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

Newsletter Sign-Up