Presentation slides and sql scripts up
I have posted the slides for the presentation I gave to the DotNet Columbia User Group.
The talk was called, "Something...
2006-08-09
715 reads
Blog Posts
Visual Studio Team System - Database Professionals: Database Connection Error
If you're like me, you don't have SQL Server 2005 sitting on the
default instance because SQL Server 2000 is sitting...
2006-08-06
660 reads
Excellent article on SQL Server 2005 Common Table Expressions
SQL Server MVP Nigel Rivett has written an excellent article on Common Table Expressions on Red Gate Software's Simple Talk...
2006-08-02
754 reads
Identifying NTLM vs. Kerberos authentication using Fiddler
I saw this post on using Fiddler to tell the difference between an NTLM and a Kerberos connection to a...
2006-08-02
4,556 reads
Does your organization need a DBA? (part 2)
This is a follow-on to Does your organization need a DBA? and Andy Leonard's Database Professionals: An Enterprise Requirement.
I was...
2006-08-01
693 reads
Does your organization need a DBA?
Andy Leonard pens the following blog entry:
Database Professionals: An Enterprise Requirement
There are quite a few organizations that feel they can...
2006-07-30
1,536 reads
Succint Article on Encypting File System (EFS)
Encrypting File System, or EFS, first debuted in Windows 2000 and gave
users to encrypt files without a 3rd party tool....
2006-07-30
1,587 reads
Detecting SQL Server 2005 Properly
There is a new post in the SQL Server Express blog which indicates the
right way to detect SQL Server 2005:...
2006-07-29
1,474 reads
More SQL Server blogs
There is a new site for SQL Server blogs, SQLBlog.com. "Brought to you by Peter DeBetta & Adam Machanic," it has...
2006-07-29
1,317 reads
New Windows Vista Security Blog
If you're keeping up with Windows Vista and you're interested in the
security aspects of it, there's a new blog, with...
2006-07-29
1,391 reads
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
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...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
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
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