Sometimes we don’t have a choice on what data we work with, where it’s from or what format we have to deal with. This, in a way, can effect the time take to develop a solution.
In this case we will be looking at XML Data, and how to effortlessly convert that data to a dynamic object which we can easily work with.
Read more “How to convert an XML Document to a Dynamic Object in .NET”
I’ve been in discussions with other bloggers out there, and a few of us came to a mutual agreement to feature “guest” posts every once in a while. keep an eye out.
Please note this is an expansion to the article on HOW TO ALLOW A USER WITH AN SQL LOGIN TO MANAGE SQL SERVER AGENT.
The entire source code, with comments, for this tutorial can be downloaded here.
in the mentioned article we learnt how to set up an SQL user to manage SQL Jobs, in this article we are going to learn how to manage jobs through a C# application,
and we will be using the SQL user created in the mentioned article to connect to the database and actually mange the SQL Server Agent jobs.
Please NOTE: SQL Server 2008 R2 or later must be installed on your development machine.
What tools am I using ?
Read more “How to manage SQL Server Agent jobs through Csharp”