Viewing 15 posts - 1 through 15 (of 39 total)
You've determined the best Batman movie, not the best Batman. A Batman can be awesome in an otherwise crap movie, or crap in an otherwise awesome movie.
May 9, 2022 at 11:21 am
I prefer to use Powershell, and Invoke-DbaQuery from within my Powershell scripts for things that require T-SQL. The source of all scripts is then in my Powershell library, instead of...
April 20, 2022 at 8:19 am
How thread-safe is this? I.e. will other sessions with updates also not fire the trigger?
April 13, 2021 at 7:37 am
It might help to read the 3rd sentence of the @language argument description in the docs sp_execute_external_script (Transact-SQL).
I have. But see also the second line...
November 20, 2020 at 9:34 am
In SQL Server 2019, Java, Python, and R runtimes are supported.
So not every language can be added with a language extension, or am I misreading this?
November 19, 2020 at 9:55 am
I would've expected DROP TABLE to set @@ROWCOUNT to the number of dropped rows.
November 6, 2020 at 10:08 am
'Colts' is in the middle of the string, and TRIM() only removes characters from the beginning and the end.
October 2, 2020 at 11:29 am
"I don't know why they made this decision instead of structuring things like this..."
Because now you don't have to overload TRIM() with 2 definitions (one with 1 parameter, one with...
October 2, 2020 at 11:25 am
It also limits the number of connections to 1.
And technically, you don't limit the access to sqlcmd, you limit the access to any application that says it's sqlcmd.
September 28, 2020 at 9:28 am
Filter vs where-object:
Filter = SELECT only columns you need WHERE only rows you need
Where-Object: SELECT * without WHERE, and then filter in the application
August 17, 2020 at 9:19 am
The decision which properties are shown by default for get-service is done by an XML file called 'types.ps1xml' in C:\Windows\System32\WindowsPowerShell\v1.0
In this file you will find the following XML block:
<Type>
<Name>System.ServiceProcess.ServiceController</Name>
<Members>
<MemberSet>
<Name>PSStandardMembers</Name>
<Members>
<PropertySet>
<Name>DefaultDisplayPropertySet</Name>
<ReferencedProperties>
<Name>Status</Name>
<Name>Name</Name>
<Name>DisplayName</Name>
</ReferencedProperties>
</PropertySet>
</Members>
</MemberSet>
<AliasProperty>
<Name>Name</Name>
<ReferencedMemberName>ServiceName</ReferencedMemberName>
</AliasProperty>
<AliasProperty>
<Name>RequiredServices</Name>
<ReferencedMemberName>ServicesDependedOn</ReferencedMemberName>
</AliasProperty>
<ScriptMethod>
<Name>ToString</Name>
<Script>
$this.ServiceName
</Script>
</ScriptMethod>
</Members>
</Type>
The columns...
August 13, 2020 at 7:49 pm
Get-Module only lists the currently loaded modules, if you want a list of all installed modules you need to use 'Get-Module -ListAvailable'.
August 13, 2020 at 8:59 am
Since answer 2 and 5 are the same, they can't be the correct answer. So that leads almost automatically to the right answer.
January 30, 2020 at 9:25 am
The documentation doesn't mention 'rt' at all, only 'r' and 'rb': https://docs.python.org/3/tutorial/inputoutput.html#reading-and-writing-files
January 29, 2020 at 10:09 am
What about temporal tables for your tables that need to be recovered very fast?
October 29, 2019 at 10:26 am
Viewing 15 posts - 1 through 15 (of 39 total)