How to Downgrade a SQL Server Database To A Previous Version?
Upgrading a SQL Server database to a newer version is one of the core duties...
2023-10-07 (first published: 2023-10-06)
15 reads
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)
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-23 (first published: 2023-09-22)
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)
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-03 (first published: 2023-09-02)
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)
1 reads
Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell
For a very important client, I currently manage over 200 SQL...
2023-08-30 (first published: 2023-08-29)
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-08-18 (first published: 2023-08-17)
1 reads