3 Ways to Debug T-SQL Code
Writing new code = bugging. That part’s easy. Taking those bugs back out, that’s the hard part. Developers are used to their tools having built-in ways to show what line of code is running now, output the current content of variables, echo …
Index Types in PostgreSQL: Learning PostgreSQL with Grant
As with any other relational data management system (RDBMS), PostgreSQL uses indexes as a mechanism to improve data access. PostgreSQL has a number of different index types, supporting different behaviors and different types of data. In addition, again …
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 an …
Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools
The post Analyze Azure Cosmos DB data with Synapse Serverless SQL Pools appeared first on SQLServerCentral.
Using sp_prepare and sp_execute to utilize prepared SQL statements
The post Using sp_prepare and sp_execute to utilize prepared SQL statements appeared first on SQLServerCentral.
Cross-RDBMS Code Quality Reports in Flyway
The post Cross-RDBMS Code Quality Reports in Flyway appeared first on SQLServerCentral.
Ethical Hacking Tutorial
Are you afraid of the word hacking? Ironically, it is legal hacking that is benefiting us. If this is your first article about hacking, reading it will undoubtedly provide you with some possible insight. I provide a brief overview of ethical hacking in …
Introducing the MySQL common table expression
This article is part of Robert Sheldon’s continuing series on Learning MySQL. To see all 10 items in the series, click here. As with many relational database management systems, MySQL provides a variety of methods for combining data in a data manipulat …
Don’t Just Chase the Shiny
Fish are beautiful creatures, but they have one minor issue. The main thing I remember from the years I fished is that fish can be susceptible. If you have a fishing lure that shows off with a bright, colorful, shiny appearance that splashes around jus …
How to Find Missing Rows in a Table
When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table: It has Ids -1, 1, 2, 3, 4, 5 … but no 6 or 7. (Or 0.) If …
The SQL Server Posts You Read the Most in 2022
Here’s what I wrote in 2022 that gathered the most views: #10: Who’s Hiring in the Database Community? February 2022 Edition – I saw the success of Hacker News’ “Who’s Hiring” monthly posts, and I blatantly sto …
Setting up for Team-based Database Development using Flyway Desktop
The post Setting up for Team-based Database Development using Flyway Desktop appeared first on SQLServerCentral.
Azure Function and User Assigned Managed Identities
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity. When we build Azure functions, they usually need …
Announcing the 2023 Data Professional Salary Survey Results.
Are your peers being paid more this year? Are they switching job roles? Are they planning on leaving their companies? To find out, I run a salary survey every year for folks in the database industry. Download the raw data here and slice & dice ’em …
Who’s Hiring in the Microsoft Data Platform Community? January 2023 Edition
Was your New Year’s resolution to get a new job? Heads up: the comments in this post are for you. Is your company hiring for a database position as of January 2023? Do you wanna work with the kinds of people who read this blog? Let’s set up …