|
You are here |
lwpro2.wordpress.com | ||
| | | | |
blobeater.blog
|
|
| | | | | I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself as I found a way to get a time based on a geographic region. This new feature is available to you from SQL 2016 which obviously means SQL database too (Azure). It is called AT... | |
| | | | |
power2build.wordpress.com
|
|
| | | | | Another tool to help with SQL Tuning? Yes! Hopefully with some advantage over what you used until today :-) Collecting diagnostics around a SQL is not fun, if you've been there you know that.... Source: SQLd360, SQL diagnostics collection made faster | |
| | | | |
alwayssql.wordpress.com
|
|
| | | | | Many times it happens that your backup (or restore) activity has been started by another Database Administrator or by a job, and you cannot use the GUI anything else to check the progress of that Backup / Restore. By combining multiple commands, I have generated below script which can give us a summary of current... | |
| | | | |
azureplayer.net
|
|
| | | Efficient Upserts into Data Lakes with Databricks Delta When MERGE on data lake is inefficient. Building a Data Mesh Architecture in Azure - part 1 With this... | ||