The Oscars
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
The Unpopular SELECT Statement
SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.
Business Intelligence and a Culture of Analysis
Public sector agencies very often need to work at ensuring that their corporate cultures establish a high value on, and properly reward, a push toward analysis.
Do You Want to Help Provide Feedback on a New Book I Am Writing?
Normally when I write a book, I create a book outline, give it to my editor for feedback, make some changes, then begin writing the book.
It's Your Ship
I saw this book ( It's Your Ship ) in a Barnes and Noble and the title and cover attracted me. So I picked it up and read the back, thought it was interesting, and later grabbed it for the Kindle.
SQL Server security settings using the Surface Area Configuration tool (SAC)
Are any tools available to secure SQL Server independent of the logins and users that I have in place? Do I need to manage SQL Server on each machine or can I do so from a single application?
Celebrating A Million
SQLServerCentral crossed the 1 million member mark yesterday and we have a few things in mind for a celebration.
Celebration
Steve Jones reminisces a bit and comments on reaching one million members in the community.
Configuring Replication for Partitioned Tables Using T-SQL
New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.
Using the Timestamp Data Type - SQL School Video
The timestamp data type is a unique data type in SQL Server. Brian Knight shows how it can be used in your tables.
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
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
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
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?