|
...in a service that is intended to fill in where Sql Server Express is lacking?
I discovered that SQL Server Express lacks the ability to implement agents, so I'm writing a service that provides agent-like capabilities. It uses MEF to allow plugin DLLs to be developed that can run like an agent at specified intervals, specific times, based on your own triggering mechanism (such as using a FileSystemWatcher), or on-demand (from another desktop/web application).
You could even run agents against any instance of SQL Server on your network from the same service.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
modified 21-Jan-15 11:04am.
|
|
|
|
|
Sounds glorious to me: go for it !
cheers, Bill
«I'm asked why doesn't C# implement feature X all the time. The answer's always the same: because no one ever designed, specified, implemented, tested, documented, shipped that feature. All six of those things are necessary to make a feature happen. They all cost huge amounts of time, effort and money.» Eric Lippert, Microsoft, 2009
|
|
|
|
|
Yes.
I've thought of doing some work in SQLServer Express at home, but have delayed because of the very issue you raise. Yes, I can get to a full version of SQL using my work credentials, but that would be using an illegal copy, so I haven't.
Tim
|
|
|
|
|
If you are able to run this on older versions of SQL Server then hell yes.
As I am working with SQL Server 2008 R2 at present.
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
Any instance of any version. Each agent executes the code you write, and connects to the database you specify. Any sql query you write in the agent would be task-specific, so it would be version-agnostic. You could even run the service on a machine that doesn't have sql server installed on it.
I'm also going to try to make agent modules be able to trigger on-demand run requests between each other.
You could potentially setup a system that interacts with several SQL instances at once, regardless of their version.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Anything that advances the cause. Go for it!
|
|
|
|
|
Oh heck yeah!,
That would make YOU the slayer of Kesi!
(Which reminds me, white rats, lab mice, even wildtype mice captured from around the apartment and domesticated (sp), should have plenty of casein in their diet. And remember that not all commercial rodent food are created equal)
Your friend, RedDk ...
|
|
|
|
|
Sounds intriguing...
If your actions inspire others to dream more, learn more, do more and become more, you are a leader.-John Q. Adams
You must accept one of two basic premises: Either we are alone in the universe, or we are not alone in the universe. And either way, the implications are staggering.-Wernher von Braun
Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.-Albert Einstein
|
|
|
|
|
Absolutely, yes! Go for it, John!
Will Rogers never met me.
|
|
|
|
|
I'd be interested in using it. Worked on something like this some years back, and may need something like this again the future. Do you need help and are you posting it online?
|
|
|
|
|
Nope, don't need help, and was going to post it as an article.
|
|
|
|
|
"Google is now a more trusted source of news than the websites it aggregates" [^]:
"Online search engines have overtaken traditional media as the most trusted source for general news and information, according to a global survey of 27,000 people by Edelman, a public relations firm. The data will be presented to delegates at the World Economic Forum in Davos this week.
The trust gap between traditional media and search engines is even more pronounced among millennials." I guess this explains why my cursor is lit up with a blue-fluorescence reminiscent of Cherenkov Radiation.
«I'm asked why doesn't C# implement feature X all the time. The answer's always the same: because no one ever designed, specified, implemented, tested, documented, shipped that feature. All six of those things are necessary to make a feature happen. They all cost huge amounts of time, effort and money.» Eric Lippert, Microsoft, 2009
|
|
|
|
|
I remember some #cough cough# years ago when I was studying Politics at A-Level discussing olde worlde news sources. A rather well informed professor gave us articles from different papers on the same event and we had to compare them. One thing that came out of this was that [0] the more news sources you used, the more honest the aggregated information was and [b] Margaret Thatcher was a bithc.
veni bibi saltavi
|
|
|
|
|
Funny thing is that most of the times, news journals are posted by their authors after Google-ing about the Hot topics of that day.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Google themselves aren't the source of the news, though, so it's a good thing. Any bias in the results you get is likely to be the bias you wanted.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
I wish google would implement a bullshit meter on it's posts.
New version: WinHeist Version 2.1.0
My goal in life is to have a psychiatric disorder named after me.
I'm currently unsupervised, I know it freaks me out too but the possibilities are endless.
|
|
|
|
|
I don't think there'd be room for numbers that big.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
In the States we have "The Daily Show" for when we want the news.
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "As far as we know, our computer has never had an undetected error." - Weisert | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
|
Is when this comet is estimated to return. How would life on Earth be at that time?
|
|
|
|
|
Life will carry on. Whether or not humans are still in 'control' is another matter!
|
|
|
|
|
Avijnata wrote: How would life on Earth be at that time?
Well, at least Obama won't be the president. Silver linings, people.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Here is my list:
1. XML (Both human and computer have difficulties reading this crap. It's slow as dismembered turtle. Also the tools and accompanying technologies related to XML are crap too. Only Java use to have some dissent XML libraries, but Java is dead for good, so no much use of these.)
2. Web Services (Spawn of the devil. Working with this gives you a depression. .Net tools are not so bad. SOAP is a good protocol. But the entre thing is hit and miss situation. Definitely the result not worth the effort, except for some specific cases.)
3. COM (I have more than a decade long, love-hate relationship with COM. Very useful in some cases, but PITA most of the time. Really steep learning curve.)
4. MFC (Haven't evolved a bit(pun not intended) for the last 15 years.)
There is only one Vera Farmiga and Salma Hayek is her prophet!
Advertise here – minimum three posts per day are guaranteed.
|
|
|
|
|
.NET
It is sluggish, heavy and the framework is poorly documented. The learning curve is way steeper than the COM one, considering that many framework classes are encapsulated COM this shouldn't surprise anyone.
Geek code v 3.12
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- r++>+++ y+++*
Weapons extension: ma- k++ F+2 X
|
|
|
|
|
Poorly documented? 3GB of help files are POOR? Dude, you're just troll.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
