July 19, 2018 Overview of Connecting to Azure Analysis Services With Azure Analysis Services Firewall off. As admin account – Log in to Azure Deploy model Connect with SQL Server Management Studio from laptop…
July 9, 2018 Geo-Replication in Azure I was recently asked to look at creating a read-only copy of a SQL Server database in China, with the source being in the…
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 ~]$…