SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


Aaron Nelson ( blog | twitter ) is a Microsoft MVP for SQL Server (Data Platform) and leads the PowerShell Virtual Chapters of PASS, and volunteers for the local PASS Chapter AtlantaMDF, and helps organize SQL Saturday events in Atlanta. The PowerShell VC of PASS hosts monthly sessions on SQL Server and PowerShell, and you can find the recordings of those sessions on their YouTube channel.

Export AdventureWorksDW2017 to Excel for a Power BI Demo with Export-Excel

Have you ever wanted to export an entire SQL Server database to Excel file?  Yeah, me neither.  Until yesterday, when I was trying to build a Power BI demo with sample data (that needed to come from files, not a db) I have never even considered doing such a thing. Read more

0 comments, 142 reads

Posted in SQLvariant on 14 March 2019

How to Submit Feedback to Azure Data Studio WITHOUT tweeting.

This is one of those things that doesn’t warrant a blog post; until you talk to three other well-versed data professionals who all had the same confusion.

Azure Data Studio is a great little cross-platform SQL editor and the team has been working hard to add some of the most… Read more

0 comments, 149 reads

Posted in SQLvariant on 12 March 2019

Invoke-Sqlcmd is Now Available Cross-Platform in the SqlServer module

Invoke-Sqlcmd is Now Available for MacOS & Linux in the SqlServer module.  The module has been posted as v21.1.18095-preview which means to download the module you’ll have to add the -AllowPrerelease parameter.

Update-Module SqlServer -AllowPrerelease

But wait, there’s more.  In order to use the Invoke-Sqlcmd cmdlet on PSCore you’ll… Read more

0 comments, 840 reads

Posted in SQLvariant on 5 March 2019

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 looking for the slides or the video, those are available over on the Ignite site:… Read more

0 comments, 614 reads

Posted in SQLvariant on 28 September 2017

#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 what I’m going to write about today. Instead, I’m just going to post some pointers to… Read more

1 comments, 324 reads

Posted in SQLvariant on 11 September 2017

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 from this weekend:

With this August 2017 preview, users can create Power BI…

Read more

2 comments, 3,778 reads

Posted in SQLvariant on 28 August 2017

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 meeting new people and running into old friends.

If you’ll be at Ignite, here are the… Read more

0 comments, 305 reads

Posted in SQLvariant on 23 August 2017

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 to build me session. Here are the things I talked about and the and where to… Read more

0 comments, 416 reads

Posted in SQLvariant on 17 August 2017

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 persistence, process, source control and all the rest of the tools and mechanisms, and most importantly,… Read more

1 comments, 472 reads

Posted in SQLvariant on 13 June 2017

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 built to help people keep up with all the things that have been made… Read more

0 comments, 480 reads

Posted in SQLvariant on 7 June 2017

Recent SQL PowerShell Articles I Have Written

It’s been too quiet on this blog this year, especially with all the awesome things going on in the SQL PowerShell world!

It’s all my fault

I’ve been spending a lot of the time I could have been using to write blogs to write articles instead. I’ve been trying… Read more

0 comments, 431 reads

Posted in SQLvariant on 4 May 2017

Finding Free Space Per Drive & Mount Point in PowerShell

Back in 2010 I was inspired by a twitter conversation between Nicolas Cain (blog | twitter) and Dave Levy (blog | twitter) about checking Disk Space & Mount Points to create a PowerShell function called Get-DisksSpace which can tell you how much space is available on… Read more

1 comments, 898 reads

Posted in SQLvariant on 3 May 2017

SQL PowerShell 2017 IS HERE!

Cue Princess Jasmine.

What do I mean “Cue Princess Jasmine”?
Well because starting today, it’s a “Whole New World for You & Me”

What on Earth am I talking about??
The SqlServer PowerShell is now available for download in the PowerShell Gallery! http://sqlps.io/sqlserver

What Does It Mean!?

It means that… Read more

1 comments, 2,998 reads

Posted in SQLvariant on 26 April 2017

PowerShell Virtual Group of PASS February Newsletter

We had a schedule conflict so today’s meeting will be pushed until next Wednesday.  However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in).


In this newsletter:

  • Add SSRS to the SQLServer PowerShell Provider?
  • Tonight: PowerShell SQL Server: Modern Database Administration with dbatools and…

Read more

0 comments, 481 reads

Posted in SQLvariant on 15 February 2017

Dark Theme in Office 2013 & 2016

Last week I blogged about how you can turn on Dark Theme in SSMS 2016 but that it’s unfinished and you can use it at your own risk.

As good quality 4K monitors in the 30+ inch range continue to get cheaper & cheaper I find myself wanting to have… Read more

0 comments, 4,716 reads

Posted in SQLvariant on 5 February 2017

Running SSMS 2016 in Read Uncommitted Mode

Back in July when we received the first official release of SSMS not tied to an engine release we got a new SQL PowerShell module and we also received the ability to run SSMS in Read Uncommitted mode via a registry setting.

I was hopeful that this new option would… Read more

3 comments, 1,948 reads

Posted in SQLvariant on 25 January 2017

PowerShell Virtual Group of PASS January Newsletter

We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS.  But hey, we’re database people, not email mavens, and the newsletter does go out to over 4,000 people so it’s worth taking time to try and get it right (even though we don’t… Read more

0 comments, 516 reads

Posted in SQLvariant on 18 January 2017

T-SQL Tuesday #86 – Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view

Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date of the last known good DBCC CHECKDB to SYS.DATABASES. This one seems like a no-brainer to me. When you NEED this… Read more

2 comments, 420 reads

Posted in SQLvariant on 10 January 2017

Refreshing the SQL Server PowerShell Provider

Sometimes SSMS gives you stale results and there you have the Refresh button to fix that.

In SQL PowerShell, the same situation can arise where the SQL Server PowerShell Provider is responding to your request with stale data. So how do you fix that? Pretty easily actually. Wherever you are… Read more

0 comments, 522 reads

Posted in SQLvariant on 6 January 2017

Up Next, SQL PowerShell for SSAS!

I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s time.

I use SSAS on a regular basis but I’m probably not going to come up with the lion’s share of… Read more

1 comments, 309 reads

Posted in SQLvariant on 12 December 2016

Older posts