retrieve logins from a master database backup file

How to retrieve logins from a master database backup file in SQL Server

After a big disastrous crash on one of our customers SQL Server 2016,  the server could not be brought online. But luckily, we were able to recover most of everything from our scheduled full backups. User databases have been restored easily but we also needed to retrieve logins details that have been there before the...Continue reading

Creating accessible reports

How to create accessible reports

It is important for report designers to be able to create accessible reports. Creating accessible reports ensures access of information to all users, with all levels of ability. That means your reports needs to comply with the Web Content Accessibility Guidelines (WCAG) and needs to be accessible to users with disabilities. There are two extremely...Continue reading

Tableau Dashboard to see all permissions-access for all users

Tableau Dashboard to see all permissions/access for all users in a SQL Server database

Case: One of our client’s employees is leaving the organization and they would like to see all permissions/access for this person for all databases on a server for security auditing purposes. By all access: all the users that have access to a database, or objects within the database such as tables, views, and stored procedures,...Continue reading

Creating a report

Best practices to create a high quality report

Creating a report is meant to give actionable insights to the report users about their data, just forming a report with sales information in it isn’t just enough for business professionals to make informed decisions. While building a report the designer should always ask important questions to themselves: What is the purpose of this report?...Continue reading

Hands on a notepad and coffee cup in front of a laptop and smart phone.

4 Things to Consider When Building a New BI Solution

Whether you’re a new business, a business new to Business Intelligence software or a business looking to upgrade its current system, there are a lot of options available these days. That’s because more and more businesses have begun to recognize the benefits of these softwares and services. But with so many options to choose from,...Continue reading

How to combine/merge multiple workbooks with different data source into a single workbook in Tableau

Sometimes you can have multiple similar workbooks that need to be combined / merged into a one central workbook. Although individual workbooks in Tableau can lead to powerful insights that help your business, many times, it makes sense to combine the workbooks into a single one. By combining varying visualizations into a one central one,...Continue reading

Scroll to top