December 2, 2013 at 2:50 pm
When I said half I was looking at just these two lines:
Eight to ten years database programming experience using two or more of the following databases; MS SQL Server, Oracle, Sybase, Informix, DB2.
Ten years using two or more of the following programming languages, including associated IDE's and development tools; Perl, ColdFusion, Java, C++, Visual basic, ASP. Eight+ years in the following web technologies; ColdFusion, ASP, Apache, IIS, html, CGI, TCP/IP, ODBC, Java Script.
I think everyone can guess which half I feel qualified to do.
[/quote]
It doesn't say 8-10 years on two DB platforms, it says 8-10 years doing databases with experience in multiple platforms. SQL Server is different to Informix in a number of ways, particularly , certainly up to 9.xx you don't use sp's the way you do in SQL Server as the informix optimiser and configuration's not set up to use them as effeciently. In Oracle, yes, use sp's but Oracle packages are a very different way of coding (and then there are the mysteries of the dual table) - I personally like them coming originally from a DEV background, many SQL Server bods *hate* them. It just means be flexible, surely? Bottom line, it's an opportunity, talk to them. Hell they may have a drinking buddy who just wants *you*. You're in the marketing and sales business now mate. :w00t:
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 2, 2013 at 3:03 pm
LutzM (11/23/2013)
Greg Edwards-268690 (11/23/2013)
We had SQL Server, DB2, Sybase, and Oracle. But we moved the application from Oracle to SQL Server. And DB2 was for the ERP System, and moved to SQL Server for Data Warehouse.
And the Sybase was just for the phone system, and it was just a data source for reports.
Sometimes they may make it sound like you need to know everything, but as Lutz mentions, see if you can have them narrow down to the real focus.
Yes - over inflated resumes seem to have a counter part in over inflated job requirements / descriptions.
I would think they may attract each other, but may have some of the best candidates turned off.
If it is real, it could be a real mess to walk into.
I have a hard time remembering using actual ASP for a web page, or compiling a VB6 exe.....
Did you have a single person to manage all those database systems (as it is "requested" here)? I guess not. And that's my point: if they'd have all that stuff sitting around they'd probably have more than just a single person taking care of it...
Oh it happens. Third party app gets bought by a business function, third party knows SFA and can't actually *spell* database ... do you wave your paw at them and go Bah! Dogbert style, or support the poor misguided fools (while using this as an occasional excuse to torture them, depending on the general acceptability on a site by site basis?) in actually running the business? If the best of breed CRM system for your SalesWeasels, in your market, runs on Sybase - when your ERP system runs on Informix, your in house dev and DW run on sql Server, you have Access coming out of your ears and some buffoon has bought some s***e running on Progress - what to you do? You learn Sybase.
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 2, 2013 at 3:21 pm
jasona.work (11/26/2013)
/rant mode onFrickin' bloody pain in the tuckus idiotic mindless rules drones! Gotta go in early tomorrow because it's entirely possible a SQL server and a couple Oracle servers I've been baby-sitting for a couple months may get pulled from the network because they're not "updated." Let's see, a SQL server that is required to go away by Monday because it's running Win Server 2008 and not 2008R2 that when I tried to update it lost several drives after the reboot (VM, so I was able to revert to the snapshot from before doing anything,) and Oracle databases that are in a:
"You need to patch for this vulnerability.
There's no patch from Oracle for the version being run for that vulnerability and there's no Oracle DBA to handle upgrading.
You need to patch for this vulnerability.
See my previous response.
You need to patch for this vulnerability or upgrade.
See my previous response.
We're threatening to pull these servers from the network if you don't apply the patch.
THERE IS NO D*MN PATCH FOR WHAT YOU WANT!!!!"
So now I get to go in early, potentially to explain to the customers why stuff isn't working, where my only answer can be "IA pulled them because there's no patch to fix what they want fixed from the vendor, or "fixing" the problem breaks the server anyways."
yay
/rant off
So, hope everyone has a happy Thanksgiving if you celebrate it, or a nice weekend otherwise!
There are many words and phrases for that in British English, absolutely none of which are appropriate to post in this forum
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 2, 2013 at 3:23 pm
GilaMonster (11/27/2013)
Anyone want to handle this one?'A server which sends custom alerts is sending notifications that an offline database is offline. Why would it do that?'
http://www.sqlservercentral.com/Forums/Topic1518022-146-1.aspx
I *Want* to ... but surely the answer is in the question? Am I just being thick here?
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
December 2, 2013 at 7:46 pm
jcrawf02 (12/2/2013)
Steve Jones - SSC Editor (12/2/2013)
Lynn Pettis (12/1/2013)
Actually, Thanksgiving Day was spent in-transit from ISAF HQ to Bagram. We had a non-traditional Thanksgiving Dinner which consisted of Thai food (I had the Crying Tiger).
We've had a few non-traditional ones in the mountains. Pizza, Chinese food, even Wendy's one year when we skied too long.
well there's an odd mental picture. No matter how far you ski, there will always be a Wendy's.
LOL, didn't think of "long" as distance, but time. We got off the mountain so late one Thanksgiving in Frisco, CO that there was very little open by that time. We hit a Wendy's by the hotel that night.
December 3, 2013 at 5:19 pm
Steve,
I thought you might want to see this:
http://www.sqlservercentral.com/Forums/FindPost1519227.aspx
By alerting you, I am not vouching for its veracity.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
December 3, 2013 at 9:15 pm
dwain.c (12/3/2013)
Steve,I thought you might want to see this:
http://www.sqlservercentral.com/Forums/FindPost1519227.aspx
By alerting you, I am not vouching for its veracity.
I have a copy of Itzik's book, and I can vouch for this "article" being very substantially word-for-word extracts and code samples from Chapter 1.
What's worse is the very prominent links to http://www.learn-with-video-tutorials.com/window-functions-tutorial offer to sell you the same material for USD 29. The free sample shows the video is simply Itzik's text being read by a software voice. Yes, seriously.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
December 4, 2013 at 6:23 am
dwain.c (12/3/2013)
Steve,I thought you might want to see this:
http://www.sqlservercentral.com/Forums/FindPost1519227.aspx
By alerting you, I am not vouching for its veracity.
Dwain, I thought some of that code looked familiar - didn't we mess with it last year sometime?
I'd no idea the article was ripped off - but it does appear to be rather random samples from a larger more concise piece of work.
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
December 4, 2013 at 6:29 am
ChrisM@Work (12/4/2013)
dwain.c (12/3/2013)
Steve,I thought you might want to see this:
http://www.sqlservercentral.com/Forums/FindPost1519227.aspx
By alerting you, I am not vouching for its veracity.
Dwain, I thought some of that code looked familiar - didn't we mess with it last year sometime?
I'd no idea the article was ripped off - but it does appear to be rather random samples from a larger more concise piece of work.
Truth is I only skimmed it. When I found he did no performance testing and seemed to be arguing that window aggregates are "high performance" I snatched out the code he provided, put it into a 1M row test harness and posted the results into the discussion thread. I don't actually have the book by Mr. Ben-Gan to compare it to, but I trust Paul.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
December 4, 2013 at 7:46 am
Paul White (12/3/2013)
dwain.c (12/3/2013)
Steve,I thought you might want to see this:
http://www.sqlservercentral.com/Forums/FindPost1519227.aspx
By alerting you, I am not vouching for its veracity.
I have a copy of Itzik's book, and I can vouch for this "article" being very substantially word-for-word extracts and code samples from Chapter 1.
What's worse is the very prominent links to http://www.learn-with-video-tutorials.com/window-functions-tutorial offer to sell you the same material for USD 29. The free sample shows the video is simply Itzik's text being read by a software voice. Yes, seriously.
Sigh. The only think this person changed was the table name of some of the code. Everything else that is the text of the article is, word-for-word, a direct copy/paste from Itzik's book.
I sure hope that this person is black-listed from ever writing for SSC again.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
December 4, 2013 at 9:36 am
Paul White (12/3/2013)
dwain.c (12/3/2013)
Steve,I thought you might want to see this:
http://www.sqlservercentral.com/Forums/FindPost1519227.aspx
By alerting you, I am not vouching for its veracity.
I have a copy of Itzik's book, and I can vouch for this "article" being very substantially word-for-word extracts and code samples from Chapter 1.
What's worse is the very prominent links to http://www.learn-with-video-tutorials.com/window-functions-tutorial offer to sell you the same material for USD 29. The free sample shows the video is simply Itzik's text being read by a software voice. Yes, seriously.
Check. Removed.
Thanks. Feel free to PM me in the future.
December 4, 2013 at 10:17 am
Just a quick question, does anyone know what port(s) SQL Server uses for its Linked Servers?
December 4, 2013 at 10:21 am
Lynn Pettis (12/4/2013)
Just a quick question, does anyone know what port(s) SQL Server uses for its Linked Servers?
Whichever port the remote instance is listening on, it's just an outgoing connection to a data source, like any application OLE DB/ODBC connection. The direction of a linked server is one way, so it doesn't create a local listener or anything like that...
December 4, 2013 at 10:25 am
HowardW (12/4/2013)
Lynn Pettis (12/4/2013)
Just a quick question, does anyone know what port(s) SQL Server uses for its Linked Servers?Whichever port the remote instance is listening on, it's just an outgoing connection to a data source, like any application OLE DB/ODBC connection. The direction of a linked server is one way, so it doesn't create a local listener or anything like that...
So if it is the default instance the linked servers use port 1433?
December 4, 2013 at 10:27 am
Lynn Pettis (12/4/2013)
HowardW (12/4/2013)
Lynn Pettis (12/4/2013)
Just a quick question, does anyone know what port(s) SQL Server uses for its Linked Servers?Whichever port the remote instance is listening on, it's just an outgoing connection to a data source, like any application OLE DB/ODBC connection. The direction of a linked server is one way, so it doesn't create a local listener or anything like that...
So if it is the default instance the linked servers use port 1433?
Yes. Unless you've changed your default instance to use a non-standard port 😛
Viewing 15 posts - 42,271 through 42,285 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply