Articles

Dynamic data sources in PowerBI Desktop

What if we had 50 SQL Servers and wanted to plot the history of SQL Agent jobs or any other common metric? And what if we wanted to create a template and be able to feed a different list of servers every time? This could be challenging but hopefully, PowerBI can be dynamic.

Move data to Azure Archive Storage using PowerShell

We can move existing files, in the existing Storage Account to the archive tier, or upload files as we normally would to an existing account and can then mark them for archiving. This process is completely manual but with the help of PowerShell can be easily automated.

Use CONTEXT_INFO to avoid firing triggers

DML Triggers are commonly used to apply some business rules to the data in the table. The most common implementation would be updating the date_updated column automatically whenever the data in the table changes. Learn how to avoid firing trigger when doing an update without disabling it.

Data and Microsoft Data Platform Consultancy based in York, UK.

[email protected]

Services

Data Migrations

Data Integrations

Business Intelligence

SQL Server Management

Automation

Cost reduction

Data Security

Managed Services

Performance Tuning and Testing

Company

Sargable Group Ltd.

Registered office:
Club Chambers
Museum Street
York, YO1 7DN
United Kingdom.

Company No: 10454775
VAT: GB295768926

MS Partner Logo