Takeaways from Data Grillen 2024
Two days of Data, Beer and Bratwurst. What did it bring me, find out by reading this photo-rich article.
2024-05-24
420 reads
SQL
Will AI end with SQL, Is this the end of SQL?
An experienced DBA asks an AI to perform some common tasks. Read to see how it fairs and if an AI will impact DBA jobs.
2024-03-11
7,576 reads
SQL Window Functions Series: NTILE()
Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.
2024-02-03 (first published: 2024-01-03)
4,560 reads
SQL Window Functions Series: LAG() and LEAD()
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
7,066 reads
SQL Window Functions Series: RANK() and DENSE_RANK()
Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().
2023-11-20 (first published: 2023-11-15)
9,982 reads
How to Use SQL to Analyze the Bitcoin Blockchain
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
2023-09-08
4,401 reads
SQL WHERE LIKE to Construct More Efficient Queries
In this article, we will discuss the purpose and use of the WHERE LIKE clause in SQL Server and how it can help you construct more efficient queries.
2023-06-02
Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances
Learn how to get started with Google Cloud MySQL and PostgreSQL databases by creating and configuring a database.
2023-05-26
973 reads
Why a monitoring tool is an essential tool for growing server estates
As we continue into the era of supporting more and more database platforms in our data estates, self-monitoring goes from being a very difficult task to a truly daunting task. I am personally advanced at diagnosing Microsoft SQL Server performance issues, but when that PostgreSQL server gets added, I just have to hope nothing goes wrong for a few years while I learn.
2023-04-10
Database Deployment with Terraform - Modules
Deploy resources in Azure using reusable code with Terraform modules.
2022-10-10
11,456 reads
Blogs
T-SQL Tuesday #184–Mentoring
By Steve Jones
This month’s T-SQL Tuesday blog party is hosted by Deborah Melkin, and it’s a...
T-SQL Tuesday 184 - Mentorship
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
March 2025 SQL Challenge: Test Your Skills with Advanced SQL Scenarios
If you’re an experienced SQL user eager to sharpen your expertise with real-world challenges,...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
SSIS Execute Process Task forfiles not working
I'm trying to use forfiles in an Execute Process Task in my SSIS package...
Display Data
Hi I want below data to appear like below using query CREATE TABLE [dbo].[Test](...
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers