April 4, 2018 Creating a RunAsAccount in Azure for Azure Automation Warning: We have three different people with three different levels of security in our Azure tenant and only one of us could create this…
March 22, 2018 Loading Linux command line logs in to Windows SQL Server We recently decided, for auditing reasons, that we would like to keep a record of all of the commands that were run on our…
February 22, 2018 SQL Server Reporting Services Timeout The other day we ran in to an issue where the report was running 30 minutes, this may be the only report that we…
February 15, 2018 FindTime for meetings I received an email today from FindTime Notifications. If you haven’t heard of this Outlook add-in, it’s a pretty cool addition from Microsoft, that…
February 7, 2018 Using alias to upgrade old servers One trick that I have used numerous times and really like is to use a server alias when moving to new servers. For instance,…
January 3, 2018 Connect to SQL Server when you don’t know SA account or don’t have sysadmin access Below are the steps you need to perform to grant SYSADMIN access to a user in SQL Server in case you are completely locked…
December 31, 2017 Reading List – 2018 I don’t normally do New Year Resolutions, but during the Christmas break I was reading numerous articles on LinkedIn, I’ve always enjoyed Linkedin, with…
December 20, 2017 Determine what Linux Version 4 different commands that you can run to see information about your Linux distro. [oracle@server ~]$ cat /etc/issueOracle Linux Server release 6.8 [oracle@server ~]$…
December 20, 2017 Create Data Guard standby using RMAN Production server – serverProdStandby server – serverStbyProduction database – whseprodStandby database – whsestby Step 1: Using RMAN, Backup the database that includes backup of…
December 12, 2017 2018’s list of goals Many items peak my interest and that can sometimes make it difficult to choose a few that I would like to gain a deeper…
