ANSI SQL can perform breakthrough any-to-any hierarchical data structure reshaping. These are transformations that are performed utilizing only the structure semantics in the data assuring correct semantic results.
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
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.
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.
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.
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.
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?
SQLServerCentral crossed the 1 million member mark yesterday and we have a few things in mind for a celebration.
Steve Jones reminisces a bit and comments on reaching one million members in the community.
New author Michelle Ufford brings us an article that shows how you can replicate those partitioned tables in your environment.
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item 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?