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.
2022-07-25
Articles
Establishing a Connection to PostgreSQL with GoLang
Learn how to use golang to connect to a PostgreSQL database.
2022-07-22
17,997 reads
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.
2022-07-22
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.
2022-07-22
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.
2022-07-20
24,403 reads
DevOps Collaboration and Process Visibility in Flyway Developments
A brief history of the DevOps movement and a discussion of the pivotal role of a tool like Flyway in the DevOps toolchain, when developing and delivering database changes.
2022-07-20
How to troubleshoot and fix PostgreSQL performance issues
PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan.
2022-07-20
How to Connect to an Analysis Services Database in Power BI
Learn how to work with SSAS data in Power BI in this article.
2022-07-18
5,634 reads
Taming Database Documentation with Flyway and MySQL
Database object documentation is essential for explaining to busy developers, and the wider business, the purpose of each object and how to use it. The solution presented in this article consists of a SQL script to allow developers to add comments to MySQL database objects, without affecting the database version, and a simple way to generate a documentation report, in JSON. The SQL script will execute automatically as a callback, during any Flyway Teams migration run, and the report will allow the team to spot any gaps quickly.
2022-07-18
T-SQL Comment Best Practices for SQL Server
Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.
2022-07-18
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers