I’ve seen on quite a few occasions of people asking ways to validate the source data especially in integration and ETL type of projects. The usual suggestion in those cases is to leverage upon the set of standard validation functions…
Get the Nth positioned string from a delimited list
Today had a colleague asking me on a method to return particular positioned string from a delimited list. The scenario was like belowConsider a string like abcd-efgh-jkl-mnop-qrst-uvwx. The requirement was to get 3rd string from it ie ijkl. The usual…
Checking database access rights for a user in a sqlserver instance
There was a recent requirement in one of my projects to check the access for particular user in all the databases in a server. Thought of sharing the script used through the blog for quick reference. The solution makes use of…