Daily Coping 30 Sep 2022
Today’s coping tip is to find a new way to use one of your strengths or talents. I asked someone for strengths recently. Most of those items are things...
2022-09-30
14 reads
Why You Need Presentation Skills
And no, the answer is not because you want to be a Microsoft MVP. Multiple surveys have been published over the decades that list “fear of public speaking” as...
2022-09-29
29 reads
Daily Coping 29 Sep 2022
Today’s coping tip is to avoid saying “I should” and make time to do nothing, or do something fun. I’m writing this ahead of time, and I am doing...
2022-09-29
12 reads
How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a...
2022-10-14 (first published: 2022-09-29)
303 reads
Query Tuning At PASS Data Community Summit
The all new, in-person, PASS Data Community Summit is in just a few weeks. Since I’m shortly going to be publishing a 100% rewritten book on query tuning, I...
2022-10-12 (first published: 2022-09-28)
212 reads
Daily Coping 28 Sep 2022
Today’s coping tip is let go of other people’s expectations of you. I think in general I’m not too concerned about what other people think of me, or expect...
2022-09-28
14 reads
SQL Server In Place Upgrades
Good morning dear blog reader. Today’s episode is fresh from a great weekend with the family. It is always fun to go on a road trip with my wife...
2022-09-27
2,688 reads
Daily Coping 27 Sep 2022
Today’s coping tip is take your time. Make space to just breathe and be still. An easy one today. I’m relaxing in Venice with my wife, and likely no...
2022-09-27
14 reads
Running SQL Server in Windows Subsystem for Linux (WSL)
I previously wrote a post on how to convert a SQL Server Docker image to a Windows Subsystem for Linux distribution. I did this because if you tried to...
2022-10-05 (first published: 2022-09-27)
5,322 reads
Viewing errors with extended events
A little while back I came across this post: Identifying failed queries with extended events. It has a script to ... Continue reading
2022-10-10 (first published: 2022-09-27)
360 reads
Blogs
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers