Performance Improvement for Cursors in Stored Procedures

Exploring some differences between using cursors, local fast forward cursors and using set logic.

Multi-Step Input Forms in ASP.NET MVC

It is a common problem with a web page that a form is too complex to fit easily on the page. You can, of course, rely on the scrollbar, but it soon becomes a daunting and erratic process for the poor user. Wizards, that allow you to guide the user through a process, are great but take time to set up. Is there a simple solution for those occasions where there is too much data-entry for a form but a full wizard seems like overkill?

Data Lifecycle Management using SQL Server

With the data proliferation issues, a well-defined lifecycle for data retention is a growing demand.

Azure SQL Database - Implementing Azure AD Authentication

Marcin Policht focuses on the specifics of using Azure Active Directory to authenticate to Azure SQL Database.

Byte Me: Plugged in

Find and Remove Duplicate Rows from a SQL Server Table

Though duplicate rows are bad practice, sometimes they're necessary for a short time. But how do you clean your tables when they're no longer needed? Sergey Gigoyan provides a few different solutions.

Using OVER() to Remove Duplicate Rows

Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.

SQL Server Timeouts During Backups and CHECKDB

So you’re hosting your SQL Server in the cloud, and you’ve noticed that when you’re running a backup or a DBCC CHECKDB, you suffer from extreme performance problems - what's going on? Brent Ozar explains.

TempDB growth due to version store on AlwaysOn secondary server

On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.

Power BI for Data Modelling

Power BI has a lot of uses, but one of the most interesting of them is to model and shape data to make it easier for self-service BI. Power BI is a full-stack solution that includes data loading, data modelling, metrics, reporting and distribution. It can take the source data, and perform in-process data modelling relatively easily as well a providing an easy to use and powerful user interface for analytics and reporting.