A third-party database monitoring tool is an investment that drives enormous value for the bottom line of your business in ten key ways. Here's how a tool like Redgate SQL Monitor can save you money, time and assist with security and compliance concerns.
2022-06-03
Learn about several different aspects of Databricks Lakehouse such as encryption, row level security, visually viewing query plans, SQL merge, change data capture and more.
2022-06-03
Joe Celko explains how several mathematical concepts, combinations, permutations, and derangements, relate to databases.
2022-06-01
In this article, I'll discuss the most important quality metrics for a database development, and then practical ways to ensure that a Flyway-managed database is designed and implemented to a high enough standard that it is reliable to use.
2022-06-01
In this short article, see how a unit test can be easily written in tsqlt, and how this can help us refactor or build better code.
2022-05-30 (first published: 2019-09-24)
14,000 reads
How to get started with Flyway, as simply as possible, using PowerShell. This article provides a practice set of Flyway migration scripts that will build the original pubs database on either SQL Server, PostgreSQL, MySQL, MariaDB or SQLite and then migrate it from version to version, making a series of improvements to its schema design.
2022-05-30
In this article we look at T-SQL script you can use to search for a string in every table and view in every database or in a specific database.
2022-05-30
I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.
2022-05-27 (first published: 2017-10-16)
6,650 reads
You can find memory leaks in Python code with tracemalloc. In this article, Priyanka Nawalramka demonstrates how to use tracemalloc to find the leaks.
2022-05-27
If you can generate a file-based (JSON) model for each new version of a database, produced by a Flyway migration, then you have an easy way to run simple reports to help you search, list, and understand the structure of these databases. I'll show how to produce the models using PowerShell and then run some queries against them to generate the reports.
2022-05-27
By Steve Jones
I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...
By DesertDBA
In case you don’t follow me on LinkedIn or Twitter, your humble host joined...
By James Serra
With Power BI continuing to get many great new features, including the latest in...
I receive data in JSON files and for one particular type of data I...
Hi I have a tabular model and have been asked to retrieve the last...
Comments posted to this topic are about the item Working with T-SQL function AVG...
Ask SSC