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
Session Materials for dataMinds Connect 2022
You can find the slides and the demo scripts (.sql files) in my Github repo. You can use the materials as you like, attribution would be nice 🙂
The post...
2022-10-10
35 reads
Tales From The Field Weekly Wrap Up
Hello Dear Reader!
It's been a while. I've been busy working with a few colleagues on our show Tales from the Field. This has been a learning experience.
I've had to...
2022-10-17 (first published: 2022-10-07)
164 reads
Blogs
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...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
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