August 22, 2019 at 2:23 pm
Steve Jones - SSC Editor wrote:Luis Cazares wrote:It's been good. We're still waiting for our baby girl to decide to be born. She's taking her time. (Yesterday was the "due date")
I'm assuming by now congratulations are in order. Enjoy the new little one.
You were really close. Our little Renata was born on August 19 at 2:12pm EST. There were some complications and she's spending some time at NICU, but getting healthier and stronger every day. We hope to have her home soon, but don't expect her before next week.
Congrats!!! With the best for everyone. How are mom and dad holding up?
_______________________________________________________________
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/
August 22, 2019 at 2:30 pm
Steve Jones - SSC Editor wrote:Luis Cazares wrote:It's been good. We're still waiting for our baby girl to decide to be born. She's taking her time. (Yesterday was the "due date")
I'm assuming by now congratulations are in order. Enjoy the new little one.
You were really close. Our little Renata was born on August 19 at 2:12pm EST. There were some complications and she's spending some time at NICU, but getting healthier and stronger every day. We hope to have her home soon, but don't expect her before next week.
Congradulations!!!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 22, 2019 at 2:32 pm
Grant Fritchey wrote:Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index is a great question.
I'm not even remotely surprised that you're getting bad answers. The level of knowledge out there of "mid-level", and sometimes even "senior", people is appalling. One year of experience, multiplied. That's most people, sadly.
Interviewing a Senior DBA, I was told that a full backup didn't back up the log file. That would make a restore interesting.
In what context was this discussion? Just the actual backup process? Or was it regarding a specific data question?
Because that information, so far as I know, is correct. Transaction log backups back up the log file. That's why people get things so screwed up on their systems when they're only doing full backups and don't know why the transaction log keeps growing to insane sizes.
August 22, 2019 at 2:51 pm
The question was "What types of backup are there?" followed by a lot of muttering, hesitation and apologies for going blank. I've gone completely blank in interviews before, so it is undertandable. The remark about the full backups was made as a kind of throw-away comment at the end.
"A full database backup backs up the whole database. This includes part of the transaction log so that the full database can be recovered after a full database backup is restored."
Pedantic, I know but I have more of a problem with people saying something wrong than just saying they don't know - especially at that level of DBA.
August 22, 2019 at 3:16 pm
Pedantic, I know but I have more of a problem with people saying something wrong than just saying they don't know - especially at that level of DBA.
That isn't being pedantic, that is what should be expected. There is nothing wrong with not knowing how to do something, but just making it up is not a good way to proceed. Sure in the real world this is sometimes what we have to do but hopefully asking peers or seeking advice first, not just go do it and find out what happens.
_______________________________________________________________
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/
August 26, 2019 at 2:18 pm
Had a very pleasant surprise on Saturday!!!
I spoke in Providence on Saturday. Among my audience were these two gentlemen, one of whom was Jeff Moden. (Hi, Jeff! Good to see you again!)
(Yeah, I use the word "gentlemen" loosely. I know, I know! 😉 )
The other, sitting next to him, was someone I didn't recognize. He introduced himself to me after I finished my presentation. When I saw his name tag, I realized who he was!
After years and years of conversing with him here on the SSC forums (not to mention playing fantasy football against him), I finally got to meet Lynn Pettis in person!
Good to finally meet you, Lynn! Nice to put a face to a name!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
August 26, 2019 at 2:48 pm
Nice, glad you got to meet. I hope to go to Providence at some point.
August 28, 2019 at 8:27 am
Yes I agree this website is slowing down. Not just performance but activity as well.
On another topic of slow...here was this last weekends goods from the smoker.
<li style="list-style-type: none;">
- Beef short ribs
<li style="list-style-type: none;">
- baby back ribs
<li style="list-style-type: none;">
- Pork Belly burnt ends
<li style="list-style-type: none;">
- Bacon explosion
And look at the smoke ring on those short ribs....
I did a full brisket for the first time on Friday just gone. I'd never been happy with the results using the UK cut so I decided to treat myself while I had the opportunity and ordered one online. Ironically, it was from a reasonably local supplier but they don't sell direct which was a little annoying. There's still work to do but it was much more tender than anything I'd achieved before. I'll be much happier doing one for the whole clan now, particularly after I'd seen how much meat there was for Mrs B and me alone!
P.S. Congrats Luis.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
August 28, 2019 at 11:38 am
Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index is a great question.
This is one of the questions! Often I'm told that locking should be avoided at all costs as well.
Because that information, so far as I know, is correct. Transaction log backups back up the log file. That's why people get things so screwed up on their systems when they're only doing full backups and don't know why the transaction log keeps growing to insane sizes.
A full backup does back up the active portion of the log; it just doesn't truncate it (i.e. make space available for reuse); only a log backup will do that (when in Full recovery model).
August 28, 2019 at 12:41 pm
Grant Fritchey wrote:Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index is a great question.
This is one of the questions! Often I'm told that locking should be avoided at all costs as well.
Because that information, so far as I know, is correct. Transaction log backups back up the log file. That's why people get things so screwed up on their systems when they're only doing full backups and don't know why the transaction log keeps growing to insane sizes.
A full backup does back up the active portion of the log; it just doesn't truncate it (i.e. make space available for reuse); only a log backup will do that (when in Full recovery model).
A transaction log backup also works as expected in the Bulk Logged Recovery Model if a FULL backup has been taken in the past, the same as if you're in the Full Recovery Model.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2019 at 12:44 pm
Had a very pleasant surprise on Saturday!!!
I spoke in Providence on Saturday. Among my audience were these two gentlemen, one of whom was Jeff Moden. (Hi, Jeff! Good to see you again!)
(Yeah, I use the word "gentlemen" loosely. I know, I know! 😉 )
The other, sitting next to him, was someone I didn't recognize. He introduced himself to me after I finished my presentation. When I saw his name tag, I realized who he was!
After years and years of conversing with him here on the SSC forums (not to mention playing fantasy football against him), I finally got to meet Lynn Pettis in person!
Good to finally meet you, Lynn! Nice to put a face to a name!
It was great to see both you and Lynn again, Ray.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 28, 2019 at 12:56 pm
I did a full brisket for the first time on Friday just gone. I'd never been happy with the results using the UK cut so I decided to treat myself while I had the opportunity and ordered one online. Ironically, it was from a reasonably local supplier but they don't sell direct which was a little annoying. There's still work to do but it was much more tender than anything I'd achieved before. I'll be much happier doing one for the whole clan now, particularly after I'd seen how much meat there was for Mrs B and me alone!
P.S. Congrats Luis.
Nice!!! Brisket can be tricky to get it right. But once you dial it in they are quite delicious. And yeah it is a big piece of meat.
_______________________________________________________________
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/
August 28, 2019 at 2:28 pm
Ray K wrote:Had a very pleasant surprise on Saturday!!!
I spoke in Providence on Saturday. Among my audience were these two gentlemen, one of whom was Jeff Moden. (Hi, Jeff! Good to see you again!)
(Yeah, I use the word "gentlemen" loosely. I know, I know! 😉 )
The other, sitting next to him, was someone I didn't recognize. He introduced himself to me after I finished my presentation. When I saw his name tag, I realized who he was!
After years and years of conversing with him here on the SSC forums (not to mention playing fantasy football against him), I finally got to meet Lynn Pettis in person!
Good to finally meet you, Lynn! Nice to put a face to a name!
It was great to see both you and Lynn again, Ray.
Is was great to finally meet you as well Ray. Getting to see Jeff again was good, too. Thanks again for the dinner, Jeff. My daughter, Kylie, was surprised by your generosity and thanks you as well.
August 28, 2019 at 5:13 pm
One of our groups is using MongoDB and we got a notice that we're evaluating making it more widely available. In the announcement was a link to a course we could take to help in the evaluation. The course uses an externally hosted database, but a coworker and I have both experienced problems connecting to that database. I'm thinking it's probably a firewall setting, so I was in a chat with our help desk. As part of the troubleshooting, the website suggested running a tracert. The helpdesk person had apparently never seen a tracert before.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
August 29, 2019 at 1:33 am
SSC Fantasy Football league has at least one opening : https://www.sqlservercentral.com/forums/topic/ssc-fantasy-football-2019
Drop a note in the thread above if you want to play.
Viewing 15 posts - 63,946 through 63,960 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply