Did you know you can use Gmail to send emails from SQL Server?
SQL Server
Get Inserted, Updated and Deleted members from MDS
To get all inserted or updated members from a SQL Server MDS database, subscription views are … Get Inserted, Updated and Deleted members from MDSRead more
Running an MapForce mapping from SSIS
In an earlier blog post I demonstrated how to map between hierarchical (XML) and relational (SQL) … Running an MapForce mapping from SSISRead more
Max or min value from a set of columns
The min and max aggregates in SQL Server are normally used to work over rows, getting … Max or min value from a set of columnsRead more
Default collation different from instance default
If you have databases with another default collation than the instance default, you may get something … Default collation different from instance defaultRead more
Error 3624 when creating natively compiled stored procedure
I was trying to upgrade my MACD technical analysis calculation to use the new In Memory … Error 3624 when creating natively compiled stored procedureRead more
Sorted data flows in SSIS
Sometimes a data flow in SSIS needs to be sorted. It may be because the business … Sorted data flows in SSISRead more
Add missing lookup in SSIS
Before a fact table is loaded, a common pattern is to do a lookup in SSIS … Add missing lookup in SSISRead more
T-SQL function SERVERPROPERTY
The T-SQL function SERVERPROPERTY returns a lot of properties about the current SQL Server instance. The … T-SQL function SERVERPROPERTYRead more
Table Valued Parameters in Stored Procedures
In most cases stored procedures are developed so that it accepts a number of input parameters … Table Valued Parameters in Stored ProceduresRead more