Do you know the feeling when someone gives you a flat file to import, without any schema information? You have to dump it in your database as-is, then spend …
Technical Articles
Deep dives into SQL Server, data engineering, Azure, AI, and enterprise data practices.
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 …
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. This is the case of …
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 …
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; …
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 …
I love extended events, and if you’re still using SQL profiler, go feel ashamed and come back only when you’ve stopped using it. Now that …
On my GitHub you can find the slides for my presentation @ Data Saturdays 001 in Pordenone
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 …
Good news everyone! As always, I’ve updated the SQL Server Diagnostic Notebook to include the latest updates to the source scripts No new addition this …
Categories
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
- 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
- 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
- Telegraf
- Test
- Tnsnames
- Troubleshooting
- Tsql
- Unresponsive
- Video
- Wait stats
- While
- Xel
- Xlsx
- Xml