Legal Security
As database professionals, we know that we are responsible for the security and integrity of the data in our systems. But Steve Jones wonders if you know what legal responsibilities you might have.
Legal Security
As database professionals, we know that we are responsible for the security and integrity of the data in our systems. But Steve Jones wonders if you know what legal responsibilities you might have.
Legal Security
As database professionals, we know that we are responsible for the security and integrity of the data in our systems. But Steve Jones wonders if you know what legal responsibilities you might have.
SQL Server 2008 Capture DML Changes Using Change Data Capture
In this article Ashish continues to explore the Change Data Capture feature in SQL Server 2008. This article demonstrates how to track DML changes
What is SQL Server
This refresher on SQL Server examines when to use a database as well when not to, along with some of the key terms used with SQL Server.
An IT Union - Database Weekly (Sept 8, 2008)
As Information Technology workers become more wired, with more demands, and less benefits, should they consider unionizing.
No Non-competes
More and more technology workers are being asked to sign non-compete agreements as a condition of their employment. But is that fair? Steve Jones has a few thoughts.
Use Operations Manager to Monitor Your SQL Agent Jobs
Monitoring your SQL Server Agent jobs is important to ensuring that all of the automation you have created on your server is working correctly. Thomas LaRock brings us another article on Operations Manager and its integration with SQL Server.
Database Mirroring Automating Failover for Multiple Databases
Database Mirroring was released with SQL Server 2005 and is becoming a popular choice for a failover solution. One of the big issues with Database Mirroring is that the failover is tied to one database, so if there is a database failure the mirrored server takes over for this one database, but all other databases remain functional on the primary server.
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?