Sometimes I need to shadow a user’s session and the tool we usually use sometimes doesn’t work. In those cases, we can try connecting to the user’s session using Microsoft Remote Desktop. Here are the steps: Run the following command to get the users session which will give an output of all active sessions: Find […]
In a previous post, we saw how you can create a task to run on any available node in a Windows Cluster. That’s great when all of the nodes in the cluster can do the job, but what if you need the task to run on a particular node? Or more importantly, what happens if […]
In one of my first fulltime jobs, I started experiencing shoulder and neck pain, and after talking to some medical people and older IT people, I realised that the cause was my mouse. The crappy little mice that come free with your computer are an ergonomic disaster. There’s plenty of research that goes in to […]
In a previous post, I showed how you can create a clustered scheduled task. Now we could use that trick to change the schedule of a scheduled task by deleting and then importing a new one, but wouldn’t it be better to just change the schedule? Using PowerShell, this is quite simple. First, connect to […]
Do you use Scheduled Tasks as part of your production environment? Maybe to run those end of month reports for finance, or to run a nightly batch process, to import data from some uploaded flat files, or to download data from an external source on a regular interval. Scheduled Tasks are a really simple way […]
SQL 2019 RC1 is now generally available and I wanted to try it out. Instead of installing it on my PC, I decided to give it a go in Docker. After a bit of mucking around, I worked out the following: Getting SQL up and running took a matter of minutes. You find the docker […]
In SQL, when you don’t want to change the result set, but you want to provide some messages, for example, when debugging a query in SSMS, it can be really helpful to use the PRINT statement. What you’ll start to notice though is that the print statement doesn’t always print straight away. Usually this is […]
SQL Server Reporting Services uses Windows Authentication to authenticate users when they connect, but it also impersonates the user. Depending on how you’re setup, this often requires the creation of an SPN. SPN’s are awesome when they work, they allow integration with Active Directory, but when they don’t work, it’s a nightmare to fix. Reporting […]
So you’ve worked out how often to take your backups, what sort to take, and where to store them. You’ve created your jobs and have them running regularly, now what? Now you need to test that they’re working, and not just now, but forever into the future. There is only 1 way to know that […]
If you manage data for a business, the biggest risk you should always consider is how much of this data am I going to lose if a disaster strikes? Your manager is always going to want to have 0 data loss, that everything saved is kept no matter how big the disaster. However, they are […]
