April 25, 2011 at 1:04 am
Jeff,
VSTA is installed by SQL Server 2008 for use with SSIS scripting (see http://msdn.microsoft.com/en-us/library/bb522527(v=SQL.100).aspx). SQL Server 2005 used something called VSA (notice the missing 'T'). VSTA can be used to edit and build existing .NET projects in VB or C#, but it can't create new ones. It is intended to support SSIS only so even running VSTA.exe /SETUP (http://blog-mstechnology.blogspot.com/2009/11/no-template-information-found-visual.html) only installs the templates for SSIS projects, not VB or C#.
You don't need anything (aside from the .NET framework everyone gets with a SQL Server install) to build .cs files - you can use the csc command-line compiler the flash UIs use underneath. See http://msdn.microsoft.com/en-us/library/ms379563(v=vs.80).aspx and http://msdn.microsoft.com/en-us/library/78f4aasd.aspx.
Having a good UI tool installed does make writing new code a much more pleasant experience though, so it is worth installing a 'proper' version of Visual Studio - either Express or a full version from your MSDN and TechNet subscriptions. Perhaps do it in a VM if you just want to test drive it.
Installing Visual Studio also gives you the choice of writing your SQL CLR code in C/C++, VB.NET, C#, or F#. You can write in an even wider variety of languages like M, Python, and Ruby via add-ins. This all works because whatever language you use compiles down to the same intermediate platform-independent code.
Paul
April 25, 2011 at 4:34 am
GilaMonster (4/23/2011)
Jack Corbett (4/23/2011)
So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx
Want to swap? I'm having some amusement with someone who has alphabet soup in their sig.
http://www.sqlservercentral.com/Forums/UserInfo938631.aspx and http://www.sqlteam.com/forums/search.asp?mode=DoIt&MEMBER_ID=68011
No, I'm not asking for an assist, much less a pile-on please.
Oh, heavens. This thread of his is particularly amusing:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159655
Someone is paranoid about his job, methinks. @=)
April 25, 2011 at 4:48 am
Brandie Tarvin (4/25/2011)
GilaMonster (4/23/2011)
Jack Corbett (4/23/2011)
So now we have someone saying don't REORG indexes only REBUILD and you don't need to do statistics maintenance.http://www.sqlservercentral.com/Forums/Topic1094168-146-3.aspx
Want to swap? I'm having some amusement with someone who has alphabet soup in their sig.
http://www.sqlservercentral.com/Forums/UserInfo938631.aspx and http://www.sqlteam.com/forums/search.asp?mode=DoIt&MEMBER_ID=68011
No, I'm not asking for an assist, much less a pile-on please.
Oh, heavens. This thread of his is particularly amusing:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159655
Someone is paranoid about his job, methinks. @=)
Good gosh, he should be. If I find out someone has spent all day, every day, running maintenance routines, during business hours, instead of scheduling them... yeah, he should be VERY paranoid about his job.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 25, 2011 at 5:29 am
He has an obsession with max worker thread setting at the moment. $Deity knows why, it's one of those settings that shouldn't be touched without a really good reason.
http://www.sqlservercentral.com/Forums/FindPost1097698.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2011 at 6:35 am
All,
I'm speaking about designing a data recovery plan at SQL Saturday 74 this weekend and am looking for some flavor to add to the presentation.
Does anyone have any RL examples of when a Boss or Customer asked for something unreasonable in the recovery plan? Bad SLA expectations, etc. Anything besides "It's all important! We can't lose one single thing!"
April 25, 2011 at 7:02 am
SQLkiwi (4/25/2011)
Jeff,VSTA is installed by SQL Server 2008 for use with SSIS scripting (see http://msdn.microsoft.com/en-us/library/bb522527(v=SQL.100).aspx). SQL Server 2005 used something called VSA (notice the missing 'T'). VSTA can be used to edit and build existing .NET projects in VB or C#, but it can't create new ones. It is intended to support SSIS only so even running VSTA.exe /SETUP (http://blog-mstechnology.blogspot.com/2009/11/no-template-information-found-visual.html) only installs the templates for SSIS projects, not VB or C#.
You don't need anything (aside from the .NET framework everyone gets with a SQL Server install) to build .cs files - you can use the csc command-line compiler the flash UIs use underneath. See http://msdn.microsoft.com/en-us/library/ms379563(v=vs.80).aspx and http://msdn.microsoft.com/en-us/library/78f4aasd.aspx.
Having a good UI tool installed does make writing new code a much more pleasant experience though, so it is worth installing a 'proper' version of Visual Studio - either Express or a full version from your MSDN and TechNet subscriptions. Perhaps do it in a VM if you just want to test drive it.
Installing Visual Studio also gives you the choice of writing your SQL CLR code in C/C++, VB.NET, C#, or F#. You can write in an even wider variety of languages like M, Python, and Ruby via add-ins. This all works because whatever language you use compiles down to the same intermediate platform-independent code.
Paul
Thanks, Paul. I started looking around and found the express versions you speak of. I really do need to get out more... I had no idea that such a thing was available.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 25, 2011 at 7:19 am
GilaMonster (4/25/2011)
He has an obsession with max worker thread setting at the moment. $Deity knows why, it's one of those settings that shouldn't be touched without a really good reason.
He's quickly becoming an example of why all those certifications he has listed are meaningless. Though that is what I'd expect of an IBMCDBA.
I don't know everything, but I also don't have a bunch of letters after my name that claim I should.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 25, 2011 at 7:45 am
Stefan Krzywicki (4/25/2011)
GilaMonster (4/25/2011)
He has an obsession with max worker thread setting at the moment. $Deity knows why, it's one of those settings that shouldn't be touched without a really good reason.He's quickly becoming an example of why all those certifications he has listed are meaningless. Though that is what I'd expect of an IBMCDBA.
I don't know everything, but I also don't have a bunch of letters after my name that claim I should.
On behalf of everyone with alphabet soup sigs (looking at my own @=), just because I have them doesn't mean I'm claiming to know everything. In fact, I'll be the first to say I don't know everything I should (or want to) know.
April 25, 2011 at 7:56 am
Stefan Krzywicki (4/25/2011)
I don't know everything, but I also don't have a bunch of letters after my name that claim I should.
I do have a bunch of letters (a long bunch), they don't mean I know everything (the set of letters that implies that isn't there yet).They're not in my sig simply because I don't see the need to have then there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2011 at 8:54 am
GilaMonster (4/25/2011)
Stefan Krzywicki (4/25/2011)
I don't know everything, but I also don't have a bunch of letters after my name that claim I should.I do have a bunch of letters (a long bunch), they don't mean I know everything (the set of letters that implies that isn't there yet).They're not in my sig simply because I don't see the need to have then there.
Oh, I know and my apologies to you, Brandie and others who have done the certifications. It is just that all too often I see people brandishing the letters as statements of authority even while they spout nonsense. I get frustrated when I encounter managers who think the letters substitute for needing to interview. I get annoyed with the people who have the letters who think it does mean they know everything.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 25, 2011 at 10:22 am
Stefan Krzywicki (4/25/2011)
...all too often I see people brandishing the letters as statements of authority even while they spout nonsense...
Exsqueeze me, but I can spout nonsense without requiring any statement of authority. It's a particular talent of mine!
Oh, wait. I guess I do have those letters after my name too.
Brandie Tarvin - PhD. B.S.
:hehe:
April 25, 2011 at 10:24 am
Is anyone else having trouble getting thread notifications from SSC today?
I noticed the issue last Friday too, but today it's particularly bad. I just received notification for Jeff's last post, which was several hours ago.
April 25, 2011 at 10:27 am
Brandie Tarvin (4/25/2011)
I noticed the issue last Friday too, but today it's particularly bad. I just received notification for Jeff's last post, which was several hours ago.
Today's good for me. Yesterday I was getting notifications 10 hours late. Today it's just 3.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2011 at 10:31 am
GilaMonster (4/25/2011)
Brandie Tarvin (4/25/2011)
I noticed the issue last Friday too, but today it's particularly bad. I just received notification for Jeff's last post, which was several hours ago.Today's good for me. Yesterday I was getting notifications 10 hours late. Today it's just 3.
Adverse winds for the carrier pigeons? 😉
April 25, 2011 at 10:55 am
GilaMonster (4/25/2011)
Brandie Tarvin (4/25/2011)
I noticed the issue last Friday too, but today it's particularly bad. I just received notification for Jeff's last post, which was several hours ago.Today's good for me. Yesterday I was getting notifications 10 hours late. Today it's just 3.
Ditto - seeing the same kind of "improvement"
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 25,921 through 25,935 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply