-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Jared Zagelbaum's Blog

Jared is a highly experienced IT professional, specializing in the Microsoft Data Platform suite of technologies since 2007. He expertly leads projects and teams through enterprise solution design and implementation for data management, analytics, and information delivery. Jared regularly speaks at user groups and events across the Midwest, as well as blogging and providing technical review for SQL Server publications. He is a Microsoft Certified Solutions Expert (MCSE) in Business Intelligence, and a graduate of the University of Florida with a BS in Finance, Accounting and Economics.

Download Attachments from Exchange Web Services using SSIS

I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted in an on prem exchange server. The excel sheets were based on a standard template and had a reasonable enough level of validation to support data quality with loading into… Read more

12 comments, 2,337 reads

Posted in Jared Zagelbaum's Blog on 11 March 2016

Download Attachments from Exchange Web Services using SSIS

I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted in an on prem exchange server. The excel sheets were based on a standard template and had a reasonable enough level of validation to support data quality with loading into… Read more

0 comments, 103 reads

Posted in Jared Zagelbaum's Blog on 11 March 2016

Bitwise XOR in DAX

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

https://en.wikipedia.org/wiki/Bitwise_operation

  1. Why would we want to implement this in DAX?
  2. How do we implement it?

1) I implemented XOR to ensure that only… Read more

0 comments, 2,008 reads

Posted in Jared Zagelbaum's Blog on 29 September 2015

Automated Metadata Report for SSAS Tabular

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 opportunity recently at a client to implement a version of this report solution rewritten for SSAS tabular. It took a few tweaks to the DMV queries, but I… Read more

2 comments, 681 reads

Posted in Jared Zagelbaum's Blog on 9 September 2015

Migrating SQL Agent Jobs with Schedules using T-SQL

I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like. One thing I have not found readily is the ability to create jobs while maintaining the scheduling in place. For those who may not be aware, the easiest way to… Read more

3 comments, 610 reads

Posted in Jared Zagelbaum's Blog on 26 May 2015

Synchronizing Read / Write SQL Agent Jobs Across AlwaysOn Replicas

Intro

AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like mirroring and log shipping. However, there is also additional complexity involved in implementing this technology, and one of the stickiest areas for database administrators is having to deal with… Read more

11 comments, 6,320 reads

Posted in Jared Zagelbaum's Blog on 5 May 2015

Automated Restore Script Output for Ola Hallengren’s Maintenance Solution

Intro

This blog post is designed to be useful to two different audiences:

  1. Those implementing Ola Hallengren’s Maintenance Solution for the first time
  2. Those that have been using it for awhile, but might have a hole in their DR plan – what to restore when a resource goes offline

There’s… Read more

28 comments, 4,727 reads

Posted in Jared Zagelbaum's Blog on 16 April 2015

Delete unused SQL Agent jobs from instance

I recently worked on a project where the client requested to “remove all of the unused jobs” that had been installed across their production instances over time. I originally thought that using the enabled property would lead me to the right jobs, but as that is user dependent, and the… Read more

5 comments, 7,750 reads

Posted in Jared Zagelbaum's Blog on 1 April 2015

Consolidating time series metadata for users in Tabular

Background

DAX offers many powerful time intelligence functions that can be applied at virtually any level of a date / time hierarchy. There are also custom patterns available that can be implemented for week based and ISO 8601 calendars that will emulate the same functionality (case in point, see Time… Read more

1 comments, 6,313 reads

Posted in Jared Zagelbaum's Blog on 4 February 2015

SSRS SharePoint Integrated Mode – Report Server URL

This is a short, but hopefully sweet post for someone, whom, like me, might have had to end up spending a few hours trying to find the Report Server URL for SSRS 2012 (or newer)  SharePoint integrated Mode. I found it in Microsoft documentation, but I don’t remember where, so… Read more

0 comments, 2,417 reads

Posted in Jared Zagelbaum's Blog on 3 December 2014

Update all SSRS reports to apply consistent header / footer on demand

Teaching good old SSRS a new trick…

Background

Not too long ago I had a client with a very simple, yet practical requirement: they wanted all of their SSRS reports to have standard headers and footers. Nothing ground breaking there, however, the twist that they put on this requirement was… Read more

4 comments, 683 reads

Posted in Jared Zagelbaum's Blog on 14 November 2014

Let’s get started

Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to give back to the great community that has provided me with the knowledge to build my career over the years. Hopefully, I’ll be able to help a frustrated person out… Read more

0 comments, 309 reads

Posted in Jared Zagelbaum's Blog on 10 November 2014