Additional Articles


External Article

Create a Feedback Loop between Devs and DBA Teams with Monitoring

With remote working still encouraged around the world, there is a need to ensure that operations teams have full visibility of your estate, not just your production servers. If your engineering teams have access to secure development and testing servers, deployment issues are caught before they reach production. Find out how to keep communication flowing between DBA and development teams in this free whitepaper. Read the whitepaper here.

2020-10-29

External Article

Why choose Oracle?

Oracle has been established as one of the top database systems used in enterprises throughout the world. In this article, Cynthia Dzikiti describes her career as an Oracle application developer and covers some of the benefits of Oracle.

2020-10-28

External Article

Introduction to DAX Financial Functions – Part 1

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions. In this article, he exposes five functions that are popular in the calculation of loans and other annuities. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.

2020-10-22

Blogs

Making Legend Order Match Segment Order in a Power BI Stacked Column Chart

By

A reader of one of my previous posts pointed out that the legend order...

The Only Valid Test of a Backup is a Restore

By

Please, let me reiterate: The only valid test of a backup is a restore....

Comparing an Old Running Total to Window Functions

By

Often I see running totals that are written in SQL using a variety of...

Read the latest Blogs

Forums

Help with index rebuild

By dnison-905607

Hi there!  This should make some eyes roll for some of you DBA's out...

Cannot connect to Analysis Services via Excel

By Bhagat

For myself this seems to work and for other users they receive this error:...

Azure Managed Instance Backup Schedule with SQL Job

By mohan.bndri

Lets do configure backups in my own in Azure Managed Instance......My Lead has directed...

Visit the forum

Question of the Day

Migration Assistant Issues

If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3)

See possible answers