Many of us have spent time looking through manuals or the documentation for some software or product. I know I'm on the MS docs site regularly for work, and there is no shortage of times I've used various manuals to help me fix something around the house. We usually use a manual when we want […]
Explaining some of the 'gotchas' that can trip up the unwary Flyway user, and how to avoid them. One or two of these you'll encounter quickly, such as the case-sensitivity of parameters and arguments. Others, such as potential problems with undo scripts or running scripted callbacks, only when you are tackling more complex development processes.
There are several common challenges when creating paginated reports from Power BI datasets. In this article, Adam Aspin explains how to work around several of these issues.
Charts and graphs need a scale to be meaningful. When to include zero in your scale is a question that is more complicated than Steve expected.
In this article we walk through things you should know to create new tables in SQL Server using the SQL Server Management Studio interface.
In case you missed it! Before you get very far with database development you need to be clear about your strategy for handling data. In this article I'll explain some of these issues in general terms, and then demonstrate how you can navigate these problems easily with Flyway.
In this article, learn how to work with your repo online at GitHub.
This next article in the git series looks at managing powershell code in Git.
This article will cover a basic set of code merges between different branches.
This is the second article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git Basic Git for DBAs: Sharing Files Through GitHub Basic Git for DBAs: the Basics of Branches Basic Git for DBAs: Making Changes in GitHub Basic Git […]
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Komp. Taman Harapan Indah Blok EE No.1, Jelambar Baru, Daerah Khusus Ibukota Jakarta 11460
Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa Barat...
Gedung WTC Mangga Dua Lantai Ground Lobby Selatan dan Lantai Upper Ground (UG) PCL001,...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers