MSSQL – Runaway Job, Missing Max Run Time for SQL Job (Tame Them…)

Hi, Recently an issue attracted my attention where we needed to tame the runaway SQL jobs, where the step in the job to import a file from the FTP source at times would run up to 2 days (which would normally complete in ~2 minutes). Well at times ftp downloads by scripts are affected by Read More …

SQL – Backup Database Schema and SQL Jobs via Powershell

Hi, being a developer at times we value our code more than the content that is modifies… Hmmm.. Well sounds suspicious from the business standpoint, but from a developer perspective our code is gold !!!! Any ways, this post outlines one of the methods to backup your MSSQL database schema and SQL jobs regularly. This Read More …

Cannot set the initialization properties for OLE DB provider “MSOLAP” for linked server, Double Hop Authentication

Ohhh… Well the above words can only describe the pain which I encountered again on a different combination of multi server components authentication of MSBI using windows authentication. Well the set up, I worked with is as follows: So as it goes, I had a chart on SSRS, which sources the data from the SQL Read More …

SQL – Drop and Rebuild Foreign Keys, Dynamic ALTER Statements

In the data warehousing world of relationship, identification at the earliest is vital (lets say we are targeting a star schema Kimball model). But at times you miss out on the critical information during requirement phase and later is brought (even change of business requirements) on table that you have add a new dimension to Read More …