A Visit to Microsoft and SQL Server 2016
Today we have a guest editorial from Andy Warren as Steve is on vacation. Andy talks about a trip to Microsoft for the SQL Server 2016 launch.
Biml Academy 2 - Importing, Staging, and Loading Data
Next week are 5 more lessons on working iwth Bilm. Each day, Aug 15-19, at 1:00pm EDT.
SQL Server Stored Procedure to Compress Non Partitioned Tables
My SQL Server database has some very big tables that can be compressed. The tables are simple, non-partitioned tables and I want a quick tool to compress them. I
An object lesson about what is really important
A story I heard a long time ago reminds us to choose what is really important.
Executing Multiple Threads to Create a Load
Learn a few techniques for executing multiple sets of queries at once.
SSIS in SSDT: The Basics
SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially. Rob Sheldon provides a beginner's guide to get you started with using SSIS with Visual Studio and SQL Server Data Tools (SSDT).
Keyboard Hardlines
The potential vulnerabilities of wireless devices might be a security issue for databases.
Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes
Find out how to speed up your queries by indexing and partitioning data, U-SQL style.
Stretch Database in SQL Server 2016 RTM
Tim Radney of SQLskills shows how the Stretch Database feature has evolved from its early CTP beginnings to the RTM version released earlier this month.
Data Overload
When do you have too much data? What do you do if you aren't actually using all of it?
Blogs
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...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
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