It’s time. After years of building this site to work with SQL Server, I sold it to Red Gate Software. Part of that transaction meant that I had to work for Red Gate for a period of time afterwards. I think I’ve done a good job in that time, but I don’t own this site anymore, and can’t compete with it contractually.
Is the next data center for your SQL Servers going to be portable? Steve Jones comments on some of the changes being put forth by Microsoft and others.
Is the next data center for your SQL Servers going to be portable? Steve Jones comments on some of the changes being put forth by Microsoft and others.
Is the next data center for your SQL Servers going to be portable? Steve Jones comments on some of the changes being put forth by Microsoft and others.
Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design in terms of its derivability, redundancy, and consistency. . Increasingly, this little-understood aspect of relational theory, that emphasises the cardinality of the attributes of tuples in a relation and the reciprocity with isomorphic foreign key restraints, is becoming a hot forum topic.
The process to use a vb script task to check for a file existence over a time range.
This month Steve Jones looks at the problems in the auto industry along with a link to the cars most likely to be caught speeding.
This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.
Many SQL Server developers and DBAs have, in the past, had their own favourite diagnostic Stored Procedures for investigating blocking issues. But since SQL Server 2005, it's a good idea to use the SQL Profiler for all but the most complex problems. Brad McGehee takes us through the steps...
This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
Comments posted to this topic are about the item SQL Art: I Made a...
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers