CLR Triggers in SQL Servers
Do CLR triggers really represent the most popular usage of CLR in enterprise SQL Servers? Phil Factor wants to know if this is the case, and if so, what on earth are they doing?
Software Giants
Microsoft is the largest software company in the world. What does this mean for SQL Server? Steve Jones thinks it's good.
When is a Backup Considered Successful?
What makes a successful backup? New author Steven Bouffard talks about some things you might want to consider when evaluating if your backup process is considered a success.
Basic Server Reporting Functionality in SQL Server 2005 Express Edition
In the recent installments of our series dedicated to the most prominent features of SQL Server 2005 Express Edition, we have started an overview of its reporting capabilities. This article focuses on elementary methods you can employ to generate custom reports.
Creating packages in code – Execute SQL Task
The Execute SQL Task is for obvious reasons very well used, so I thought if you are building packages in code the chances are you will be using it. Using the task basic features of the task are quite straightforward, add the task and set some properties, just like any other. When you start interacti.
Understanding File System IO, Lessons Learned From SQL Server
I do more than just SQL Server. I enjoy programming. In my former life I have worked with C/C++ and Assembler. I also spent quite a bit of time in Visual Basic. I loved it for prototyping and what we now call RAD development efforts.
Software Giants
Microsoft is the largest software company in the world. What does this mean for SQL Server? Steve Jones thinks it's good.
Software Giants
Microsoft is the largest software company in the world. What does this mean for SQL Server? Steve Jones thinks it's good.
Software Giants
Microsoft is the largest software company in the world. What does this mean for SQL Server? Steve Jones thinks it's good.
Execute SQL job through batch file
This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
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