March 30, 2016 at 8:49 am
From what I know about VB.NET and C# (which isn't a lot), VB.NET does things for you behind the scenes that you have to do explicitly in C#. That could also be an IDE thing for all I know.
March 30, 2016 at 8:59 am
Lynn Pettis (3/30/2016)
From what I know about VB.NET and C# (which isn't a lot), VB.NET does things for you behind the scenes that you have to do explicitly in C#. That could also be an IDE thing for all I know.
This is true from both sides. For example vb.net does not have a USING statement. For those unfamiliar with that statement it is really powerful. You can wrap any object that inherits iDisposable with a USING statement (things like sql connections) and they will automatically be disposed of when the code exits the block. You of course can do this inside a FINALLY in vb.net but in C# you don't have to close and dispose of your connections manually.
One thing I wish C# had is WITH blocks. Those are so handy.
There are plenty of good things about both languages.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 30, 2016 at 9:02 am
Sean Lange (3/30/2016)
Lynn Pettis (3/30/2016)
From what I know about VB.NET and C# (which isn't a lot), VB.NET does things for you behind the scenes that you have to do explicitly in C#. That could also be an IDE thing for all I know.This is true from both sides. For example vb.net does not have a USING statement. For those unfamiliar with that statement it is really powerful. You can wrap any object that inherits iDisposable with a USING statement (things like sql connections) and they will automatically be disposed of when the code exits the block. You of course can do this inside a FINALLY in vb.net but in C# you don't have to close and dispose of your connections manually.
One thing I wish C# had is WITH blocks. Those are so handy.
There are plenty of good things about both languages.
Well shoot. I said the USING block was missing with such certainty I figured I should look. Last time I used vb.net I couldn't find one...it seems it is there. :blush:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 30, 2016 at 9:18 am
Sean Lange (3/30/2016)
Lynn Pettis (3/30/2016)
From what I know about VB.NET and C# (which isn't a lot), VB.NET does things for you behind the scenes that you have to do explicitly in C#. That could also be an IDE thing for all I know.This is true from both sides. For example vb.net does not have a USING statement. For those unfamiliar with that statement it is really powerful. You can wrap any object that inherits iDisposable with a USING statement (things like sql connections) and they will automatically be disposed of when the code exits the block. You of course can do this inside a FINALLY in vb.net but in C# you don't have to close and dispose of your connections manually.
One thing I wish C# had is WITH blocks. Those are so handy.
There are plenty of good things about both languages.
I learned VB around the time of VB3 and then moved to VB.NET (painful!). I made the switch to C# (also painful) when SSIS scripts started supporting C# and I haven't looked back. C# syntax suits my brain better than VB ... I think that it's VB's relative verbosity, when compared with C#, that I dislike the most.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 30, 2016 at 10:11 am
Phil Parkin (3/30/2016)
Sean Lange (3/30/2016)
Lynn Pettis (3/30/2016)
From what I know about VB.NET and C# (which isn't a lot), VB.NET does things for you behind the scenes that you have to do explicitly in C#. That could also be an IDE thing for all I know.This is true from both sides. For example vb.net does not have a USING statement. For those unfamiliar with that statement it is really powerful. You can wrap any object that inherits iDisposable with a USING statement (things like sql connections) and they will automatically be disposed of when the code exits the block. You of course can do this inside a FINALLY in vb.net but in C# you don't have to close and dispose of your connections manually.
One thing I wish C# had is WITH blocks. Those are so handy.
There are plenty of good things about both languages.
I learned VB around the time of VB3 and then moved to VB.NET (painful!). I made the switch to C# (also painful) when SSIS scripts started supporting C# and I haven't looked back. C# syntax suits my brain better than VB ... I think that it's VB's relative verbosity, when compared with C#, that I dislike the most.
Agreed. I used VB back starting with VB5 and VB6 then migrated to classic asp. Once dotnet came out we quickly migrated to asp.net using C#. I liked the syntax a lot better as it was a lot fewer words. And it is the almost identical syntax across the board with javascript so switching between those two is super painless.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 30, 2016 at 11:06 am
Can someone who knows how Microsoft has chosen to implement snapshot Isolation take a lppk here? I've answered as best I can, but my answers are based on stuff I was doing about 25 years ago, not even on what Microsoft actually did 10 or 12 years ago let alone how SQL Server works today.
Tom
March 30, 2016 at 11:37 am
TomThomson (3/30/2016)
Can someone who knows how Microsoft has chosen to implement snapshot Isolation take a lppk here? I've answered as best I can, but my answers are based on stuff I was doing about 25 years ago, not even on what Microsoft actually did 10 or 12 years ago let alone how SQL Server works today.
Your explanation is very accurate. At least, according to my understanding and rereading that section of Kalen's book.
"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
March 30, 2016 at 11:47 am
David Burrows (3/30/2016)
It more a personal familiarity than C# is awful.I have been coding Basic, QBasic and VB for 40+ years and 90+% of my job is working with VB.NET, so trying to remember C# constructs takes me time (I am getting old you know)
I found C and C++ less of a problem, although C# should be easier.
I have converted several C# projects to VB just so that I do not have to work with C# 😉
The only real gripe I have it that I could never get C# IntelliSense and debugging to work well in VS, probably due to some configuration but I just cannot be bothered as my work with C# is so minimal.
There is a lot of debate over which is best.
I work faster and easier with VB so I use VB.
I do not berate people who use C#, whatever floats your boat 😀
Of course it's always possible that finding C# difficult was a result of the problem Dijkstra mentioned with Basic ("It is practically impossible to teach good programming to students that have had a prior exposure to BASIC: as potential programmers they are mentally mutilated beyond hope of regeneration"). :w00t:
But I too find C# difficult; that's a result of deciding not to learn it, because it's part of the C family so it must be inherently evil (although I suspect it's not quite as evil as C++ :sick:, in which I did manage to do some useful things despite its utterly appalling awfulness as an example of language design).
edit: By the way, what I quote above is something Dijkstra wrote about Basic in 1975; the statement about Basic that he's most often claimed to have made was actually about Cobol ("The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense") - it's in the same 1975 Dijkstra aphorism collection as his Basic comment.
Tom
March 30, 2016 at 11:57 am
Sean Lange (3/30/2016)
Greg Edwards-268690 (3/30/2016)
Sean Lange (3/30/2016)
David Burrows (3/30/2016)
Chad Crawford (3/29/2016)
Feeln' good. 😀+1
I am a developer and I knew the answer :w00t:
:sick: Blurgh! I hate C#
Not to start a huge debate or anything but what is so awful about C# that you have such negative feelings about it? I can understand some languages causing such hatred like RPG or JCL. If C# is so awful, what language(s) do you prefer and why?
Many times your perception of language is determined by your troubleshooting experience.
And the code some other developer left for you that's causing a problem.
RPG - I've seen it represent itself as understandable as well written and easy to follow the flow.
And as spaghetti, a pile of noodles with no sauce.
Part of it too is likely your exposure level when a production issue is tossed over the wall at you.
Some managers seem to think all the languages are the same, and all coders have the same style.
You see so many job descriptions that imply if you can start your car in the morning, if it dies halfway to work, you should be able to fix it using a toothbrush. And still be there early.
On something that will help your mind wander away from the generally dismal interview process, this weekend BBQ Ribs on the menu at our annual Grand Marais poker weekend. I am hungry already.
Nice!!! Two of my favorite things...ribs and poker. Add some dark malt beverages you have described my personal nirvana. 🙂 Myself I found a crazy deal on pork shoulders. Full picnics at $1.14/pound. That is unbelievably cheap around here. I picked up 4 of them so I will be firing up my smoker this weekend too.
Fitgers in Duluth and Castle Danger will be stops on the way up for beverages.
Already have empty growlers ready for exchange.
Both of these micro breweries have a good mix.
Castle Danger has excellent IPA, but also some great stout and brown ale.
Fitgers has a tasty habanero enhanced one that excites the senses.
Will be in KC area in June. Hot Rod Power Tour ends there this year.
One of the guys is researching the local BBQ's.
Any recommendations?
March 30, 2016 at 12:20 pm
Grant Fritchey (3/30/2016)
TomThomson (3/30/2016)
Can someone who knows how Microsoft has chosen to implement snapshot Isolation take a lppk here? I've answered as best I can, but my answers are based on stuff I was doing about 25 years ago, not even on what Microsoft actually did 10 or 12 years ago let alone how SQL Server works today.Your explanation is very accurate. At least, according to my understanding and rereading that section of Kalen's book.
Thanks, Grant.
I've no idea why the OP is interested in the mechanism, but I tend to to regard curiosity as a good characteristic in a developer or a dba or a sysdmin, so I gave an answer and wanted to be sure it was reasonably accurate.
Tom
March 30, 2016 at 12:55 pm
Greg Edwards-268690 (3/30/2016)
Sean Lange (3/30/2016)
Greg Edwards-268690 (3/30/2016)
Sean Lange (3/30/2016)
David Burrows (3/30/2016)
Chad Crawford (3/29/2016)
Feeln' good. 😀+1
I am a developer and I knew the answer :w00t:
:sick: Blurgh! I hate C#
Not to start a huge debate or anything but what is so awful about C# that you have such negative feelings about it? I can understand some languages causing such hatred like RPG or JCL. If C# is so awful, what language(s) do you prefer and why?
Many times your perception of language is determined by your troubleshooting experience.
And the code some other developer left for you that's causing a problem.
RPG - I've seen it represent itself as understandable as well written and easy to follow the flow.
And as spaghetti, a pile of noodles with no sauce.
Part of it too is likely your exposure level when a production issue is tossed over the wall at you.
Some managers seem to think all the languages are the same, and all coders have the same style.
You see so many job descriptions that imply if you can start your car in the morning, if it dies halfway to work, you should be able to fix it using a toothbrush. And still be there early.
On something that will help your mind wander away from the generally dismal interview process, this weekend BBQ Ribs on the menu at our annual Grand Marais poker weekend. I am hungry already.
Nice!!! Two of my favorite things...ribs and poker. Add some dark malt beverages you have described my personal nirvana. 🙂 Myself I found a crazy deal on pork shoulders. Full picnics at $1.14/pound. That is unbelievably cheap around here. I picked up 4 of them so I will be firing up my smoker this weekend too.
Fitgers in Duluth and Castle Danger will be stops on the way up for beverages.
Already have empty growlers ready for exchange.
Both of these micro breweries have a good mix.
Castle Danger has excellent IPA, but also some great stout and brown ale.
Fitgers has a tasty habanero enhanced one that excites the senses.
Will be in KC area in June. Hot Rod Power Tour ends there this year.
One of the guys is researching the local BBQ's.
Any recommendations?
Absolutely. Here is my top 5.
Joe's KC - The burnt ends are the best in town hands down. The only serve them on Mondays, Saturday lunch and Wednesday dinner. The babyback ribs are also really good. My favorite is the Hog Heaven, a pulled pork and sausage sandwich. If you were coming in the cold months I would also suggest the chili complete with house popped pork rinds.
Q39 - Everything here is really good but for me the major standout is the brisket sliders.
LC's - A KC staple that has been a favorite greasy spoon forever. The pulled pork is so tender it just melts in your mouth.
BB's Lawnside BBQ - the food here is almost always great. Occasionally it is sub-par but not too often. The service is some of the best around. The biggest selling point here is they have a great beer selection and live blues every single night. They have a heavy New Orleans influence and I have on occasion found some good Nawlins style specials.
Fiorella's Jack Stack - this is a bit more "upscale" with cloth napkins instead of paper towel rolls but the food is might good. It is a little bit pricier across the board than some places but the smoked lamb ribs are truly something you should experience.
Let me know when you are coming out this way. We could probably get together for some food and/or some cold beverages.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 30, 2016 at 2:03 pm
http://techcrunch.com/2016/03/30/be-very-afraid-hell-has-frozen-over-bash-is-coming-to-windows-10/
Bash will be available in Windows.
Gee, just when I forgot everything I knew about bash and started getting comfortable with PowerShell.
Maybe we can lobby for VI editor?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 30, 2016 at 2:24 pm
Sean Lange (3/30/2016)
Greg Edwards-268690 (3/30/2016)
Sean Lange (3/30/2016)
Greg Edwards-268690 (3/30/2016)
Sean Lange (3/30/2016)
David Burrows (3/30/2016)
Chad Crawford (3/29/2016)
Feeln' good. 😀Absolutely. Here is my top 5.
Joe's KC - The burnt ends are the best in town hands down. The only serve them on Mondays, Saturday lunch and Wednesday dinner. The babyback ribs are also really good. My favorite is the Hog Heaven, a pulled pork and sausage sandwich. If you were coming in the cold months I would also suggest the chili complete with house popped pork rinds.
Q39 - Everything here is really good but for me the major standout is the brisket sliders.
LC's - A KC staple that has been a favorite greasy spoon forever. The pulled pork is so tender it just melts in your mouth.
BB's Lawnside BBQ - the food here is almost always great. Occasionally it is sub-par but not too often. The service is some of the best around. The biggest selling point here is they have a great beer selection and live blues every single night. They have a heavy New Orleans influence and I have on occasion found some good Nawlins style specials.
Fiorella's Jack Stack - this is a bit more "upscale" with cloth napkins instead of paper towel rolls but the food is might good. It is a little bit pricier across the board than some places but the smoked lamb ribs are truly something you should experience.
Let me know when you are coming out this way. We could probably get together for some food and/or some cold beverages.
Thanks!
I'll have to get in touch when things get closer.
Just know that June 17th is when they hit KC.
And there are 4 or 5 of us coming down in 2 cars.
I know 2 or 3 want to be down there Thursday, but haven't firmed that up yet.
Hope your weekend smoking goes well.
We are looking at 9 degrees in the morning up there.
Brrrr!
March 30, 2016 at 3:16 pm
TomThomson (3/30/2016)
Grant Fritchey (3/30/2016)
TomThomson (3/30/2016)
Can someone who knows how Microsoft has chosen to implement snapshot Isolation take a lppk here? I've answered as best I can, but my answers are based on stuff I was doing about 25 years ago, not even on what Microsoft actually did 10 or 12 years ago let alone how SQL Server works today.Your explanation is very accurate. At least, according to my understanding and rereading that section of Kalen's book.
Thanks, Grant.
I've no idea why the OP is interested in the mechanism, but I tend to to regard curiosity as a good characteristic in a developer or a dba or a sysdmin, so I gave an answer and wanted to be sure it was reasonably accurate.
Oh yeah, never against curiosity, ever. It's just when people are asking questions that aren't necessarily deep and then suddenly get really concerned with some low level behavior that most of us never even really see, I get worried about what's going on in their head.
"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
March 30, 2016 at 8:15 pm
Michael L John (3/30/2016)
http://techcrunch.com/2016/03/30/be-very-afraid-hell-has-frozen-over-bash-is-coming-to-windows-10/Bash will be available in Windows.
Gee, just when I forgot everything I knew about bash and started getting comfortable with PowerShell.
Maybe we can lobby for VI editor?
No need - it already exists. There's was a VI and VIM (VI Improved) for Windows back in the late 1990's. I wouldn't use it, but it existed. Another guy I worked with loved it, but I never could figure out why.
There's several scripting environments in Windows - DOS and Cygwin come to mind, but there are others. Then there's lots of ports of Unix commands for Windows you can use if you need them. I'll just stick with the native stuff for the most part.
Viewing 15 posts - 53,281 through 53,295 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply