• Start
  • About
  • Contact
mattssok.com
Menu Close
  • Start
  • About
  • Contact

T-SQL

How to resolve the metadata issue when using a stored procedure as source in SSIS?

2019-11-26mattssok Leave a Comment

So you want to use a stored procedure as source (EXECUTE dbo.usp_YourProcedure) in your SSIS data flow but all it gives you is some weird could not determine metadata error… That can be resolved with an easy step – RESULT… Continue Reading →

Business Intelligence, SSIS, T-SQL Data flow, Data source, Metadata, OLEDB, SQL, SSIS, Stored Procedure

A quick, and not so dirty, date dimension for SQL Server

2019-01-29mattssok Leave a Comment

So this week I thought we should have a look at one of the many ways to build a date dimension. With that said I want to stress that most of this is borrowed/stolen from the great mssqltips. The changes… Continue Reading →

Business Intelligence, DateDimension, Procedure, Script, SSMS, T-SQL, Uncategorized BI, Date dimension, mssqltips, Script, SQL, Stored Procedure

Effortless deployment of code between environments with synonyms

2019-01-19mattssok Leave a Comment

One typical data warehouse or BI problem is keeping the code dynamic and consistent over multiple environments. Say that you have a BI solution and in said solution you have two databases, Stage and DataModel. Every day you truncate and… Continue Reading →

Business Intelligence, Procedure, Productivity, Script, SSIS, SSMS, SSMS, T-SQL, Uncategorized Dynamic, dynamic sql, synonym, T-SQL

A merge template for SCD2 loading

2019-01-05mattssok Leave a Comment

For me, working mainly with BI, the MERGE operator is by far one of the most useful ones. Since a lot of the work in a data warehouse is to store data in a structured and organized way the MERGE… Continue Reading →

Business Intelligence, Merge, Procedure, Productivity, SCD2, SSIS, SSMS, T-SQL BI, Merge, Raiserror, SCD2, SQL, T-SQL

Query the SSIS database for SQL Server Agent job status

2019-01-01mattssok Leave a Comment

Today there will be a short post of a semi useful query for you who want to monitor your Agent jobs without looking into the standard reports.

Agent, Procedure, Productivity, SSIS, SSMS, T-SQL, Uncategorized Job, SQL, SQL Server Agent, SSMS, Status, T-SQL

One way to standardize your SSIS packages (with dynamic SQL)

2018-12-22mattssok Leave a Comment

This time I thought we can have a look at one way of making your SSIS packages a bit more copy and paste friendly. The assumption in this case is that your source is a SQL Server database and that… Continue Reading →

Editor, Procedure, Productivity, Script, SSIS, T-SQL Control flow, Data flow, Dynamic, Package, Productivity, SQL, SSIS, Stored Procedure, Variables

SQL Server – drop and alter constraints

2018-12-15mattssok Leave a Comment

Hi all! This week we will have a look at an easy and convenient way to get around those situations when you have been a good developer and used you constraints. (As you should.) However, for some reason you need… Continue Reading →

Productivity, Script, SSMS, T-SQL, Uncategorized Alter, Constraint, Drop, Enable, Primary key, Script, SQL, TSQL

Add dummy rows to a table to enforce primary/foreign key constraint

2018-12-08mattssok Leave a Comment

Sometimes the data is not what you want it to be. Or rather the quality is not what you want it to be. What I am referring to in this case is when you have a primary key and you… Continue Reading →

Procedure, Productivity, Script, SSMS, T-SQL Columns, Foreign key, Primary key, Productivity, Script, SQL, SSMS, Stored Procedure, T-SQL, Table Definition

Two useful functions that you should bind in SSMS

2018-11-27mattssok Leave a Comment

So this is my first post in a while so I though we could look at two useful SSMS customizations that I use somewhere around 20-150 times each day. (Yes, those figures are directly correlated to the length of my… Continue Reading →

Editor, Productivity, SSMS, T-SQL, Uncategorized Columns, Productivity, SQL, SSMS, Stored Procedure, T-SQL, Table Definition, Tables

Archives

  • November 2019 (1)
  • January 2019 (4)
  • December 2018 (3)
  • November 2018 (1)

Categories

  • Business Intelligence (4)
    • SCD2 (1)
  • Productivity (7)
    • Editor (2)
    • SSMS (2)
  • SSIS (5)
    • Agent (1)
  • SSMS (6)
  • T-SQL (9)
    • Merge (1)
    • Procedure (6)
      • DateDimension (1)
    • Script (5)
  • Uncategorized (5)
© 2021 mattssok.com. All rights reserved.
Fashionista by aThemes