The Curse and Blessings of Dynamic SQL
How you use dynamic SQL, when you should - and when you should not.
2008-07-01
4,990 reads
Articles
2008-07-01
47 reads
Data Rich and Information Poor
Do you deal with data or information? Do you know the difference and are you transforming one into the other. Steve Jones comments on the state of many companies' data.
2008-06-30
47 reads
Data Rich and Information Poor
Do you deal with data or information? Do you know the difference and are you transforming one into the other. Steve Jones comments on the state of many companies' data.
2008-06-30
44 reads
Data Rich and Information Poor
Do you deal with data or information? Do you know the difference and are you transforming one into the other. Steve Jones comments on the state of many companies' data.
2008-06-30
45 reads
How insiders hack SQL databases with free tools
When you find out how easy it is for insiders to hack SQL Server databases with a few free security tools and a little luck, you'll re-examine your database security practices.
2008-06-30
8,714 reads
How To Return a Result Set from a SQL Server 2005 CLR Stored Procedure
We occasionally come up with a requirement that would be a good fit for a CLR function or stored procedure. For instance we would like to call a stored procedure to get the list of files in a particular folder. How can we return the list of files as a standard result set (i.e. rows and columns) using the CLR?
2008-06-30
4,802 reads
The June 2008 Energy Update
It's time again to take a look at energy news from an IT perspective, or at least the Steve Jones' perspective and there have been some interesting notes over the last couple months in the world of energy.
2008-06-29
745 reads
The June 2008 Energy Update
It's time again to take a look at energy news from an IT perspective, or at least the Steve Jones' perspective and there have been some interesting notes over the last couple months in the world of energy.
2008-06-29
500 reads
The June 2008 Energy Update
It's time again to take a look at energy news from an IT perspective, or at least the Steve Jones' perspective and there have been some interesting notes over the last couple months in the world of energy.
2008-06-29
489 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