DevOps From Redgate
In a few weeks at the PASS Data Community Summit, I’ll be joining several other Redgaters to put on an all-day precon where we take you on a database...
2022-10-14 (first published: 2022-10-04)
116 reads
Blog Posts
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)
295 reads
Daily Coping 13 Oct 2022
Today’s coping tip is to remind yourself that things can change for the better. It can be easy to get upset/sad/depressed/angry/etc. about the way something is in the world....
2022-10-13
8 reads
Daily Coping 12 Oct 2022
Today’s coping tip is to start your day with the most important thing on your to-do list. I’m writing this on 11 Oct. The most important thing today is...
2022-10-12
19 reads
Goal Progress for Sep 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Well, clearly I’ve gotten away from my goals. No updates...
2022-10-12
16 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)
210 reads
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
28 reads
Storytelling with Data – Enertia User Conference 2022
Thank you to everyone who attended my session at the Enertia User Conference in Las Vegas earlier this month! It was a blast meeting everyone, and I can’t wait...
2022-10-12 (first published: 2022-09-30)
178 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
11 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
8 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers