March 28, 2017 at 1:49 am
Luis Cazares - Monday, March 27, 2017 11:58 AMdrew.allen - Monday, March 27, 2017 10:17 AMNow that I'm officially unemployed, I finally got around to downloading SQL 2016 developer edition to play around with. Right now, the two most frustrating things are that they changed the syntax for regex search and replace (without changing the documentation to match) and I no longer have RedGate SQL Prompt.Drew
I've heard so many nice things about RedGate SQL Prompt that I'm afraid of asking for it to avoid losing it when changing jobs and fall into depression.
It is very useful. Do what I did when I moved - whine, sulk, throw your toys out until they buy it. It's pretty much standard everywhere I've worked, so I wouldn't worry about that. SQL Prompt in isolation isn't expensive. I was going to buy it myself if I couldn't convince the company to get the toolbelt.
March 28, 2017 at 3:00 am
Luis Cazares - Monday, March 27, 2017 11:58 AMdrew.allen - Monday, March 27, 2017 10:17 AMNow that I'm officially unemployed, I finally got around to downloading SQL 2016 developer edition to play around with. Right now, the two most frustrating things are that they changed the syntax for regex search and replace (without changing the documentation to match) and I no longer have RedGate SQL Prompt.Drew
I've heard so many nice things about RedGate SQL Prompt that I'm afraid of asking for it to avoid losing it when changing jobs and fall into depression.
I am no longer able to type T-SQL without it.
"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 28, 2017 at 3:09 am
Grant Fritchey - Tuesday, March 28, 2017 3:00 AMLuis Cazares - Monday, March 27, 2017 11:58 AMdrew.allen - Monday, March 27, 2017 10:17 AMNow that I'm officially unemployed, I finally got around to downloading SQL 2016 developer edition to play around with. Right now, the two most frustrating things are that they changed the syntax for regex search and replace (without changing the documentation to match) and I no longer have RedGate SQL Prompt.Drew
I've heard so many nice things about RedGate SQL Prompt that I'm afraid of asking for it to avoid losing it when changing jobs and fall into depression.
I am no longer able to type T-SQL without it.
For those that do have it, as one of us normally brings it up when we talk budget every 6 months or so, how does the "users" cost work (what does a user count as)? If I'm on my desktop in the office, and then log into the laptop at home to work remotely, does that count as 1 user (as it's the same domain account), or 2, as it's 2 different machines?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 28, 2017 at 3:27 am
Grant Fritchey - Tuesday, March 28, 2017 3:00 AMLuis Cazares - Monday, March 27, 2017 11:58 AMdrew.allen - Monday, March 27, 2017 10:17 AMNow that I'm officially unemployed, I finally got around to downloading SQL 2016 developer edition to play around with. Right now, the two most frustrating things are that they changed the syntax for regex search and replace (without changing the documentation to match) and I no longer have RedGate SQL Prompt.Drew
I've heard so many nice things about RedGate SQL Prompt that I'm afraid of asking for it to avoid losing it when changing jobs and fall into depression.
I am no longer able to type T-SQL without it.
Hmmm, not sure if I'd use that as a marketing slogan.
"SQL Prompt, the tool that makes you forget your basic skills"
March 28, 2017 at 4:19 am
Thom A - Tuesday, March 28, 2017 3:09 AMFor those that do have it, as one of us normally brings it up when we talk budget every 6 months or so, how does the "users" cost work (what does a user count as)? If I'm on my desktop in the office, and then log into the laptop at home to work remotely, does that count as 1 user (as it's the same domain account), or 2, as it's 2 different machines?
Yes. That's one user. If someone else were using your system at work at the same time as you were using your laptop, that would be two users.
"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 28, 2017 at 4:25 am
Hugo Kornelis - Tuesday, March 28, 2017 3:27 AMGrant Fritchey - Tuesday, March 28, 2017 3:00 AMLuis Cazares - Monday, March 27, 2017 11:58 AMdrew.allen - Monday, March 27, 2017 10:17 AMNow that I'm officially unemployed, I finally got around to downloading SQL 2016 developer edition to play around with. Right now, the two most frustrating things are that they changed the syntax for regex search and replace (without changing the documentation to match) and I no longer have RedGate SQL Prompt.Drew
I've heard so many nice things about RedGate SQL Prompt that I'm afraid of asking for it to avoid losing it when changing jobs and fall into depression.
I am no longer able to type T-SQL without it.
Hmmm, not sure if I'd use that as a marketing slogan.
"SQL Prompt, the tool that makes you forget your basic skills"
"SQL Prompt, the tool so awesome it replaces your knowledge of T-SQL with bigger, better and more knowledge of T-SQL"
We'll just have to run a product warning too, something like what comes with Happy Fun Ball.
"SQL Prompt can cause permanent memory loss. Do not taunt SQL Prompt. If SQL Prompt begins to whine and emit smoke, seek shelter immediately..."
"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 28, 2017 at 5:36 am
Grant Fritchey - Tuesday, March 28, 2017 4:25 AMHugo Kornelis - Tuesday, March 28, 2017 3:27 AMGrant Fritchey - Tuesday, March 28, 2017 3:00 AMLuis Cazares - Monday, March 27, 2017 11:58 AMdrew.allen - Monday, March 27, 2017 10:17 AMNow that I'm officially unemployed, I finally got around to downloading SQL 2016 developer edition to play around with. Right now, the two most frustrating things are that they changed the syntax for regex search and replace (without changing the documentation to match) and I no longer have RedGate SQL Prompt.Drew
I've heard so many nice things about RedGate SQL Prompt that I'm afraid of asking for it to avoid losing it when changing jobs and fall into depression.
I am no longer able to type T-SQL without it.
Hmmm, not sure if I'd use that as a marketing slogan.
"SQL Prompt, the tool that makes you forget your basic skills""SQL Prompt, the tool so awesome it replaces your knowledge of T-SQL with bigger, better and more knowledge of T-SQL"
We'll just have to run a product warning too, something like what comes with Happy Fun Ball.
"SQL Prompt can cause permanent memory loss. Do not taunt SQL Prompt. If SQL Prompt begins to whine and emit smoke, seek shelter immediately..."
I know a few BA's who should carry this warning.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
March 28, 2017 at 6:12 am
Grant Fritchey - Tuesday, March 28, 2017 4:19 AMThom A - Tuesday, March 28, 2017 3:09 AMFor those that do have it, as one of us normally brings it up when we talk budget every 6 months or so, how does the "users" cost work (what does a user count as)? If I'm on my desktop in the office, and then log into the laptop at home to work remotely, does that count as 1 user (as it's the same domain account), or 2, as it's 2 different machines?Yes. That's one user. If someone else were using your system at work at the same time as you were using your laptop, that would be two users.
Thanks Grant. Didn't want to make the assumption that user was indeed "user". Least it's not a model of "Oh, you have multiple users on the same PC due to hot desk/dynamic working? Well if you have 2 possible users on 3 different machines, that's 3 x 2 users. So you need 6." -_-
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 28, 2017 at 8:15 am
Grant Fritchey - Tuesday, March 28, 2017 4:19 AMThom A - Tuesday, March 28, 2017 3:09 AMFor those that do have it, as one of us normally brings it up when we talk budget every 6 months or so, how does the "users" cost work (what does a user count as)? If I'm on my desktop in the office, and then log into the laptop at home to work remotely, does that count as 1 user (as it's the same domain account), or 2, as it's 2 different machines?Yes. That's one user. If someone else were using your system at work at the same time as you were using your laptop, that would be two users.
I think a clarifying point is whether you are remoting into the machine at work or if you are just using sql prompt on the laptop. I was doing the latter and therefore had to get two licenses.
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
March 28, 2017 at 8:47 am
SQLRNNR - Tuesday, March 28, 2017 8:15 AMGrant Fritchey - Tuesday, March 28, 2017 4:19 AMThom A - Tuesday, March 28, 2017 3:09 AMFor those that do have it, as one of us normally brings it up when we talk budget every 6 months or so, how does the "users" cost work (what does a user count as)? If I'm on my desktop in the office, and then log into the laptop at home to work remotely, does that count as 1 user (as it's the same domain account), or 2, as it's 2 different machines?Yes. That's one user. If someone else were using your system at work at the same time as you were using your laptop, that would be two users.
I think a clarifying point is whether you are remoting into the machine at work or if you are just using sql prompt on the laptop. I was doing the latter and therefore had to get two licenses.
Hmmm.... that's not how I thought it worked, but hey, I could be wrong. It won't be the first time... today.
"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 28, 2017 at 9:08 am
Grant Fritchey - Tuesday, March 28, 2017 8:47 AMSQLRNNR - Tuesday, March 28, 2017 8:15 AMGrant Fritchey - Tuesday, March 28, 2017 4:19 AMThom A - Tuesday, March 28, 2017 3:09 AMFor those that do have it, as one of us normally brings it up when we talk budget every 6 months or so, how does the "users" cost work (what does a user count as)? If I'm on my desktop in the office, and then log into the laptop at home to work remotely, does that count as 1 user (as it's the same domain account), or 2, as it's 2 different machines?Yes. That's one user. If someone else were using your system at work at the same time as you were using your laptop, that would be two users.
I think a clarifying point is whether you are remoting into the machine at work or if you are just using sql prompt on the laptop. I was doing the latter and therefore had to get two licenses.
Hmmm.... that's not how I thought it worked, but hey, I could be wrong. It won't be the first time... today.
Licensing questions are best directed towards a Microsoft licensing specialist and / or your software vendor....
OK, sorry, my typical licensing question reply just seemed to leap from my fingers to the keyboard there...
😀:hehe:
March 28, 2017 at 10:25 am
Thom A - Tuesday, March 28, 2017 9:25 AMOn a totally unrelated note, why has our webdev suddenly decided he wants all of his data unpivoted >_< ARGH.
He's just softening you up for tomorrow, when he will be asking you to change the protection level on your 1,400 SSIS packages to 'Encrypt sensitive with password' 😛
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 28, 2017 at 10:55 am
The Colorado Springs SQL Server Users Group held its SQL Saturday this past Saturday (2017-03-25). Our fearless SSC Leader was there and held two outstanding sessions (yes, I am kissing up a bit), and while I had the opportunity to talk to him I asked if it would be okay to ask for some help from this awesome community. So here it goes, my daughter would like some help so she doesn't have to depend on me to make this great opportunity happen. What opportunity you ask? This one: Daughter seeking help Awesome Internship Opportunity Abroad in Ireland.
Yes, I benefit as well, as I save some money that can go to continuing to pay for her college.
Thank you.
Viewing 15 posts - 57,916 through 57,930 (of 66,679 total)
You must be logged in to reply to this topic. Login to reply