October 20, 2015 at 11:39 am
Jack Corbett (10/20/2015)
Lynn Pettis (10/20/2015)
Jack Corbett (10/20/2015)
Not to make those of you not able to attend the PASS Summit jealous, but I just went through and setup my schedule and there are multiple session in each time slot I'm interested in. Even worse the time slot I'm speaking in has 5 other sessions I'd like to attend :w00t:Does this mean I am behind the power curve? I haven't even looked at the sessions yet.
I wouldn't say you were behind the curve, I just have other volunteer activities that have to go on my schedule as well, so I need to know what sessions I'm interested in so I can pick the right times for other volunteer activities.
Not ready to volunteer there, it's my first PASS Conference and I want to enjoy it.
October 21, 2015 at 7:09 am
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.
There are sessions that we get to attend? Huh. News to me. When is there time between all the meetings and sessions I have to present at the Redgate booth?
My hope is, I get to a couple of DocumentDB sessions. We'll see.
"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
October 21, 2015 at 7:18 am
Grant Fritchey (10/21/2015)
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.There are sessions that we get to attend? Huh. News to me. When is there time between all the meetings and sessions I have to present at the Redgate booth?
Well you wanted to serve on the board... I just have to spend a couple hours each day being friendly in the community zone.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 21, 2015 at 7:29 am
GilaMonster (10/21/2015)
Grant Fritchey (10/21/2015)
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.There are sessions that we get to attend? Huh. News to me. When is there time between all the meetings and sessions I have to present at the Redgate booth?
Well you wanted to serve on the board... I just have to spend a couple hours each day being friendly in the community zone.
Whoa! You have to be friendly? Glad I didn't volunteer for that job.
"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
October 21, 2015 at 7:41 am
Grant Fritchey (10/21/2015)
GilaMonster (10/21/2015)
Grant Fritchey (10/21/2015)
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.There are sessions that we get to attend? Huh. News to me. When is there time between all the meetings and sessions I have to present at the Redgate booth?
Well you wanted to serve on the board... I just have to spend a couple hours each day being friendly in the community zone.
Whoa! You have to be friendly? Glad I didn't volunteer for that job.
Volunteer? People get to volunteer, and not get volunteered by others? 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 21, 2015 at 7:48 am
Grant Fritchey (10/21/2015)
GilaMonster (10/21/2015)
Grant Fritchey (10/21/2015)
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.There are sessions that we get to attend? Huh. News to me. When is there time between all the meetings and sessions I have to present at the Redgate booth?
Well you wanted to serve on the board... I just have to spend a couple hours each day being friendly in the community zone.
Whoa! You have to be friendly? Glad I didn't volunteer for that job.
I didn't exactly volunteer. I was told what I was required to do, no input permitted (what I get for asking for a comp registration).
😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 21, 2015 at 8:05 am
GilaMonster (10/21/2015)
Grant Fritchey (10/21/2015)
GilaMonster (10/21/2015)
Grant Fritchey (10/21/2015)
GilaMonster (10/20/2015)
I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.There are sessions that we get to attend? Huh. News to me. When is there time between all the meetings and sessions I have to present at the Redgate booth?
Well you wanted to serve on the board... I just have to spend a couple hours each day being friendly in the community zone.
Whoa! You have to be friendly? Glad I didn't volunteer for that job.
I didn't exactly volunteer. I was told what I was required to do, no input permitted (what I get for asking for a comp registration).
😀
No input permitted? If you say what's on your mind, isn't that output, not input? 😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2015 at 2:30 pm
RE: the answers in this thread
You guys are joking, right? right guys? :blink:
October 22, 2015 at 2:42 pm
Andrew P (10/22/2015)
RE: the answers in this threadYou guys are joking, right? right guys? :blink:
Now I'm not sure if I read the question correctly 😀
October 22, 2015 at 3:15 pm
Luis Cazares (10/22/2015)
Andrew P (10/22/2015)
RE: the answers in this threadYou guys are joking, right? right guys? :blink:
Now I'm not sure if I read the question correctly 😀
Ahhh, I see the issue. I've assumed he wanted to simply filter out rows where the UniqID = "ABC". I've edited my responses to be more relevant. I had thought you had intentionally written a complex way of doing the same; my apologies.
October 22, 2015 at 4:23 pm
Andrew P (10/22/2015)
Luis Cazares (10/22/2015)
Andrew P (10/22/2015)
RE: the answers in this threadYou guys are joking, right? right guys? :blink:
Now I'm not sure if I read the question correctly 😀
Ahhh, I see the issue. I've assumed he wanted to simply filter out rows where the UniqID = "ABC". I've edited my responses to be more relevant. I had thought you had intentionally written a complex way of doing the same; my apologies.
It's an interesting little challenge if you understand what the OP is asking... In his sample data 2,3 & 4 would be correct but not 1. Scott's answers is rather slick because it only scans the table once to get the right answer.
Challenges like this are born out of terrible database design.
-- Itzik Ben-Gan 2001
October 22, 2015 at 4:32 pm
anthony.green (10/19/2015)
Jeff Moden (10/18/2015)
I realize this post should probably be under "Jobs" but I thought I'd give the dedicated denizens of the thread first crack at it.Any "hybrid" DBAs that have a good handle on being a combination of a "Sr. System DBA" (including security, of course), "Sr. Database Developer", and having some really good knowledge of how to find and fix performance challenged code that want to work as a direct hire FTE near the MS offices in Southfield, MI? The pay and the environment are good and I know the boss lady. She's awesome to work for (I was a consultant), knows more about SQL Server and T_SQL than anyone we've interviewed (she's a smart beginner so you've gotta know that the people we've interviewed are mostly ignorant) and she's looking for a direct hire FTE that loves both sides of SQL Server.
This is mostly NOT a telecommute job. Here's the job description which, of course, is an overview/wishlist. I'm not at liberty to describe the pay range in public but if you're good, it's good. Really not looking for wanna-bees or skaters here. Looking for true Sr. folks that have excellent knowledge of both sides of the house.
[font="Arial Black"]Position Title: Senior Database Administrator[/font]
Position Summary:
This is a combination MS SQL Server DBA and Application DBA role largely responsible for providing operational database services to the organization. We are looking to fill a need to have a highly competent and highly motivated individual in this role. This is a production and development DBA role, as such it will require a commitment on your part as well as ours. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g.: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with the Infrastructure Group to come up with strategic solutions to recurring problems.
The Systems DBA part of the role requires a service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems, and proactively escalating any issues that cannot be resolved within the established timeframes.
The position also requires that attention of an Application DBA that will participate in design decisions, enforce company standards and best practices, and mentor Developers through 100% code reviews, individual training, group training, and ad hoc discussion as the need arises. This position also requires the occasional development of project code and documentation to support the databases and our customers.
This role requires excellent communication and documentation skills. If you have a blog then please pass along the URL so we can review your work. If you do not actively blog that is fine, but you should be prepared to show us an example of something you have written previously if we should happen to ask.
Position Requirements:
We are looking for a person that has:
•Strong experience with Database Administration for MSSQL Server.
•Extremely strong knowledge of T-SQL, database design, and the related best practices.
•Strong experience with backups, restores and recovery models including automated and manual restores from production to test and development environments.
•Strong knowledge of indexes, index management, and statistics.
•Strong knowledge of security best practices including but not limited to the prevention of SQL Injection, Command Line Injection, and the secure deployment and use of xp_CmdShell.
•Experience in troubleshooting and resolving database problems.
•Experience in Performance Tuning and Optimization (PTO) using native monitoring and troubleshooting tools including but not limited to analysis of execution plans.
•Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
•Experience in developing and implementing operational automation using scripts, stored procedures, and Maintenance Plans.
•Ability to teach best practices and optimal methods to Developers and Data Architects during code reviews and other teaching opportunities.
•Excellent communication and documentation skills.
Preferred candidates would also meet the following criteria:
•Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups.
•Certification is a plus but is absolutely not required if you can do the work.
•Previous experience in either a teaching or volunteer role (SQLSaturdays count!).
•Experience with SOX, ISO, and SEC compliance.
Looks great, just a shame its in the US and not the UK
As a side, anyone wanting to work for MS? https://careers.microsoft.com/jobdetails.aspx?ss=&pg=0&so=&rw=3&jid=201836&jlang=EN&pp=SS
As a side side note, any of the State side folk fancy a SysAdmin job in Antarctica?
That's what I say every time I order fish and chips.
-- Itzik Ben-Gan 2001
October 22, 2015 at 4:52 pm
Alvin Ramard (10/19/2015)
Jeff Moden (10/18/2015)
I realize this post should probably be under "Jobs" but I thought I'd give the dedicated denizens of the thread first crack at it.Any "hybrid" DBAs that have a good handle on being a combination of a "Sr. System DBA" (including security, of course), "Sr. Database Developer", and having some really good knowledge of how to find and fix performance challenged code that want to work as a direct hire FTE near the MS offices in Southfield, MI? The pay and the environment are good and I know the boss lady. She's awesome to work for (I was a consultant), knows more about SQL Server and T_SQL than anyone we've interviewed (she's a smart beginner so you've gotta know that the people we've interviewed are mostly ignorant) and she's looking for a direct hire FTE that loves both sides of SQL Server.
This is mostly NOT a telecommute job. Here's the job description which, of course, is an overview/wishlist. I'm not at liberty to describe the pay range in public but if you're good, it's good. Really not looking for wanna-bees or skaters here. Looking for true Sr. folks that have excellent knowledge of both sides of the house.
[font="Arial Black"]Position Title: Senior Database Administrator[/font]
Position Summary:
This is a combination MS SQL Server DBA and Application DBA role largely responsible for ...
Jeff, if you're involved in the interview process, don't forget to ask candidates to explain the use of parameters 1 and 2 for DBCC Timewarp. 🙂
That would certainly let me know if they were a member of a certain forum we all know and love. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2015 at 3:03 am
Anyone in the UK after a "SQL Trainer" contract role? Travel across Europe all expenses paid?
I would have jumped on this like a sky rocket, but I have just signed an extension to my current contract which takes me up to the 23rd December.
http://www.nigelfrank.com/en/vacancy/119858/wwwnigelfrankcom
October 23, 2015 at 5:53 am
Alan.B (10/22/2015)
Andrew P (10/22/2015)
Luis Cazares (10/22/2015)
Andrew P (10/22/2015)
RE: the answers in this threadYou guys are joking, right? right guys? :blink:
Now I'm not sure if I read the question correctly 😀
Ahhh, I see the issue. I've assumed he wanted to simply filter out rows where the UniqID = "ABC". I've edited my responses to be more relevant. I had thought you had intentionally written a complex way of doing the same; my apologies.
It's an interesting little challenge if you understand what the OP is asking... In his sample data 2,3 & 4 would be correct but not 1. Scott's answers is rather slick because it only scans the table once to get the right answer.
Challenges like this are born out of terrible database design.
Just like there are usually multiple ways to answer a question, there are also many different ways to ask a question. Many times, the experience of the person asking is just as important ask the person answering.
As an example, take our favorite ask-on-thing-and-mean-another poster, the master of the Silver Spoon. They can ask something about a topic and the real question really has nothing to do with what they asked. We also have to pull information about what the question is to even figure out what they want. The conversation wanders from topic to topic and usually Lynn uses the crystal ball to somehow pull an answer nails it.
I just hope that we're not only helping people solve their immediate problem, but also helping them to grow and increase their own knowledge. If nothing else, at least how to ask the right question.
Viewing 15 posts - 51,091 through 51,105 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply