Blog Posts
- Home /
- Blog Posts
A SQL script to automatically infer the data types of data that someone just dumped in your DB with no effort
Do you know the feeling when someone gives you a flat file to import, without any schema information?
Read MoreQuick 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 fix "Connect Timeout" and/or "Cannot open server xxx requested by the login" when connecting to Azure SQL Managed Instance in redirect mode
Here is something that will save you lots of time and headaches when trying to connect to Azure SQL Managed Instances, especially from onprem servers or from other clouds; I had to repeat this multiple times to multiple actors, so I know it will happen to someone else too.
Read More
How to build an Application with modern Technology
Nemo vel ad consectetur namut rutrum ex, venenatis sollicitudin urna. Aliquam erat volutpat.
Read MoreHow to build an Application with modern Technology
Nemo vel ad consectetur namut rutrum ex, venenatis sollicitudin urna. Aliquam erat volutpat.
Read MoreHow to build an Application with modern Technology
Nemo vel ad consectetur namut rutrum ex, venenatis sollicitudin urna. Aliquam erat volutpat.
Read MoreHow to build an Application with modern Technology
Nemo vel ad consectetur namut rutrum ex, venenatis sollicitudin urna. Aliquam erat volutpat.
Read MoreHow to fix direct Query authentication delegation issues with Power Bi Report Server with Edge and Chrome
With the end of the IE support for Power Bi (and in general tbh), companies are scrambling finally to move their users from the legacy browser to modern ones; it was about time if you ask me.
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 MoreCategories
Tags
- 18-7
- Access
- Admin
- Ads
- Agent-Jobs
- Alignment
- Analysis
- Analyze-Xel
- Api
- Automatic-Data-Types
- Automatic-Typing
- Azds
- Azure
- Azure-Data-Factory
- Azure-Data-Studio
- Azure-Data-Studio-Extension
- Azure-Sql
- Azuredatastudio
- Benchmark
- Bigquery
- Book
- Bug
- Cache
- Cast
- Client
- Cloud
- Clustered
- Columnstore
- Conference
- Connect
- Connection
- Convert
- Core
- Coronavirus
- Cost
- Counters
- Create
- Csv
- Data-Analysis
- Data-Manipulation
- Data-Science
- Data-Types
- Databases
- Diagnostic
- Diagnostic-Book
- Diagnostic-Queries
- Discussion
- Docker
- Docker-Compose
- Dop
- Dynamic-Sql
- Error-Creating-Session
- Etl
- Excel
- Expensive
- Extended-Events
- Extended-Events-File
- Extensions
- Failure
- Filestats
- Firstresponderskit
- Flow
- Function-Parallel
- Function-Performance
- Function-Serial
- Function-Single-Thread
- General
- Generate-Scripts
- Grafana
- Groupby
- Heap
- Identity
- Import
- Index
- Influxdb
- Inserts
- Installation
- Instance
- Jupyter
- Jupyter-Book
- Kapacitor
- Linked-Server
- Load
- Load-Extended-Events
- Loop
- Loops
- Maintenance
- Management-Studio
- Marketplace
- Monitoring
- Nextjs
- Notebook
- Notebooks
- Notification
- Odbc
- Odp
- Offtopic
- Optimization
- Oracle
- Paas
- Parallelism
- Perfmon
- Performance
- Pipeline
- Powerbi
- Powerbi-Admin
- Powershell
- Presentation
- Presenting
- Pricing
- Publish
- Query
- Query-Plans
- Queryplan
- Rdp
- Read
- Read-Extended-Events
- Refresh
- Remote
- Report
- Risk
- Row-Level-Security
- Saving
- Scalar-Function
- Security
- Session
- Silicon
- Software
- Sql
- Sql-Diagnostic-Book
- Sql-Managed-Instance
- Sql-Server
- Sql-Server-Functions
- Sql-Server-Linux
- Sql-Server-Management-Studio
- Sql-Troubleshooting-Script
- Sqlmi
- Sqlserver
- Ssms
- Ssns
- String
- Strings
- Synapse
- Synapse-Analytics
- Tailwind
- Technology
- Telegraf
- Test
- Tnsnames
- Troubleshooting
- Tsql
- Unresponsive
- Video
- Wait-Stats
- While
- Xel
- Xlsx
- Xml