Snowflake Key Pair Authentication
Snowflake does a great job on documenting the key pair process using bash for Linux environments. That’s great, but what if you need to work within a windows environment...
2022-10-12
33 reads
How to use Azure Site Recovery (ASR) to replicate a Windows Server Failover Cluster (WSFC) that uses SIOS DataKeeper for cluster storage
Intro So you have built a SQL Server Failover Cluster Instance (FCI), or maybe an SAP ASCS/ERS cluster in Azure. Each node of the cluster resides in a different...
2022-10-24 (first published: 2022-10-12)
297 reads
Query Store at PASS Data Community Summit
While Query Store has been out for quite some time now, released in 2016, there’s still quite a lot of missing understanding of what Query Store can do for...
2022-10-11
12 reads
T-SQL Tuesday #155–Using Dynamic SQL for SQLCMD
It’s that time of month, and I’m the host this month. I wrote the invitation last week and now its’ time to answer. I’m actually using an example from...
2022-10-21 (first published: 2022-10-11)
425 reads
Daily Coping 11 Oct 2022
Today’s coping tip is to take a small step towards a goal that matters to you. I’ve been working on a coaching certification. I don’t really need it, but...
2022-10-11
13 reads
Comments in your generated code : T-SQL Tuesday #155
The ever amazing Steve Jones (blog|twitter) is our host this month. And in case you didn’t know he also is ... Continue reading
2022-10-24 (first published: 2022-10-11)
327 reads
Overcoming a storage failover issue with SQL Server on Kubernetes using Portworx
In a previous post I talked about an issue with storage failover when a Kubernetes node goes offline. In a nutshell, the issue is that the attachdetach-controller in Kubernetes...
2022-10-19 (first published: 2022-10-11)
168 reads
Snowflake Warehouses
Everyone has heard of scaling up and scaling out compute. Have you ever heard about a term called scaling across? Before Snowflake, I never. Scaling up and down is...
2022-10-11
20 reads
Check Every Metric
Recently, a person asked about the costs differences in an execution plan, referencing them as if they were performance measures. The key to understanding performance is to check every...
2022-10-10
22 reads
Daily Coping 10 Oct 2022
Today’s coping tip is to write down three things you can look forward to in the next month. Easy. Visiting my daughter. I’m heading up this weekend to watch...
2022-10-10
14 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