This article provides PowerShell automation scripts for running Flyway database migrations. These scripts use SQL Compare to automatically generate all the required database build artifacts in the version control system, for each Flyway deployment.
In this article, Brent Ozar explains why you should avoid starting T-SQL comments with two dashes.
Releases of on-premises SQL Server arrived quite rapidly for a few years with seven releases during the years spanning 2008 and 2019. While it has technically been less than two years since SQL Server 2019 reached general availability in November 2019, it feels like ages since we have heard any news about what’s coming next. […]
There are many things we may miss about the office, but one of them is the chance to interact with and impress management.
Technical skills come and go while soft skills will serve you throughout your life. They will have the greatest influence over your career, job and role. For some people soft skills come naturally. As an Aspergers person (Aspie) I have to practice my soft skills at every opportunity. Pure techies need not lose hope. Soft […]
In this article we cover the topic of data wrangling which is steps you can take to cleanup and validate data prior to data analysis.
This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST. For example, if the input Source file name […]
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
Security is changing, and the "edge" of where we need to protect data is changing as well.
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
I’ve been doing storage load tests for SQL Server for a long time, both...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Comments posted to this topic are about the item Half of All Engineers
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers