Skip to content

Tomas Lind

  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software

Year: 2014

Get Inserted, Updated and Deleted members from MDS
Posted in
  • Master Data Services (MDS)

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

by Tomas Lind•2014/09/092014/09/08•3
Running an MapForce mapping from SSIS
Posted in
  • MapForce
  • SSIS

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

by Tomas Lind•2014/08/292015/04/24•0
Using MapForce to insert hierarchical XML to relational tables
Posted in
  • MapForce
  • XML

Using MapForce to insert hierarchical XML to relational tables

In an earlier blog post, I demonstrated a way to insert a hierarchical XML document into … Using MapForce to insert hierarchical XML to relational tablesRead more

by Tomas Lind•2014/08/192016/03/07•0
Max or min value from a set of columns
Posted in
  • T-SQL
  • Tips & Tricks

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

by Tomas Lind•2014/08/162014/08/15•0
Default collation different from instance default
Posted in
  • Collation
  • Configuration

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

by Tomas Lind•2014/06/122015/12/07•0
Error 3624 when creating natively compiled stored procedure
Posted in
  • Bug
  • In-Memory

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

by Tomas Lind•2014/05/242014/05/24•0
Sorted data flows in SSIS
Posted in
  • SSIS

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

by Tomas Lind•2014/05/202014/05/18•1
Add missing lookup in SSIS
Posted in
  • Master Data Services (MDS)
  • SSIS

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

by Tomas Lind•2014/05/132014/05/12•7
T-SQL function SERVERPROPERTY
Posted in
  • Configuration
  • System Stored Procedures

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

by Tomas Lind•2014/05/062015/12/07•0
Table Valued Parameters in Stored Procedures
Posted in
  • T-SQL

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

by Tomas Lind•2014/05/012014/04/28•0

Posts pagination

Previous 1 2 3 … 6 Next

confided data manager

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • How to align columns in Notepad++
  • Line numbers in t-sql error messages
  • CDC Cleanup job
  • Calculating Earned Premium in SQL Server
  • Export data from Excel to SQL Server

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2025 Tomas Lind.
Powered by WordPress and HybridMag.
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software