A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around
How To Gain Access To SQL Server When No DBA
When I showed a draft of this article to a friend of mine, to...
2023-09-27 (first published: 2023-09-22)
32 reads
Enable PowerShell Remoting
Enable PowerShell Remoting
I use PowerShell quite a lot to manage servers, especially SQL Servers. So I need to be able to run PowerShell...
2023-09-25 (first published: 2023-09-24)
17 reads
Yet another kind of orphan users in SQL Server
Yet another kind of orphan users in SQL Server
Or YAOU for short. (This silly acronym, I just made it up so don’t try...
2023-09-25 (first published: 2023-09-02)
476 reads
A Study in SQL Server Ad hoc Query Plans
A Study in SQL Server Ad hoc Query Plans
We, (or maybe it’s just my dismissive attitude towards it), often think of ad hoc...
2023-09-23 (first published: 2023-09-22)
33 reads
Get Configuration Change History From the SQL Server Error Logs
Get Configuration Change History From the SQL Server Error Logs
There are several options if and when you need to see if any configuration change was...
2023-09-23
9 reads
How to check if powershell is running as administrator with elevated privileges
How to check if powershell is running as administrator with elevated privileges
In case it's not clear from the title, I am referring to...
2023-09-06 (first published: 2023-08-14)
392 reads
Another option is coming to gain extended support for SQL 2012
Another option is coming to gain extended support for SQL 2012
If you still have SQL 2012 servers, you are probably aware that support...
2023-09-04 (first published: 2023-08-17)
229 reads
Getting list of protocols enabled in a SQL Server instance
protocols enabled in a SQL Server instance
There are number of ways you can find out what protocols are enable in a SQL Server...
2023-09-01 (first published: 2023-08-31)
23 reads
A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs
A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs
As a SQL Server DBA, especially Production/Operations DBA in a relatively large environment,...
2023-08-16 (first published: 2023-07-31)
696 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-13 (first published: 2023-08-12)
148 reads
Blogs
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
FDD 2023 – Session Materials
You can find the slides for my session at Future Data Driven summit at...
Forums
Alwyason availability group can set primary role permanently?
Hi. Two node windows clusters Node1 and Node2 and configured alwayson availability group. Will...
need some help with spilt raw data
Hello, I am trying to split data, looks like there is some special...
Backing Up a Restoring Database
Comments posted to this topic are about the item Backing Up a Restoring Database
Ask SSC