Using Power Query to Combine Data from Multiple Sheets in Excel
This article employs Power Query features to combine queries and implement requirements in different listed scenarios.
2023-08-07
Additional Articles
How to List First or Last n% Records Using NTILE() in SQL Server
Sometimes, we need to find the first or last n% records from a dataset based on a particular column. For instance, a teacher wants to know which students are in the bottom 25% based on marks. Hence, in such situations, the SQL NTILE() function helps. We will leverage this tip to get first or last n% records using NTILE() in SQL Server.
2023-08-04
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.
2023-08-02
PASS Data Community Summit 2023
Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year. If you’re not already on the mailing list, sign up now and be the first to know all Summit 2023 updates.
2023-08-02
Installing SQL Server Integration Services
You're tasked with installing SSIS as part of a SQL Server installation or adding it to an existing one and would like a step by step guide showing how to install it.
2023-07-31
Best Practices for Google Cloud Security
Security is a concern whether it be on-premises or cloud-native. Google Cloud offers many products and services including SQL Server. What are some of the security controls that should be considered when using Google Cloud services?
2023-07-28
How to Make Database Changes Without Breaking Everything
You’ve got an existing application with a database back end. You’re thinking about changing the database, and you don’t wanna break stuff.
2023-07-28
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from the common goal of populating a large data set such as a numbers or calendar table. A few favorites include building sample data, pivoting an unknown number of columns, data extrapolation, and filling gaps in date or time ranges.
2023-07-26
PASS Data Community Summit 2023
Keynote speakers for Summit 2023 have been announced! Who will you go see on the main stage? If you’re not already on the mailing list, sign up now and be the first to know all Summit 2023 updates.
2023-07-26
DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections
In this tip, we explore two behaviors for the DAX RANKX function that can lead to incorrect results and discuss workarounds and fixes.
2023-07-24
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
MMOExp EAFC25 to the Major New Features
FC 25: A Comprehensive Guide to the Major New Features "Same game with different...
MMOExp NBA2kMT to controlling the rock
NBA 2K25: The Top 5 Players with the Best Ball-Handling Skills In the world...
MMOExp Dark And Darker for evaluating the power
Dark and Darker: How Does Gear Score Work? In Dark and Darker, gear is...
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers