Skip to main content
Category

SQL Server

Jan 31 2023
Love0

Using Query Store to Analyze Database Performance

By Application Development, SQL Server

Are you concerned about how your database is performing for your application? Did you know that there is a built-in feature in SQL Server and Azure SQL that you can use to evaluate your database for potential problems? Query Store has been available since the introduction of SQL Server 2016, and is enabled by default in Azure SQL and Azure SQL Managed Instances, but it has flown under the radar as a performance tool.

Read More
Jan 20 2022
Love0

Using Hangfire to Run Background Jobs in IIS

By All Posts, Consulting, Managed Services, Productivity, SQL Server
Using Hangfire to Run Background Jobs in IIS Recently one of our clients went through an application modernization project to upgrade and update their internal business applications. Among the technical challenges to conquer was how to handle long-running and recurring scheduled jobs. In the existing system, the long-running jobs were being allowed to run in process, with the users being instructed to initiate the process in their browsers and then not do anything until it...
Read More
May 11 2021
Love0

What is Data Engineering?

By All Posts, Azure, Business Intelligence, Power BI & SQL, SQL Server
When you look at a dashboard or report in Power BI, you are seeing the tip of the iceberg; the data you see has likely taken many steps from its source on its way to Power BI. Data engineering is the work that brings data from one or more sources and shapes it, validates it, cleans it, correlates it, and (often) stores it, and it’s a lot of what we do at Imaginet. Power BI...
Read More
Oct 20 2020
Love0

5 Lessons Learned with SQL Always Encrypted

By All Posts, Application Development, SQL Server
Microsoft introduced Always Encrypted with SQL Server 2016 as an approach to encrypting data at rest and in transit to protect personally identifiable information and financial transactions. Always Encrypted works by encrypting the data on the client side and hiding the encryption keys from the server. Without explicit permission and configuration, even database administrators cannot read the information stored in an encrypted column. This is obviously a significant step forward in security and allows users...
Read More
May 26 2020
Love0

6 Reasons to Use Angular Instead of ASP.NET MVC (Razor)

By All Posts, Application Development, Application Lifecycle Management, Azure, Consulting, DevOps, Enterprise Architecture, Enterprise Mobile, Modern Workplace, Power BI & SQL, Productivity, SQL Server
At Imaginet, we recommend the use of single-page applications using Angular for building enterprise applications. Customer solutions are still being built using ASP.NET MVC with Razor pages, generally because it is a well-known technology stack that is familiar to most companies’ development teams. However, this article will present six reasons why Angular is the superior option for building your application. Angular applications still follow an MVC style (or perhaps more correctly MVVM). In fact, they...
Read More
Feb 15 2017
Love0

Scaling Azure SQL Databases Up and Down

By All Posts, Azure, Power BI & SQL, SQL Server, Tutorials No Comments
Scaling Azure SQL databases up and down   I've recently been working on a project where we push data from an on-premise database to a set of Azure SQL databases daily, and use that Azure SQL database as the source for a Power BI dataset. The dataset gets refreshed once a day. Our Azure SQL data marts are pretty small - all but one of them are under 2 GB, and the largest one is...
Read More
Let‘s Talk.

Let's talk!