The Programming Languages We Use
Steve comments on some programming languages and how we approach those we choose to use.
Using pre-commit to prevent simple mistakes
Git hooks are a useful way of triggering code quality scripts. The pre-commit tool provides us with a way of doing this and tapping into the huge library of scripts already in existence to ensure our code complies with general linting and formatting good practice.
Database Sharding to help Improve Performance and Maintenance Tasks
In this article, we will review the benefits and drawbacks of using database partitioning (sharding) to help improve performance and maintenance tasks.
How to Create a Box and Whisker Plot in Power BI Desktop
In this article, we look at how to build a box and whisker plot chart using Power BI Desktop with a step-by-step walkthrough.
Translate Text Data using Azure Cognitive Services
Learn the basics of the Text Translation services in Azure Cognitive Services.
Subqueries in MySQL
A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The subquery itself is typically a SELECT statement, although you can also use a TABLE statement or VALUES statement. Even so, the SELECT statement continues to be the most common choice for subqueries, and that’s the one I focus on in this article.
Useful Commands for Snowflake Transactions
In this article, we look at how to create transactions when using Snowflake along with several commands specific to working with transactions.
Forgoing Tech Investments
SouthWest Airlines had some issues, possibly because of their technical debt and lack of investment.
How to Create a Power BI report using MySQL data
Introduction In this article, we will learn to create a Power BI report using MySQL data. The article will teach us to use the MySQL Workbench (something like the SSMS, but for MySQL). We will do the following in this article. First, we will connect and create a database in MySQL. Secondly, we will create a […]
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
WhatsApp +52 6643030891 Get A1, B1, C2 telc zertifikat without exam
geotheexamscenter@yahoo.com Welcome to All German Certificates the best website which produces genuine German language...
Get TELC Zertifikat B2 Without Exam in * Slovenia WhatsApp +52 6643030891
geotheexamscenter@yahoo.com Welcome to All German Certificates the best website which produces genuine German language...
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers