Recently I had to validate the row counts of some existing tables in PBI Data Flows that I was converting over to a new source. So wanted to make sure the row counts matched between the current a...
http://blog.matticus.net/2022/05/validate-row-counts-of-pbi-tables-in.html
While designing a data platform using Azure Synapse (or Azure Data Factory) it is quite common to want to use variables and/or parameters to control various aspects of your code execution. One co...
http://blog.matticus.net/2022/03/azure-synapse-notebook-variable.html
The following is a list of resources useful for Power BI training and product news: PRODUCT NEWS Power BI Blog https://powerbi.microsoft.com/en-us/blog/ SYNTAX AND LANGUAGE REFERENCE Da...
Take this scenario. Your writing a PowerBI report to pull data from a REST Api. The Api doesn't provide a search route which returns all the rows and data you require in one call. You can retri...
http://blog.matticus.net/2018/07/powerbi-calling-rest-api-for-each-row.html
Introducing my latest SQL Server Life Cycle and Versions lookup tool. HTTPS://SQLVERSIONS.AZUREWEBSITES.NET Back in 2016 I released the first version of this app and the goals were the sam...
http://blog.matticus.net/2018/06/new-sql-version-life-cycle-tool.html
A recent project I have worked on was using CSV files as part of an ETL process from on-premises to Azure and to improve performance further down the stream we wanted to convert the files to Par...
http://blog.matticus.net/2018/05/convert-csv-files-to-parquet-using.html
Announcing my new SQLOPS EXTENSIONS ALWAYSON INSIGHTS https://github.com/Matticusau/sqlops-alwayson-insights/releases MSSQL INSTANCE INSIGHTS https://github.com/Matticusau/sqlops-mssql-instan...
SQL Server 2016 introduced a new capability with AlwaysOn Availability Groups called Automatic Seeding. This allows you to automatically start streaming the backup using VDI across the log strea...
http://blog.matticus.net/2017/10/troubleshooting-sql-server-alwayson-ag.html
I was recently working on a solution where a DSC Configuration block was not compiling in Azure Automation. This solution included Node Data, DSC Resources, and custom Composite Resources. The c...
http://blog.matticus.net/2017/09/checklist-for-troubleshooting.html
With SQL Server 2016 the Availability Groups now include the option to enable Database Level Health Detection. While this option is turned off by default, Microsoft strongly recommends you enab...
http://blog.matticus.net/2017/08/taking-availability-group-database.html
With the release of SQL Server Management Studio 17.0 (SSMS) the SqlServer PowerShell module has finally been decoupled and now can be installed independently. To take full advantage of this cha...
http://blog.matticus.net/2017/04/installing-sqlserver-powershell-module.html
One of the best new tools I have been using lately is Cmder. A Terminal Emulator for Windows which is great for a number of reasons: Tabbed terminals Multiple languages can be emulated Fully...
http://blog.matticus.net/2017/03/cmder-enhance-your-windows-terminal.html
Firstly let me start by stating that when I originally set out in an IT career I was heading down a developer path, and certainly had a number of developer type roles over the years, or found wa...
http://blog.matticus.net/2017/03/why-management-studio-is-no-longer-my.html
I use a combination of GitHub and Visual Studio Team Services (Visual Studio Online, VSTS, etc) repositories. GitHub is pretty straight forward for resolving merge conflicts of pull requests thr...
http://blog.matticus.net/2017/02/fixing-merge-conflicts-in-vs-code.html
StretchDB is a new capability in SQL Server 2016 which provides the ability to effectively partition your data between warm and cold data, and more importantly allow SQL Server to automatically ...
http://blog.matticus.net/2016/12/restoring-stretchdb-databases-and-why.html
Things have been a bit busy for me personally over the last few months but that is another story. What I have done is use some of this time to get back to a little project I started a while back...
http://blog.matticus.net/2016/08/new-sql-server-builds-api-improve-your.html
While discussing the concepts of 'optimize for ad hoc workloads' and 'Forced Parameterization' in SQL Server I decided to modify an existing query I wrote to analyse the query performance from t...
http://blog.matticus.net/2016/04/tsql-to-identify-queries-which-are.html
Yesterday I was talking to a workshop about implementing Risk Mitigation capabilities into your own Advanced Functions in PowerShell. This got me thinking about how to identify the commands that...
http://blog.matticus.net/2016/03/powershell-finding-commands-functions.html
UPDATE 03/03/2016: It's amazing how quickly this went from a simple script to within an hour yesterday becoming a Module and now released on PowerShellGallery and GitHub . Check out the instruct...
http://blog.matticus.net/2016/03/powershell-ise-add-on-to-toggle.html
A colleague pointed out to me today that it has been a long time since I blogged, and you know what he is right as I have mostly been posting tweets about interesting news. Given I was taking so...
http://blog.matticus.net/2016/02/generating-certificates-for-desired.html
If you haven't heard, Microsoft have broken the release of SQL Management Studio away from the main product. While at this stage it is continuing to be released at the same cadence as the SQL 20...
http://blog.matticus.net/2015/10/latest-ssms-stream-lines-process-for.html
The SQL Server Management Pack has been refreshed with all new dashboards, which look to be fully extensible and designed for larger server farms. Full details on how to configure the dashboards...
http://blog.matticus.net/2015/06/scom-sql-server-management-pack-6600.html
I've been automating the installation of SQL Server components for 10+ years now so it's no surprise I am a fan of PowerShell and Desired State Configuration (DSC). Given my background in large,...
http://blog.matticus.net/2015/06/announcing-release-of-my-sql-server-dsc.html
Something I came across in SCOM 2012 R2 is that when users try and view Reports from the OpsMgr console wunderbar they could receive a blank list. POSSIBLE CAUSE #1 - INCORRECT SSRS FILE SY...
http://blog.matticus.net/2015/06/scom-fixing-blank-report-list-in-ops.html
In case you missed the announcement SQL Server 2016 CTP2 preview was publicly announced today. You can read about it in the following post: http://blogs.technet.com/b/dataplatforminsider/archiv...
http://blog.matticus.net/2015/05/sql-server-2016-query-store-first-looks.html