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.
Connect to SQL Server with Python to Create Tables, Insert Data and Build Connection String
The post Connect to SQL Server with Python to Create Tables, Insert Data and Build Connection String appeared first on SQLServerCentral.
Data Activity Tracking Using SQL Triggers
Introduction In Today’s IT world, data is everything, so providing data access to many users introduces a potential threat of unknown risks. We must take proper measures to capture data changes and updates to avoid such risks. Therefore, the data manag …
Data Masking in Principle
The post Data Masking in Principle appeared first on SQLServerCentral.