Who’s Hiring in the Database Community? June 2022 Edition
Is your company hiring for a database position as of June 2022? 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 inclu …
Managing Database Code Quality in a Flyway Development
The post Managing Database Code Quality in a Flyway Development appeared first on SQLServerCentral.
Combinations, permutations, and derangements
The post Combinations, permutations, and derangements appeared first on SQLServerCentral.
The Job of a Technical Editor (as Louis sees it)
One of the most essential parts of producing a great technical article, blog, or even a book, (referred to from now on generally as a work) is having someone who can check your writing and make sure it is right. You can do a mediocre job with grammar, …
Getting Started with Flyway and any RDBMS
The post Getting Started with Flyway and any RDBMS appeared first on SQLServerCentral.
Search all String Columns in all SQL Server Tables or Views
The post Search all String Columns in all SQL Server Tables or Views appeared first on SQLServerCentral.
Summarizing data using GROUP BY and HAVING clauses
SQL Server provides the GROUP BY clause as a means to take a set of detailed values and summarize them into aggregated values. The detailed records can be aggregated based on one column, as well as expressions, which are specified in the GROUP BY claus …
Security in MySQL: Part Two
Welcome back to this series about improving the security in your MySQL infrastructure. The first part of this series touched upon the reasons why should you consider securing your MySQL environment and walked you through some of the security basics. It …
Simple Reporting with Flyway and Database Models
The post Simple Reporting with Flyway and Database Models appeared first on SQLServerCentral.
Memory profiling in Python with tracemalloc
The post Memory profiling in Python with tracemalloc appeared first on SQLServerCentral.
I’m teaching Mastering Parameter Sniffing at the PASS Summit!
At the PASS Data Community Summit in Seattle on November 12th, I’m teaching a one-day pre-conference workshop. This year, the Summit is a hybrid event: you can either attend in-person in Seattle, or online via live streaming. If you attend online …
Datamarts and exploratory analysis using Power BI
Power BI Datamarts is an important new feature announced during BUILD. This new feature expands Power BI possibilities in directions which may be unexpected to many Power BI users. Next, discover more about what this means for Power BI users and develo …
How to troubleshoot and fix PostgreSQL performance issues
PostgreSQL is a popular database that is used by many applications. It’s been in active development for 30 years! PostgreSQL (or Postgres) is a powerful database management system (DBMS) that you can use and worry less about performance. Although …
Breaking News: SQL 2019 CU16 Changes Backup Formats, Can Break Log Shipping.
The newest Cumulative Update for SQL Server 2019 has this gem in the release notes: It’s not a known issue, it’s an improvement This is a massive problem if: You have databases encrypted with TDE You take backups WITH COMPRESSION (which has …
Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform
The post Sharing SQL Prompt Code Snippets and Styles via the Redgate Platform appeared first on SQLServerCentral.