Creating a “Real” Copy of a View: #SQLNewBlogger
I saw a post where a developer was trying to read the Information Schema views to create a copy of a view as a “real” table, a user table....
2024-12-16 (first published: 2024-12-11)
139 reads
The Voice of the DBA
T-SQL Tuesday #181: A Technology Present
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve gotten to #181. That’s over 15 years of monthly blog parties. This month we have...
2024-12-10
34 reads
Grinding Away: Brent Ozar
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many of you have likely seen him speak, read his blog, used his sp_Blitz script, or...
2024-12-20 (first published: 2024-12-09)
450 reads
Monday Monitor Tips: Am I Patched?
One of the things that I think is neat is that Redgate Monitor helps you track patching on your systems. This is something that has been challenging in every...
2024-12-16 (first published: 2024-12-09)
222 reads
Big Queries, Big Money
I had been meaning to post this, so as I finished a piece that referenced this, I decided to post the picture. This was from Small Data SF, where...
2024-12-06
24 reads
A New Word: Fardle-dun
fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through your issues like a forest fire, which clears out your dry and hollow grievances and...
2024-12-06
24 reads
FIRST_VALUE vs. Min: #SQLNewBlogger
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter asked about the difference between Min() and First_value. This post looks at a few cases....
2024-12-13 (first published: 2024-12-04)
570 reads
A New Word: Nachlophobia
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty shallow, that although your relationships feel congenial in the moment, an audit of your life...
2024-11-29
107 reads
Adding Test data to msdb.sysjobhistory
One of our internal people was looking to test some process in (I assume) Redgate Monitor and needed more job history than they had in msdb.sysjobhistory. They wanted to...
2024-12-09 (first published: 2024-11-27)
201 reads
Episode 11 of Simple Talks: Oracle
The 11th episode is now live, recorded a few weeks ago at the PASS Data Community Summit. This was a lot of fun, us grabbing a space in the...
2024-12-06 (first published: 2024-11-22)
174 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...