George V Woods

DBA, Business Intelligence, Big Data & Cloud

  • linkedin
  • twitter
  • github
  • about
Skip to content
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 ~]$…

Posts navigation

Previous 1 2 3 4 Next

Recent Posts

  • Correct settings to use Azure Blob Storage as a data source for the Power BI Service
  • 2018 Reading List
  • Connecting to Integration Services
  • Back up all databases in a SQL Server instance
  • Comparing time to production for On-Prem QlikView vs Power BI in the Cloud

Archives

  • January 2019
  • December 2018
  • November 2018
  • August 2018
  • July 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • December 2014

Categories

  • Azure
  • Business Intelligence
  • Career
  • Cloud
  • Data Guard
  • DBA
  • employee greatness
  • LinkedIn
  • Linux
  • oracle
  • Oracle Cloud
  • PASS Summit
  • planning
  • Power BI
  • PowerShell
  • Reporting Services
  • SQL Agent Jobs
  • sql server
  • statistics
  • Uncategorized

Follow George on Twitter

Tweets by @gvwoods
Copyright George V Woods. All rights reserved. | Theme by SuperbThemes