How to Execute SSIS Packages from SQL Server Agent
Learn about best practices for developing SSIS packages that you want to execute from SQL Server Agent and the steps to follow.
Mental Health and Wellness Day 2022
Our annual mental health and wellness day is slated to happen on 8th April 2022. We have a fantastic lineup,schedule as below. For more details on speakers and sessions refer to our blog post here.
Post-migration Validation and Optimization Guide
SQL Server post migration step is very crucial for reconciling any data accuracy and completeness, as well as uncover performance issues with the workload.
SQL Unit Testing reference guide for beginners
In this article, we are going to learn the basics of SQL unit testing and how to write a SQL unit test through the tSQLt framework.
Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security
In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
Advice for Business
Some advice from Steve and Sam Altman, whether you work in business or want to build one.
Machine learning K-Means applied to SQL Server data
This article shows how to use Python to access data in SQL Server and produce a K-Means analysis with a chart.
Using a SQL Tokenizer
Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so you can check the whole SQL Expression and work out why it is running so slowly.
Has AI Changed Software Development?
Generative AI is everywhere, but especially in software development. Is it helping us? Steve has a few thoughts.
Dijkstra's Algorithm
Introduction This article celebrates a classic algorithm [1] of Dijkstra (1930 – 2002) which finds a path of minimal cost between any pair of nodes in an undirected graph. His procedure is widely recognized as a fundamental tool for examining communication and transportation networks (eg. Google Maps) and is surprisingly simple. By his own admission, […]
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers