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…
Programaticaly executing packages in SSIS 2012 project deployment model
The usual way to execute SSIS packages programmatically was by invoking Dtexec utility until SQL 2012. With the arrival of project deployment model in SSIS 2012 we can now rely upon catalog view and system stored procedures for executing SSIS…
Demystifying LAST_VALUE function in SQL 2012
The impetus for writing this blog is the ambiguity existing regarding the documentation of LAST_VALUE() function in books online/ MSDN.Recently I was playing around with new analytic functions of SQL 2012. Was trying to implement the LAST_VALUE functionality when I noticed the…
Implementing Checkpoints in SSIS
Checkpoints indicate a consistent state of a database. This is essential for database to perform actions like writing to log file, truncating log etc.The concept of checkpoints have also been implemented in SSIS packages. Checkpoints will indicate a saved consistent state in…
Error Handling in SSIS loops
This is an extension to the below posthttp://visakhm.blogspot.in/2012/05/package-to-implement-daily-processing.htmlwhere I explained the usage of looping logic in SSIS to do automated file processing on daily basis. One of the common issues we face in above scenario is ability to handle error…
Retrieve latest weekday date from a given date
Recently for one of my projects there was a requirement to get the latest Tuesday from a date value. I had used the below logic for the requirement. I’m converting it to a UDF and posting it here so that…
Technical tips for SQL Server
As you were probably aware, last Friday we had techweets which was an initiative by South Asia MVPs to post day long technical tweets. In case you missed it, I’m sharing the tips through this blog which I’d tweeted as…
Techweets- Whole day technical tweets
Techweets is happening. Day full of technical tips as tweets from South Asia MVPs @IndiaMVP. I’m posting techtip every 30 mins. Follow my tweets at #techweets @IndiaMVP
Object Filtering using SSMS object explorer
A little known but very useful feature in SQL Server Management Studio (SSMS) is the ability to filter objects (tables, stored procedures etc) by specifying a variety of filter conditions. This particularly comes handy in cases where you need to…
Wildcard based character search using PATINDEX
This is a follow up of the below blog on wildcard character based searchhttp://visakhm.blogspot.in/2013/01/wildcard-character-based-pattern-search.html Extending this further, I did some experiments on how various wildcard characters will work inside pattern in t-sql .Lets see how we can apply similar logic…