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 …
Technical Articles
Deep dives into SQL Server, data engineering, Azure, AI, and enterprise data practices.
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 …
UPDATE 2: The bug was fixed in SSMS 18.8 UPDATE: The bug still isn’t fixed in SSMS 18.7.1 Oh boy, what I found; I haven’t seen anybody else …
I’ve bored you with my SQL Server Diagnostic Book for long enough, now I’ll bore even more people @ DataWeekender , where I’m doing a …
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 …
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 …
UPDATE: This is now somewhat deprecated, because you can install the Book as an extension, without having to type anything, as detailed here. Good news …
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 …
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 …
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
- 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
- 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