November 6, 2015 at 12:13 pm
Sean Lange (11/6/2015)
Ed Wagner (11/6/2015)
Brandie Tarvin (11/6/2015)
Greg Edwards-268690 (11/6/2015)
Eirikur Eiriksson (11/6/2015)
On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?Three options given
1) To get the current time (wrong)
2) You don't (correct)
3) Time for the applicant to leave (also often correct)
😎
If the bbq ribs are coming off the grill, time to eat might be my answer.
Otherwise, isn't it the 42nd parameter for DBCC TimeWarp?
Which I think always returns 3.....
When the elephant sits on your fence.
Except on Tuesdays in odd-numbered months of even-numbered years unless they're leap years.
But if it is a leap year and not raining then it is the 43rd parameter.
I thought it was the 34th. That's what happen when I use the manga version of the parameters documentation. :hehe:
November 6, 2015 at 12:17 pm
Luis Cazares (11/6/2015)
Sean Lange (11/6/2015)
Ed Wagner (11/6/2015)
Brandie Tarvin (11/6/2015)
Greg Edwards-268690 (11/6/2015)
Eirikur Eiriksson (11/6/2015)
On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?Three options given
1) To get the current time (wrong)
2) You don't (correct)
3) Time for the applicant to leave (also often correct)
😎
If the bbq ribs are coming off the grill, time to eat might be my answer.
Otherwise, isn't it the 42nd parameter for DBCC TimeWarp?
Which I think always returns 3.....
When the elephant sits on your fence.
Except on Tuesdays in odd-numbered months of even-numbered years unless they're leap years.
But if it is a leap year and not raining then it is the 43rd parameter.
I thought it was the 34th. That's what happen when I use the manga version of the parameters documentation. :hehe:
I may have misinterpreted the cipher in the fourteenth octet. I am going to have to give back my secret encoder ring.
_______________________________________________________________
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/
November 6, 2015 at 12:24 pm
SQLRNNR (11/6/2015)
Luis Cazares (11/6/2015)
Once I interviewed someone that claimed to have experience on Oracle but not much on SQL Server. I told that person to answer based on Oracle (which was the main technology in his last claimed project) and couldn't come up with the basic functions either.So many people lie on their resumes to get past recruiters so the ones that avoid to lie but are knowledgeable won't get to the interviews.
That is a big pet peeve of mine.
Used to be one of mine too. Partly though it's the employers' HR people (or the high and mighty managers above the recruiting managers) who are to blame. They invent requirements that are mostly nonsense - a list of everything that only a really exceptional person could meet listed as essential prerequisites and an additional lis of "would also be useful" stuff that blows the thing up to ridiculous size. Then they tell the recruitment agency that they only want to see resumés from people who scoure 100% on the essential bits and have at least 20% of the also useful items, and that they'll pay 45k pounds per annum (I'm thinking of pay scales of more than a decade ago) with minimal other benefits. Since anyone who could actually match the requirement could get at least 100k and decent additional benefits and the rcruitment agents don't dare send them CVs that clearly don't fit the requirement, the only CVs that will be passed on will be full of overstated skills and experiences, in fact mostly a pack of lies. Then someone like Geoff (or me) ends up interviewing them (and finding it hard to be polite).
This seems to be a US and Western Europe and India problem, as far as I can tell. And it's a fairly new problem - I didn't get any of this when recruiting in the 70s. Nor in 2006 recruiting to create a development division in Beirut: technical people (led by me) determined the requirements, and vetted the CVs; since we'd written realistic specs, and our chairman of the board (aka president the other side of the pond) knew very well what real pay rates were like in Beirut for people at the levels beginner to do divisional director (vice-president, who would be CEO in a few years if he could cut it) we wanted we were talking realistic qualifications and experience and realistic pay. We had a very good range of people to interview, and made more than a dozen offers in one week of interviewing - enough people to get things off the ground. In a couple of years we moved all technical work (development, QC and release, customer support, supplier relations, etc.) to Beirut and when that was clearly working I retired; and the team out there is doing a great job.
And then people like that end up getting the job and tainting the industry. Let's say they get hired at a rate of 110k/yr (not knowing anything). When they leave the company is frequently opposed to paying that much, or even more, because that was a very knowledgeable (and senior level) person that wAas paid scads of money to not be able to fix their problems. If they couldn't do it, nobody can do it.
110k (dollars) sounds rather cheap but I guess it depends on where the job is: there are several cities in Britain where you couldn't get a very knowledgable and senior level DB developer or DBA at that rate (and US pay for techies is supposedly higher than British) and there are also cities where 73k (pounds) would definitely be scads of money.
Tom
November 6, 2015 at 12:25 pm
Sean Lange (11/6/2015)
Luis Cazares (11/6/2015)
Sean Lange (11/6/2015)
Ed Wagner (11/6/2015)
Brandie Tarvin (11/6/2015)
Greg Edwards-268690 (11/6/2015)
Eirikur Eiriksson (11/6/2015)
On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?Three options given
1) To get the current time (wrong)
2) You don't (correct)
3) Time for the applicant to leave (also often correct)
😎
If the bbq ribs are coming off the grill, time to eat might be my answer.
Otherwise, isn't it the 42nd parameter for DBCC TimeWarp?
Which I think always returns 3.....
When the elephant sits on your fence.
Except on Tuesdays in odd-numbered months of even-numbered years unless they're leap years.
But if it is a leap year and not raining then it is the 43rd parameter.
I thought it was the 34th. That's what happen when I use the manga version of the parameters documentation. :hehe:
I may have misinterpreted the cipher in the fourteenth octet. I am going to have to give back my secret encoder ring.
No you don't. The 14th octet is the pointer to the country where you have to check to see if it's raining. Use the 15th and 16th octets for the exact GPS location within the country. 15th = X; 16th = Y; Z is not supported yet. 😛
November 6, 2015 at 12:31 pm
Eirikur Eiriksson (11/6/2015)
On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?Three options given
1) To get the current time (wrong)
2) You don't (correct)
3) Time for the applicant to leave (also often correct)
😎
I've used it to mean "you can take your job and stuff it, sonny, so stop wasting your worthless time and keeping me from the pub".
But that was when I was young and polite and used to euphemise instead of saying what I meant. 😛
Tom
November 6, 2015 at 12:33 pm
Luis Cazares (11/6/2015)
Sean Lange (11/6/2015)
Ed Wagner (11/6/2015)
Brandie Tarvin (11/6/2015)
Greg Edwards-268690 (11/6/2015)
Eirikur Eiriksson (11/6/2015)
On the current topic, a very favorite question: When do you use the function "WhatTimeIsIt()"?Three options given
1) To get the current time (wrong)
2) You don't (correct)
3) Time for the applicant to leave (also often correct)
😎
If the bbq ribs are coming off the grill, time to eat might be my answer.
Otherwise, isn't it the 42nd parameter for DBCC TimeWarp?
Which I think always returns 3.....
When the elephant sits on your fence.
Except on Tuesdays in odd-numbered months of even-numbered years unless they're leap years.
But if it is a leap year and not raining then it is the 43rd parameter.
I thought it was the 34th. That's what happen when I use the manga version of the parameters documentation. :hehe:
Beware of the parameter changes in the DBCC TIMEWARP, the forward and backward direction parameters ( decimal 288230376151711744 and 36028797018963968 respectively (now previously reversed)) (yes there are two of them and you can do the both at the "same" time) switched places between versions (breaking changes) so the danger is getting caught in an endless loop:hehe: so beware of the parameter changes in the DBCC TIMEWARP, the forward and backward direction parameters ( decimal 36028797018963968 and 288230376151711744 respectively (now previously reversed)) (yes there are two of them and you can do the both at the "same" time) switched places between versions (breaking changes) so the danger is getting caught in an endless loop:hehe: so beware of the parameter changes in the DBCC TIMEWARP, the forward and backward direction parameters ( decimal 288230376151711744 and 36028797018963968 respectively (now previously reversed)) (yes there are two of them and you can do the both at the "same" time) switched places between versions (breaking changes) so the danger is getting caught in an endless loop:hehe: so b.....
😎
November 6, 2015 at 2:12 pm
Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL besides in the Skill, Educational Background and Experience section.
Job Responsibilities:
?Assists with planning, design, installation and configuration of database software.
?Implements operational solutions with SQL Server 2008 or 2012.
?Performance Tuning and Query Optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
?Works with developers to design and document data structures, and assists with the use of databases.
?Works with application development teams on database architecture and development, providing direction and documentation on coding standards and practices.
?Maintains database documentation and security.
?Performs backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and High Availability strategies for MS SQL environments.
?Monitors database activity and resolves performance issues.
?Performs after-hours production support.
?Troubleshoots and resolves database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
?Identifies and troubleshoots SQL Server related CPU memory, I/O, disk space and other resource contention.
?Design and develops applications for data migration and maintenance.
Skill, Educational Background and Experience
?Bachelor's degree or equivalent years of experience.
?At least 5 years of IT work related experience to include 3+ years of SQL DBA experience.
?MS SQL Server 2008 R2, 2012.
?SSRS - Reporting Services Administration and Development.
?SSIS - Integration Services Administration and Development.
?Advanced SQL Query performance tuning experience is required.
?PostgreSQL is required.
?Windows/SQL Clustering and HA knowledge.
?Availbility Groups.
?SQL Trace.
?Transactional/Merge Replication.
?Extended Events.
?Power Shell.
?Proficient skills and experience with IBM Informix is preferred.
?Service Broker knowledge is preferred.
?Knowledge of xml, xpath, and flowr is preferred.
?Good communication and interpersonal skills with the ability to work in a team environment.
?Relational application design and development experience.
?Experience with Kronos Timekeeper software, Remedy Action Request System, ERwin database design tool, Oracle and SQL Server databases is desirable.
November 6, 2015 at 2:17 pm
Lynn Pettis (11/6/2015)
Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL besides in the Skill, Educational Background and Experience section.
Job Responsibilities:
?Assists with planning, design, installation and configuration of database software.
?Implements operational solutions with SQL Server 2008 or 2012.
?Performance Tuning and Query Optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
?Works with developers to design and document data structures, and assists with the use of databases.
?Works with application development teams on database architecture and development, providing direction and documentation on coding standards and practices.
?Maintains database documentation and security.
?Performs backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and High Availability strategies for MS SQL environments.
?Monitors database activity and resolves performance issues.
?Performs after-hours production support.
?Troubleshoots and resolves database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
?Identifies and troubleshoots SQL Server related CPU memory, I/O, disk space and other resource contention.
?Design and develops applications for data migration and maintenance.
Skill, Educational Background and Experience
?Bachelor's degree or equivalent years of experience.
?At least 5 years of IT work related experience to include 3+ years of SQL DBA experience.
?MS SQL Server 2008 R2, 2012.
?SSRS - Reporting Services Administration and Development.
?SSIS - Integration Services Administration and Development.
?Advanced SQL Query performance tuning experience is required.
?PostgreSQL is required.
?Windows/SQL Clustering and HA knowledge.
?Availbility Groups.
?SQL Trace.
?Transactional/Merge Replication.
?Extended Events.
?Power Shell.
?Proficient skills and experience with IBM Informix is preferred.
?Service Broker knowledge is preferred.
?Knowledge of xml, xpath, and flowr is preferred.
?Good communication and interpersonal skills with the ability to work in a team environment.
?Relational application design and development experience.
?Experience with Kronos Timekeeper software, Remedy Action Request System, ERwin database design tool, Oracle and SQL Server databases is desirable.
This is either a list of current buzzwords thrown together by somebody with no technical background or they are looking for somebody who doesn't exist. Often times with requirements like this it is because they already know who they want so they make an impossible list of requirements so that nobody can meet those requirements and they can hire the person they want.
_______________________________________________________________
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/
November 6, 2015 at 3:57 pm
Least it has the database engines listed. :hehe:
Get's even worse with the use of 'NoSQL' or 'Hadoop'.
November 6, 2015 at 4:08 pm
Sean Lange (11/6/2015)
Lynn Pettis (11/6/2015)
Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL besides in the Skill, Educational Background and Experience section.
Job Responsibilities:
?Assists with planning, design, installation and configuration of database software.
?Implements operational solutions with SQL Server 2008 or 2012.
?Performance Tuning and Query Optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
?Works with developers to design and document data structures, and assists with the use of databases.
?Works with application development teams on database architecture and development, providing direction and documentation on coding standards and practices.
?Maintains database documentation and security.
?Performs backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and High Availability strategies for MS SQL environments.
?Monitors database activity and resolves performance issues.
?Performs after-hours production support.
?Troubleshoots and resolves database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
?Identifies and troubleshoots SQL Server related CPU memory, I/O, disk space and other resource contention.
?Design and develops applications for data migration and maintenance.
Skill, Educational Background and Experience
?Bachelor's degree or equivalent years of experience.
?At least 5 years of IT work related experience to include 3+ years of SQL DBA experience.
?MS SQL Server 2008 R2, 2012.
?SSRS - Reporting Services Administration and Development.
?SSIS - Integration Services Administration and Development.
?Advanced SQL Query performance tuning experience is required.
?PostgreSQL is required.
?Windows/SQL Clustering and HA knowledge.
?Availbility Groups.
?SQL Trace.
?Transactional/Merge Replication.
?Extended Events.
?Power Shell.
?Proficient skills and experience with IBM Informix is preferred.
?Service Broker knowledge is preferred.
?Knowledge of xml, xpath, and flowr is preferred.
?Good communication and interpersonal skills with the ability to work in a team environment.
?Relational application design and development experience.
?Experience with Kronos Timekeeper software, Remedy Action Request System, ERwin database design tool, Oracle and SQL Server databases is desirable.
This is either a list of current buzzwords thrown together by somebody with no technical background or they are looking for somebody who doesn't exist. Often times with requirements like this it is because they already know who they want so they make an impossible list of requirements so that nobody can meet those requirements and they can hire the person they want.
Geez, how did I miss this?
Proficient skills and experience with IBM Informix is preferred.
November 7, 2015 at 5:25 am
Lynn Pettis (11/6/2015)
Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL besides in the Skill, Educational Background and Experience section.
Job Responsibilities:
?Assists with planning, design, installation and configuration of database software.
?Implements operational solutions with SQL Server 2008 or 2012.
?Performance Tuning and Query Optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
?Works with developers to design and document data structures, and assists with the use of databases.
?Works with application development teams on database architecture and development, providing direction and documentation on coding standards and practices.
?Maintains database documentation and security.
?Performs backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and High Availability strategies for MS SQL environments.
?Monitors database activity and resolves performance issues.
?Performs after-hours production support.
?Troubleshoots and resolves database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
?Identifies and troubleshoots SQL Server related CPU memory, I/O, disk space and other resource contention.
?Design and develops applications for data migration and maintenance.
Skill, Educational Background and Experience
?Bachelor's degree or equivalent years of experience.
?At least 5 years of IT work related experience to include 3+ years of SQL DBA experience.
?MS SQL Server 2008 R2, 2012.
?SSRS - Reporting Services Administration and Development.
?SSIS - Integration Services Administration and Development.
?Advanced SQL Query performance tuning experience is required.
?PostgreSQL is required.
?Windows/SQL Clustering and HA knowledge.
?Availbility Groups.
?SQL Trace.
?Transactional/Merge Replication.
?Extended Events.
?Power Shell.
?Proficient skills and experience with IBM Informix is preferred.
?Service Broker knowledge is preferred.
?Knowledge of xml, xpath, and flowr is preferred.
?Good communication and interpersonal skills with the ability to work in a team environment.
?Relational application design and development experience.
?Experience with Kronos Timekeeper software, Remedy Action Request System, ERwin database design tool, Oracle and SQL Server databases is desirable.
Except for the Postgre, that's pretty standard stuff. Silly, yes, but not surprising. Before I left my last company, my boss sat down with me and insisted that we list out everything I knew, worked with or touched. The list was shockingly huge. However, I kept saying "Yeah, but I only helped that group for a couple of days." Didn't matter, Dynamics CRM was on the list. Looking at it, I would never apply to the job, and it was my job that it supposedly described.
"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
November 7, 2015 at 5:26 am
xsevensinzx (11/6/2015)
Least it has the database engines listed. :hehe:Get's even worse with the use of 'NoSQL' or 'Hadoop'.
Yeah, but it shows Profiler
BURN IT WITH FIRE!
"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
November 7, 2015 at 6:02 am
Grant Fritchey (11/7/2015)
xsevensinzx (11/6/2015)
Least it has the database engines listed. :hehe:Get's even worse with the use of 'NoSQL' or 'Hadoop'.
Yeah, but it shows Profiler
BURN IT WITH FIRE!
Grant, how about an article explaining why not to RDP to a problematic server and start the Profiler for diagnostics.
😎
November 7, 2015 at 6:07 am
Lynn Pettis (11/6/2015)
Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL besides in the Skill, Educational Background and Experience section.
Job Responsibilities:
?Assists with planning, design, installation and configuration of database software.
?Implements operational solutions with SQL Server 2008 or 2012.
?Performance Tuning and Query Optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
?Works with developers to design and document data structures, and assists with the use of databases.
?Works with application development teams on database architecture and development, providing direction and documentation on coding standards and practices.
?Maintains database documentation and security.
?Performs backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and High Availability strategies for MS SQL environments.
?Monitors database activity and resolves performance issues.
?Performs after-hours production support.
?Troubleshoots and resolves database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
?Identifies and troubleshoots SQL Server related CPU memory, I/O, disk space and other resource contention.
?Design and develops applications for data migration and maintenance.
Skill, Educational Background and Experience
?Bachelor's degree or equivalent years of experience.
?At least 5 years of IT work related experience to include 3+ years of SQL DBA experience.
?MS SQL Server 2008 R2, 2012.
?SSRS - Reporting Services Administration and Development.
?SSIS - Integration Services Administration and Development.
?Advanced SQL Query performance tuning experience is required.
?PostgreSQL is required.
?Windows/SQL Clustering and HA knowledge.
?Availbility Groups.
?SQL Trace.
?Transactional/Merge Replication.
?Extended Events.
?Power Shell.
?Proficient skills and experience with IBM Informix is preferred.
?Service Broker knowledge is preferred.
?Knowledge of xml, xpath, and flowr is preferred.
?Good communication and interpersonal skills with the ability to work in a team environment.
?Relational application design and development experience.
?Experience with Kronos Timekeeper software, Remedy Action Request System, ERwin database design tool, Oracle and SQL Server databases is desirable.
These requirements are written by a novice mate, pure gibberish.
😎
November 7, 2015 at 6:07 am
Lynn Pettis (11/6/2015)
Here is a posting for a SQL Database Administrator. I've looked it over several times. Please tell me where it says anything about PostgreSQL besides in the Skill, Educational Background and Experience section.
Job Responsibilities:
?Assists with planning, design, installation and configuration of database software.
?Implements operational solutions with SQL Server 2008 or 2012.
?Performance Tuning and Query Optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
?Works with developers to design and document data structures, and assists with the use of databases.
?Works with application development teams on database architecture and development, providing direction and documentation on coding standards and practices.
?Maintains database documentation and security.
?Performs backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication and High Availability strategies for MS SQL environments.
?Monitors database activity and resolves performance issues.
?Performs after-hours production support.
?Troubleshoots and resolves database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
?Identifies and troubleshoots SQL Server related CPU memory, I/O, disk space and other resource contention.
?Design and develops applications for data migration and maintenance.
Skill, Educational Background and Experience
?Bachelor's degree or equivalent years of experience.
?At least 5 years of IT work related experience to include 3+ years of SQL DBA experience.
?MS SQL Server 2008 R2, 2012.
?SSRS - Reporting Services Administration and Development.
?SSIS - Integration Services Administration and Development.
?Advanced SQL Query performance tuning experience is required.
?PostgreSQL is required.
?Windows/SQL Clustering and HA knowledge.
?Availbility Groups.
?SQL Trace.
?Transactional/Merge Replication.
?Extended Events.
?Power Shell.
?Proficient skills and experience with IBM Informix is preferred.
?Service Broker knowledge is preferred.
?Knowledge of xml, xpath, and flowr is preferred.
?Good communication and interpersonal skills with the ability to work in a team environment.
?Relational application design and development experience.
?Experience with Kronos Timekeeper software, Remedy Action Request System, ERwin database design tool, Oracle and SQL Server databases is desirable.
These requirements are written by a novice mate, pure gibberish.
😎
Viewing 15 posts - 51,286 through 51,300 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply