Viewing 15 posts - 2,026 through 2,040 (of 39,720 total)
Actually, you can just use the counter. Don't need the object, but certainly the explanation can usually be improved.
Love to see you or others submit something if you think of...
March 12, 2021 at 6:33 pm
I am always looking to say "I don't know" in an interview, but then explain how I'd learn. I can do to the docs, or use Google to search these...
March 12, 2021 at 6:32 pm
Not sure what your question is. The ref is a general link for the DMV. The link from there to SQL Server objects describes each counter. This would be the...
March 12, 2021 at 2:59 pm
I'm not quite sure. Do you mean
a) using sys.dm_os_performance_counters to check deprecated features with a counter has the counter deprecated?
b) I have a function that calls sp_addserver, and that proc...
March 11, 2021 at 3:20 pm
You can use ReadHost, like this:
$First = Read-Host -Prompt 'Input the TP lookup'
For the rest of the question, you really need to provide some text input or...
March 10, 2021 at 11:33 pm
Likely you have a connection error, which might be due to a connection setting change from Power BI. I assume you are able to connect from SSMS.
From Power BI, is...
March 10, 2021 at 8:49 pm
To add to what DesNorton noted, local variables only exist in a certain scope of this batch. Moving to some other batch, even inside a stored procedure, puts local variables...
March 10, 2021 at 6:45 pm
The SQL Server setup program from the installation media.
March 10, 2021 at 6:37 pm
These aren't databases. They are instances. A SQL Server install is an instance, and it can contain multiple databases. If these instances are not being used, and not ever started,...
March 10, 2021 at 5:52 pm
In terms of getting parameters, I'd add a help to the script to note this, and then add parameters that return an error message if they aren't passed in.
For the...
March 10, 2021 at 5:50 pm
The 2nd post is an automated post. As noted. If no one answers in a day, we bump the topic so that more people might see it.
In terms of your...
March 10, 2021 at 5:46 pm
Windows Containers - https://docs.microsoft.com/en-us/virtualization/windowscontainers/about/
Client applications in containers: https://go.turbo.net/
The latter could be interesting, Rob, if your org wanted to modernize, but keep older apps running.
March 10, 2021 at 4:56 pm
Check what? A feature? Code? There are lists of deprecated features, but these aren't well maintained. I haven't checked the XEvents, but supposedly those should catch code running that is...
March 10, 2021 at 4:50 pm
I like sausage, but not sure I'd want to taste test scrapple. Or cook it.
March 9, 2021 at 4:29 pm
Actually, this appears to have a list in 2019, even after restart.
If you run this on 2017, nothing appears. Even if I do something like:
EXEC sp_addtype @typename...
March 9, 2021 at 4:20 pm
Viewing 15 posts - 2,026 through 2,040 (of 39,720 total)