Viewing 15 posts - 1 through 15 (of 53 total)
Check out Invoke-WebRequest.Links. I'm using PoSH 7.2.1 and I think it's a fairly new cmdlet.
(Invoke-WebRequest biblegateway.com).Links
I'm not an html coder but it might provide what you want.
January 7, 2022 at 2:42 pm
"clip" works but is actually invokng clip.exe which means your going outside of PoSH to save results to the clipboard. You can also do it completely within PoSH with this...
January 7, 2022 at 1:30 pm
I'v not done much in the cloud because of all the crippling restrictions it imposes on SQL Server. Especially Azure SQL. Are you saying that the backend storage in Azure...
February 19, 2021 at 7:35 pm
In the old days before we were using SANs there were several advantages. Performance was improved by spreading the data over many spindles and even over multiple interfaces. Also if...
February 19, 2021 at 2:31 pm
The idea is to restore a production msdb on a non-production system so you can copy the job back to the production system. I've used this technique before.
You could actually...
February 2, 2021 at 7:04 pm
Here's a mostly point and click method involving little coding.
February 2, 2021 at 5:42 pm
So why did 90% of the SPNs need to be re-registered? Do you have a network with a lot of domain controllers? If so we've seen a problem where it's...
September 10, 2020 at 8:27 pm
EXEC () as written in the example is also susceptible to SQL injection attack. Consider the case where @lstChngDt (which based on the example is likely a varchar or nvarchar)...
May 7, 2020 at 6:41 pm
Very sneaky. And even worse, it leaves an open transaction! Please put a ROLLBACK in that CATCH block before someone walks away from their keyboard and starts triggering alerts! (You...
April 30, 2020 at 2:10 pm
I know this 5 years old but if Steves going to resurrect it, I'll update it. I still have working SQL 2000 databases as old as 17-Dec-2002. Next year it'll...
October 11, 2019 at 7:54 pm
It depends. 🙂
Is there a PK on the table on the pharmacy and/or claim no. If so you'd get one row inserted and 4 PK constraint violation errors.
September 16, 2019 at 2:25 pm
Did you ever get a real answer on this? I'm experiencing blocking issues on ReportServer database too (no it's NOT slow running queries - it is verifiable blocking). Id like...
May 2, 2019 at 1:11 pm
Oh crap. Something got flushed and I don't think it was cache.
April 17, 2019 at 1:49 pm
I know this is a very old thread but someone might find this useful. This is not a query but does let you see the installed features.
Run the...
March 26, 2019 at 12:43 pm
exec dba_CopyLogins @ParnterServer = 'PrimaryReplica'
Should...
March 12, 2019 at 1:26 pm
Viewing 15 posts - 1 through 15 (of 53 total)