Business CaseRecently I had an opportunity to inherit a system from a client for doing some enhancements. One of the tasks involved in the project was also to clean up the system which had lots of left overs like unused…
SSMS Table Designer Not Recognizing Rowversion Datatype
This blog is the result of a recent discussion I had with my fellow colleagues. One of my colleagues asked me why rowversion is not recognized as a valid datatype with SQLServer. I was surprised at this statement and told…
T-SQL Tips: Customizing CDC for Oracle Service Implementation in SQLServer
The purpose of this blog is to explain a quick tip which you can implement to customize the default functionality of CDC for Oracle service in SQLServer to help you overcome the limitation posed by the default deployment script. Business…
T-SQL Tips: UDF To Swap The Parts Of A Datetime Value
Context There was a requirement recently which required changing only the year portion of one of the date fields.The business scenario was to extend validity of insurance details on a table.I’ve also come across similar requests in forums also asking…
T-SQL Tips: Modify All Default Constraints in a Database Based on a Common Value
Context This blog discusses a method that can be applied for doing the modification of default constraints on multiple fields within a database which currently points to one value Scenario Recently in one of my projects there was a need…
IIf function T-SQL vs SSRS Behavioral Difference
This blog explains on the behavioral difference of IIf function between Reporting Services and in Transact SQL.IIf function was a new addition in SQL Server 2012 which provides a simplified way to implement conditionally logic. Though we have a similar…
Know Your DMVs : sys.dm_exec_procedure_stats
Context The impetus behind this post is a technical conversation I had with a fellow team member couple of days back. He was doing the performance analysis of a few procedures in a datawarehouse and was using the DMV sys.dm_exec_procedure_stats…
T-SQL Tips: Multifaceted MERGE Statement
MERGE statement was a very useful addition which was introduced from SQL 2008. It is very useful in lots of day to day scenarios like normal UPSERT (UPDATE + INSERT) operations, slowly changing dimension processing etc. This blog aims at…
T-SQL Tips: Fun with date FORMATing
FORMAT was a new function introduced in SQL 2012 which can be use to format date,numeric values to a variety of different formats and styles.This blog discusses on some of the cool date value formatting tips that can be done…
Troubleshooting SQLServer CDC Service for Oracle Capturing Only Changed Column Values for Updates Issue
Recently for one of my datawarehouse projects we had a scenario which required getting data from a Oracle server. Since this Oracle server was a high end OLTP system with high frequency DML operations happening the impact on the system…