Daily Coping 29 Jun 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-29
21 reads
Blog Posts
HAL0004 – I don’t feel well Dave
It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for ... Continue reading
2020-06-29
50 reads
Power BI DAX Dynamic Measures
Dynamic measures are an effective way to avoid crowding your report with different versions of the same visual without using bookmarks. No disrespect to the versatility of bookmarks, but...
2020-06-29 (first published: 2020-06-16)
2,896 reads
What is Batch Mode on Rowstore in SQL Server?
Under compatibility level 150, in both SQL Server 2019 and Azure SQL Database, you now can use batch mode for CPU-bound analytic type workloads without requiring columnstore indexes. There...
2020-06-29 (first published: 2020-06-16)
898 reads
Last Week Reading (2020-06-28)
Press ExpandString in Powershell This function can do much more than you think. Pester – using -should -throw Useful example when you want to filter output by ExceptionType or ErrorId....
2020-06-28
13 reads
Living in the new normal as a data engineer
For the past few months most of the world has been in quarantine and you may think that this is the new normal, especially now that “re-opening” has been...
2020-06-28
134 reads
How to “Rename” the Master Branch to Main in Git in Azure DevOps
I believe that language matters, and that it is worth our effort to move away from language associated with slavery and racism whenever possible. Azure DevOps doesn’t technically allow...
2020-06-26
431 reads
My Thoughts on PASS Virtual Summit – An Editorial
On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server...
2020-06-26 (first published: 2020-06-11)
333 reads
Non-SQL Tips and tricks – #tsql2sday 127 Rollup
I was thrilled to host TSQL Tuesday this month (#127) and I my prompt was non-SQL tips and tricks. Now ... Continue reading
2020-06-26 (first published: 2020-06-16)
497 reads
Publish ADF from code to service easily
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good news for you. There is a new tool in the market. It’s a task for...
2020-06-26
55 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA Finance WTC Mangga Dua Tlp/WA.(+62 821°3111°179
<!--more-->Tlp/WA.(+62 821°3111°179 Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001,...
BCA KCU DAAN MOGOT Telp/WA.0851°8812°0691
BCA KCU DAAN MOGOT Telp/WA.0851°8812°0691 Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan,...
BCA KCU PONDOK INDAH Tlpn/wa0853.7373-7551
Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec. Kebayoran...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers