SQL Server Audit in SQL Server 2008 – Part 2
Learn how to monitor database-level actions and write audit results to files.
2008-07-22
2,557 reads
Articles
Owning the Spelling Suggestion Feature
To create your own spelling suggestion feature, you need a look-up with correct spellings and misspellings. I walk you through it.
2008-07-21
4,922 reads
How to Track Down Deadlocks Using SQL Server 2005 Profiler
It is irritating, sometimes alarming, for the user to be confronted by the 'deadlock message' when a deadlock happens. It can be a tiresome business to prevent them from occurring in applications. Fortunately, the profiler can be used to help DBAs identify how deadlocking problems happen, and indicate the best way of minimising the likelihood of their reappearance.
2008-07-21
5,295 reads
The IT Employee Benchmark
What's important in an IT employee? Steve Jones talks about the skills and measurements CIOs want today and tomorrow.
2008-07-21
60 reads
The IT Employee Benchmark
What's important in an IT employee? Steve Jones talks about the skills and measurements CIOs want today and tomorrow.
2008-07-21
54 reads
The IT Employee Benchmark
What's important in an IT employee? Steve Jones talks about the skills and measurements CIOs want today and tomorrow.
2008-07-21
65 reads
T-SQL Function to Determine Holidays in SQL Server
While working on a project recently I was asked to develop a mechanism that would provide the dates for state and federal holidays in a given year. Since this project deals with all states and territories of the United States, the list had to be comprehensive and the client asked that this list be in the form of a SQL query calculated on-the-fly, rather than a static list.
2008-07-21
5,482 reads
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
2008-07-20
58 reads
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
2008-07-19
48 reads
Going Naked
Steve Jones talks about the value of software maintenance and how you should view their value.
2008-07-19
52 reads
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