Category Archives: GitHub

Reporting Services Databases on Availability Groups

In my current job as a DBA, one of my missions is making everything as automated as possible and making sure that when things go wrong(trust me, they will), the applications that are using my environment can smoothly continue to run with less intervention possible.

You will make mistakes which is part of the job, learning from those mistakes is what makes you grow. Today I want to share with you a few tips that will make your experience with SSRS Databases and Availability Groups less painful. Read the rest of this entry

Removing Databases from Availability Groups with Powershell

Those days at work I had to remove a bunch of databases from the Availability Groups and later drop them from the primary and secondary replicas. I know I could do the click, click and drop thing, but why not PowerShell? Read the rest of this entry

Looking at dbatools github with Power BI

First of all! Really, really thanks dbatools team for this. I don’t have words to describe the impact that you guys have in my job. I use it every single day!

Now… back to the subject..

Those days I was preparing myself for a presentation and started to play around with Online Services Content Packs and decided to use the GitHub App Connector that is available.

In the left bottom of the Power BI area you have the Get Data option.

image

Once the page is opened you should choose Services and click on GET.

image

In the search bar just type Github. In the Github connector click on Get it now

image

Now the fun begins. What about if you want to have a look at your favorite DBA Powershell  Gallery? Off course I am talking about dbatools.io. Read the rest of this entry

Do you want to improve SQL Server Docs?

I think many of us have not heard this, but recently (maybe not that recently) Microsoft made the SQL Server Docs available on GitHub under this link: https://github.com/MicrosoftDocs/sql-docs

Currently, if you navigate to any SQL Server Documentation and let’s say that you right now goes to this link: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server in the right hand side of the window you will see this… Read the rest of this entry