Interview Trick Questions
Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want...
2019-02-25 (first published: 2019-02-04)
3,172 reads
SQL RNNR
Interview Trick Questions
Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an effort to...
2019-02-04
4 reads
Defaults In msdb Database
Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of...
2019-02-19 (first published: 2019-01-28)
2,453 reads
Defaults In msdb Database
The defaults in the msdb database are about what is missing. It's missing quite a few things that could be critical to your environment.
Related Posts:
SQL Server Configurations - Back...
2019-01-28
10 reads
Easy Permissions Audit
Something I have written about more than a handful of times is the need to audit. When people think about...
2019-02-05 (first published: 2019-01-21)
2,568 reads
Easy Permissions Audit
This is an introductory level method demonstrating how to quickly audit database objects and principals for granted permissions.
Related Posts:
Failed to Create the Audit File December 31, 2017
Quick Permissions...
2019-01-21
7 reads
Audit SQL Agent Jobs
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if...
2019-01-17
986 reads
Audit SQL Agent Jobs
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance - unless they fail. What if the job failed because something was changed in...
2019-01-17
211 reads
Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out...
2019-01-21 (first published: 2019-01-14)
2,889 reads
Quick Permissions Audit
DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.
Related Posts:
Easy Permissions Audit...
2019-01-14
11 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?