GitHub Desktop Tutorial
Introduction Previously, we created a tutorial to connect Visual Studio Code with GitHub. Now, we will show another useful tool to track changes in our SQL code. The tool is GitHub Desktop. What is GitHub Desktop? It is a free tool that works with Git …
PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant
The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after all, that’s what matters. Simply having a backup is fine. However, if you can’t restore your data from that backup, it doesn’ …
Using Containers to Avoid Installing SQL Server
I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop …
SQL ROUND Function vs. Bankers Rounding with T-SQL
The post SQL ROUND Function vs. Bankers Rounding with T-SQL appeared first on SQLServerCentral.
Storing and Retrieving the Initialization and Configuration Data for Applications
All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A long time ago, it was generally decided that simple text files containing key/values were best, stored with the application. After all, yo …
[Video] Office Hours Q&A: Abrupt Exit Edition
Last week, we had an abrupt intro, and this week, we have an abrupt ending when my camera overheats, hahaha: We went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:43 cha2rg: We have …
Microsoft Fabric and PySpark: Coding tricks to improve your solutions
PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked about loops before. Let’s discover some more tricks to make our coding easier and more powerful. The Power of the pyspark REDUCE functi …
Geographic Sharding is Usually a Pretty Bad Idea.
Let’s say you built a web app and it became globally popular. You’ve got users scattered across North America, Europe, and Asia. In theory, you could shard your data globally: build 3 sets of SQL Servers, one on each continent, and split up …
I Must Be an Idiot: Automatic Tuning Never Works for Me.
The post I Must Be an Idiot: Automatic Tuning Never Works for Me. appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? September 2024 Edition
Is your company hiring for a database position as of September 2024? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must …
Solving the Overlap Query Problem in PostgreSQL
Range queries are a very common task in SQL: selecting dates, numbers, or even text values that fall within some specified range. For instance: all loan applications for the month of March, or all sales transactions between $50 and $500. SQL developers …
How to Slice Data by Fiscal Month using DAX for Power BI Reports
The post How to Slice Data by Fiscal Month using DAX for Power BI Reports appeared first on SQLServerCentral.
Choosing Data Types and Column Options
An entire post on choosing the correct data types either seems like overkill or much needed and overdue. The perspective might vary based on the databases you’ve worked with recently. I decided to write this after seeing some code with data type decisi …
MySQL Index Overviews: Composite B-Tree Indexes
Indexes in MySQL are one of the primary ways to enhance query performance and they are especially useful when the primary use case of our project refers to reading data stored in a database. We‘ve already told you about the nuanced world of indexes in …
Microsoft Fabric: Using Lakehouse data in Real Time Dashboards
The post Microsoft Fabric: Using Lakehouse data in Real Time Dashboards appeared first on SQLServerCentral.