Expert Insights

blog

SQL Server


Azure Backup for SQL Server 2019

How to backup your important data stored in SQL is something on the minds of many IT professionals. Recently, Azure announced a new feature for backing up SQL servers running in VMs on Azure.

Paul Harris by Paul Harris

New Additions to Azure Infrastructure as a Service - Microsoft Ignite 2019

Last week, the yearly Microsoft Ignite conference occurred in Orlando, Florida. At this conference, Microsoft brings together developers and IT Professionals to learn what is coming next with Microsoft’s product offerings. Let’s discuss some of the new developments in the IaaC world

Paul Harris by Paul Harris

Power BI vs SSRS

A detailed description of the differences between Power BI and SSRS

Zed Dietrich by Zed Dietrich

Moving Big data in and around Azure using Azure Data Factory.

There are numerous data storage options available on Azure, each one designed and developed for different modern data storage scenarios. These storage options could be in the form of database, data warehouse, data caches and data lakes. Usage of these depends on the application and the scale that they serve. Within databases, some applications might need relational database, some might need NOSQL, or a key-value storage, or in-memory database (for caching), or blob storage (for media and large files). Another criteria to keep in mind when selecting a database for your application is the required read-write throughput and latency. Azure has a wide array of fully-managed database services which frees up the development teams valuable time in managing, scaling and configuring these databases.

Whatever database you choose, you should also keep in mind how easy or difficult it is to move the data in and out of that database. You might have a situation in future where you need to move to a new database solution because of reasons like change in application architecture, scale, performance, or even cost. Microsoft Azure has a very powerful ETL tool called Azure Data Factory to easily move data in and around Azure at scale. It has over 80 native connectors which can serve both as source and sink.  In this blog, I would like to highlight a few features and concepts of Azure Data Factory which will serve as a quick start guide for anyone looking to do data movement and transformation on Azure.

Siddharth Bhola by Siddharth Bhola

Accelerated Database Recovery - The Future of the Transaction Log

With SQL Server 2019, Microsoft is introducing a new feature called Accelerated Database Recovery (ADR).  ADR fundamentally changes the way SQL processes transactions, resulting in dramatically reduced time for crash recovery and rollback.

Frank Gill by Frank Gill

Creating a Suspect SQL Database

Recently, a customer contacted us asking for the steps to force a SQL Server database into a Suspect state.  Although there are other blog posts about doing exactly that, they didn’t quite work for us.  Let’s take a look at how we got this working for them.

Mitchell Grande by Mitchell Grande

Concurrency Data and Analytics Internship

Hi! My name is Chance Alexander, and this blog post will entail the experiences and responsibilities within Concurrency's internship program on the data and analytics team.

Chance Alexander by Chance Alexander

RIP @sqlsoldier

Today I learned that Robert Davis, aka @sqlsoldier, passed away. Among other things, Robert literally wrote the book on SQL Server mirroring. I met him briefly at SQL Saturday Oregon, but interacted with him frequently via the #sqlhelp hashtag. He was often one of the first people to reply to my many questions about the […]

Frank Gill by Frank Gill

PowerShell Function to Automate Availability Group Failover

I’ve been working with Availability Groups (AG) since their release in SQL Server 2012 and have always wanted to leverage PowerShell to administer them.  Recently I received a request to develop an automated process for failing Availability Groups over gracefully prior to server patching.  Believe it or not, but a hard shutdown of the primary […]

Frank Gill by Frank Gill