#PowershellBasics: Write the output to a file.
Last week I posted about a request to get a list of services. The first problem I ran into was ... Continue reading
2022-07-14
232 reads
SQLStudies
You’re doing your POC wrong! : T-SQL Tuesday #152
It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A ... Continue reading
2022-07-27 (first published: 2022-07-12)
382 reads
#PowershellBasics: Expanding the column width to avoid truncation
I was recently asked to get a list of all of the services running on one of the boxes we ... Continue reading
2022-07-20 (first published: 2022-07-07)
442 reads
SQL Homework – July 2022 – Update your resume.
Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to ... Continue reading
2022-07-06 (first published: 2022-07-05)
33 reads
What’s next? Pt 2
Well, it’s only been about a week and a half but here’s an update. First a piece of advice. You ... Continue reading
2022-06-30
97 reads
Creating a Database Audit Specification can create new users & schemas in the background
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on ... Continue reading
2022-06-28
32 reads
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and probably isn’t worth it. It’s pretty ... Continue reading
2022-07-11 (first published: 2022-06-24)
517 reads
What’s next?
As I’m sure a fair number of you already know I was told my position had been eliminated. They are ... Continue reading
2022-06-21
340 reads
Too many coding standards : T-SQL Tuesday #151
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading
2022-06-14
87 reads
SQL Homework – June 2022 – SQL Agent Jobs continued.
A few years ago I gave you homework to create a SQL Agent Job and play with it a little ... Continue reading
2022-06-02
24 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?