Insight and analysis on the information technology space from industry thought leaders.

Featured on Industry Perspectives

T-SQL Feature Request: Add RESET WHEN Clause to Reset Window Partition
Other Programming Languages
T-SQL Feature Request: Add RESET WHEN Clause to Reset Window PartitionT-SQL Feature Request: Add RESET WHEN Clause to Reset Window Partition

In this article, I present a couple of classic, representative T-SQL querying tasks, provide the solutions that are used currently, and explain how you would handle them with improved solutions using the RESET WHEN clause. Hopefully, by the end of this article you will be convinced of the importance of this feature and will add your vote to the connect item requesting it.

byItzik Ben-Gan
Jul 11, 2017
|
12 Min Read
How to Benefit from Veeam ONE: Monitoring, Performance Optimization, Reporting, and More
Data Backup
How to Benefit from Veeam ONE: Monitoring, Performance Optimization, Reporting, and MoreHow to Benefit from Veeam ONE: Monitoring, Performance Optimization, Reporting, and More
byVeeam Guest Blogger
Jun 28, 2017
6 Min Read
Microsoft Public Folders & Other Notes from the Field
Microsoft 365
Microsoft Public Folders & Other Notes from the FieldMicrosoft Public Folders & Other Notes from the Field
byPriasoft Guest Blogger 1
Jun 23, 2017
7 Min Read
Free Veeam Tools for Powerful Data Protection
Data Backup
Free Veeam Tools for Powerful Data ProtectionFree Veeam Tools for Powerful Data Protection
byVeeam Guest Blogger
May 1, 2017
4 Min Read
Unlock the Power of Nano
Private Cloud
Unlock the Power of NanoUnlock the Power of Nano
byVeeam Guest Blogger
Apr 5, 2017
4 Min Read
Veeam Availability Suite 9.5: Updates to Veeam ONE and Free NFR Keys
Data Backup
Veeam Availability Suite 9.5: Updates to Veeam ONE and Free NFR KeysVeeam Availability Suite 9.5: Updates to Veeam ONE and Free NFR Keys
byVeeam Guest Blogger
Jan 24, 2017
5 Min Read

More from Industry Perspectives

Linux + PowerShell = Awesome, Not Awkward, Together!
PowerShell
Linux + PowerShell = Awesome, Not Awkward, Together!
Linux + PowerShell = Awesome, Not Awkward, Together!
Dec 15, 2016
|
3 Min Read
byVeeam Guest Blogger
ITPro Today logo logo in a gray background | ITPro Today logo
Microsoft 365
Cloud-Based Mail Backup and Recovery with Veeam Backup for Microsoft Office 365
Cloud-Based Mail Backup and Recovery with Veeam Backup for Microsoft Office 365
Dec 8, 2016
|
3 Min Read
byVeeam Guest Blogger
Why ReFS Is the Recommended File System for Windows Server 2016
Data Backup
Why ReFS Is the Recommended File System for Windows Server 2016
Why ReFS Is the Recommended File System for Windows Server 2016
Oct 25, 2016
|
2 Min Read
byVeeam Guest Blogger
Meet Pure Storage at Microsoft Ignite 2016!
Data Storage
Meet Pure Storage at Microsoft Ignite 2016!
Meet Pure Storage at Microsoft Ignite 2016!
Sep 26, 2016
|
2 Min Read
byPure Storage Guest Blogger
Veeam Backup & Replication: Tips and tricks
Data Backup
Veeam Backup & Replication: Tips and tricks
Veeam Backup & Replication: Tips and tricks
Aug 22, 2016
|
4 Min Read
byVeeam Guest Blogger
Are Your Backups Application-Aware?
Data Backup
Are Your Backups Application-Aware?
Are Your Backups Application-Aware?
Jun 10, 2016
|
2 Min Read
byVeeam Guest Blogger
The Microsoft Enterprise Mobility Suite: Getting Better with Age
Cloud Services
The Microsoft Enterprise Mobility Suite: Getting Better with Age
The Microsoft Enterprise Mobility Suite: Getting Better with Age
Apr 28, 2016
|
3 Min Read
byBinary Tree
The Ultimate Network Security Checklist
IT Security
The Ultimate Network Security Checklist
The Ultimate Network Security Checklist
Mar 8, 2016
|
2 Min Read
byGFI Software Guest Blog
Delve Analytics: Big Brother or Fitbit for the Enterprise?
Microsoft 365
Delve Analytics: Big Brother or Fitbit for the Enterprise?
Delve Analytics: Big Brother or Fitbit for the Enterprise?
Mar 8, 2016
|
5 Min Read
byBinary Tree
Advanced Persistent Threats – Clearing Up Misconceptions
Archived Assets
Advanced Persistent Threats – Clearing Up Misconceptions
Advanced Persistent Threats – Clearing Up Misconceptions
Dec 3, 2013
|
2 Min Read
byViewfinity
Migrating and Co-Existence between Messaging Systems
Cloud Computing
Migrating and Co-Existence between Messaging Systems
Migrating and Co-Existence between Messaging Systems
Dec 2, 2013
|
2 Min Read
byGSX Solutions Guest Blogger
Ten Great Exchange Server Tools
Cloud Computing
Ten Great Exchange Server Tools
Ten Great Exchange Server Tools
Nov 4, 2013
|
3 Min Read
byGSX Solutions Guest Blogger
The Skinny on Hactivists: When Hacking is Trendy, Everyone Needs to Watch Out
Archived Assets
The Skinny on Hactivists: When Hacking is Trendy, Everyone Needs to Watch Out
The Skinny on Hactivists: When Hacking is Trendy, Everyone Needs to Watch Out
Nov 1, 2013
|
2 Min Read
byViewfinity
Windows XP is 21 Times More Likely to be Infected by Malware than Windows 8
Windows 8
Windows XP is 21 Times More Likely to be Infected by Malware than Windows 8
Windows XP is 21 Times More Likely to be Infected by Malware than Windows 8
Oct 7, 2013
|
2 Min Read
byViewfinity
Exchange 2010 Monitoring: Client Access (Part 1, Connectivity)
Cloud Computing
Exchange 2010 Monitoring: Client Access (Part 1, Connectivity)
Exchange 2010 Monitoring: Client Access (Part 1, Connectivity)
Sep 30, 2013
|
3 Min Read
byGSX Solutions Guest Blogger
PowerShell ISE: Tips and Tricks
PowerShell
PowerShell ISE: Tips and Tricks
PowerShell ISE: Tips and Tricks
Sep 13, 2013
|
2 Min Read
byGSX Solutions Guest Blogger

Editor's Choice

jobs key on keyboard
Career Management
IT Jobs Outlook 2025: Evolving Skills, AI, Workplace Flexibility Will Shape IT Workforce
IT Jobs Outlook 2025: Evolving Skills, AI, Workplace Flexibility Will Shape IT Workforce

Nov 20, 2024

an it pro is disappointed as a poster for sustainability is switched with one for financial results and garbage piles up next to a recycling bin
Green IT
How Do I Advocate for Green IT Without Being Dismissed as a Lorax?
How Do I Advocate for Green IT Without Being Dismissed as a Lorax?

Nov 27, 2024

person using a laptop with the Ubuntu logo on its scree
IT Operations
3 Simple Ways to Install and Run a Virtual Machine on Ubuntu
3 Simple Ways to Install and Run a Virtual Machine on Ubuntu

Nov 22, 2024

Exclusive ITPro Resources
See all ITPro Resources

Featured Technical Explainers

AI chip
Cloud Computing
Cloud vs. On-Prem AI Accelerators: Choosing the Best Fit for Your AI Workloads
Cloud vs. On-Prem AI Accelerators: Choosing the Best Fit for Your AI Workloads
SaaS concept on a tablet
Cloud Computing
Why SaaS Backup Matters: Protecting Data Beyond Vendor Guarantees
Why SaaS Backup Matters: Protecting Data Beyond Vendor Guarantees
DevOps logo on top of code
DevOps
DevOps: Key to Faster, More Efficient Government Software Development
DevOps: Key to Faster, More Efficient Government Software Development
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

Recent What Is

cartoon shows a person next to a checklist and several icons that represent disaster scenarios
Disaster Recovery
BCDR Basics: A Quick Reference Guide for Business Continuity & Disaster RecoveryBCDR Basics: A Quick Reference Guide for IT Pros
technology interface with a person's hand drawing gears and cogs
PowerShell
Introduction To PowerShell Environment VariablesIntroduction To PowerShell Environment Variables
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