Managing SQL Server Database and Application Metadata
Unless you are the Database Administrator or the Application Analyst for a particular database you are usually oblivious to the naming conventions of the databases that support the applications you rely upon daily. This is why it is important to have the metadata repository in place to provide that translation when the need arises.
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.
Union
One of the less used commands in T-SQL, the UNION command can come in very handy in a number of situations. SQL Server expert trainer, Andy Warren, discusses how you can use UNION.
Benefits and limitations of using synonyms in SQL Server 2005
A SYNONYM is new to SQL Server 2005. It is a way to give an alias to an already existing or potential new object. It is just a pointer or reference, so it is not considered to be an object.
Legal Liability
Are database professionals liable for the security of their data? Should they be? Some think so, but Steve Jones thinks this is a bad idea and we might need protection as data professionals.
Legal Liability
Are database professionals liable for the security of their data? Should they be? Some think so, but Steve Jones thinks this is a bad idea and we might need protection as data professionals.
Legal Liability
Are database professionals liable for the security of their data? Should they be? Some think so, but Steve Jones thinks this is a bad idea and we might need protection as data professionals.
Terminate User processes in SQL Server
This article illustrates how to create a simple procedure to kill many sessions at the same time, kill a range of sessions and kill all of the sessions connecting to a database.
Creating a Matrix Report - SQL School Video
In this video, you will learn how to use Reporting Services to build a report that contains a matrix of data.
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers