Converting a Datetime to UTC
I was in a need of converting some datetime values (of which I know the actual timezone) to UTC dates. A quick Google search showed me that most results...
2020-09-28 (first published: 2020-09-22)
1,175 reads
Blog Posts
Daily Coping 28 Sep 2020
I 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-09-28
41 reads
Azure SQL Offers Manual Failover for PaaS Resources
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a...
2020-09-25 (first published: 2020-09-22)
239 reads
Daily Coping 25 Sep 2020
I 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-09-25
46 reads
Git Tricks–Getting a New Remote Branch–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is probably more for me than anyone,...
2020-09-25 (first published: 2020-09-16)
190 reads
Daily Coping 24 Sep 2020
I 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-09-24
16 reads
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing poorly for some parameter sets, and quite fast for other parameter values. In short, this...
2020-09-24 (first published: 2020-09-17)
568 reads
Stop Letting Accessibility Be Optional In Your Power BI Reports
We don’t talk about inclusive design nearly enough in the Power BI community. I was trying to recall the last time I saw a demo report (from Microsoft or...
2020-09-24 (first published: 2020-09-17)
319 reads
[Coping] Dum Spiro Spero
Dum Spiro Spero – “While I breathe, I hope.” Because it’s the motto for South Carolina, it’s on the state seal. As a result, it is part of The...
2020-09-23
54 reads
A new malware attack on SQL Server
Tencent Security has released a report (written in Chinese) describing a new malware attack by the name of “MrbMiner” on SQL Server instances exposed to the Internet with passwords that can...
2020-09-23
395 reads
Blogs
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Forums
Alamat BCA KCP Cempaka Putih Telp:08218520153
WhatsApp CS 628218520153 Jl. Letjen Suprapto No.30 EF, RT.7/RW.2, Harapan Mulya, Kec. Kemayoran, Kota...
Alamat BCA KCP Menteng Telp:08218520153
WhatsApp CS 628218520153 Jl. HOS. Cokroaminoto No.83, RT.3/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
Alamat BCA KCP Wahid Hasyim Telp:08218520153
WhatsApp CS 628218520153 Jl. K.H. Wahid Hasyim No.82, RT.15/RW.3, Kb. Sirih, Kec. Menteng, Kota...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers