Infographic Designer Visuals in Power BI
Learn how you can make your visuals more interesting with the Infographic Designer Visual.
Query SQL Server with Python and Pandas
In this article, we examine how to read SQL Server data and parse it directly into a dataframe and perform operations on the data using Python and Pandas.
Summarizing data using GROUP BY and HAVING clauses
You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how.
Query Tuning, Why Bother?
Today Grant wonders why we spend so much time trying to learn about query tuning.
Establishing a Connection to PostgreSQL with GoLang
Learn how to use golang to connect to a PostgreSQL database.
Columnstore Indexes are Finally Sorted in SQL Server 2022
There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column.
Power BI - How to Download and Get Started
In this article learn how to download, install and get started building your first Power BI report using SQL Server data.
A Culture That Allows Mistakes
The culture in which we work is important. Having a culture that accepts and allows mistakes can help your organization. Not having this can make the environment much worse.
PerfMon: Using SQL Server Performance Counters
Learn how you can use Windows Performance Monitor and the PAL to gather metrics from your SQL Server instances.
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
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...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers