#Office365 Roadmap Website Launched

Microsoft today launched a new website covering the roadmap for Office 365, http://office.microsoft.com/en-us/products/office-365-roadmap-FX104343353.aspx. This is great, now you can see what new features and functionality has been launched, is rolling out and in development. One of the cool new features that is in the Rolling Out section is the ability to opt in to being…

SQL Server: Bulk Update

I maintain a rollup table of project metrics, which get updated on a frequent basis. This table contains a lot of calculations and data from multiple sources, which first populates a TABLE variable. Once all of the calculations and aggregate data sources have been completed, I want to update my project metrics table with the…

SQL Query: Joining a SQL Table with a Table-valued Function

Did you know that you can use a SQL Query to join together a SQL Table with a Table-valued Function into a single result set? Here’s how: I have created a Function that contains several calculations and returns some standard Project Metrics: CREATE FUNCTION [dbo].[fnGetProjectMetrics] (    @ProjectId int ) RETURNS @results table (     [ActivityStartDate] datetime     , [ActivityEndDate] datetime     ,…