General
- Home /
- Categories /
- General
Quick Tip: Dumb fix for "ORA-26086: direct path does not support triggers" in Azure Data Factory or Azure Synapse Analytics Pipelines
You should already know that in my opinion, due to my extended experience, Larry Ellison has an explicit agenda to make your life as miserable as possible and locking you in while you use Oracle products.
Read MoreHow to connect Azure Data Factory / Synapse Pipelines to Google BigQuery without losing your sanity over connection tokens
When I talk about knowing the struggles with the Cloud (as I did recently at PASS 2022), I really mean it, and this is one example of it.
Read MoreHow to read data from Oracle Database via PowerShell without using ODBC or installing Oracle Client (and import it to SQL Server too)
If you read my previous article on how to configure a Linked server to Oracle , you know that I feel like someone is plotting to keep the topic of how to get our precious data outside of the Oracle ecosystem as obscure as possible out of the oracle circle Fear not!
Read MoreSlides for "How to use the Cloud for data and actually save money"
On my GitHub you can find the slides for my presentation @ Data Saturdays 001 in Pordenone
Read MoreHow to configure a Linked Server to a modern version of Oracle in SQL Server
It definitely was his plan, all along Following an Oracle migration to a new version (19c on AWS RDS), I had to update the related linked server in a SQL Instance, upgrading the Oracle Client to the latest version.
Read MoreSQL Server Diagnostic Notebook Updated
Good news everyone! As always, I’ve updated the SQL Server Diagnostic Notebook to include the latest updates to the source scripts
Read MoreHow to ship SQL Jupyter Notebooks and Books directly to Azure Data Studio by creating an extension in the Marketplace
The recently released Extension Generator for Azure Data Studio has opened up yet another way to ship Notebooks and Books to ADS allowing you to easily author your extensions.
Read MoreThe SQL Server Diagnostic Book is now on the Azure Data Studio Marketplace!
Great News Everyone! As detailed in my previous article , you can now create extensions containing SQL (note)books and publish them on the Azure Data Studio Marketplace!
Read MoreHow IT helped the world during the CoronaVirus Pandemic, and how it can continue to help
The 2020 global coronavirus pandemic has shown how Health, Food, and Logistics are essential services to allow the integrity of a nation in a time of need.
Read MoreA Self-deployable TICK Stack for ingesting data, monitoring and alerting for any service (including SQL Server)
Oh boy, this is a spinoff of my previous post on “How To Use Grafana (On Docker) To Monitor Your Sql Server (Eventually On Docker Too) – Feat.
Read MoreA PowerBI Report for the COVID19 Emergency in Italy
As you may know, I’m from Italy; at the moment we’re experiencing the most difficult medical emergency in our history due to the new coronavirus.
Read MoreHow to use Grafana (on docker) to monitor your SQL Server (eventually on docker too) - feat. InfluxDB and Telegraf
In this container-centric era to complement my SQL Server instance on docker (previous articles here ) I’ve looked over containerized monitoring solutions, and chose Grafana as my first candidate; spoiler: everything is simple once you’ve figured out how this stuff works, which can be not trivial for a Windows Guy (like me)
Read MoreThe SQL Diagnostic Notebook: Update 2
Just a quick note, the SQL Diagnostic Book has been updated, here is the changelog:
Read MoreShould you put all your eggs in one basket? Thinking about Database eggs and Cloud baskets
I had a conversation recently that started a train of thoughts related to database, cloud providers, and risk.
Read MoreHow to update a SQL Server container on Docker for Windows (spoiler - there is a catch)
With the 1st CU for SQL 2019 released just yesterday, and Microsoft updating the docker image right away, the only natural response for me was to update the docker instance that I showed you how to deploy a few months back.
Read MoreThe SQL Diagnostic (jupyter) Book
Welcome to 2020! I wanted to start this year by giving to all my fellow consultants another way to troubleshoot our beloved SQL Servers; I’ve already talked about diagnostic notebooks in the past, and now, since Azure Data Studio has implemented the feature, I wanted to group them into a Diagnostic Book.
Read MoreWhy RDP'ing into a SQL machine is a bad idea
Guys, you should stop doing this, there are reasons if it’s not recommended to log into the SQL Server Machine via RDP as opposed to using a client on your PC (or another machine).
Read MorePresenting at SQL Saturday
I’ll be presenting my session on “How to use PowerBi as a Free monitoring tool” this Saturday in Parma.
Read MoreUse SQL Server on Docker for Windows, the easy way
I wanted to install and test SQL Server 2019 on a new machine, without the hassle to create a VM from scratch, since I had none of my resources from this new place, that’s when I remembered about Docker and how Microsoft is slowing reaching feature parity for SQL on LInux , moreover, I didn’t need any of the unsupported stuff, so.
Read MoreSlides and materials for my session "How to use PowerBI as a Monitoring Tool" @ GroupBy.org
Good news everybody! As you may know if you follow me on Linkedin , I’ve been selected as one of the GroupBy Speakers for the last GroupBy session for 2019!
Read MorePROTIP: Performance Tuning on the cloud will save you money by the hour
Note: I'll be focusing on Azure Cloud and SQL Server, but these considerations are valid for any Cloud/DB Vendor.
Read MoreHow to implement a Linear Regression Prediction in a PowerBI report using Python
Machine learning is the buzzword of the moment, so I wanted to talk about that sweet ML here too.
Read MoreSQL Notebooks: On the right track to enhance Data Analysis on SQL Server
Since about a couple of versions ago, Azure Data Studio introduced Jupyter Notebooks support for SQL Server (and with SQL Server 2019 “Big Data Clusters” on the horizon, it was about time)
Read MoreCast any string directly to XML with auto-escaping characters in SQL Server
Recently I had to look up the definition for a bunch of SQL objects and didn’t want to manually retrieve them manually in SSMS (with Create Scripts) or Visual Studio (by searching the object name in my TFS repository).
Read MoreA quick function to remove (or keep only) string patterns from SQL Server Strings
Working with strings in SQL Server isn’t as easy or powerful as using any programming language, but, I’m sure that more than once you had to to some data manipulation directly in the database, this may help you out, and it doesn’t use Loops, CLR or XML
Read MoreTracking Dynamic SQL performance automatically with a wrapper on sp_executesql (Dynamic SQL Inception)
in some projects I have a lot of Dynamic SQL going on, some queries are fast, some queries are slow, it depends on how the dynamic statement is actually put together ¯\_(ツ)_/¯ Tracking the performance of such statements is usually difficult because you don’t really know “why it’s slow” and you have to interpolate data from the app and the plan cache (if the plan is still there and wasn’t purged due to memory pressure) and try to figure out which was the piece of the offending dynamic SQL and why it did that.
Read MoreTest: confronting various methods of bulk loading data from a table to another, what's the fastest?
Most of the support request I get involved with can be summarized with the following keywords: “slow” + “datawarehouse” + “ETL” + “Save us” What about thinking about ETL performance before it goes bad?
Read More