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
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers