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
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers