Author Archive > yoad

SQL Server – TSQL development – Great Articles

Check out this article: http://www.sommarskog.se/dynamic_sql.html regarding Dynamic SQL. The author describes the technology, different options and basically a lot of insights from his experience. And this article from the same author: http://www.sommarskog.se/dyn-search-2008.html about dynamic search conditions (when we can filter a list of data using one or more filters.. basically every list report in backoffice [...]

Continue reading

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

Subversion, JIRA and Visual Studio – Some integration options

There is a good reason why you would want to be able to link from a Jira issue to an svn commit(s) and vice versa.If you cant think of a reason you can’t be my friend (and you may not want to further read this post). I would like to describe here some tools and [...]

Continue reading

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...

SQL Server Express – Where is the scheduler?

There isn’t one,¬†Apparently. SQL Server Express edition does not come with the “SQL Agent” component which among other things is responsible for job scheduling. In order to still be able to schedule jobs, several options are available: Stone age technique – Create batch files to run sql scripts using the command line utility “SQLCMD“. Schedule [...]

Continue reading


1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading ... Loading ...
Rss Feed Tweeter button Facebook button Linkedin button