10 tips on converting MS SQL queries to MySQL
The syntax of SQL queries in MS SQL and MySQL are similar but not identical. This article discovers 10 most popular differences between MS SQL and MySQL syntax.
Career Engagement
This Friday Steve Jones asks if you like your job. Are you engaged? Do you want to stay? Give us your answer today.
Create CNN-style Map in Reporting Services
This article demonstrates how to use US Census' TIGER/Line shapefile to display CNN-style map in Reporting Services.
SQL VIEW Basics
SQL Views are essential for the database developer. However, it is common to see them misued, or neglected. Joe Celko tackles an introduction to the subject, but there is something about the topic that makes it likely that even the experienced developer will find out something new from reading it.
Never, Ever Use Clustered Indexes
Today we have a guest editorial from Grant Fritchey that might surprise you. Today Grant talks about clustered indexes in your tables.
Is Empowerment Good?
Today Steve Jones notes that we use computers to enable others to handle their own work without help. But is that always a good idea.
Managing Database Data Usage With Custom Space Alerts
A quick how-to on configuring SQL Server Agent alerts to manage file space usage.
Maintaining SQL Server default trace historical events for analysis and reporting
I often see questions online where someone wants to find out who started a trace, when tempdb last had an autogrow event, or when the last full backup for master occurred. Since these and other events are captured by the default trace, but the default trace only keeps five 20MB rollover files by default. This means that the event you are after may no longer be there, depending on how long ago it was and how busy your server happens to be. Unfortunately, people often need to find this information well after the fact.
Create Your Own Intense Interview
Today Steve Jones talks about interviews and the way in which he approaches them to make sure that the job is the best fit for both the company and the candidate.
SSIS FTP Task – Receive Files from FTP Site
This article will show you how to configure the FTP task in SSIS to recieve files from remote server using the FTP protocol.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers