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...
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...
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...
My friend Reza Rad ( blog | twitter ) reached out to me this morning because he was running into some issues with a PowerShell cmdlet for gathering some log data. To make a...
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...
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 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...
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...
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...
Available from dbatools.io and github
SQL PASS PowerShell
Virtual User Group
SQLvariations: SQL Server, a little PowerShell, maybe some Power BI
