Social Anxiety and Events Like the PASS Summit
If you are an introvert like me, events like the PASS Summit can call forth your social anxiety. I know this past week, I definitely felt it, even though...
2024-11-11
62 reads
Blog Posts
A New Word: Skidding
skidding – v. intr. the practice of making offhand comments that sound sarcastic but are actually sincere and deeply felt. I used to make lots of sarcastic comments. Some...
2024-11-08
21 reads
PASS Summit – Thursday
Let’s start with the keynote. The biggest take away was how having to support multiple data platforms is growing and becoming the norm. This has been my experience and...
2024-11-08
23 reads
Tell me the positives of your solution
I still have a tendency to talk about all the cons of a proposed solution I don’t believe is the optimal one. There’s an old saying that “no one...
2024-11-08 (first published: 2024-10-29)
167 reads
Using SQL Compare in Read-Only Databases
Recently a customer asked if SQL Compare and SQL Data Compare can be used with a read-only database as a source. It’s a good questions as I’ve seen some...
2024-11-08 (first published: 2024-10-21)
174 reads
PASS Summit 2024 – Wednesday
A common theme in the PASS Summits I've attended is community and that's definitely true this year. It's one of the reasons I have loved coming when I can....
2024-11-07
36 reads
Taming Database Challenges: Insights from Redgate Keynote
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying Complexity – Making the Database Work in the Real World. As the database landscape grows...
2024-11-07
28 reads
Introduction to Advanced Analytics
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
2024-11-06 (first published: 2024-10-27)
416 reads
PASS Summit 2024 – A Very Different World
The last data centric conference I attended was the PASS Summit in 2019. A few months later, much of the world went on lockdown due to COVID. Since then,...
2024-11-06
26 reads
Using Copilot to help me update SQL Saturday
An interesting AI experiment here with Copilot from GitHub in handling some code I don’t work with that often. Read on and watch. This is part of a series...
2024-11-06 (first published: 2024-10-16)
357 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers