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.
Who’s Hiring in the Microsoft Data Platform Community? December 2022 Edition
Is your company hiring for a database position as of December 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must i …
The Good, The Bad, and Suboptimal of Sticking to What You Know
The Good In the late 1990s, one of the world’s most popular technologies was waning. COBOL. Relational databases were starting to take over, and COBOL usage was waning. By now, you would think it was utterly dead, right? You would be wrong. Go to …
Webinar | Database Monitoring: The ROI of Build vs. Buy
The post Webinar | Database Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
Amazon EC2 | Creating a Connection to an Amazon RDS Instance
Introduction In a previous article, we showed how to expose an Amazon RDS instance to the public internet securely for direct access to the database. This article focuses on configuring an Amazon EC2 instance for network access to an existing Amazon RD …
SQL Server 2022 Paid Editions Require a Licensing Key
The post SQL Server 2022 Paid Editions Require a Licensing Key appeared first on SQLServerCentral.
Dealing with the Bits of a Binary Value in SQL Server
How you used to do it For example, say you want to find all the read-write database using SQL Server 2022 system objects (I think this started back in 2005, in fact). You can write: SELECT name FROM sys.databases WHERE is_read_only = 0 AND name IN (‘ma …
Backing Up MySQL Part 7: MySQL Enterprise Backup
MySQL Enterprise Backup is a known tool for everyone inside of the world of MySQL, no matter if people dealing with the tool are enterprise (business) minded or not. The tool can be considered the flagship of MySQL’s enterprise-level offerings: i …