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,098 reads
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
5,098 reads
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
308 reads
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,160 reads
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,240 reads
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
1,649 reads
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,812 reads
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,006 reads
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,451 reads
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,617 reads
This is a short, but hopefully sweet post for someone, whom, like me, might have had to end up spending...
2014-12-03
2,690 reads
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Comments posted to this topic are about the item How Many Can Be the...
Comments posted to this topic are about the item How to process images and...
Comments posted to this topic are about the item Patching the Patch
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers