SSIS Lookup using a Script Component
What would you do if you want to perform 15 to 30 lookups using the same reference dataset? This is how I did it...
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
Database conversion between the most popular DBMSs
Today many companies determine to publish their data on the Internet trying to expand their business and make their information more accessible. The IT industry proposes a wide range of original solutions for resolving data inconsistency problems that publishers inescapably face when exporting their data as they need to properly access, process and interchange large amounts of information mainly through the web.
Proxy Accounts in SQL Server
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them
SQL Bits IV - Call for Presentations
SQL Bits IV, in Manchester, UK next year on March 28th, is now looking for speakers. Please submit a session if you are interested.
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
How Would You Rate This? - Database Weekly (Dec 29, 2008)
Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?
Scripting INSERTs
A little procedure to quickly product a script for copying data from one database to another.
Calculations Made Outside of the Data Warehouse
At first glance, a client appeared to be violating a cardinal rule of data warehousing. However, Bill Inmon's further investigation revealed that perhaps their actions were acceptable.
The Year in Review 2008
Steve Jones looks back at the past year and database news that has occurred.
Blogs
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Forums
Cumulative Update 23 - KB5074819 - Database Mail - No longer working.
Hi there, Has anyone else had any trouble with Database Mail in Cumulative Update...
Script Task execution error with HTTP request
I have a script task that tries to execute a HTTP request, which seems...
SQL Server 2025 Standard Developer Edition
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Question of the Day
URL Safe or Not?
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers