VBscript hacks for DTS packages
This article is about using VBscript hacks to overcome two limitations of DTS packages.
Intrinsic Member Properties: The MEMBER_KEY Property
Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
Microsoft Jet 4.0 Sorting APIs: DBCompareStringW and DBLCMapStringW
The Microsoft Jet 4.0 relational database engine utilizes character sorting tables when creating and querying field indexes made up of character data. Two Microsoft Windows APIs are generally utilized for this functionality:
The Database Weekly Update for July 14, 2008
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
The Database Weekly Update for July 14, 2008
Steve Jones talks about data mining in the drug industry and the advantages of cheap software.
The Database Weekly Update for July 14, 2008
Steve Jones talks about data mining in the drug industry and the advantages of cheap software.
Building Parent-Child Table Tree information
How many times have you wanted to know which child or grandchild records exists for a parent record? SSMS doesn't make this information easy to find beyond one level. New author Narasimhan Jayachandran brings us an article and a recursive solution.
The Value of an MBA in IT
Do you have an MBA? If so, has it helped you? Is it worth getting one for someone in IT? Ted Pin comments.
DIY
For this Friday, Steve Jones has a poll about life outside of work and how much you tinker with things.
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