Viewing 15 posts - 3,826 through 3,840 (of 39,821 total)
Glad you enjoyed it. Pix looked great.
I'm headed to Pensacola this weekend and Austin next month. No Albany for me, I'll be in the UK 🙁
June 26, 2019 at 8:19 pm
It's still slightly weird, because coordinating changes is difficult at times. It's something I think we'd want to get to, but because there are database changes at times, it's not...
June 26, 2019 at 7:50 pm
Interesting, is it just me, or would anyone read that from the note on the latest version of What's new in SQL Server 2019 preview that although 2008(R2) ...
June 26, 2019 at 6:48 pm
With the new SSC, everything is supposed to run through a dev/QA cycle before prod. We have PRs that require review before they get merged into a deployable spot.
However, we...
June 26, 2019 at 6:47 pm
I've never seen that. I wonder if someone changed yours from AD Group Policy? It's certainly strange.
June 26, 2019 at 6:43 pm
Reminds me of a tech support run I did at the nuclear plant with my boss. A manager complained their PC wouldn't turn on. We walked over to the office,...
June 26, 2019 at 2:19 pm
That's a good idea, and a nice sentiment. I've volunteered for things my kids have been involved in over the years, and doing less now as they've gotten older, but...
June 26, 2019 at 2:16 pm
You can certainly add logging to your app that captures start of query and then when the datareader/datatable fills. I don't know of anything directly that does this natively in...
June 25, 2019 at 6:47 pm
I agree that doing a POST is a bit overkill for something like that. Must have been timing but it was quite strange. Might also be a good...
June 25, 2019 at 6:32 pm
Snippets are your friend... Pretty much every new query I write starts off with 5 keystrokes... {ssff[tab]}...
I use the snippet like this, but I still now have to go...
June 25, 2019 at 6:31 pm
AFAIK, Azure doens't provide anything like SES from AWS. In fact, the few references I've seen note that SMTP is blocked for Azure IPs. You'd need a relay. Most people...
June 25, 2019 at 6:18 pm
So the extension is changed in Windows? You didn't state that. If you run "dir" on the folder, you see .ndf?
That is a file type extension that Windows Explorer renders....
June 25, 2019 at 6:16 pm
AFAIK, no utility exists. SQL Server is designed to just do this. Most third party vendors, like Redgate with SQL Backup, do provide a utility so SQL Server can read...
June 25, 2019 at 6:10 pm
You can account for those items by using multiple REPLACE() statements for tabs, CRLF, etc.
June 25, 2019 at 6:07 pm
This can help: https://www.sqlservercentral.com/articles/how-to-change-the-file-extension-for-a-data-file
June 25, 2019 at 6:04 pm
Viewing 15 posts - 3,826 through 3,840 (of 39,821 total)