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...
2016-03-11
5,109 reads
Jared Zagelbaum's Blog
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...
2016-03-11
325 reads
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...
2015-10-08 (first published: 2015-09-29)
3,164 reads
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...
2015-09-09
1,279 reads
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....
2015-05-26
2,086 reads
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...
2015-05-15 (first published: 2015-05-05)
6,823 reads
Automated Restore Script Output for Ola Hallengren’s Maintenance Solution
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
6,023 reads
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...
2015-04-09 (first published: 2015-04-01)
8,484 reads
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....
2015-02-13 (first published: 2015-02-04)
6,624 reads
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...
2014-12-03
2,697 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers