SQL Server Error Message 3628
How trace flag 1254 fixes SQL Server Msg 3628 with queries using In-Memory tables
07 Jun 2019

I recently ran into this issue with SQL Server 2019 CTP 2.5 where I was getting the error – Msg 3628, Level 16, State 1, Line 4 The Database Engine received a floating point exception from the operating system while processing a user request. Try the transaction again. If the problem persists, contact your system administrator. It turned out that this would happen whenever I ran a query that joined In-Memory tables with disk based tables and the result ended […]

Power BI Set Filters
Power BI — Set Visual, Page, and Report Level Filters — Episode 13
04 Jun 2019

Welcome to the last episode of my Power BI Best Practices Series. In today’s episode, I will show you how to filter your report based on visual level, report level, or page level filters. Here we go! Set Filters First of all, let’s discover the main filter types and examine their differences. Visual level filters allow for filtering only the selected visual. Likewise, page level filters allow for filtering the entire page. And report level filters allow for filtering all […]

Power BI Edit Interactions
Power BI — Edit Interactions — Episode 12
04 Jun 2019

Welcome to Episode 12 of my Power BI Best Practices Series. In today’s episode, I will show you how and why you should edit your interactions in your visuals. Editing interactions allows for you to apply the filter directly on a visual. Also, you can change the way the filter interacts with different visuals on your page. Here we go! Edit Interactions In the Edit interactions menu, you can specify, to which visuals this filter applies. You can turn off […]

Power BI Cut Unnecessary Visuals
Power BI — Cut Unnecessary Visuals — Episode 11
03 Jun 2019

Welcome to Episode 11 of my Power BI Best Practices Series. In today’s episode, I will show you how and why you should cut unnecessary visuals in your dashboard to allow for better user experience. Clean reports have a better look and feel. Moreover, they make it easier for the user to understand the information and navigate through the dashboard. Here we go! Cut Unnecessary Visuals An unnecessary visual is a visual that shows replicated data that you don’t need […]

Report Support Tab
Power BI — Include a Report Support Tab — Episode 10
03 Jun 2019

Welcome to Episode 10 of my Power BI Best Practices Series. In today’s episode, I will show you how to include a report support tab in your Power BI report. This tab helps your users see where the data comes from. Also, here you can include your contact information, so the users of your report will know how to reach you if they have questions. Here we go! Include a Report Support Tab A report support tab stores auxiliary information. […]

mvp
Why MVP is a viable way to start your business?
03 Jun 2019

A minimum viable product (MVP) is a development strategy in which a new product is developed with sufficient features to satisfy early users. The final, complete set of features is only designed and developed after considering feedback from the product’s initial users. Generally speaking, the minimum viable product is the first version of a mobile application or a website, which has only the crucial features that reflect the core idea of your startup. As your user base grows, so does […]

Power BI Themes
Power BI — Themes Are Your Best Friend — Episode 9
28 May 2019

Welcome to Episode 9 of my Power BI Best Practices Series. In today’s episode, I will show you how you can create themes in your Power BI report and allow for more branding experience. Here we go! Create Power BI Themes Power BI themes allow for brighter visualizations, as well as customizing and standardizing your reports. You can select one of the predefined themes, import an existing theme, pick up a theme from the gallery or even create a new […]

mapping Oracle data types
Use Caution When Mapping Oracle Data Types for Procedures and Function Parameters in SSMA
27 May 2019

When converting Oracle database code to Microsoft SQL Server, I often face the problem of correctly mapping Oracle data types to SQL Server data types. I regularly use SQL Server Migration Assistant (SSMA) to automate Oracle database code conversion to SQL Server. However, SSMA’s default data type mapping for Oracle procedure and function parameters uses the maximum possible size for each specific data type to prevent data loss. This approach causes unintended consequences with application code. The Problem In Oracle, […]

Migrating Oracle apps with OCI interface to SQL Server
General approach to migrating Oracle applications with OCI interface to Microsoft SQL Server
24 May 2019

When migrating a customer’s Oracle databases to Microsoft SQL Server I often face the problem of updating relevant applications. A broad range of our customers use the Oracle Call Interface (OCI) to develop their database applications. Oracle Call Interface is the comprehensive, native C language interface to Oracle Database. Our customers regularly use the OCI interface to create custom and packaged applications. The problem This interface is specific to Oracle and you can’t use it to connect to any other […]