SQLvariant.com blog by Aaron Nelson

SQLvariations: SQL Server, a little PowerShell, maybe some Power BI Blog

2017.09.28

Scripts for SQL PowerShell Session at Microsoft Ignite 2017

This is just a quick blog post to share the scripts I used during my sessions at the Ignite conference this year. You can download a .zip file with the scripts here. If you’re...

PowerShell

2017.09.11

#TSQL2sDay Long Story Short: Avoid -Scope User

For T-SQL Tuesday #94 the topic is databases and PowerShell. Rob Sewell asks us: What are you going to automate today? I’m going to automate some thing in SSRS & SSAS, but that’s not...

Power BI

2017.08.28

Power BI Report Server (On-Premises) for All Data Sources is Available!

Power BI Report Server August 2017 Preview is now available. Think of this a “v.Next” of Power BI Report Server [On-Premises], for all Data Sources. Here’s an excerpt from the Power BI blog post...

SQL Server

2017.08.23

I’m Speaking at Ignite in Orlando!

I’m excited to say that I will be speaking at Ignite this year in Orlando! I was at Ignite in Atlanta last year and it was an excellent experience. I’m really looking forward to...

SQL Server

2017.08.20

[Quick Blog] SQL Server Cross-Platform Command Line Tools

Recently while I was on a conference call with some of the engineers from the SQL Server product team at Microsoft, the topic of their new multi-platform scripting tool came up. I told them...

Virtualization

2017.08.17

Session Resources for: Visual Design Tips for Power BI & SSRS 2016+

Yesterday I did a session for Idera’s Geek Sync series called “Visual Design Tips for Power BI & SSRS 2016+”. In the session, I called out a bunch of resources that I had used...

PowerShell

2017.06.13

DevOps or DataOps Either Way It’s Coming to SQL Server

For T-SQL Tuesday #91 the topic is databases and devops. Grant Fritchey asks us: How do we approach DevOps as developers, DBAs, report writers, analysts and database developers? How do we deal with data...

PowerShell

2017.06.07

SQL PowerShell Pre Con at SQL Saturday Chattanooga

I happy to be doing a PreCon at SQL Saturday Chattanooga on Friday June 23rd. A lot has changed in the SQL PowerShell world in the last 15 months and this full-day session is...