Thank You Andy!
I remember going into Andy Leonard’s session at PASS Summit in Denver. I’m not going to lie, it was kind of sparsely attended, so I got to sit up...
2022-08-02
7 reads
The Scary DBA
Learning PostgreSQL: The Tools
In case you don’t know, I’ve been writing a series of articles over on Simple-Talk as I learn PostgreSQL. It’s all from the point of view of a SQL...
2022-08-01
13 reads
Thank You Tim!
Ah, Tim Ford. I remember the time we were sitting at Ruth Kriss Steakhouse trying to figure out which of the two of us was the dumbest person in...
2022-08-01 (first published: 2022-07-26)
8 reads
Database Fundamentals #32: Create Unique Constraints with T-SQL
In the last Database Fundamentals post, I explained what a unique constraint was and how you can create them using the GUI. Using TSQL to create a constraint is...
2022-07-25
30 reads
Thank You Wendy!
I honestly don’t know when or how I met Wendy Pastrick, but I’m so happy I did. Wendy and I have been friends for a very long time. Thank...
2022-07-19
11 reads
Sabbatical!
Redgate Software has a policy wherein every 5 years, employees receive a 6-week paid sabbatical. Well, I’m up to year 11 (I skipped a year my first time), so...
2022-07-18
3 reads
Thank You Allen!
I know I can say that I’m a friend of Allen White without getting into trouble. Allen and I have a shared a lot of things over the years...
2022-07-12
94 reads
Extended Events for Anything But Query Tuning: xml_deadlock_report_filtered
One of my favorite little bits of information about Extended Events is the fact that everyone running a full instance of SQL Server has deadlock information available to them,...
2022-07-11
8 reads
Goodbye to Good Morning!
For two years and three months, since April 2020, I’ve posted a tweet saying “Good Morning!” on every workday. I think I missed one. I was late for a...
2022-07-07
23 reads
Thank You Kevin!
I don’t think I’m going too far out on a limb to call Kevin Kline a friend. I’m extremely humbled and honored that I can say that. Kevin is...
2022-07-06
13 reads
Blogs
Daily Coping 9 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Visiting with DBAs at midnight : T-SQL Tuesday #153
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our...
Working with Neo4j Imports–I HATE CASE SENSITIVITY
By Steve Jones
I’ve been working to better understand graph databases and where they can be useful....
Forums
MAX not working with a CTE
I have a query that is supposed to return one patient id but even...
doe it locks my view while checking it ? EXEC sp_refreshview '[View_SCHEMA]'
i have a cursor that runs on all my views and then exec...
Transaction log full error 9002 on Alwayon Availability groups
Hi All, I am looking for some inputs on how to avoid or prevent...
Ask SSC