A Fine Slice Of SQL Server
Hugo Calzada Martin recovers from an oopsie:
If we have a Customer-managed TDE (Transparent Data Encryption) and we delete by mistake the entire “Azure Key Vault” or just the “Key” object, the database will be inaccessible:
Read on for Hugo’s response as well as how to recover from this scenario. There are examples of how to do this in the Portal, in Powershell, and the CLI.
Comments closedJose Manuel Jurado Diaz writes a program:
Today, I worked on a service request that our customer is looking for all blocking issues that is happening in their database. We have many articles about it Lesson Learned #22: How to identify blocking issues? – Microsoft Community Hub and in Diagnostics Settings and QDS we can collect this information but all points to that we cannot see the TSQL that is blocking and TSQL command that is blocked in an easy way. In the following script that I share as a script example we could take this one.
First of all, please, remember that a blocking issue is normal and fundamental for any RDBMS. This script is basically when you need to understand what is happening to improve or reduce this.
I was a little surprised the answer wasn’t to use Extended Events, though this does work if you simply need something to run in ad hoc scenarios.
Comments closedJana Sattainathan gets things backwards and then forwards:
In the case of this app, I just did “Select All” within the app and moved all the videos over to “Photos”. When I downloaded the content to my computer, I noticed that it downloaded the most recently downloaded video first and the oldest video last. This meant the file names given to the videos were in reverse order of chronological order.
Read on to see how you can use Powershell to sort this all out.
Comments closedKenneth Fisher puts a sticky note over the blinking red light so it won’t bother him anymore:
Ok, great! Good information. Not something that affects me right now but still helpful to know. And I really appreciate the fact that going forward I can expect this type of information.
I found this information less useful and less appreciated after I put it into a loop and it ran ~40 times in a row, hiding any real information beneath a pile of warnings. Fortunately, right there in the warning there is a helpful note on how to suppress it
Read on for the story of why this message popped up, as well as how to prevent it from popping up and Kenneth’s medium-term plan for dealing with it.
Comments closedTony Wilhelm troubleshoots a nasty problem:
Items that were checked / tried:
- Rebooting server and clients
- Dropping and recreating the SPNs
Oh did I mention that this was SQL Server 2005…
It turns out neither of those was the solution. Click through to learn how to fix the problem.
Comments closedAndrew Pruski tries out a tool:
We’ve all been there as DBAs…people requesting access to the servers that we look after to be able to view certain things.
I’ve always got, well, twitchy with giving access to servers tbh…but what if we could completely restrict what users could do via powershell?
Enter Just Enough Administration. With JEA we can grant remote access via powershell sessions to servers and limit what users can do.
Click through to see how it works.
Comments closedDavid Wilson needs to open a module:
When you’re testing PowerShell modules, importing, referencing, and removing modules can be a little bit tricky. These are some things that I’ve found to make tests more reliable.
Click through for several tips on how to do this.
Comments closedI have a SQL Server Agent job in a disabled status. The disabled status is applied to the SQL Agent Job and the associated schedule. The problem is I’m logged on as a full administrator onto the Windows Server – and as BUILTIN\Administrator is defined on the SQL Server , but am able to manually override the SQL Agent Job.
Is there a way to Disable the SQL Agent Job where I’m not able to manually override the job?
Click through for the answer.
Comments closedJana Sattainathan doesn’t have time to click-and-repeat:
This is something I had to do today. In this blog post, I am going to show you how you can disable or remove indexes matching certain name criteria or other condition(s) across multiple servers and databases in various tables. Usually, this is a very painful process if done by hand but with the fantastic work done by the dbatools team, it becomes quite easy.
Read on for the Powershell script.
Comments closedPatrick Gruenauer makes a remote connection:
With Powershell 7, we can enable and use SSH Remoting. Unlike WinRM, SSH is more popular because it is a more familiar technology and is also available on other platforms. In this post I will show you how to easily enable SSH on PowerShell 7 with a few lines of code.
Click through to see what you need to install on the machine and how to configure everything.
Comments closed