Blog

blog

Exploring SQL Server Metrics in Power BI

This blog is aimed at IT/Database folks to show you how you can leverage Power BI when analyzing databases and environments for problem areas or performance issues. This exercise presents an alternative to rows and rows of data, and gives some tools/ideas to create a quick report and make it repeatable across environments when analyzing SQL Server metrics.      

Seth Bauer by Seth Bauer

Querying using Views

Today we look at a high level overview of using Views in your SQL queries and the implications behind them.

Nick Adams by Nick Adams

JOIN vs APPLY

A real world but different look into JOIN vs APPLY.

Nick Adams by Nick Adams

Welcome to R!

A brief introduction to R Language

Nick Adams by Nick Adams

Watch “Moving from Profiler to Extended Events”

 I talk about why you want to learn it, show you a direct comparison between setting up a Profiler session and an XE session, and teach you how to convert existing Profiler traces to XE.

Concurrency Blog by Concurrency Blog

Watch “Level Up Your SQL Server Index Knowledge”!

Adding the right index is a little bit of science and a lot of knowledge about how your database is being used.

Knowing the basics about SQL Server indexes will help you be a better developer

Concurrency Blog by Concurrency Blog