Import data from Azure SQL to Tabular Databases
Daniel Calbimonte shows how to create an Azure SQL Database with the AdventureworksLT data, and how to import the information into a SQL Server Analysis Services Tabular Model Database.
Better Coding
The Australian Census was a mess, and supposedly some university students build a better version. Steve Jones comments on better coding practices.
Using Microsoft R in Enterprise Environments
This article talks about using the the positive aspects of setting up R in enterprise environment and give instructions on first steps how to do it.
SQL Server Access Control: The Basics
No technology yet invented can in any way allow us to neglect the task of ensuring the security of the database by controlling access. Security must be applied in depth, and the database is designed provide a system that will thwart even the most determined external attack. If it seems a bit complicated at first, that is no longer an excuse now that Rob Sheldon has provided this simple guide for getting started.
Stairway to U-SQL Level 7: More Partition Schemes
Following on from our previous introduction to indexes and partition schemes, we review the distribution schemes used by horizontal partitioning.
The Future for Database Administrators
Today Steve Jones talks about the job changes and prospects for those that manage IT systems.
Installing Master Data Services in an AlwaysOn Environment
This article describes a solution for Master Data Service (MDS) hosted on AlwaysOn Availability Group configuration. The article describes how to install and configure SQL 2016 Master Data Services on a SQL 2016 AlwaysOn Availability group (AG). The main purpose of this solution is to improve high availability and disaster recovery of MDS backend data hosted on a SQL Server database.
Security Leaks from Websites
No matter what we do to secure our databases, we need to be sure our applications are well written, both with secure coding, but also good information handling.
Trace Flag 2389 and the new Cardinality Estimator
Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.
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
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:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers