Using a CTE as a Tally Table
Sometimes you need to output blank lines
- in effect displaying Records for Missing Data. This article explains how to use a CTE to do this
The Top Five Things That DBAs Need to Monitor
Being a database administrator is much more than knowing how to install SQL Server and set up a database. One of the most important responsibilities is being proactive by monitoring the instances in their care. But, what should be monitored? Here are the top five things to monitor when you are a SQL Server DBA
Dynamic SQL Crossword
This crossword is based on terms you might come across in an article about Dynamic SQL.
SQL Server Index Tutorial Overview
Although there are many different things that can be done to improve the performance of a database system, creating an index is the main tool in every DBA's toolbox that is used when we are trying to improve the performance of a query.
Steps to Migrate Oracle Database to Azure SQL Database
In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future. On other hand, a technology or platform may reach the end of its life for other business reasons, like ease of use, increased cost, etc.
I'm Not a Lawyer, But...
Over the last 18 months or so, I’ve spent a lot of time reading about the General Data Protection Regulation or GDPR. If you don’t know about it, you live under a rock, are a very old school dba, here’s a reference to the law itself. If you’re working as a data professional, I’d strongly […]
SQL Server Data Table as CRM Data Source on VBA Form
Using SQL SERVER Database as Data Source
FOR MS Access VBA Switchboard and Data Entry Form. I am presenting, once again, a method of connecting and upgrading a SQL data source into a VBA presentation process.
Will Terminators Be Required?
The use of terminators in T-SQL is incredibly inconsistent. Steve Jones thinks it will always be this way.
How to Successfully Deliver IT Projects in a Not-so-Agile Organization
Agile methodology for software delivery is accepted at many organizations but is not used everywhere. In this article, Mohammad Rizvi gives advice on how to successfully implement a software project in a non-Agile environment.
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers