The Curse and Blessings of Dynamic SQL
How you use dynamic SQL, when you should - and when you should not.
The Database Weekly Update for June 30, 2008
Steve Jones looks back at a week of news on data center infrastructure, the EF war, and SQL Server 2008 news.
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.
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.
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.
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.
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.
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?
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.
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Alamat Kantor BCA KCU Wisma Asia Telp:08218200174
Via Wa:628218200174 Alamat Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Alamat Kantor BCA KCU Kebayoran Baru Telp:08218200174
Via Wa:628218200174 Alamat. Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
Alamat Kantor BCA KCU Wisma Millenia Telp:08218200174
Via Wa:628218200174 Alamat.Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec. Tebet,...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers