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…
String pattern search – XML based method
Its a common scenario these days to search for a string value within a delimited list. Though its not a good design to store delimited values inside a table field, I’ve come across numerous cases where I’ve inherited systems with…
system_sql_modules and all_sql modules views
Previously I’d blogged on the advantages of using sys.sql_modules view here http://visakhm.blogspot.in/2012/03/advantages-of-using-syssqlmodules-view.html There are two more related views available from SQL 2005 onwards. They’re sys.system_sql_modules and sys.all_sql_modules. So how are they different from sys.sql_modules? The difference is as followssys.sql_modules –…
Wildcard character based pattern search in T-SQL
Today happen to see a question based on wildcard characters search within a string pattern in a forum. I gave the solution for it and in my efforts found that the documentation given on this is not clear enough in…