Viewing 15 posts - 2,806 through 2,820 (of 39,896 total)
In addition to what Jeff noted, if you get to move this to different hardware or change the makeup of the LUN, having a different drive letter provides some abstraction.
June 10, 2020 at 4:54 pm
Good points. Submitted a PR to add SELECT to DML.
Anyone can do this: http://voiceofthedba.com/2018/01/03/creating-a-books-online-pull-request/
June 10, 2020 at 4:52 pm
Steve, it's good to know that you weren't truly flat-lined during those missing days.
Hopefully the reports and averages show that!
June 10, 2020 at 4:24 pm
...
There is a danger that your targets become a psychological rod for your back. Getting anxiety because you haven't done your 10,000 steps a day!
I try hard not to...
June 10, 2020 at 4:22 pm
Heh... I wonder if some of the information that the fitness watch is telling you isn't a part of the reason for some of the restless nights 😀
Maybe, but...
June 10, 2020 at 4:18 pm
We haven't supported tables directly. I was surprised myself, and it's on a backlog, but I think it's relatively unimportant. Most of the time, having DDL/DML is better for us...
June 10, 2020 at 4:17 pm
You don't have time zone info, so you can convert this based on EST, knowing that some of your data will be incorrect. During parts of the year, EST is...
June 9, 2020 at 8:12 pm
Can I run this code? Sure, there are security implications, but this can work. Would I do this? No, because you've not littered a three part naming in code. The...
June 9, 2020 at 8:06 pm
I don' t mean to imply SQL 2017 isn't a good product (or 2014 for that matter), but for most people, this isn't a compelling change to move off 2016....
June 9, 2020 at 7:59 pm
I understand how and why this works, but I do think this is inconsistent with other languages. Quick tests when I wrote this in Python and PowerShell show the answer...
June 9, 2020 at 3:48 pm
I'd argue people are the most important part, with process second. The tools/platform/automation/tech bits is the easiest part by far.
Unfortunately, too many people stop with tools/etc. and don't work on...
June 9, 2020 at 3:31 pm
You can't download git to a work laptop? I wouldn't remotely understand that as a technical person. This is highly stable, free, well tested software that millions, likely hundreds of...
June 9, 2020 at 3:06 pm
You can, but why? I'd put the distributor on each publisher. Simpler and works well.
For moving this into a central warehouse, you can use some sort of structure to ensure...
June 8, 2020 at 8:54 pm
Version control is important. Not using it is unprofessional.
GIT is everywhere. It is a good version control system for people working on open source projects or where multiple companies...
June 8, 2020 at 8:45 pm
Thanks for the article. It was very informative and you demo'ed the tool that we actually use at work (sourcetree).
There are some things that I think are not clear...
June 8, 2020 at 8:43 pm
Viewing 15 posts - 2,806 through 2,820 (of 39,896 total)