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 …
Technical Articles
Deep dives into SQL Server, data engineering, Azure, AI, and enterprise data practices.
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 …
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 …
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 …
I’ll be presenting my session on “How to use PowerBi as a Free monitoring tool” this Saturday in Parma. Here you can check the session …
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 …
https://youtu.be/aP15fp99h2s
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