Opening JSON Data with T-SQL
The T-SQL code samples in this tip illustrate ways of displaying JSON formatted data in SQL Server as well as how to transfer JSON formatted data to SQL Server tables.
2021-06-25
java
Managing database changes using Flyway: an Overview
This article describes the principles of using Flyway migrations to build a database from scripts, to a specified version, and to track, manage and apply all database changes.
2021-02-03
Postgresql JDBC Tutorial on Linux
PosgtreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language. Though originally designed to run on UNIX platforms, Postgres is able to run on various platforms, such as macOS, Solaris, Windows, Unix, and Linux. PostgreSQL databases provide enterprise-class database solutions and are used by a wide […]
2020-05-11
6,190 reads
Blogs
Understanding Microsoft Purview Pricing
By Mr Fox SQL
Ever since its official launch around October 2021, Microsoft Purview has been one of...
Why I tweet about work and personal topics from the same account
Over the last few years, I’ve had a few people ask me why I...
Daily Coping 26 Sep 2022
By Steve Jones
Today’s coping tip is to enjoy photos from a time with happy memories. On...
Forums
things to do
In our lifes, we have manys things to do, many places to visit, many...
cursor to do update for multiple tables of a specific field
I am trying to scramble ID field in multiple tables in database. I created...
3616 Trigger Error when Calling Stored Procedure on Linked Server
I am updating a proprietary database using an SSIS package. From a web UI...
Ask SSC