Azure Data Studio is starting to mature and some neat features are coming to the vscode-based (and now multidatabase and multiplatform) tool. We got query plans …
Technical Articles
Deep dives into SQL Server, data engineering, Azure, AI, and enterprise data practices.
I don’t know you, but people from other BU are old fashioned guys that do everything by hand, and then send you an Excel file to “put this data in …
What it is and how to get it When working with SQL Instances that have lots of databases, sensitive data and equally lots of users/applications that accesses …
It must have happened you at least once to find identity columns with values that from one row to the next one jump by 1000’s rows, of course without …
A conversation had me wondering about performance implications in SQL Server RLS feature, specifically on how to mitigate the performance impact; TL; DR; ? …
Working with strings in SQL Server isn’t as easy or powerful as using any programming language, but, I’m sure that more than once you had to to some …
As my “community service” this month, I’ve worked on this neat (I hope!) PowerBI report (and companion stored procedure) to easily analyze all …
It will be part of the FirstResponderKit tool, free for all
I was wondering if PowerBI could be used for reporting on Live data, not coming from my Database using DirectQuery (or the new super neat composite mode) with …
SQL Server: How to Find a safe restore point (and who messed up) by reading from the Transaction Log
Panic: Someone has messed up and deleted a super important piece of information in a table! Who did it? Nobody knows. When did it happen? “The data was …
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