Ahh, functions, the greatest tool at a programmer’s disposal, they make code reusable and easy to read, they’ve been essential since the first …
Technical Articles
Deep dives into SQL Server, data engineering, Azure, AI, and enterprise data practices.
Super quick tip, I’ve seen this done via CMD or DaxStudio, but not via PowerShell (probably because I haven’t searched so much since I’ve done …
Great News Everyone! Microsoft just dropped SSMS 18.5 after almost 5 long months without any updates; this new release fixes a lot of bugs and introduces a few …
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. …
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. Influxdb …
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. As …
In this container-centric era to complement my SQL Server instance on docker (previous articles here) I’ve looked over containerized monitoring solutions, …
Just a quick note, the SQL Diagnostic Book has been updated, here is the changelog: Updated FirstResponder’s Kit and Glen Berry’s Scripts Added SQL …
I had a conversation recently that started a train of thoughts related to database, cloud providers, and risk. Should we treat DBs like investments and …
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 …
Categories
Tags
- 18 7
- Access
- Admin
- Ads
- Agent jobs
- Ai agents
- 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
- Benchmarking
- Bigquery
- Bm25
- Book
- Bug
- Cache
- Cast
- Claude code
- 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
- Hybrid search
- Identity
- Import
- Index
- Influxdb
- Inserts
- Installation
- Instance
- Jupyter
- Jupyter book
- Kapacitor
- Linked server
- Linux
- Load
- Load extended events
- Loop
- Loops
- Maintenance
- Management studio
- Marketplace
- Monitoring
- Notebook
- Notebooks
- Notification
- Odbc
- Odp
- Offtopic
- Open source
- Optimization
- Oracle
- Paas
- Parallelism
- Perfmon
- Performance
- Pipeline
- Powerbi
- Powerbi admin
- Powershell
- Presentation
- Presenting
- Pricing
- Publish
- Python
- Quantization
- Query
- Query plans
- Queryplan
- Rag
- Raggio performance
- 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
- Sqlite
- Sqlmi
- Sqlserver
- Ssms
- Ssns
- String
- Strings
- Synapse
- Synapse analytics
- Telegraf
- Test
- Tnsnames
- Troubleshooting
- Tsql
- Unresponsive
- Vector database
- Video
- Wait stats
- While
- Xel
- Xlsx
- Xml