Finding Object Dependencies in SQL Doc
I had a customer recently ask if they could find out which objects are dependent on others using SQL Doc. This post shows how to do that. Using SQL...
2023-11-01
331 reads
Adding a Foreign Key in the CREATE TABLE statement–#SQLNewBlogger
I had someone ask this question recently and had to double check the syntax myself, so I thought this would make a nice SQL New Blogger post. Another post...
2023-11-15 (first published: 2023-10-30)
354 reads
Common Mistakes in SQL Server – Final
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion...
2023-10-30
12 reads
Common Mistakes in SQL Server – Final
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion...
2023-11-15 (first published: 2023-10-30)
566 reads
Tips, ideas, and recommendations on your technical blog
This technical blog is hardly the ideal, but I'll use this space here to summarize some of the guidance that my colleague Randolph West and I presented at a...
2023-11-13 (first published: 2023-10-27)
387 reads
Suppressing the FOMO
I saw a post recently on Twitter/X/whatever we call it. It was for a DevOps in a Day from Redgate taking place in Jacksonville. I’ve been a part of...
2023-10-27
30 reads
A New Word: Funkenzwangsborstellung
funkenzwangsborstellung – n. the primal trance of watching a campfire in the dark. I am not a big camper, but 3-4 times a year we usually go out with...
2023-10-27
31 reads
About those Read-Only Replicas
In a post, I wrote last month I showed how you can take advantage of your replicas in SQL Sever by adding a single attribute to your connection string...
2023-11-13 (first published: 2023-10-26)
455 reads
What is Azure SQL
I get asked about Azure SQL very often. This is a topic that I’ve written about and taught many times. To be honest, this is a rather large topic...
2023-11-17 (first published: 2023-10-25)
442 reads
Database Concerns – A Poll!
What are you most concerned about in your database platforms? Please pick from the list below, and expand on your choice in the comments if you like: Thanks...
2023-11-08 (first published: 2023-10-25)
232 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries
The Service Name
Comments posted to this topic are about the item The Service Name