Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
2008-07-22
67 reads
Articles
Knock, Knock...What's Funny?
Humor in the workplace is essential for a good environment, but employees need to be careful about what they might consider sharing.
2008-07-22
65 reads
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
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,925 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
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Everything is the right question away
Comments posted to this topic are about the item Everything is the right question...
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers