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

Uncategorized

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

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

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

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