There are multiple reasons for no full backup: corrupted backups, taking too much time to restore, etc. In this post, I want to show an alternative for these cases, an ace up one’s sleeve, that you can use to recover data.
There is something magical about SQLBits. Whether it is the technical sessions, the sense of community and fun, or the relentless commitment to learning about the latest innovation, this event continues to serve as a pulse check for where data is today and where it’s going tomorrow. This year’s SQLBits at the ExCel in London […]
Learn about a few different options for migrating from Microsoft SQL Server to PostgreSQL.
Steve wonders if it is worth it to use multiple monitoring systems for a database.
Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it work. This should not be used for production usage and this blog is for educational/testing purposes only.
Today Steve wonders how many of you might be looking forward to SQL Server 2025 and consider it to be a major release.
This article explores how to use Snowflake’s task features to implement parent-child data workflows. We will walk through a real-world scenario in which a healthcare organization manages patient records using a sequence of tasks for data ingestion, transformation, enrichment, and reporting.
Before I start the whining (whinging if you prefer), let me just say I have the greatest job in the world. I'm exceedingly lucky to have it. I'm grateful as can be. And someone else (looking at you Tim) can get it when they pry it from my dead cold fingers. With that out of […]
See how ChatGPT can get data from images and conduct analysis on the data.
If you have had to fix the thing you just fixed with a fix, you might enjoy today's editorial.
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
ABC dan 11 H, Jl. Pangeran Tubagus Angke No.10, Jelambar Baru, Kec. Grogol petamburan,...
Graha Elok Mas, Jl. Panjang No.79 EF, RT.6/RW.1, Kedoya Sel., Kec. Kb. Jeruk, Kota...
Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers