Intervals and Counts

View on Mobile Phone | View as Web Page

Intervals and Counts, Part 1 By Itzik Ben-Gan, itzik@solidq.com When using SQL Server, you frequently need to work with data that represents intervals of time. For example, consider intervals representing sessions, contracts, projects, and so on. I covered a few aspects of manipulation of intervals in the past (see the list of Related Articles), but there are still many interesting challenges to cover. Tasks related to interval manipulation are typically quite intriguing, especially because coming up with efficient solutions isn't easy. I recently had the chance to work on a few challenges involving intervals and counts. This article is the first in a series covering those challenges and their solutions. More . . .   ADVERTISEMENT Confront the Elephant in the Room – Your Bad Data Sponsored by Melissa Data Corp All companies struggle in some way with bad data.  Up to 70% of contact data is outdated after 12 months, including titles, addresses, phone numbers and email addresses.  Melissa Data has tools that easily plug in to SSIS to cleanse, update and consolidate your global contact data. Download a free trial today!   What Makes a Good SQL Server Reporting Services (SSRS) Base Template? From myITforum.com The simple answer is there is no simple answer. However, what we find is that you can narrow it down to these steps. More . . . Microsoft Cloud BI Update 2013 By Mark Kromer I've been blogging about cloud business intelligence (BI) and the advantages and possibilities of cloud-based business intelligence for IT and business knowledge users for a number of years now. Up until July 2013, I had put together only hybrid solutions using the entire Microsoft stack. I described that same "hybrid" on-premise and cloud model right here on the SQL Server Pro blog almost the same time one year ago. More . . . Events and Resources Free Tool! On-Demand Identity & Access Management for Cloud/SaaS A simple wizard driven process enables AD integration that allows access to your domain controller.  It takes less than 20 minutes to deliver. To find out more, click here. SharePoint Virtualization and the Benefits of Modern Data Protection Virtualizing the SharePoint environment can provide a pathway for simple, yet powerful, SharePoint backup. Download this helpful guide and find out for yourself whether virtualizing your SharePoint environment is a good option for your organization.	ADVERTISEMENT   This issue is sponsored by Melissa Data Corp.   Free SQL Server Backup Tool Find out more about the capabilities and system requirements of this free SQL check tool by clicking here. Why VMWare and Hyper-V Disk is Broken Protection for virtual environments is a critical aspect of a strong and efficient virtual machine. Environments like VMWare and hypervisors require specialized backup, but the majority are vulnerable, being protected by generic systems. MORE RESOURCES   SQL Server Foundations If you're new to SQL Server or just looking to brush up on your skills, register now for this eLearning course focusing on the various versions of SQL Server, performance tuning, implementing backups as well as crucial SQL Server basics. You'll learn about the core concepts every DBA should know and how things outside of SQL Server affect and influence your daily tasks. Six sessions, beginning August 27th. Driving Cloud Interoperability to Reduce Costs and Speed Innovation Click here to learn more about an open approach to cloud management and about IBM's new SmartCloud Orchestration. MORE EVENTS

Contact Us About the commentary -- articles@sqlmag.com About technical questions -- www.sqlmag.com/forums About product news -- products@sqlmag.com Make sure your copy of SQL Server Update doesn't get mistakenly blocked by antispam software! Be sure to add SQL Server Update to your list of allowed senders and contacts.   You are subscribed as: buzzhairs.tech@blogger.com . To manage your subscription, click here. View the Penton Privacy Statement SQL Server Magazine is a division of Penton 1166 Avenue of the Americas/10th Fl | New York, NY 10036 Copyright 2013, Penton All Rights Reserved.