Faking Multidimensional Arrays in T-SQL made easy!
Another method to create arrays in T-SQL which is actually a "throwback" to the earlier days of compilers!
Participation
With Election Day in the US, Steve Jones talks about how you can make a difference. This editorial was originally published on Nov 4, 2008. It is being republished as Steve is out of town.
Using Break Points in SSIS - SQL School Video
MVP Brian Knight brings us a look at how you can easily debug your Integration Services packages.
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
GIS and SQL Server 2008: Making Maps with your Data
When Microsoft introduced GIS into SQL Server with SQL Server 2008, it opened up a whole range of new applications that were previously impossible to do with SQL Server. So what can you do with GIS Data? We asked an expert!
Using Powershell to Generate Table-Creation Scripts
For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what each line does.
Dead LINQ - Database Weekly (Nov 3, 2008)
Steve Jones comments on a few pieces of interesting SQL Server news this week, including Service Pack 3.
How SSIS and Other Tools Obtain Metadata
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers