T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements
Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.
How to Get SQL Server Security Horribly Wrong
It is no good doing some or most of the aspects of SQL Server security right. You have to get them all right, because any effective penetration of your security is likely to spell disaster. If you fail in any of the ways that Robert Sheldon lists and describes, then you can't assume that your data is secure, and things are likely to go horribly wrong.
Opening Up Data
Tim O'Reilly, head of O'Reilly publishing, has been an advocate of better date movement in the world. Steve Jones has a few comments on an interview he gave earlier this year.
The Case for Scalar-valued, User-defined Functions in T-SQL
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...
How do you work with databases?
How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.
How To Calculate Behavioral Streaks in SQL Server Data
In this tip, Tim Smith demonstrates how to measure a behavioral streak with SQL Server, an important skill for determining ROI and extrapolating trends.
Not Only a Meeting of Minds, but of Open Minds.
In which Phil Factor claims that professional application development requires a broad knowledge base.
The Service Pack Fiasco
The recent SQL Server 2014 Service Pack fiasco wasn't the first, but hopefully it won't be the last.
Database Source Control Workshop: Philadelphia, PA
Redgate and Ike Ellis are hosting a database source control workshop in Philadelphia PA, on June 4, 2015. Learn all you need to put your development databases in source control, using the version control system of your choice. Register while space is available.
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?