There is a stored procedure that must be run by only one user at a time. In this tip, learn how to prevent multiple users from running the stored procedure at the same time.
The MCM certification program has been abandoned by Microsoft. Steve Jones thinks the material can still be useful for the community.
The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.
How can you perform due diligence on new employees? There are a variety of ways, but Steve Jones has an idea that might help you nudge a potential employer in the direction you want them to move.
Steve Jones is putting out an open call for guest editorial pieces in the spring of 2014. If you're interested, read on.
Part two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.
Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.
This article describes a way to automatically restore multiple database backups from a directory.
Consolidating SQL Server instances is something Steve Jones has done in the past and he thinks we'll all do more of in the future.
Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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?