Jared Zagelbaum's Blog

Download Attachments from Exchange Web Services using SSIS

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...

2016-03-11

4,020 reads

Download Attachments from Exchange Web Services using SSIS

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...

2016-03-11

221 reads

Bitwise XOR in DAX

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

In T-SQL and other languages we have bitwise XOR natively supported; the T-SQL operator is simply ^. Here’s the explanation of...

2015-10-08 (first published: 2015-09-29)

2,746 reads

Automated Metadata Report for SSAS Tabular

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

There’s been an excellent free solution for documenting SSAS metadata in multi-dimensional models for quite some time: http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/.
I had the...

2015-09-09

1,079 reads

Migrating SQL Agent Jobs with Schedules using T-SQL

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like....

2015-05-26

753 reads

Synchronizing Read / Write SQL Agent Jobs Across AlwaysOn Replicas

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

Intro
AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like...

2015-05-15 (first published: 2015-05-05)

6,650 reads

Automated Restore Script Output for Ola Hallengren’s Maintenance Solution

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

Intro
This blog post is designed to be useful to two different audiences:
Those implementing Ola Hallengren’s Maintenance Solution for the first timeThose...

2015-04-16

5,751 reads

Delete unused SQL Agent jobs from instance

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

I recently worked on a project where the client requested to “remove all of the unused jobs” that had been...

2015-04-09 (first published: 2015-04-01)

8,207 reads

Consolidating time series metadata for users in Tabular

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

Background
DAX offers many powerful time intelligence functions that can be applied at virtually any level of a date / time hierarchy....

2015-02-13 (first published: 2015-02-04)

6,567 reads

SSRS SharePoint Integrated Mode – Report Server URL

• by Jared-Zagelbaum

• Jared Zagelbaum's Blog

This is a short, but hopefully sweet post for someone, whom, like me, might have had to end up spending...

2014-12-03

2,673 reads