December 20, 2017 at 6:14 am
xsevensinzx - Tuesday, December 19, 2017 8:47 PMLynn Pettis - Tuesday, December 19, 2017 6:20 PMQuick question as I am getting ready to head out from work and may not get back on a computer until work tomorrow, the GraphDB Microsoft added in SQL Server 2017, is that in the on premise software or only Azure. Any links I can follow tomorrow between other things I am working would be appreciated. Starting to plan a bunch of training starting next year, although not all is going to be SQL Server. I do need to get proficient with PostgreSQL and MongoDB, but hope to show that SQL Server can still do what they think PostgreSQL and MongoDB can do better and for free. We all know that there is no such thing as a free lunch.Got a lot to plan for and hopefully have the time to do it.
I believe it's for both and in both cases it's integrated into the SQL Engine. Last I saw, it was still in preview with Azure SQL.
And it's going to be hard to prove to anyone that is already in love with PostgreSQL and MongoDB that SQL Server is the way. Both of these are pretty good on their own as is.
I lied, I am on but getting ready for bed as morning comes early.
The problem with PostgreSQL and MongoDB is no one here is really an expert on either. As far as they are concerned they are simply data stores. No one really learns how to use them to their best. That is one reason I am going to start learning them, to find out their strengths and weaknesses. With that I will also learn how to position SQL Server. As far as most of the engineers and powers that be the biggest benefit for PostgreSQL and MongoDB is that they are free. Again, we all know that there is no such thing as a free lunch. As I learn about the competition I will also start learning about the new features of SQL Server 2017 and how I may be able to show how they can be used for the benefit of our customers.
Good night.
Might be barking up the wrong tree with PostgreSQL. You make it sound like we are all using it because we are broke. It's a pretty solid product that many swear by. MongoDB on the other hand, well. 🙂
December 20, 2017 at 9:10 am
Lynn Pettis - Tuesday, December 19, 2017 11:19 PMxsevensinzx - Tuesday, December 19, 2017 8:47 PMLynn Pettis - Tuesday, December 19, 2017 6:20 PMQuick question as I am getting ready to head out from work and may not get back on a computer until work tomorrow, the GraphDB Microsoft added in SQL Server 2017, is that in the on premise software or only Azure. Any links I can follow tomorrow between other things I am working would be appreciated. Starting to plan a bunch of training starting next year, although not all is going to be SQL Server. I do need to get proficient with PostgreSQL and MongoDB, but hope to show that SQL Server can still do what they think PostgreSQL and MongoDB can do better and for free. We all know that there is no such thing as a free lunch.Got a lot to plan for and hopefully have the time to do it.
I believe it's for both and in both cases it's integrated into the SQL Engine. Last I saw, it was still in preview with Azure SQL.
And it's going to be hard to prove to anyone that is already in love with PostgreSQL and MongoDB that SQL Server is the way. Both of these are pretty good on their own as is.
I lied, I am on but getting ready for bed as morning comes early.
The problem with PostgreSQL and MongoDB is no one here is really an expert on either. As far as they are concerned they are simply data stores. No one really learns how to use them to their best. That is one reason I am going to start learning them, to find out their strengths and weaknesses. With that I will also learn how to position SQL Server. As far as most of the engineers and powers that be the biggest benefit for PostgreSQL and MongoDB is that they are free. Again, we all know that there is no such thing as a free lunch. As I learn about the competition I will also start learning about the new features of SQL Server 2017 and how I may be able to show how they can be used for the benefit of our customers.
Good night.
Might be barking up the wrong tree with PostgreSQL. You make it sound like we are all using it because we are broke. It's a pretty solid product that many swear by. MongoDB on the other hand, well. 🙂
You read that wrong, they are looking at PostgreSQL here because it is free, not because they have the experience and knowledge of the product. Trust me on this, all the engineers here just look at SQL Server as a data store. They don't care about data type mismatches, using cursors inappropriately (yes, there are time we need to use them but at least I have a better idea of when and how), poor indexing, poor general coding skills along with no real desire to learn better techniques (if it works great, don't worry about response time or scalability until the customer complains). I have 20+ years experience with SQL Server, I have tuned quite a bit of the poor SQL released into production because no one let me review the code before it even went to IPAT or better yet, during development. One of the tech leads I worked with in Afghanistan explained it to me like this, "you are specialist in a company of generalists."
Moving to PostgreSQL means learning a database engine, learning to adapt the skills I have and learning the differences between SQL Server and PostgreSQL so that I can eventually do in PostgreSQL that I do in SQL Server, Moving to MongoDB means a paradigm shift in my thinking as well.
December 20, 2017 at 10:28 am
OK, is it just me, or does anyone else immediately think of the line from Blazing Saddles when someone mentions MongoDB?
"Telegram for Mongo, telegram for Mongo!"
December 20, 2017 at 11:23 am
jasona.work - Wednesday, December 20, 2017 10:28 AMOK, is it just me, or does anyone else immediately think of the line from Blazing Saddles when someone mentions MongoDB?
"Telegram for Mongo, telegram for Mongo!"
I always think "Mongo only pawn in game of life"
December 21, 2017 at 1:10 am
jasona.work - Wednesday, December 20, 2017 10:28 AMOK, is it just me, or does anyone else immediately think of the line from Blazing Saddles when someone mentions MongoDB?
"Telegram for Mongo, telegram for Mongo!"
December 21, 2017 at 5:14 am
I get why they did it, removing all hyperlinks from the emails so people don't accidentally click on bad links, but it is very annoying that I have to now cut and paste all the links from my SSC notifications into a browser because there's no way to make an exception for sites like this...
SIGH. At some point corporate's going to get so paranoid about security that we soon won't even be able to read emails because they'll be encrypted to heck and back without us having access to the public key.
December 21, 2017 at 6:17 am
Lynn Pettis - Wednesday, December 20, 2017 9:10 AMxsevensinzx - Wednesday, December 20, 2017 6:14 AMMight be barking up the wrong tree with PostgreSQL. You make it sound like we are all using it because we are broke. It's a pretty solid product that many swear by. MongoDB on the other hand, well. 🙂You read that wrong, they are looking at PostgreSQL here because it is free, not because they have the experience and knowledge of the product. Trust me on this, all the engineers here just look at SQL Server as a data store. They don't care about data type mismatches, using cursors inappropriately (yes, there are time we need to use them but at least I have a better idea of when and how), poor indexing, poor general coding skills along with no real desire to learn better techniques (if it works great, don't worry about response time or scalability until the customer complains). I have 20+ years experience with SQL Server, I have tuned quite a bit of the poor SQL released into production because no one let me review the code before it even went to IPAT or better yet, during development. One of the tech leads I worked with in Afghanistan explained it to me like this, "you are specialist in a company of generalists."
Moving to PostgreSQL means learning a database engine, learning to adapt the skills I have and learning the differences between SQL Server and PostgreSQL so that I can eventually do in PostgreSQL that I do in SQL Server, Moving to MongoDB means a paradigm shift in my thinking as well.
Yeah, I think it's because you keep saying "here" and I'm thinking as the SQL Server or data community and I see now you're referring to your job. Yeah, that makes sense, especially if you already have a RDBMS such as SQL Server running with a specialist on board to make it sing versus PostgreSQL, which you have no experts in at your company. I would agree, that does sound rather silly unless the costs of expanding in SQL Server is just something the business is not willing to invest in for whatever reason. But on the other hand, outside of being free, many non-data professionals share the popular opinion that a database is a database is a database.
December 21, 2017 at 7:23 am
Brandie Tarvin - Thursday, December 21, 2017 5:14 AMI get why they did it, removing all hyperlinks from the emails so people don't accidentally click on bad links, but it is very annoying that I have to now cut and paste all the links from my SSC notifications into a browser because there's no way to make an exception for sites like this...
SIGH. At some point corporate's going to get so paranoid about security that we soon won't even be able to read emails because they'll be encrypted to heck and back without us having access to the public key.
Yeah, that would be annoying. I know that some people can't seem to stop themselves from clicking every link they receive, but there's got to be a point where people have to be responsible adults and engage their brain.
My wife's company inserts red text at the top of external emails pointing out that the email is from an external source. Between that, the standard signature block and then the standard legal disclaimer, a one-line email runs about 50K.
December 21, 2017 at 7:50 am
Ed Wagner - Thursday, December 21, 2017 7:23 AMBrandie Tarvin - Thursday, December 21, 2017 5:14 AMI get why they did it, removing all hyperlinks from the emails so people don't accidentally click on bad links, but it is very annoying that I have to now cut and paste all the links from my SSC notifications into a browser because there's no way to make an exception for sites like this...
SIGH. At some point corporate's going to get so paranoid about security that we soon won't even be able to read emails because they'll be encrypted to heck and back without us having access to the public key.
Yeah, that would be annoying. I know that some people can't seem to stop themselves from clicking every link they receive, but there's got to be a point where people have to be responsible adults and engage their brain.
My wife's company inserts red text at the top of external emails pointing out that the email is from an external source. Between that, the standard signature block and then the standard legal disclaimer, a one-line email runs about 50K.
My wife's company has recently started adding [EXTERNAL] to the beginning of the subject for any emails outside their company. I can see how that might seem like a good idea at first but now how do you sort your email when all the subjects start with the same inserted topic? She spends most of her day working with clients so 90% of her communication is from outside people. It drives her nuts.
_______________________________________________________________
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/
December 21, 2017 at 7:59 am
Sean Lange - Thursday, December 21, 2017 7:50 AMMy wife's company has recently started adding [EXTERNAL] to the beginning of the subject for any emails outside their company. I can see how that might seem like a good idea at first but now how do you sort your email when all the subjects start with the same inserted topic? She spends most of her day working with clients so 90% of her communication is from outside people. It drives her nuts.
Generally, it's better to put tags like that at the end of an Emails subjects, not the beginning. That is, until some (muppet) sends out a blank email, with the subject header:
Hi everyone, has anyone seen my purse? I went to lunch today and when I went to pay for it it wasn't in my pocket or bag! I have checked everywhere for it, and I can't see it. Can anyone also lend me some money so i can buy my lunch, just for today please? That would be really helpful. Thanks everyone I really appreciate it lots and lots!. Thanks again!!!! Sue
Far too often do I get emails like that... (and I just ignore them).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2017 at 8:09 am
Thom A - Thursday, December 21, 2017 7:59 AMSean Lange - Thursday, December 21, 2017 7:50 AMMy wife's company has recently started adding [EXTERNAL] to the beginning of the subject for any emails outside their company. I can see how that might seem like a good idea at first but now how do you sort your email when all the subjects start with the same inserted topic? She spends most of her day working with clients so 90% of her communication is from outside people. It drives her nuts.
Generally, it's better to put tags like that at the end of an Emails subjects, not the beginning. That is, until some (muppet) sends out a blank email, with the subject header:
Hi everyone, has anyone seen my purse? I went to lunch today and when I went to pay for it it wasn't in my pocket or bag! I have checked everywhere for it, and I can't see it. Can anyone also lend me some money so i can buy my lunch, just for today please? That would be really helpful. Thanks everyone I really appreciate it lots and lots!. Thanks again!!!! Sue
Far too often do I get emails like that... (and I just ignore them).
I agree. I can also see why the decision was made to put it at the beginning in case the subject is lengthy. I would a proponent of making the employee responsible and doing stupid stuff like clicking every link in an email. Especially at her place where nearly everyone is technical to some degree or other as they are a software company.
_______________________________________________________________
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/
December 21, 2017 at 8:42 am
Brandie Tarvin - Thursday, December 21, 2017 5:14 AMI get why they did it, removing all hyperlinks from the emails so people don't accidentally click on bad links, but it is very annoying that I have to now cut and paste all the links from my SSC notifications into a browser because there's no way to make an exception for sites like this...
It could be worse, Brandy. One excolleague of mine was recently bewailing the fact that his employer was removing all attachments from incoming mail - including incoming attachemnts from suppliers and from R&D collaborators and from customers, even cryptographically signed documents. I suggested he work out what nasty legal consequences could arise from this stupidity, and after a liitle stiudy he managed to get the nonsense stopped because playing that stupid game inevitably entailed violating contractual undertakings with suppliers, collaborators, and customers (for example some contracts stated that certain types of communication should be carried out by emailing covering messages with attached documents in such-and-such formats, othrs that licence agreements should be sent as cryptographically signed elctronic documents, and so on).
SIGH. At some point corporate's going to get so paranoid about security that we soon won't even be able to read emails because they'll be encrypted to heck and back without us having access to the public key.
Surely if corporate is dumb enough to do that the encryption will be easy to break. They probably think ROT52 is four times as good as ROT13, so maybe they'll use that. Very easy to decrypt, zero effort in fact.
Tom
December 21, 2017 at 8:49 am
Brandie Tarvin - Thursday, December 21, 2017 5:14 AMI get why they did it, removing all hyperlinks from the emails so people don't accidentally click on bad links, but it is very annoying that I have to now cut and paste all the links from my SSC notifications into a browser because there's no way to make an exception for sites like this...
SIGH. At some point corporate's going to get so paranoid about security that we soon won't even be able to read emails because they'll be encrypted to heck and back without us having access to the public key.
At least at my workplace it replaces the URL. So, for example, the link to Sean's post above for the notification came out as https://protect-eu.mimecast.com/s/%5Binsert unique link code here]-?domain=sqlservercentral.com. It's just a redirect URL, but Mimecast's website is not the quickest, so when I click a link it takes a good 20 seconds to load SSC (or any other site). We can whitelist links, such as we have for Sage (for payroll), but not a domain.
If the link is bad, then when you click the link it'll take you to a warning page and emails our network team, who review the link. Of course, a lot of users seem to think that a warning page means that if they click the link again 5 seconds later it'll work.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 21, 2017 at 12:44 pm
Sean Lange - Thursday, December 21, 2017 8:09 AMThom A - Thursday, December 21, 2017 7:59 AMSean Lange - Thursday, December 21, 2017 7:50 AMMy wife's company has recently started adding [EXTERNAL] to the beginning of the subject for any emails outside their company. I can see how that might seem like a good idea at first but now how do you sort your email when all the subjects start with the same inserted topic? She spends most of her day working with clients so 90% of her communication is from outside people. It drives her nuts.
Generally, it's better to put tags like that at the end of an Emails subjects, not the beginning. That is, until some (muppet) sends out a blank email, with the subject header:
Hi everyone, has anyone seen my purse? I went to lunch today and when I went to pay for it it wasn't in my pocket or bag! I have checked everywhere for it, and I can't see it. Can anyone also lend me some money so i can buy my lunch, just for today please? That would be really helpful. Thanks everyone I really appreciate it lots and lots!. Thanks again!!!! Sue
Far too often do I get emails like that... (and I just ignore them).
I agree. I can also see why the decision was made to put it at the beginning in case the subject is lengthy. I would a proponent of making the employee responsible and doing stupid stuff like clicking every link in an email. Especially at her place where nearly everyone is technical to some degree or other as they are a software company.
I'm the one who stops and thinks about every link I click in an email, so I'm at the opposite end of the spectrum. I sometimes get things from HR or payroll where the link displayed is different then the actual href tag. :w00t: When that happens, I'm the one to replies to them and points out the discrepancy. I don't know if they appreciate it or get annoyed by it, but it's scam behavior I've seem from legitimate scams and exploit attempts.
Maybe working with security and having to keep up on hacks has made me a little too sensitive to this type of stuff, but I'd rather be too aware than unaware.
December 21, 2017 at 12:53 pm
How much query tuning can you really expect from a simple select statement that only returns seven rows with no joins, a single SARGable where condition, and a sort?
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 15 posts - 60,751 through 60,765 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply