The ORDER BY clause is one of the basic keywords that defines the SQL Language. And it can help prevent strange results from being returned to the average user. Read on to see how and why this addition to your queries can help ensure more "ordered" results 🙂
Apex SQL Tools has released Apex SQL Script 3.0, database Tools for database scripting. Apex SQL Script scripts both database structures (tables, views etc) as well as database data, which it converts to insert
scripts. The new release has a completely redesigned user interface, faster database scripting engine and many more database scripting options.
Do you have to refresh a test or QA server from the production system? Do you have a good process or is it a spur of the moment, let's get it done thing? Here's a look at Steve Jones' process, which was used weekly for well over a year.
What happens when you have a day job, a web site, a new job at work, and a baby? Chaos! See what Andy's been up to the past few months. It's off topic from SQL of course, but it contains an interested bit or two.
Do you run an anti-virus product on your SQL Servers? After all, it's recommended, more and more, that you run anti-virus on ALL machines you have. There's just too much stuff running around out there. But putting this on a SQL Server creates some interesting issues. Our resident security guru, Brian Kelley, looks at some of the things you need to consider when deploying anti-virus products on your servers.
How can you tell if your code if performing well? Do you know what you want to look for when starting to analyze code? Here's an article from Leo Peysakhovich that looks at some of the things that you can use at a high level to improve the performance of your code.
Here's a little replacement for Query Analyzer that appears to provide most of the functions, plus a few more. While we haven't given it a full review, at first glance it appears to do the job. Plus there's NO INSTALL!!!! Always a plus for me.
How many of you register a server in Enterprise Manager? Now how many of you click the "save password" box? Probably most of you. Are you aware of the security risks associated with this? James Travis looks at one of potential problems here and other security issues relating to SQL-DMO.
Another look at how the next version of SQL Server will integrate and work with .NET technologies.
Although Brian likes that Microsoft delayed the next release of SQL Server for quality, he disagrees with the release strategy. See his opinion and argue your own!
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