The problem with averages
Everyone learns to calculate an average in school, but, as Joe Celko shows, there are better ways to summarize data.
2022-03-25
Articles
Why you don’t just buy tools to make DevOps happen
Matt Gordan is next in the hot seat. We discuss how Matt keeps the lights on while overseeing many data related projects and how his team know the more they are plugged into projects, the better support the can offer.
2022-03-25
Data and database management in everchanging technology landscape
This article discusses how the cloud and other technologies help companies to manage their data appropriately in the modern world.
2022-03-23
1,473 reads
How to get DevOps buy-in across your organization
In our latest DevOps 101 Series live webinar Grant Fritchey discusses why the key to successful DevOps implementation is gaining buy-in, and how you can achieve this in your organization.
2022-03-23
What is Change Management?
Change manage is a process to prepare an organization to implement change. In this article, Rohan Kapoor explains the five components of change management.
2022-03-23
Import Web pages with Power BI
Introduction In this article, we will learn how to create charts from web pages with Power BI. Power BI is an extremely great tool to easily generate reports. We will combine and analyze data from different websites, and we will talk about COVID 19 with the reports. In order to analyze the information, we will […]
2022-03-21
10,757 reads
Think you know SQL Monitor? Think again.
You spoke 📣 we listened 👂
We are dedicated to listening to what our customers want and need and implementing feedback accordingly. Learn about how SQL Monitor has evolved, and the key features we've added, since 2018.
2022-03-21
Working with MySQL tables
After getting a new database in place, the next step is to create tables. In this article, Robert Sheldon walks you through creating tables with SQL Workbench and with scripts.
2022-03-21
Monitoring Azure SQL Databases
There are many reasons you should monitor your databases, including avoiding performance problems or running out of disk space. Ideally, you want a scalable monitoring solution where you can monitor all your SQL databases in one single place. This article will describe two options that are available: Azure SQL Analytics and Azure SQL Insights. Both […]
2022-03-18
10,265 reads
Bulk Formatting of the SQL Server SQL Files
In this article, Phil Factor explains how to apply SQL formatting styles as part of an automated process, using the SQL Prompt command line formatter, with examples of bulk applying styles from the command prompt, PowerShell or a DOS batch.
2022-03-18
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
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers