Artificial Intelligence with Power BI
Executive Summary Artificial intelligence is transforming businesses across the world. There are several tools and technologies to realize the benefits of AI efficiently and effectively. However, one software package that most organizations already hav …
SSIS Bad Habits: Decreasing SSIS Package Performance
The post SSIS Bad Habits: Decreasing SSIS Package Performance appeared first on SQLServerCentral.
Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back
The post Setting SQL Deadlock Priority to Control the Transaction that is Rolled Back appeared first on SQLServerCentral.
Deploy and Configure Azure SQL Managed Instance
The post Deploy and Configure Azure SQL Managed Instance appeared first on SQLServerCentral.
How to create a Power BI report using REST API data
Introduction In this article, we will learn how to create a Power BI report using a REST API. REST API is an Application Program Interface that uses HTTP requests to get data. Usually, the data is sent in JSON format. For example, you can use REST API …
[Video] Office Hours: Great Questions, Part 2
Every time I think, “There can’t be any more SQL Server questions left,” y’all post more great ones at https://pollgab.com/room/brento! Here’s what we covered: 00:21 MattC: Hi Brent. Have you check out ChatGPT’s abil …
Updated First Responder Kit and Consultant Toolkit for December 2022
Santa’s elves took a break from building toys and shipped a new version of the First Responder Kit. There are some great improvements in here, like a makeover for sp_BlitzLock and much better PSPO compatibility for sp_BlitzCache. Wanna watch me u …
Reviewing SQL Migration Files Before a Flyway Migration
The post Reviewing SQL Migration Files Before a Flyway Migration appeared first on SQLServerCentral.
[Video] Office Hours: Great Questions, Part 1
Wow, y’all have been posting some great questions at https://pollgab.com/room/brento lately! Here’s what we covered today: 00:59 Gustav: Hi Brent We recently migrated to SQL MI General Purpose, and I noticed that the default blob storage pe …
What’s new on Power BI DataMarts UI
I wrote an article about Power BI Datamarts which was released together the feature, on the exact moment it was being announced in a conference. Of course, this feature has being evolved since that time. I would emphasize the performance. The general U …
Automate Power BI desktop data model with a PowerShell script
Waiting for PBI desktop « working on it » When you know the host and port of SSAS Tabular instance, you just need to connect to it – and your entire PBI model (i.e. tables, relationships, measures, load scripts) becomes available for scripting via .NET A …
Exploring Hive Tables with Spark SQL
The post Exploring Hive Tables with Spark SQL appeared first on SQLServerCentral.
New DevOps Process Improvement Course
The post New DevOps Process Improvement Course appeared first on SQLServerCentral.
Backing up MySQL Part 8: Zmanda Backups for MySQL & Other Backup Tools
“A Backup as Revolutionary as You Are.” Ever heard that phrase before? If you did, you’re no stranger to Zmanda Recovery Manager – or ZRM for short. Zmanda Recovery Manager is a terabyte-scale backup tool helping you take MySQL …
The Enterprise Roadmap to Reducing Costs (While Increasing Value)
The post The Enterprise Roadmap to Reducing Costs (While Increasing Value) appeared first on SQLServerCentral.