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
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Tanah Abang Zona 3 Tlp/Wa 08216977701
Gedung Tanah Abang Zona III Lantai 3A L03A, Jl. KH. Fachrudin, Kp. Bali, Kecamatan...
BCA KCP Kramat Jaya Baru Tlp/WA 08216977701
Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar Baru, Kec. Johar Baru, Kota Jakarta...
BCA KCP City Center TLP/WA 08216977701
Kawasan Terpadu Pusat Kota, Gedung Perkantoran Tower One, Lantai Dasar, Jl. KH Mas Mansyur...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers