Fleitas Arts

Doing database #DevOps can be very rewarding. In this post I am going to cover how to automatically refresh a lower environment commonly used for testing as part of your release (CD) pipeline. #AzureSQL #SQLServer #powershell #CICD

How to refresh QA automatically by leveraging DevOps Doing database devops can be challenging, but it can also be very rewarding. DevOps is the union of people, process and products to enable continuous delivery of value to your end users. In this post I am going to cover how to automatically refresh a lower environment commonly used for testing as part of your release (CD) pipeline. Well,…

How to refresh QA automatically by leveraging DevOps Doing database devops can be challenging, but it can also be very rewarding. DevOps is the union of people, process and products to enable continuous delivery of value to your end users. In this post I am going to cover how to automatically refresh a lower environment commonly used for testing as part of your release (CD) pipeline. Well,…

I wrote this step-by-step staircase guide to help you ramp up or get started with Apache Spark ✨ in #AzureSynapse Analytics. Hope it helps.

Pls feel free to share with others and spread the word. Step 1 watch this video Step 2 skim through these slides for more context: Coming soon… The rest is all hands-on stuff – if you get stuck at any point lmk. Step 3 do this learning path: Perform data engineering with Azure Synapse Apache Spark Pools – Learn | Microsoft Docs Step 4 do these 4 Spark tutorials Tutorial: Create Apache…

My pipeline is slow, what do I do?

It was a Sunday, I was working on my tile as usual. Pulling a double shift on weekends has become a norm, but enough about that. This isn’t my construction blog. The email came in about Azure Data Factory. My friend happened to watch my video and reached out for help. Watch it on YouTube His issue was pretty much as mentioned on the tile. Our bank’s Azure Data Factory pipeline is running slow…

Join me tomorrow at the Microsoft Fort Lauderdale office or at a location near you. #GlobalAIBootcamp 🤖 https://globalai.community/global-ai-bootcamp #SQLServer #MachineLearning #AzureAI

I’ll be speaking at Global AI Bootcamp this weekend in the Microsoft Fort Lauderdale office. My session will be at 1:30 pm in Room 3, tomorrow, Saturday. It’s free to attend.

I am very excited to cover new material on Spark and Azure Data Studio Machine Learning Services extension which is soon to-be-announced. I hope you get the chance to join me and come the event.

Repo

https://github.com/hflei…

Join me tmrw at @unccharlotte for #SQLSatCLT #SQLSaturday. Room 111, 10:30am. See you there!

I’d be speaking at Charlotte this weekend and it’ll be a first for me there. This is again quite exciting. I hope you get the chance to join me and come the conference.

Repo: https://github.com/hfleitas/charlotte918

Upgrade SQL Server “In-Place” with Skip Over (on Windows)

Warning

This is not for the faint of heart. Do not operate if under heavy medication. Do not try this on production, if you do, you’re awesome. This guide is more geared towards non-production / lower tiered environments like Dev/QA/DR.

First things first, make sure the OS of your machine is compatible with the version of SQL Server you plan to land on – upgrade to. ie. If your OS is Windows…

Power BI Fest 2019🎊

This year we’re having the first ever Power BI Fest in South Florida and I was lucky to have been invited to speak at the event.

I will be giving 2 talks in the morning.

More info and registration around the event can be found on the event’s website https://powerbifest.com/home/presenters.

Space is very limited. Sessions start Saturday, November 16th at 9 am. It will be held at Nova South Eastern,

🏹 See Through Walls. It's #TSQLTuesday and I received a question that occurs any day of the week, so I thought to share this one. #SQLServer

It’s #TSQLTuesday and I received a question that occurs any day of the week. I hadn’t posted anything in a few days, so I thought I’d share this one. Hope it helps.

A Friend Asked

Does the native audit feature has any GUI where we can see the reports ( example:- List of the users whose access level has changed in last 3 months)

Does the native audit tool has feature to audit the users based on…

DW Table Distribution Options. ⚡ Hash vs 🧩 Round-Robin vs 🎁 Replicate. #DataWarehouse #GetData

Replicated (optional) vs Round Robin (default) vs Hash (optional)

The statement about replicated vs round robing is simply a storage distribution setting.

In the data warehouse world due to the massive parallel processing capabilities these distribution settings help us do performance tuning so queries run optimal at a lower cost.

Azure SQL Data Warehouse has many compute nodes in a cluster.

By…

Get Cognitive API 📺 #Azure #SQLServer #T-SQL #Python #aieverywhere https://youtu.be/ONlmDKUoTnY https://github.com/hfleitas/SentimentPrediction/tree/master/PASSInsights201908-Dev

In this short video, I explain how to call the Azure Cognitive Services – Text Analytics API from SQL Server by using T-SQL and Python in a Stored Procedure. In the demo, I first cover the prerequisite steps and create a view to prep data in JSON format. Then, I use the Sentiment Analysis API to score unstructured text and save the API result(s) for further ML. Sentiment analysis can help you…

Have you haven't seen it? 🧩 Benchmark studies recently published.

Perhaps you haven’t seen it. Hopefully it helps someone as it has others. It is specific to APS (Analytics Platform System) and PDW (Parallel Data Warehouse), even if you’re assessing other items.

Want to evaluate your cloud analytics provider? Here are the three questions to ask.

By Julia White, Corp VP, Microsoft Azure.

Independent benchmark results

Company-wide access to insights

Security and…

Copy/Automate from On-Prem to Azure SQL with Azure Data Factory 📺 https://youtu.be/xigq3L_YfWo #AzureDataFactory #ETL #DataWarehouse

In this short video, I demonstrates how to copy data or multiple tables from an on-prem SQL Server, through a self-hosted run-time integration to Azure SQL DB Hyperscale and/or Azure SQL Data Warehouse with Azure Data Factory. Plus, how to automate tasks like Resuming or Pausing your Azure SQL Data Warehouse before or after your pipeline ETL runs. See bonus resources below.

Watch…

SQL Server Big Data Cluster 🧭 - Tools to help manage it from VS Code and your favorite OS. #devtools #dataanalytics #bigdata

This list of tools and resources are intended to help you manage a Big Data Cluster (SQL, PDW, HDFS, Spark, k8s) on SQL Server 2019. You can already start familiarizing yourself with them to better prepare your implementation.

Install big data tools – SQL Server big data clusters | Microsoft Docs https://t.co/uAgY4d9gMT

— Hiram Fleitas (@HiramFleitas) August 24, 2019

Resources VS Code

Working…

Free Webinar (Reminder) - This Wednesday 11am EST. #MSDynamics365 #PowerApps #MSFlow #PowerBI #MyCommunity @d365uEspanol @pabloperalta

July 10th at 11 AM Eastern.

I’ll be giving a live webinar on PowerApps, Microsoft Flow and Power BI in Spanish for the global LATAM – Dynamics 365 community.

Calendar Invite: Download D365UG: Event Dynamic Communities: Link GotoWebinar: Join

All the resources (slides & scripts) are already accessible on my previous blog post.

El 10 de julio a las 11am (gmt dst -4), presento un webinar en vivo…

📡 BIG News! So humbled and excited to announce. I've been selected to speak at #PASSSummit 2019. Are we in November? Come future-proof your data career. Sponsored by @Quest @DellEMC @redgate @SentryOne (...)

I’m very excited to announce that I’ve been accepted as a speaker at PASS Summit 2019.

I’m extremely grateful for the opportunity and look forward to PASS Summit 2019.

Category Session Title Status General Session The Power Platform Game Changer Accepted General Session Real-time Sentiment Prediction in SQL Server Accepted See you in Seattle, WA on Nov 5 – 8.

All the best, Hiram (Spea…