TSQL Tuesday 127 - Non SQL Tips and Tricks - Windows
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
4 reads
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
4 reads
Few days ago I was surfing on Twitter when dbatools asked about how it’s PowerShell module changed the way people work. We're looking to highlight how dbatools has changed...
2020-06-03 (first published: 2020-05-20)
1,284 reads
Continuing to share tips and tricks using dbatools like the Refresh databases that belongs to availability group using dbatools posted a few days ago, today I will share a...
2020-05-28
5 reads
The idea of this blog post, like many others I write, is to document a workaround solution to my problem. Hopefully I can also help someone that may be...
2020-02-21 (first published: 2020-02-12)
2,623 reads
There are some actions that we know that will have to be repeated from time to time, but the surprise comes when it’s time to do so and the...
2020-02-07 (first published: 2020-02-04)
4,521 reads
There are some actions that we know that will have to be repeated from time to time, but the surprise comes when it’s time to do so and the...
2020-02-04
7 reads
Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use of PowerShell Remoting. Which commands? Commands like Get-DbaComputerCertificate, Get-DbaPrivilege, Get-DbaClientAlias, just to mention a few...
2019-08-29 (first published: 2019-08-20)
1,183 reads
I don’t know about your experience when it comes to SQL Server Agent jobs but often I receive requests to grant permission so that clients can handle their jobs...
2019-08-22 (first published: 2019-08-13)
3,186 reads
I don’t know about your experience when it comes to SQL Server Agent jobs but often I receive requests to grant permission so that clients can handle their jobs...
2019-08-13
10 reads
Dear reader, before continue please open a PowerShell console and run the following command: If you are doing this on the date of this blog post, you have just...
2019-06-19
56 reads
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Hi Guys, I'm not sure if this is possible or not, but let me...
Comments posted to this topic are about the item Life Moves Pretty Fast
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers