How to Export Data to Microsoft Office Excel 2007 Using SQL Server 2005
This article provides a step by step guide on how to export data to Microsoft Office Excel 2007
Managed Data Access Inside SQL Server with ADO.NET and SQLCLR
Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.
An MVP From Way Down South
Please join us in congratulating one of our longtime community members on MVP status.
Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
Missing Date Ranges- the Sequel
Alex Kozak returns with another Date puzzle. A question from a Simple-Talk reader gives Alex the inspiration to see if is possible to list unused date ranges in one Select statement.
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers